Skip to Content
0
Former Member
Jan 08, 2011 at 10:24 AM

VS2008, Print, Web report

22 Views

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.