Print Page | Close Window

Append all database values not working

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3619
Printed Date: 12 Mar 2025 at 9:38pm


Topic: Append all database values not working
Posted By: frankz
Subject: Append all database values not working
Date 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?

Thanks,


Replies:
Posted By: rahulwalawalkar
Date 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.
 
cheers
Rahul
 

Posted By: frankz
Date 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?

Thanks for your help
Frank

Posted By: brendalisa
Date Posted: 27 Oct 2010 at 6:33pm
Were you ever able to get this figured out? It is SO weird. The appended data shows on my computer, but not on my boss's. Argh!

I hope there is a solution! Thanks!

Posted By: cousinbrucie
Date Posted: 21 Oct 2011 at 4:24am
I echo Brendalisa - "Were you ever able to get this figured out?"  Thanks.

Posted By: frankz
Date Posted: 21 Oct 2011 at 5:14am
Never able to figure out.  We changed parameter to a variable (prompting) instead of static.


Print Page | Close Window