Page 1 of 2
Select Records for CrossData Band.
Posted: Thu Apr 04, 2013 7:51 am
by 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?
Re: Select Records for CrossData Band.
Posted: Thu Apr 04, 2013 8:42 am
by Alex K.
Hello,
Can you please send us your a sample report with test data for analysis.
Thank you.
Re: Select Records for CrossData Band.
Posted: Thu Apr 04, 2013 9:01 am
by amitkaushik
Please take help of image for that...
Re: Select Records for CrossData Band.
Posted: Thu Apr 04, 2013 9:44 am
by Alex K.
Hello,
Please try to use the Distinct construction in your query.
Thank you.
Re: Select Records for CrossData Band.
Posted: Thu Apr 04, 2013 9:51 am
by amitkaushik
thanks but I can't do that, can I do something with DataSouce?
Re: Select Records for CrossData Band.
Posted: Thu Apr 04, 2013 11:32 am
by 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.
Re: Select Records for CrossData Band.
Posted: Thu Apr 04, 2013 11:46 am
by amitkaushik
Yes I already try that but DS still have multiple records for same IDs.
Re: Select Records for CrossData Band.
Posted: Thu Apr 04, 2013 1:57 pm
by Alex K.
Hello,
Please send us your report with test data for analysis.
Thank you.
Re: Select Records for CrossData Band.
Posted: Mon Apr 08, 2013 6:05 am
by 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
Re: Select Records for CrossData Band.
Posted: Mon Apr 08, 2013 12:17 pm
by 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.