S
SWu
Hi all
Could someone please tell me how to configure and deploy my Crystal reports?
Any help would be greatly appreciated. I want to be able to deploy my
reports/web pages to another domain, web server, database and have the
report connect via integrated security.
1. I have created a stored proc in my SQL Server db, created a report in my
ASP.NET project, created a reports.aspx and placed a CrystalReportViewer on
the page. This is the "pull" type of report that I've read about in the
documentation. All this works fine on my development machine. I can
navigate to the page and view the report. I am using Visual Studio.NET 2003
and the framework is 1.1.
2. I copied the reports.aspx and my website's DLL to the production server
which is on another machine with its own database and part of another
domain. When that didn't work, I saw a newsgroup item somewhere that said
Crystal comes with Visual Studio, not the framework so I stuck the Visual
Studio.NET 2003 installation CDs into the production machine and installed
just the Crystal parts of it.
3. With all my previous pages, this was not a problem because I could put
the connection string into the Web.config. Can I do this easily for reports
or do I have to turn the reports to "push" type (i.e. build up the dataset
etc and then pass it to the report when you want it displayed) first?
4. Assuming I couldn't use the web.config approach to connection, I then
tried to "Set Location" in the "Field Explorer". Unfortunately, when I
tried to replace the existing connection location with the one I want,
crystal/vs.net immediately verified the connection. I had selected
"integrated security" so that stuffed me up. I then thought I'd try with a
username and password; I was then able to complete the "Set Location"
operation and rebuild my website.
Could someone please give me some pointers? Thank you very much.
Stephen
Could someone please tell me how to configure and deploy my Crystal reports?
Any help would be greatly appreciated. I want to be able to deploy my
reports/web pages to another domain, web server, database and have the
report connect via integrated security.
1. I have created a stored proc in my SQL Server db, created a report in my
ASP.NET project, created a reports.aspx and placed a CrystalReportViewer on
the page. This is the "pull" type of report that I've read about in the
documentation. All this works fine on my development machine. I can
navigate to the page and view the report. I am using Visual Studio.NET 2003
and the framework is 1.1.
2. I copied the reports.aspx and my website's DLL to the production server
which is on another machine with its own database and part of another
domain. When that didn't work, I saw a newsgroup item somewhere that said
Crystal comes with Visual Studio, not the framework so I stuck the Visual
Studio.NET 2003 installation CDs into the production machine and installed
just the Crystal parts of it.
3. With all my previous pages, this was not a problem because I could put
the connection string into the Web.config. Can I do this easily for reports
or do I have to turn the reports to "push" type (i.e. build up the dataset
etc and then pass it to the report when you want it displayed) first?
4. Assuming I couldn't use the web.config approach to connection, I then
tried to "Set Location" in the "Field Explorer". Unfortunately, when I
tried to replace the existing connection location with the one I want,
crystal/vs.net immediately verified the connection. I had selected
"integrated security" so that stuffed me up. I then thought I'd try with a
username and password; I was then able to complete the "Set Location"
operation and rebuild my website.
Could someone please give me some pointers? Thank you very much.
Stephen