I just recently ran into an issue getting some reports that I created for a customer to run in their reports viewer.
My client does not have Crystal Reports designer. Instead they have a report viewer built into their helpdesk application (Frontrange HEAT). This viewer is %100 supported by SAP because they license it to Frontrange. Also, Crystal Reports has special .dlls made for HEAT.... back to the issue.
My client asked me to create some custom reports and set them up to be viewed through HEAT. I created the reports and set them up in the report viewer. Every report that I created failed with a "field name is not known" error.
Keep in mind that I built these reports off-line with a copy of their DB running on my SQL server. I used the same DSN name for my connection as the client uses for theirs.
I THOUGHT that it would be enough to use the same DSN name but that is clearly not correct. I fixed the problem by loading a 30 day eval on one of their machines and resetting the Datasource connection. BUT.......
What I would like to know is what can I do in the future to ensure that the reports that I create off-line will run on my clients viewers when I deliver them. Is there some setting that I can make to the report? Is there some hidden metadata that I'm not aware of?
Any and all suggestions are appreciated.
Edited by tdavenport - 19 Mar 2009 at 2:43pm
IP Logged
