Crystal report with prompts (1 Viewer)

[chaitanya]

Hi All,

In my crystal reports I am using command object with direct SQL query and I have dynamic prompts for which I am using Business Views.
If we use dynamic prompts with business views, we normally give the prompt condition in Report->Selection Formulas->Record
and we have to use all the prompts (objects) in the SELECT clause of the query.

But I don't want to use the prompt objects in the SELECT query as my query has GROUP BY clause and if I use them in the SELECT caluse it is changing the output.

So is there any way to use the dynamic prompts in the report and not use them in SELECT clause.
The version is XI R2.

Let me know if I am not clear or you need more info.

Thanks in Advance

 

[chaitanya]

crystal report with prompts

Hello All

Please help me out to solve the problem which i mentioned above.
Its a bit urgent for me.

Regards
Chaitanya.