Crystal Reports

Hi All

I am using crystal reports 10 for designing my reports and i am using commands to generate reports. I am using crystal enterprise for showing my reports. When i export my report to crystal enterprise and try to run it it fails with the below exception

Error Message: Unable to connect: incorrect log on parameters. File D:\Program Files\Crystal Decisions\Enterprise 10\Data\procSched\BPSAPPDEV1.reportjobserver\~tmp1bb442fbdc87cd0.rpt.

If i do not use command and use individual tables to generate report it runs fine. Only if i use command it fails. Even if i try giving database information once again it fails.

we are using db2 as database. Is there any solution to avoid this problem?

Thanks in advanceHello,

R u using subreports in ur report...If so u have to provide database information to those reports also...

I gave a small code in my last post of how to provide the Logon information to the subreports also..

regards,
Kolluru.|||I am not using any subreports. I am having this problem for any simple report that uses a command instead of tables. When i export a report to enterprise and try to run it, it gives error.sql

Crystal Report high time taking to load:

In my application , crystal report taking too much time. My Report have more than 50,000 records to display. Report not showing first page untill it receives data of total 50000 records. After reciving total records from database then it is showing first page. It is taking more than 10 mins time. How to solve this problem?Hi. . .

I too have the same problem. My report contains more than 100 pages and it's taking quite a long time to display the report.

Is there any way we can start displaying the report as soon page1 gets filled with the required data??

Any hep pls!!

Thank you all.|||I'm not sure I have the answer but here area couple of things you can check.
Are you using page number or page N of M? If you are using N of M the first page can not be displayed until the last page has been calculated so it can display the total number of pages in N of M.

Are you using indexed fields for your table joins?

Do you have "perform grouping on Server" and "use indexes on server for speed" checked in the oprtions?

Does the SQL for your report have a where clause? If not, the processing can not be pushed to the server.

Good luck and I hope this helps a little.

Crystal Report Chart

Dear All,

I was wondering if it was possible to combine two graphs in crystal reports v10 into one.

I have a line graph that is showing a budget over a year and a graph that is showing how much money different people are spending over a year. Both of these graphs are based on seperate store procedures, and making one transparent and sticking it over the other wont work because the y - axis is not static but a dynamic number,

Can you please help??

Thanks

ChristovPls. write in details.|||Instead of using two sps why cant you write one sp having the code of two sps?

Crystal Report 8 with Vb 6.0 [parameters screen]

Hi,
I m using crystal in vb 60. and showing all the reports from a folder in the list and when user double click any report it ask for parameter which i fine

but if user click on the cancel button on paramter screen then it should exit but still it open the crystal report with blank page.

How i can stop this if user click on cancel button or can i can hide the cancel button on the parameter screen?

Thanks In advanceTry posting this question in the Crystal Reports Forum (http://www.dev-archive.com/forum/forumdisplay.php?s=&forumid=64)|||[ Moved to Crystal Report forum ]

Crystal Display Conundrum

need help on reports showing incorrect currency symbol

on my workstation the reports all display correctly with the correct currency symbol. This is the GBP sign () which is formatted into each currency field on the report.

on another machine, I get the US dollar sign ($). Both machines are set to the regional settings of UK, both use the English/British keyboard, both have the currency symbol in windows set to and both machines display the in all other applications (ms access and ms excel etc)

the data is pulled from access into a vb app and from there a crystal report is launched. the data is correct in the ms access database and also in the forms in the vb app.

i've even checked out the printer settings and there was nothing there to enable you to change the currency symbol, but this printer is shared between two machines and it is correct on the other machine.

why-oh-why does it display $ instead of on the report itself :confused:

WoodyHi,
You have specified that the data are taken from Access to VB. What is the data type of the fileld?. If it is Currency then Access will use the Symbol $ default. Thats why $ is printing in the report. Try to change that filed type as Number if it is Currency data type.

Madhivanan|||managed to get this fixed.

this system has been in place since 1998 and has worked perfectly until the user bought a new pc. the data is stored in the access database as currency and then both the vb app and the crystal reports have formatting to use the pound sign when displaying the figures.

this has worked for 6 years and the application is robust - even coping well with the millennium bug.

and when i say the user bought a new pc, I mean new to her - it has win 98 on it like the original one did.

i installed the crystal report engine on her machine and found that it was formatting the fields to use a dollar. i copied the report files from my machine where they have a pound sign. during the installation of the app (using the vb package wizard) I included the reports and it used the dll that I use on my machine and they all use the pound sign.

so basically something along the way somewhere told crystal to overwrite the formatting i set and use the dollar instead. don't know what, and bloody annoying, but all sorted now.

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.