Showing posts with label crystalreports. Show all posts
Showing posts with label crystalreports. Show all posts

Tuesday, March 27, 2012

CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.

CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
Please solve this error.verify your report with the database or schema on which it is created. Might be there are more then one data base connections.

Thursday, March 22, 2012

Crystal Reports Images

I am currently using CrystalReports 9.0 and I was wondering if there is a way to make a picture appear if certain parameters are met. For example, if an employee ID = John Smith, a picture appears. I know how to put a picture on a report as well as how to use a blob field, but I can't seem to find a syntax that when a certain parameter is met, the image appears. The image is a system file. Any help would be appreciated! Thank you!Right click on the image field
Goto Format object and in the suppress click x-2 button and write this code

Parametefield="yourvalue"

Crystal Reports Exception

Hi,

I'm getting the following exception:

CrystalDecisions.CrystalReports.Engine.LoadSaveReportException: Load report failed.

I'm loading the same report with different data based on user selection from a listbox. This works just fine ordinarily. The user can select an item, view it, close the viewer, load the next, etc.

The exception only occurs after the report has been exported. Doesn't matter what the export format is ... PDF, doc, xls, etc. The only way to regain funtionality is to quit and restart the app.

It can't be that the report is getting locked. I have 4 separate reports, all very similar, but with slight differences. None will load after the export.

Any ideas?

Thanks,
MattMatt,

I am experiencing the same problem. Did you ever resolve your issue?

Eric|||So am I! Did you ever find a solution?

Regards!|||Open the Report and Do verify Database|||And if that dont work then drop the connection and build it again.

Tuesday, March 20, 2012

Crystal reports 2005

Hi,
I have to make a crystal report with C#.
Does CrystalReports supports charts?(I would be interested in pies)Hi,

Yes, Crystal Report supports charts also,

Regards,
Anbalagan. K

Crystal Reports & pdf

Hi,

I have a question. How can i fill a report made in CrystalReports in .net

Thanks in advance

YOu should post that in Crystal reports related forums rather than in a SQL forum.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Saturday, February 25, 2012

crystal & SQL Server

Hi ,
I am new to Crystal reports and I wana use CrystalReports using SQL SERVER .
How can i create DSN with SQL Server ?
pls let me know
Thx and Regards
SamDisregard this if you think I have mistaken your question. I think you want to be able to get date from SQLServer database using CR. If so, here it goes, assuming you're using window XP:

1. Make sure you can connect to the SQL database. To check this, go to Control panel => Administrative Tools => Data source (ODBC) => check on either User DSN, System DSN or File DSN tab to see if your database show. If it doesn't, you can add new. I can't help you there because I don't know how you setup securities & stuff.

2. Once it shows, you can open up CR. Create new connection, go to ODBC sources, your SQL database name should show up here. If not, you did not configure / connect the SQL properly. Go back to step 1.

3. Select the database / tables that you need.

Good luck.|||Thx thg for your reply.
I would like to work on Stored procudures in SQL Server.. Is there any Ref-Cursor's available in SQL Server as Oracle ?
which is best suggested books Online for Crystal Reports and SQL Server ?
Thx and Regards
Sam|||Make sue of help files that are part of CR and SQL Server