April 30, 2010 at 11:16 am
Hi,
If data to the report is comming from one SQL SERVER and i need the same report but the data from the differnt SQL SERVER without modifing the REPORT.I did this way:
1.set new odbc connection with different server .
2.replaced current connetion with new server connection using Set data source option in crystal.
But when i run the report i am not getting any data.
can anyone help me?
April 30, 2010 at 12:38 pm
What happens if you extract the query from crystal and run it directly on the new server?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 30, 2010 at 12:43 pm
I am not getting any data even if i run the query in SSMS.
April 30, 2010 at 1:56 pm
Then it sounds like the data does not meet the requirements of the query.
Check your data and your query. If the query works on one server but not the other, then I would lean to the data being at issue. Of course that is if the databases are exactly the same.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 30, 2010 at 2:34 pm
You are right ,i have excluded one condition and the query and report worked .right now i am using test database looks like i need to refresh it.
after refreshing from production it should work with the condition.
I will let you know if it doesn't work.
Can you tell me weather i am following the right way to change the servers and adding new data source to crystal reports.
April 30, 2010 at 2:43 pm
Good to hear.
It seems appropriate to me (your method for changing the connection).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply