cancel
Showing results for 
Search instead for 
Did you mean: 

Different selction formuls for columns in report

Former Member
0 Kudos

Hi All,

Please help me.

I want to add different selection formulas to different columns in report.

example:-

Table 1 :- ID | Marks

1 | 24

2 | 25

In report I have to show it as :

Column1 (Select Marks from Table1 where ID =1) | Column2 (Select Marks from Table1 where ID =2)

24 | 25

How can I do that ?

Please help me. Any comment is valuable for me.

Thanks .

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

i think you just need to create 2 formulas

Marks ID =1

Marks ID =2

then create a group from each formula

this should pull your associated records

Answers (2)

Answers (2)

Former Member
0 Kudos

...just read your post again...

If your intention is to list fields in columns then...

In design mode, right-click the "Details" section and select "Section Expert".

Make sure "Details" is highlighted. In the right hand pane, select "Format with multiple columns". A new tab named "Layout" appears. Select the Layout tab.

Under "Printing Direction", select "across then down"

Former Member
0 Kudos

Hi Jeff,

Thanks for reply.

In my case i cant use dynamic cascading prompt and according to your second reply its not the case to show only columns horizontally. Please see below modified question again:-

example:-

Table 1 :- ID | Marks

1 | 24

2 | 25

3| 28

4| 30

5| 40

6| 50

In report I have to show it as :

Column1 (Select Marks from Table1 where ID =1) | Column2 (Select Marks from Table1 where ID =4)|column 3 (Select Marks from Table1 where ID =5)

24 | 30|40

How can I do that ?

Do you have its solution? Please reply

Thanks .

Former Member
0 Kudos

Girish,

According to your example, you want to create a multi-select prompt where you can select the IDs with the Marks you want to display.

I would then create a formula that 'pads' the returned 'Mark' values so they are all the same character length. Then follow the procedure described in the previous post to print the records horizontally. That should give you the desired output.

Former Member
0 Kudos

Hi

keep all these records in detail section. Put two formula's in detail section, each with different selection criteria. In these formula's claculate the value of two different variables based on the selection criteria's mentioned in your question. In the footer section, display the value of these variables along with other fields of report.

Other solution could be to use suppression logic for individual fields to achieve this. This is same as we do for the complete record when some particular ones are required on the report and others are not.

However, in this case, you would need to adjust other fields also to make sure you have equal number of rows from each column.

Hope this help you!!

Former Member
0 Kudos

Hi Jeff,

Its really not possible to use prompt for the ID as per report requirement . Please tell me some different solution.

Thanks for comment.

Please help.

Former Member
0 Kudos

Hi Akhilesh,

Can you please give your solution in detail. I didnt get it.

Thanks for comment.

Former Member
0 Kudos

Girish,

Your description seems perfect for Dynamic Cascading Prompts...

...In your case, they will allow to select a value from column 1, then restrict the selection in column 2 to only those values that match column 1.

First, add the fields you would like displayed in your report.

Next, in the Field Explorer pane, right click "Parameter Fields" and select "New"

In the resulting dialogue box, type a name for parameter,

Under "List of Values", change "Static" to "Dynamic".

Type a name for the parameter group.

Under "Value", select the field you want for Column 1.

Click on 'Parameters" to create the prompt.

Add the second parameter for column 2 in the next row under the first one.

In the values option, you can change the text displayed for each prompt and set other values.

Click "OK" when done.

Next, on the main menu under Report, click the "Select Expert" and choose "Record". This process will filter the report fields to those selected in the prompts. Set the column 1 prompt equal to the column 1 prompt. Do the same for column 2.

Run the report. This should get you started in the right direction.

Hope this helps!