cancel
Showing results for 
Search instead for 
Did you mean: 

VS2008, Print, Web report

Former Member
0 Kudos

I'm using the (push) method for web application Crystal Repot in Visual Studio 2008 Crystal Reports for VS 2008 version.

I just create a dummy stored procedure to just provide appropriate fields for report and at design time link to that SP for design after report design in application I set CrystalReportSource control's report file .rpt and set DataSources to SQLDataSource control and add required parameters and set their values by setting controls on Web form.

The report is generating and showing perfect on web page, I'm using the PDF method but when I click built-in Print button on report it shows this error.

-


Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: Login failed for user 'sa'. SQL State: 28000 Native Error: Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: Invalid connection string attribute SQL State: 01S00 Error in File C:\Windows\TEMP\SalarySheet {6F29D7CE-00C0-482C-BC89-2A6873008F85}.rpt: Unable to connect: incorrect log on parameters.

-


What I've diagnosed the problem but didn't find any solution. By clicking built-in Print button on report it try reconnecting to the original data source that was used at design time.

Why it's connecting to design time data source? Obviously after deployment the design time data source will not be available.

Accepted Solutions (1)

Accepted Solutions (1)

former_member183750
Active Contributor
0 Kudos

It's trying to connect to the original DS because the data presented to it in the dataset does not agree with the structure of the stored proc. I suspect the reason you can view the report is that you have "Saved data" flag enabled on the report. When you try to print, the report attempts to get fresh data, 1st from the DS, which fails, then from the database.

To troubleshoot the issue, see [this|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13270] [original link is broken] [original link is broken] [original link is broken]; blog.

Also, I'd recommend that you are on CR Service Pack 3:

https://smpdl.sap-ag.de/~sapidp/012002523100007123572010E/cr2008_sp3.exe

MSI:

https://smpdl.sap-ag.de/~sapidp/012002523100007123592010E/cr2008sp3_redist.zip

MSM:

https://smpdl.sap-ag.de/~sapidp/012002523100007123582010E/cr2008sp3_mm.zip

Ludek

Answers (0)