Dynamic Parameters Cystal Reports 8.5

[Phil99]

Hi,

I have recently taken over the responsibility for reporting using Crystal for my Organisation. We have a large number of reports which use customer parameters, our customer list is constantly being amended.

I was informed by the person that previously looked after reporting that the if customer list changed in our database the parameters in the Crystal report would need to be manually updated using the Set Default Values option. I cannot believe this is true, as it causes a massive overhead to maintain reports.

So basically all I need is when the database values change the crystal report menu options will automatically be updated.

Thanks

Phil

 

[lyanch]

Sorry to disappoint you, but the previous Crystal person was correct. There is no dynamic upload of paramter lists. I think some people have created code to do this, but it still appears to be a bit of a maintenence nightmare as you noted.

My personal approach is to not "limit" to the list, so that users can get the information if they know the company name etc. I then have scheduled updates when I go and update the list.

For lists that change daily, I usually don't give a list, but allow wildcards (like instead of =). There have been a few occasions when I couldn't do this because of performance issues, but usually it will work.

Good luck,

Lisa