Dynamic parameter value report 1

[jehanzebn]

Afternoon all,

I have to setup a report based on the dynamic parameter values and am not sure how it can be done?.

I have dynamic parameter ({product_desc}, the report should show prices according to whatever description has been selected from the dynamic parameter.

For example

Parameters
=============
Account Number:
Description: Supra, Supra KNT, Metal, Plastic, Rimless, Rimless KNT (multiple selection)

Report Layout
============
Account Number --- Account Name --- Supra - Supra KNT - Metal - Plastic - Rimless - Rimless KNT

(Where Supra to Rimless KNT options are chosen by Descriptive parameter value - if not chosen then report will only show account number and account name).

If however only Supra is selected then the report would look like this

Report Layout
============
Account Number --- Account Name ---Supra
00100100 --- Company Name --- £0.99

Any ideas how to achieve this kind of report? I have setup the report in a landscape so that we can fit as many description values as possible.

The report is Grouped by Account number, Account Name is brought from the field, Sales Price is a conditional running total based on the dynamic parameter but that does not seem to work if multiple values have been selected in the parameter.

I am not sure how to show multiple values based on the multiple parameter values onto the report.

Any help would be highly appereciated.

Regards

Jehanzeb
Crystal Reports 2008
Visual Studio 2008
Informix Database

 

[IdoMillet]

Use a CrossTab with Descriptions as columns, Account Number and Account Name as rows.

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[jehanzebn]

I was trying to avoid crosstab as I am not sure if it will export the data into Excel properly after using it. Plus there are quite alot of limitations in Crosstab.

Saying that, I am trying it with Crosstab and will post the result soon.

Many thanks once again

regards

Jehanzeb
Crystal Reports 2008
Visual Studio 2008
Informix Database