FAQ-How can I use a Multivalue or Date Range Parameter with a Command 1

[RustyAfro]

Hi everyone, I just loaded my first faq:
faq766-6779.

You guys have helped me figure out a lot and I wanted to give back something to the community.

I have seen this issue come up before and have run into myself. I finally figured out a workaround to it.

It is of course a last resort. You should always use CR's SQL generation whenever possible. A View would be my second choice. But in those cases of a very unfriendly dba, this method can help you get a command working with user friendly prompts that is all evaluated on the server.

I hope this helps some of you! :

Joel Seguin

 

[IdoMillet]

Nice job, and a star vote from me...

The main limitation is that the report can't contain a subreport. This is because this technique requires that the original report becomes a subreport (and a subreport can't contain a subreport).

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[RustyAfro]

Agreed, but many reports do not need subreports so the technique should work often. Hopefully CR will add better command functionality in the future (2008 doesn't seem to have it).