Crystal Reports and Unicode input

Hi!

I'm trying to use Crystal Reports with our proprietory data (some of it stored in CodeBase database, some in text files, some is captured in runtime, etc). The simplest solution would be to create comma separated file and pass it to CR. It works, except our text fields can be in a variety of langauges (some european and Chinese Simplified and Traditional). Our software uses Unicode, so I'd prefer to create Unicode CSV file. These files cause CR to fail - it is obvious that CR does not realise that the file is Unicode. I tried other options, and so far I've discovered that CR can read Unicode XML files, while treating them as ADO.Net databases. This is not the best way out, as I suspect it requires .Net framework to be present on target PCs, and it's a big install.

So - any ideas? What simple format can I use to pass Unicode text to CR, or may be some other approaches.

I'm using: CR ver XI, target OS - Win2000 and XP, we can not expect target PC to have anything but Windows installed

Many thanks

balrogPS, when I said CR fails - it does not crash, it simply shows incorrect column names (the first one includes Unicode BOM), number of columns and and all values are wrong
balrog|||hi!
i'm stuck in code and i came across your post when i was searching 4 a solution.
I want to connect to crystal through an XML data source. Im using Visual C++ 6.0. I know how to do it by using an Acess db, bt cant do it using XML.
Can u tell me how?
Im using ADO to connect, bt it gives an exception:
>>_bstr_t bstrAccessConnect ("Provider='CR XML v3.6';Data Source Name='RGenXML';");

Whts wrong here? Help pleeese...

Thanx! Hope 2 hear frm u!|||In Crystal Reports (http://www.saveonsupport.com) there is a ChrW function which takes a unicode number and returns the matching character. Have you tried this?sql

Crystal Reports 8.5/ASP 3.0 - report not shown in browser

Hi

I am trying to run a web application which is done using asp 3.0 which uses crystal reports 8.5 for reporting. I am not able to view the report in the browser, it is just showing the Crystal reports viewer control.

Please help me in trobleshooting this...

Thanks,
R.K.T. AshokaAnybody can answer this ?

Hi

I am trying to run a web application which is done using asp 3.0 which uses crystal reports 8.5 for reporting. I am not able to view the report in the browser, it is just showing the Crystal reports viewer control.

Please help me in trobleshooting this...

Thanks,
R.K.T. Ashokasql

crystal reports 11

hi
i got a problem in installing crystal reports 11 it request a file called keycode.dll ?
can u help me ?[ Moved thread ]

crystal reports (the coder way) ?

Hi

I have a .NET application that needs to obtain the details of the parameters for a crystal report.

I have written some code, that opens a report into the crystal viewer and the gets the parameter info and displays it in a msgbox.

However, the viewer prompts for the parameters, before i get a chance to get the information and display it.:(

My question is, does anyone know of a way that i can get the parameter information from a report, without the user being prompted for the parameters ?

Thanks in anticipation[Moved thread]|||YOu need to populate the parameters to the report before viewing it the viewer or printing it to the printer.

here is a sample from VB on how to populate parameters and formulas.

Dim crFormula As CRAXDRT.FormulaFieldDefinition
Dim crParam As CRAXDRT.ParameterFieldDefinition

crReport.DiscardSavedData

For Each crParam In crReport.ParameterFields
Select Case crParam.Name
Case "{?SortType}"
crParam.AddCurrentValue m_strSortType

End Select
Next crParam


For Each crFormula In crReport.FormulaFields
Select Case crFormula.Name
Case "{@.StartDate}"
crFormula.Text = "DATE( 2001, 01, 01)"
Case "{@.EndDate}"
crFormula.Text = "DATE( 2002, 03, 30)"
crFormula.Text = """All Offices"""
Case "{@.DetailOrSummaryFlag}"
crFormula.Text = """" & m_strSummaryDetailFlag & """"
Case "{@.Seperate}"
crFormula.Text = """FALSE"""
Case "{@.SetShowWarning}"
crFormula.Text = """FALSE"""
Case Else
'do nothing
End Select
Next crFormula|||Hi

I have a .NET application that needs to obtain the details of the parameters for a crystal report.

I have written some code, that opens a report into the crystal viewer and the gets the parameter info and displays it in a msgbox.

However, the viewer prompts for the parameters, before i get a chance to get the information and display it.:(

My question is, does anyone know of a way that i can get the parameter information from a report, without the user being prompted for the parameters ?

Thanks in anticipation

Dim APP As New CRAXDRT.Application
Dim REPORT As CRAXDRT.Report
REPORT = APP.OpenReport("C:\SHIPMENT_SCHEDULE\REPORTS\XL.rpt")

REPORT.EnableParameterPrompting = False
(this is the one you should include...disabling the parameter prompting)

crystal report comparison

hi
I have to compare two crystal report text. Is there any tool which does this?
or Any Code which does this?
It has to be done on rpt only.No conversion of report to any other form.

With regards
RashmiIs is at runtime u want to compare 2 reports?

Crystal Report : Cross Tab Formatting(Urgent)

Hi!I am new to cross tab in reports.I am using Seagate Crystal Report 7.Currently developing report with few tables in it. I am having problem grouping it into the fields that i want.I also wish to know how do i add formula in it..as well as writing queries in the access itself.I cant seems to do anything with the column/row on the report.I hope to have some guidelines.Thank You.Hi!I am new to cross tab in reports.I am using Seagate Crystal Report 7.Currently developing report with few tables in it. I am having problem grouping it into the fields that i want.I also wish to know how do i add formula in it..as well as writing queries in the access itself.I cant seems to do anything with the column/row on the report.I hope to have some guidelines.Thank You.

Hi!!!
I'm also new with crystal reports but i have already done a cross tab report using 8.5...anyway, u can use the wizard to guide u in creating ur crosstab...or u can explain further what u want to do so we could help each other in solving ur problem... :)|||I created a cross tab query in Ms Access..hoping to link to Crystal Report 7. But when i tried to arrange the columns n rows..i cant edit anything.eg: There's summarized field to be set in Crystal report 7. I dont want it to count my field..instead displaying just the data. How can i do it?

Crystal Analysis 9.0 Vs MS SQL Server 2000 (OLAP)

Hi

I want to connect MS SQL 2000 Server with Crystal Analysis via OLAP.

I have installed SQL with Windows authentication mode and installed crystal Analysis 9.0

I have configured Crystal OLAP connection setup.

When I am trying to open or create new application through CA I am not getting through OLAP connection with SQL and I am receiving the error as the following.

Error 1

" Unknown User name and bad password."

Error 2

Failes to initialize.( Cannot connect to the server 'XXXX." the server is not started or too busy)

My SQL server has already started.

Please advsie me ASAP.Run Profiler on the SQL Server and see if you're getting a failed login attempt, or any login attempt at all. That should at least tell you if you're connecting. Can you ping the SQL Serer from where you're doing this|||Hi Chandrat,

I haven't worked with version 9 before but Crystal connectivity issues with SQL Server have somewhat of a track record.

I would suggest checking the basics eg. pinging (as per derrickleggit's post) but you might also want to check out the following:

http://aspalliance.com/532

http://www.dynalivery.com/customersupport/faq/CannotOpenSQLServer.html

Cheers
SQLobSERVER.com|||Dear derrickleggett and SQLobSERVER.com Friends

As long as The SQL and CA9.0 are sitting in the same machine, pinging is working finely.

Profiler receives the connectivity without failure.

Please clarify my doubts.

I have loded IBM Content Manager in my machine, that needs to disable IIS, SMTP, WWWS services to operate CM via IBM HTTP server and IBM Webshpere and I had done so.

Will it cause any problem for the login failure error?

Please update me.|||Is CA9 the only Crystal app you have running?|||Yes... Only Crystal Analysis 9.0..|||Is there any way to explicitly declare the connection values from Crystal? ie. servername, databasename, userID and password?|||We have the only way to connect thru Crystal OLAP connection browser.

There is an option to add server details like as follows

Server Type==> (Microsoft OLE DB provider for olap Sereices 8.0)

Caption==> (Ex:SQLTM)

Server options:

OLAP SERVER

Server Name==>(Ex: DATEC)

Username==>(Ex: SQLADMIN)

Password==>(Ex: *******)

I made the connection with a valid server name, username and password, but not get conneced.|||Chandrat,

I'm stumped - prob best to raise the support call (if you haven't done so already). Looks like you have done everything right. Profiler has even confirmed the connection. Crystal looks like the weak link.

Please let me know how you go and what BO come back with.

Cheers

Crystal 8.5 Page Length less than 4"

Hi!

I have a VB 6.0/CR 8.5 official receipt printing on a form that is 8.5 x 3.5. It was running perfectly under Windows 98 but when I have upgrade to Windows XP I can no longer access withing CR 8.5 forms that are less than 4 inches. Any idea how can I resolve this issue.

Thanks.

rclazarito[ Thread moved to Crystal Report ]

Cross tab stored procedure

Hi
I have a table with rows of timestamped values for given variables. Each of the variables are periodically inserted at the same time. ie
DateTime Variable Value.
T1 V1 xxxx
T1 V2 xxxx
T1 V3 xxxx
T2 V1 yyyy
T2 V2 yyyy
T2 V3 yyyy
In a SQLserver stored procedure I would like to insert this data into a temp table like the following. I don't need summaries just need a table or query where I can select on a variables value. ie "select * from temptable where V3 = yyyy"
Datetime V1 V2 V3
T1 xxxx xxxx xxxx
T2 yyyy yyyy yyyy
any suggestions for an SQL statement.
thanks in advance.
I don't exactly understand your business requirements. Are V1, V2, and V3 the only possible values for the Variable column? If so, something like this might help to get you started:

SELECT
DateTime,
MIN(V1),
MIN(V2),
MIN(V3)
FROM
(
SELECT
DateTime,
CASE
WHEN Variable = 'V1' THEN Value ELSE NULL
END AS V1,
CASE
WHEN Variable = 'V2' THEN Value ELSE NULL
END AS V2,
CASE
WHEN Variable = 'V3' THEN Value ELSE NULL
END AS V3
FROM
yourTable
) AS subQuery
GROUP BY
DateTime


|||

Thanks Terri

The base table contains many variables. The data in this table is produced by a periodic time base event which inserts a row for each of the variables along with their current value. What I am trying to achieve is a record set where I can compare the values of selected variables in a single row based on the timestamp. ie
DateTime Var1 Var2 Var3
1/1/2005 10:00 Product1 10 20
1/1/2005 10:05 Product2 9 15
1/1/2005 10:10 Product2 12 30
1/1/2005 10:20 Product1 15 16
Once I have this record set I can then do selections based on the value of any variable ie
"select * from recorset where Var1 = 'Product1'"
I tried a statement similar to the one you have posted but my case statement sintax wasn't quite right.
I'm not in the office for a few days so may not get a chance try your code.
regards
Noel

Cross Tab Query

Hi!

I m using sql 2005.I have a table as showing below.

yearRegionloan_amtpur_idpurpose1981Andhra pradesh$20,000.00 1Animal Husbandary1981Arunachal Pradesh$110,000.00 1Animal Husbandary1981Assam$240,000.00 1Animal Husbandary1981Bihar$75,000.00 1Animal Husbandary1981Chhattisgarh$55,500.00 1Animal Husbandary1981Gujarat$77,500.00 1Animal Husbandary1982Goa$44,888.00 1Animal Husbandary1982Himachal pradesh$4,000.00 1Animal Husbandary1982Himachal pradesh$20,000.00 1Animal Husbandary1982Jammu and kashmir$30,000.00 1Animal Husbandary1882Jharkhand$35,000.00 1Animal Husbandary1982Karnataka$40,000.00 1Animal Husbandary1982Kerala $20,000.00 1Animal Husbandary1982Madhya pradesh$5,000.00 1Animal Husbandary

I want to produce report as by using crosstab query as showing bellow

Year Asam Hyadrabad goa arunachal pardesh etc.........

1981 1000.00 2000.00 8000.2 00000 000000 .....

1981

'

'

Is it possible by crosstab query ?or please suggest me another way as early as possible.

Thanx in advance.

Abhishek

Have a look at thePIVOT method in SQL Server 2005.

|||

Agree.

Based on my understanding, I think you can use crosstab query in your case. It is desgined for that.

A crosstab calculates an aggregation on a certain column (A) in a set of rows. It then transforms the unique values in another column (X) into column names for the result. All other columns (Y) are used for grouping and their unique values define the rows for the result. The aggregated values of A are distributed among columns in the result according to the value of X and among rows in the result according to the value of Y.

BTW, since you are using sql2005, i think you would need this link:http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1131829,00.html

You can first run that script to create a sp_crosstab then you will be able to use cross tab through your database. thanks

This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

|||

can you be more specific about the columns in the query? I think it can be dne with Group By.

|||

You can't do this by cross-matrix query.

But you can gather such data Datatable in asp.net.

say you have three tables

table a which contains columns : year_id, year.

table b which contains columns : region_id, region.

table c which contains columns : year_id, region_id, amt.

you just do:

string sql="select year_id, year from a";

datatable maindt=sqlhelper.executedatatable(cn, text, sql);

sql="select region_id, region from b";

datatable tempdt=sqlhelper.executedatatable(cn, text, sql);

foreach (datarow dr in tempdt.rows)

{

maindt.columns.add(dr["region"].tostring());

}

foreach (datarow dr in maindt.rows)

{

for(int i=2;i<maindt.columns.count;i++)

{

sql="select amt from c, b where c.region_id=b.region_id and year_id=dr["year_id"].tostring() and region=maindt.columns[i].columnname";

tempdt=sqlhelper.executedatatable(cn, text, sql);

dr[i]=tempdt.rows[0][0].tostring();

}

}

|||

mayankparmar2000:

You can't do this by cross-matrix query.

Yes you can (see the link in my first post). There are other methods as well if you are using a version of SQL Server older than 2005.

|||

Hi guies !

Finaly i resolve this problem by using Pivote in sql 2005 .

Any way thanks for all of u for ur suggestion.

Abhishek.

Cross tab in crystal 8.5

Hi

I would like to know how to add column headings for the cols created in the Cross tab report in crystal 8.5. Most of the cross tab reports are come with horizontal headings as the fields in the database. If I add a few cols in the cross tab and want to have my own custom headings, how do I do that?. Your help is really appreciated.

thanks

ArunHi

It is difficult to change column heading, because the value of particular field is becoming the heading.
One solution is you can replace column field with a formula. Formula return appropriate value for each data in the field.

e.g

If {PLACE} = "Bombay" Then
"Mumbai"
Else If {PLACE} = "Maddras" Then
"Chenni"
Else
{PLACE}