Command Parameter Problems

[jenkoller]

I have read previous posts on adding a parameter in a command statement. I am using Crystal XI
Part 1) I got my report to work but have a problem in that I am prompted for the command parameter and then prompted again for this same parameter in the report parameters entry section. I do not want the user to have to enter this value in twice.

Part 2) The reason I am doing the command parameter is that when I tried to use a cascading parameter not all the fields were returned in the drop down selection list. I forwarded this problem to my Crystal instructor and he found that at 10,000 rows of data the cascading parameter did not work, but if he cut it down to 5,000 rows it did work. What I am looking for is that in my data each person who worked on a case is listed in the StudyClinicians table. Their role and full name are columns in the table. I am trying to narrow down the number of names in the selection list to only those associated with a certain role. Is anyone aware of cascading prompts not working with too many lines of data?

Any suggestions. Let me know info you need if this was not clear enough.

Thanks,

Jen

 

[muffntuf]

CR10 only brings back the first 500 rows of unique data or the first 5 seconds of unique data.

CRXI only brings back the first 1000 rows of unique data or the frist 5 seconds of unique data.


You could do a separate list and then import it, but then you would have to manually update it.

Or you could give the users the freedom to enter their own choices in the cascading parameter, which should work.

Other than that try creating a LOV in Business View Manager and running your paramemter off of that.

 

[jenkoller]

Thanks for the response. Unfortunately manually updated lists will not work for my situation. I also need some sort of list for the user to choose from. I am pretty close to coming up with what I need using a command statement. I just need to solve the issue of the parameter showing up twice, once for the command and once in the report parameter selection. Any suggestions on that?

 

[lbass]

Please see thread766-1157169. This is apparently a bug in XI that is fixed in Release 2.

-LB

 

[jenkoller]

When I read the information for this fix on the Business Objects website it says this is specifically for those using Visual Studio 2005. It states that "if you are not using Visual Studio 2005 you don't need Crystal Reports XI Release 2". Will this still help me? I am using Crystal Reports with SQL Server 2000.

 

[lbass]

I don't know. I haven't downloaded the hotfix myself. Maybe somebody else can jump in with their experience.

-LB