Hi! Is there an equivalent EOF function in Crystal Reports 8.5.?
I want to use a Do While Loop, but dont know the number of records so
I want to use the EOF so it will terminate upon reaching the end of the
file.
Thanks.you can have RECORD COUNT so based on that number you can specify total number of loops you will require in report
Showing posts with label crystal. Show all posts
Showing posts with label crystal. Show all posts
Thursday, March 29, 2012
Wednesday, February 15, 2012
Enter userid and password for the databse (Crystal Reports 10)
Hi,
I have updated crystal reports from version 8 to 10. Updated the datasource, using odbc connection to connect to SQL Server. Reports run fine on my machine. When I run reports on the server I get enter userid and password for the database. Looks like, when I run reports on the server it's caching Server name from my machine. I have clear cache on the server which did not help. I am sending userid and pwd in the URL to Crystal reports. Please let me know, if there is a work around. FYI, reports work fine in production.
Thanks in Advance,
BhavnaDon't check Trusted connection checkbox when setting Datasource location. Unchecking this check box resolved the issue.
-Bhavna
I have updated crystal reports from version 8 to 10. Updated the datasource, using odbc connection to connect to SQL Server. Reports run fine on my machine. When I run reports on the server I get enter userid and password for the database. Looks like, when I run reports on the server it's caching Server name from my machine. I have clear cache on the server which did not help. I am sending userid and pwd in the URL to Crystal reports. Please let me know, if there is a work around. FYI, reports work fine in production.
Thanks in Advance,
BhavnaDon't check Trusted connection checkbox when setting Datasource location. Unchecking this check box resolved the issue.
-Bhavna
Subscribe to:
Posts (Atom)