Crystal report - Data display issue

[Former Member]

Hi all,

I did a crystal report. the labels in the crystal report are

QTR1 QTR2 QTR3 QTR4

If I select the prompt value as QTR3, the values should display under QTR3, but data is displaying under QTR1

If I select the prompt value as QTR3 and QTR4, the values should display under QTR3 and QTR4 columns, but data is displaying under QTR1& QTR2.

i.e., the data is displaying in an order starting from first column.

Please let me know if I need to change any prompt settings to get the data in the order I needed.

Thanks in Advance.

Regards,

Viswa

[Former Member · Accepted solution]

I believe that you are getting all values irrespective of the prompt value.

You can create a suppress condition for each of the field value and show it corresponding to the prompt value.

For example, Let us take for QTR1

{prompt value} NE 'QTR1'

[Former Member · Accepted solution]

Hi ananth,

Please tell me the way how can we create a suppress condition for each of the field value and show it corresponding to the prompt value.

lets suppose, Field Names Q1 Q2 Q3 ...

prompt vales are q1 q2 q3...

in the prompt , if I select q2, the value of q2 should display under Q2. But the values are displaying under Q1.

similarly if I select q3 and q5 in the prompt, The values are displaying under Q1 and Q2 respectively.

This is the problem I am getting.

Please let me know how to use suppress condition. where is that option. I am new to BO and facing this issue.

Thanks in advance

Regards

Viswa.

[Former Member · Accepted solution]

there are 2 ways this can be done.

do they only run one qtr at a time?

you can create a group for each quarter

create a parameter to pull by quarter.

in the record selection place this statement

(if {@qtr}=0 then true else = {@qtr})

in the parameter place 0 if the qtr is numeric value otherwise place ALL (replace the 0 in the record selection with all if necc)

this will retrieve all the qtrs or the qtr specified.

if you create groupings for the qtrs place the value of the qtr in the details section below where you want to display qtr 2.

you will need to create formulas to differentiate the qtrs.

if qtr1 in date to date then $ amount

create a formula for all qtrs. this will display the dollar or value for the qtr date range only. otherwise a zero or null will be displayed.

right click on the section and go to section expert

in supress section click on the formual button

if qtr=1 then true. (keep in mind it is a supression formula so true will supress the qtr, false will display)

then on the values in the the detail section you can supress those based upon a formula also like above.

[Former Member]

Not enough information

Please shown formula where QTR1 , 2,3 & 4 are derived and how the prompts are used.

Ian