crystal report with prompts

[chaitu123]

Hi All,
Need a solution for the below question

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

 

[IdoMillet]

In Crystal, move the condition from the Record Selection formula to the Group Selection formula.

hth,
- Ido

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

http://www.MilletSoftware.com

 

[chaitu123]

Hi Ido

Thanks for your reply.

When I give the prompt conditions directly in the sql query(command object),the report is not fetching the data.

please suggest something..

Thanks
Chaitanya