Listing & Aligning data using many datasets

olivia08

I'm trying to display several columns of data where each column comes from a different data set. Basically I want it to list all Group Names along with their counts in each column.

Each dataset contains a Group & Count column and I have about 4-5 dataset in total. To start, I tried creating a Joint Dataset between two of the datasets using a full join on Group to see if that might get me what I want. But after doing that I have two output columns for Group and I need them in one so that one list of Groups will list out.

For example...
If the joint dataset columns are: DatasetA_Group, DatasetA_AcctsCreated, DatasetB_Group, DatasetB_AcctsDeleted

How can I display one group list (combine DatasetA_Group & DatasetB_Group) and then get the Accts Created and Accts Deleted values to align to the applicable group?

Also, when adding additional datasets to display with this output, do I just created a new joint dataset with the current one to get a new column added (i.e. accts updated)?

I'm confused.

Hans_vd

Hi Olivia,

You could add as many detail rows in your table as there are datasets.

So for your example you would add two detail rows, 1 detail row contains DatasetA_Group and DatasetA_AcctsCreated and the second detail row contains DatasetB_Group and DatasetB_AcctsDeleted

Then for the first detail row create a visibility expression like this:
- if (row["DatasetA_Group"] != null) false; else true;

Do the same for the other detail row with row["DatasetB_Group"]

Some time ago I wrote a blogpost about this, only difference is that I do the join in the SQL: http://enterprisesmartapps.wordpress.com/2011/10/11/showing-different-data-records-in-the-same-report-table/

Hope it helps
Hans