Embed SQL Password into Crystal Reports RPT file?

Posted by codeulike on Stack Overflow See other posts from Stack Overflow or by codeulike
Published on 2010-04-28T14:52:40Z Indexed on 2010/04/29 11:37 UTC
Read the original article Hit count: 1059

Filed under:

crystal-reports

|

reportviewer

|

odbc

We are experimenting with Crystal Reports viewers such as this one:

http://www.thereportviewer.com/

... which can actually re-connect to the data source and re-run a Crystal Reports RPT file with live data.

However when running the report the viewer asks for a password to connect to the data source (in this case SQL Server).

Does Crystal Reports have some way of embedding a connection password into a RPT file to avoid this? Or should I be using a System DSN from the Control Panel/ODBC thing to get around this?

I figure someone else must have had this problem.

© Stack Overflow or respective owner

Related posts about crystal-reports

Crystal Reports: Save Time with Formula Sharing

as seen on ASP alliance - Search for 'ASP alliance'
Once a report library grows to a certain size there are always going to be common formulas which are needed repeatedly. Having easier access to them can save a lot of development time. >>> More
Automate delivery of Crystal Reports With a Windows Service

as seen on ASP alliance - Search for 'ASP alliance'
In this article, Vince demonstrates the creation of a Windows Service to automatically run and send a Crystal Report as an email attachment. After a basic introduction, he examines the creation of the database and windows service with the help of relevant source code and explanations. Towards the… >>> More
Crystal Reports for VS deployment to Web Application doesn't work (3 replies)

as seen on .NET 247 - Search for '.NET 247'
I've followed the "documentation" for getting crystal reports to work on a production web site. I've migrated a VS 2003 web project to a VS 2008 web application. Everything works fine on my dev box. publish the site out to the server (2003 X86) and no go on the reports, get the infamous:… >>> More
Crystal Reports: 5 Tests for Top Performance

as seen on ASP alliance - Search for 'ASP alliance'
Your masterpiece report is now complete. It doesn't just meet your customer’s expectations, it blows them out of the water. All they want is a beautifully-summarized report that can be displayed in a myriad of ways. Then disaster strikes! You try to run the report for a month against the live database… >>> More
Crystal Reports for VS deployment to Web Application doesn't work (3 replies)

as seen on .NET 247 - Search for '.NET 247'
I've followed the "documentation" for getting crystal reports to work on a production web site. I've migrated a VS 2003 web project to a VS 2008 web application. Everything works fine on my dev box. publish the site out to the server (2003 X86) and no go on the reports, get the infamous:… >>> More

Related posts about reportviewer

Using ReportViewer 9 control in VS 2010

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am writing an ASP.NET app that uses a SQL Server 2005 with SSRS setup. I want to use the ReportViewer control but I get an error when using ReportViewer 10 because it needs SSRS 2008. How can I use ReportViewer 9 within my application. I've added a reference to the Microsoft.ReportViewer… >>> More
c# WinForms ReportViewer Performance issue using RefreshReport() and ServerReport.SetParameters()

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, Currently I am writing a c# client application that uses the WinForms ReportViewer Control to display reports from a remote server. I am having performance troubles with the ReportViewer Control, to be specific with the 2 methods reportViewer.ServerReport.SetParameters() and reportViewer… >>> More
Crystal Reports Reportviewer - Set Datasource Dynamically Not Working :argh:

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm running CR XI, and accessing .RPT files through a ReportViewer in my ASP.NET pages. I've already got the following code, which is supposed to set the Report Datasource dynamically. rptSP = New ReportDocument Dim rptPath As String = Request.QueryString("report") … >>> More
ASP.NET Session does not timeout on using ReportViewer Control.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, We are using the ReportViewer control to display SSRS reports in our ASP.NET application. On pages where we use the ReportViewer control the session does not time out. The reason for this is the ReportViewer control emits a "setTimeOut" javascript function which reads the Session timeout value… >>> More
The Low Down Dirty Azure Blues

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Remember the SETI screen savers that used to be on everyone's computer? As far I as know, it was the first bona-fide use of "Cloud" computing…albeit an ad hoc cloud. I still think it was a brilliant leveraging of computing power. My interest in clouds was re-piqued when I went to a technical… >>> More