Select Records for CrossData Band.

[amitkaushik]

Hi,
I have a datasource hold the multiple rows for same "ID".
I use that DS for crossdataband and i need to show an ID single(First Record) time with complete row elements.
How can I avoid another rows to print in Cross Band?

[Alex K.]

Hello,

Can you please send us your a sample report with test data for analysis.

Thank you.

[amitkaushik]

Please take help of image for that...

[Alex K.]

Hello,

Please try to use the Distinct construction in your query.

Thank you.

[amitkaushik]

thanks but I can't do that, can I do something with DataSouce?

[Alex K.]

Hello,

As a way, you can try to add the additional data source as "Data from Other DataSource" in which you can use the grouping by ID.

Thank you.

[amitkaushik]

Yes I already try that but DS still have multiple records for same IDs.

[Alex K.]

Hello,

Please send us your report with test data for analysis.

Thank you.

[amitkaushik]

Please find the attached files.
In that XML we have more the one values for ID '1' but I want to present first one on the report.

Thankyou

[HighAley]

Hello.

You should to set the Expression of the Cross-Group header to {Column.ID} and move all text components on this header.

Thank you.