I am creating a vb.net application with sql server 2008/2012 backend. This will be deployed to different police departments, which of course will have different server names. I am trying to create the reports using crystal reports.
I did some research on how to set the connection info in the backend code, however during the design of the crystal reports how do I set this up? Do I need to create a .xsd file and link it? Or if I set the datasource inside the crystal reports design to my development database, will the code-behind (that changes the datasource) override the datasource selection when I designed the crystal report?
I'm confused, any advice?