Click here to Skip to main content
15,905,776 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have a problem with crystal reports..

I have a designed a crystal reports by using the wizard. i.e., When i gave the database i just dragged and dropped the columns into the report and now the problem is i want to change the connection of database for that report... How can i change... If i delete the Table from the crystal report Field Explorer all the labels and controls are deleted from the crystal report also... so how can i change the design and connection for crystal report...And then how can i deploy the crystal report to my client as his database name is different ..... Please provide me a solution for this....
Posted
Comments
J.Karthick 11-Aug-11 2:17am    
Deleting table sure remove your added controls inside CRYSTAL. I think you dont have any other option. May be you can create an Dummy table that resembles the structure(Not sure).

Adding tables inside Crystal report may be easy for an SINGLE TABLE reports. Why don't you try it by adding VIEWS for each report?. It will useful while you are generating reports by merging two or more tables.

Already answered for similar question few months ago

Best Practices for Changing Database at Runtime[^]
 
Share this answer
 
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900