Not sure if this is quite the right place to ask, but I'm not sure anywhere else is wholly appropriate, either.
Problem: I have a report that filters based on the contents of a field (a person's name). The values that it filters on are entered by the person who brings up the report. Because the values being filtered on are relatively long, the client wants this to be selectable from a drop down box (no sweat so far, right?). Now, Crystal really only handles static selection lists for this sort of thing, so someone would need to maintain that list to keep it up-to-date in the event that the underlying data changes. Long and short of it is that nobody is going to do that -- it isn't going to happen. Additionally, this report needs to be integrated into Crystal Enterprise via a Digital Dashboard interface which doesn't seem to allow for placing an ASP as an interface to the report, unfortunately (although if anyone knows differently, I don't mind being wrong). Is there any way to keep this report up to date without human intervention?
Problem: I have a report that filters based on the contents of a field (a person's name). The values that it filters on are entered by the person who brings up the report. Because the values being filtered on are relatively long, the client wants this to be selectable from a drop down box (no sweat so far, right?). Now, Crystal really only handles static selection lists for this sort of thing, so someone would need to maintain that list to keep it up-to-date in the event that the underlying data changes. Long and short of it is that nobody is going to do that -- it isn't going to happen. Additionally, this report needs to be integrated into Crystal Enterprise via a Digital Dashboard interface which doesn't seem to allow for placing an ASP as an interface to the report, unfortunately (although if anyone knows differently, I don't mind being wrong). Is there any way to keep this report up to date without human intervention?