Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
In a table each detailrow display two rows from the dataset
Phill
Hello,
i hava a dataset with within my sql expression.
Now i want to display in a table on each row two "rowsets".
e.g.
On one line are two rows!
+
+
+
+
+
|firstname + lastname + firstname + lastname |
|
+
+
+
+
|firstname + lastname + firstname + lastname |
|
+
+
+
+
How i can display two rowsets in one row.
Find more posts tagged with
Comments
ahsiang
Hi, just add a new detail line into your table. Have a look at this attached report.
arunkumarb
Hi,
Take one table with four columns. Now drag the first value and place that value in first column. In the Same way drag the first value and place that value in second column. Like that do the same thing for second value. Check it once,
Regards,
Arun
Phill
Hi,
thanks for your answers.
I think i have describe my problem a little bit wrong.
I want to see in one row two records / entries of the database.
+
+
+
+
+
|firstname-1 + lastname-1 + firstname-2 + lastname-2 |
|
+
+
+
+
|firstname-3 + lastname-3 + firstname-4 + lastname-4 |
|
+
+
+
+
After the cols is e.g. the id of the employee.
mwilliams
The best way to do this is to add a computed column to your dataSet that do a runningcount. Then, in your layout, put a 1 row, 2 column grid. In each grid put identical tables with the columns you want. Finally, for the first table, add a filter like row["myNewColumn"]%2 equal to 1 and for the second table one like row["myNewColumn"]%2 equal to 0, where myNewColumn is your runningcount computed column you added. That should do it.
Phill
Hi,
thank you very much, it works perfectly
mwilliams
Not a problem. Let us know whenever you have questions!