is it possible to get two data field in same column...
if yes then how can we achieve...please
thank you in advance
pj
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
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.
Another way to do this is 'Unlock' the report and place the data item into the same column next to the first data item.
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
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.
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