January 11, 2012 at 7:22 am
I created a report using the Report Wizard and I Grouped by State.
I selected the option to Drilldown and everything works fine.
When I create a report from scratch I can't figure out how to do this.
I created a simple Report and Grouped by State.
The Detail Items are CompanyName, City, State, Zip.
I tried goggling this but the samples that I tried to follow did not work out.
Any help would be greatly appreciated.
Thanks!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 11, 2012 at 7:44 am
Right click on the gray bar margin of the detail row and add a parent group using State.
Then after the group is set up and working properly right click on the left most detail row textbox with data, and choose Row Group. Go to the Visibility tab and choose Hide, then check "Display can be toggled..." and choose the textbox name (usually the textbox for the group immediately above the detail.
January 11, 2012 at 8:19 am
Sorry but I do not follow you.
I have a row with the Column Names.
Then I have a group with the State.
On the Detail row I have the Company Name, City, State & Address.:unsure:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 11, 2012 at 8:22 am
Disregard the last post.
I figured it out.
Thanks for the instructions.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply