Binding data

Hi, I have a dataset with the fields name and city.
One name can have different cities. Is there any way that I can create a report that looks like this?

| Name | City 1 |City 2 | ...

Find more posts tagged with

Comments

mwilliams

Does your data come in your result set in the form of:

Name : Country
Alex : Spain
Alex : Italy
Peter : Mexico
Thomas : Germany

??

If so, you could group by the "Name" field, delete the detail row, and in the second column of the Name Group Header, you could put an aggregation that does a "concatenate" over the group. Let me know.

pJune

My dataset is like this:

Name: Alex, Peter, Thomas
Country: Spain, Italy, Mexico, Germany

Instead of displaying the data grouped bu name like

Name---Country

Alex

Spain

Italy

Peter

Mexico

Thomas

Germany

and I would like it be

Name Country 1 Country 2

Alex

Spain

Italy

Peter----Mexico

Thomas---Germany

Is that possible?

mwilliams

If your dataSet is how you say it is, how do you tell which country is for which name? Either way, my suggestion was for you to group by name and then use a concatenate aggregation in the group header to display the countries. You would delete the detail row.

pJune

It is one dataset with two data elements. This is how it looks in the Query window when I preview the results:

Name

Country

Alex

Spain
Alex

Italy
Peter

Mexico
Thomas

Germany

mwilliams

The same solution I've given in my last two posts will do it. Try it and let me know what issues you have with it. Drag your dataSet from the data explorer into the design layout. Select the table, add a group on the name field, delete the detail row, drag an aggregation from the palette into the second column in the group header row. Select "concatenate" from the drop down for the agg function, choose your country column for the expression, make the separator "," or "--" or whatever you want and then run the report. Let me know what issues you have with the output.

pJune

That worked, thank you so much for your help

mwilliams

No problem at all. Let us know whenever you have questions!