on 02-10-2012 12:02 AM
I have changed some of my reports into a new DB. till yesterday everything was working fine but today the views are not pointing to the primary keys.
When I check in the Database(SQL) evrything works fine but it is not working with the crystal reports.
What could be the problem.
Did that too but didnt work
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To be sure shot Reports that have passed as of last night and that are normally loading they are no longer loading right now..some fields are not showing up in crystal reports but are in the database
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Has anything on the database changed?
Could you do a 'Verify database' (Go to the Database option in CR designer > Verify Database) and see if it helps?
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So, you're saying that you changed the datasource of the reports to Database B from Database A; it worked fine until yesterday.
Now, some fields are missing and it gives you an option to Map fields?
Are all the fields available when you create a new report?
Could you try changing to ODBC/OLEDB/Native?
-Abhilash
It would really help a lot if you provide all of the info. 8 replies with nothing more than yes and no....
What version of Crystal Reports are you using?
Any patches installed?
What version of MS SQL Server?
How are you connecting and what Client Driver are you using, OLE DB or ODBC or JDBC?
Which Client dll are you using, SLQNCLI, SQLNCLI10 or the drviers included with MDAC?
What do you see if you create a new report, are all of the fields there?
What happens if you check off everything except Tables in the connection Options?
Don
We are using Crystal 08 and the server is SQL server MS08
we are connecting using the ODBC with SQL native client 10.
Even though we are developing some reports from scratch some of the fields are not showing up
if I write the same query in SQL server I get all the values.
I am unable to know why certain fields are not showing up.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.