Joined: 07 Jul 2008
Location: United States
Online Status: Offline
Posts: 3
Topic: Append all database values not working Posted: 07 Jul 2008 at 2:27pm
Using Crystal XI, create a static parameter, try to append database values but no data appears. Database connection appears to working since it same database table and field are used values appear in report. What would cause no data to appear for static parameter?
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Posted: 08 Jul 2008 at 12:39am
Hi
Check for ... the type of static parameter you are trying to create is the same as your field e.g. Database Field is string and type is Number then if you do append all no data will appear.
Joined: 07 Jul 2008
Location: United States
Online Status: Offline
Posts: 3
Posted: 08 Jul 2008 at 6:50am
Thanks for your response.
Confirmed data types are the same (string - varchar2). The strange thing is if I create the same static parameter on a different PC it works. I've compared CR option settings, confirmed using same DB connection... Are there other configuration settings that should be looked at?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
