two data filed in same column

[pooja]

is it possible to get two data field in same column...
if yes then how can we achieve...please

thank you in advance


pj

[pooja]

we have two data field from same table and same  data source....with same condition..
how we generate the data from both the field in same column of report..??

pj

[bonniehsueh]

Modify the formatting by displaying the fields in separate columns, but making the shared border of the two List columns and List Column Titles = 'none'.

Just did it in a list and it worked.

You may need to play with the column title. I left aligned the title so that you can't tell they are 2 columns.

[bonniehsueh]

Another way to do this is 'Unlock' the report and place the data item into the same column next to the first data item.

[pooja]

sorry for misunderstood

here is my table look like

date ---------------no---------------amount1------amount2
jan                       20                          12.16            44
feb                        20                          45               35
march                    20                          13               25
april                      20                           18                30
..                          20                           84               78
dec                       20                           23                45

no how can we display both amount1 and amount2 on same column like this

report page--

  date         no            total_amount
   jan          20                   12.16
   jan          20                    44
   feb          20                    45
   feb         20                     35
and so on.................

is it possible..??
pj

[bonniehsueh]

A Union will do the trick. Just tried it and it worked. The KB or report studio user guide should have an exercise on how to create a union.

[jahnavi]

Pooja,

first unlock and then in the column drag a table of 1 row and 2 columns and in that u can add the data items that will come .

Secondly in the layout change the heading name.

Thats it

if you have any questions let me know