Friday, December 14, 2012 11:42 AM
Hi i would like to ask, if you have those records in database
ID City Country 1 New York USA 2 London Europe 3 Madrid Europe 4 Washington USA
Can you do by some select this kind of view?
ID City Country 1 New York USA 2 London Europe 3 Madrid 4 Washington USA
Friday, December 14, 2012 12:03 PM
Friday, December 14, 2012 12:47 PM
And how can you display it by client?
Is for this any command?
Friday, December 14, 2012 1:06 PM
Use the Hide Duplicates property on the textbox displaying the Country. Set it to "Details".
Hope this helps!
Friday, December 14, 2012 4:50 PM
If you are using SSRS, your can achieve by Grouping data and use single group.
Monday, December 17, 2012 3:05 PMModerator
In order to meet your requirement,please refer to the following steps:
1. Add the field"Country" as parent group in the table data region and add field"City" and "ID" in detail group.
2.Select the whole table and in the Tablix properties dialog box,specify the LayoutDirection value with "RTL" in Font section.
3.Select the textbox which display the "Country"values and in the textbox property dialog box, Specify the TextAlign value with"Center".
The following screen shot show a similar report in my test environmnet, please take as reference.
TechNet Community Support
Friday, December 28, 2012 10:43 AM
Hi Fanny Liu
ok this I know how to do in report builder 3.
But can you do it just with sql commands?