Expand/collapse grouping in SSRS 2008

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Expand/collapse grouping in SSRS 2008

Author

Topic

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2011-11-02 : 04:47:38

Hi all,

I have an SSRS report. The report display like this format SAMPLE1. I have 21 itemid from cosmos.
when i expand the cosmos the result( please refer to sample 2) where us it should be like (sample3)
may i know what is the problem of my report?

i have two groups(from Tablix Member).
1. group1 under model
visibility = False
Toggleitem =

Row group1 properties
visibility = show

2. group2 under itemid
visibility = True
Toggleitem = Group1

Row group2 properties
visibility = hide
display can be toggled by this report item. = group1

(SAMPLE 1)
MODEL ---ITEMID----TOTALCOUNT
-----------------------------
COSMOS-------------21
LN510--------------36
LX600--------------97

(SAMPLE 2)
MODEL----ITEMID-----TOTALCOUNT
------------------------------
COSMOS---LG001-----1
LG002-----1
-----1
-----1

(SAMPLE 3)
MODEL----ITEMID-----TOTALCOUNT
------------------------------
COSMOS---LG001-----1
LG002-----3

to expand the LG002 the result should be like this.
MODEL----ITEMID-----TOTALCOUNT
------------------------------
COSMOS---LG001-----1
LG002-----1
-----1
-----1

Rgards and thank you in advance.

JOV

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-02 : 05:03:22

what are groupings you have added to report rows?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2011-11-02 : 05:13:39

Yes. I make 2 groups. group1 is the Model and group2 is itemid.

what is advisable to use expand/collapse report.
matrix or table?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-02 : 05:49:29

you can use both in sql 2008
it depends on whether you want row group only or both row and column groups

you should set property toggle visibility based on report item for child group items and link it to parent group textbox

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2011-11-02 : 22:31:42

Thanks Visakh,
Btw, I have another Query.

1. I have 3000 records in my report. I want to display it for every 45 records per pages.
the report i made doesnt have the group. the objective is to display in the screen 45 records
and even you scroll the screen it doenst move to next records until you click the next page.
May i know what should i do to set up like this format.

2. I have created a report with a sub report.
when i upload the may main report and run the main report the subreport does not appear in the main report. do i need also to upload my sub report?

3. i have Startdate and enddate date parameters. in report parameter
properties the datatype is date/time. how do i make it as short date.
if i used this format i got an error.

I wiould like th result should be like this.
01/01/2011 or
01/01/2011 00:00:00

Expression:
=FormatDateTime(Parameters!StartDate.Value,2)
=FormatDateTime(Parameters!StartDate.Value,"MM/dd/yyyy")

regards,

JOV

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-03 : 04:37:23

quote:
Originally posted by Villanuev

Thanks Visakh,
Btw, I have another Query.

1. I have 3000 records in my report. I want to display it for every 45 records per pages.
the report i made doesnt have the group. the objective is to display in the screen 45 records
and even you scroll the screen it doenst move to next records until you click the next page.
May i know what should i do to set up like this format.
Add a dummy grouping based on =(RowNumber(Nothing)-1)/45 and select property insert page break after group
2. I have created a report with a sub report.
when i upload the may main report and run the main report the subreport does not appear in the main report. do i need also to upload my sub report?
you need to upload it also to same project(folder) in server

3. i have Startdate and enddate date parameters. in report parameter
properties the datatype is date/time. how do i make it as short date.
if i used this format i got an error.

I wiould like th result should be like this.
01/01/2011 or
01/01/2011 00:00:00

Expression:
=FormatDateTime(Parameters!StartDate.Value,2)
=FormatDateTime(Parameters!StartDate.Value,"MM/dd/yyyy")
by default if its date time it will have timepart as 00:00 or 12 AM so it wont cause any issues when you select a date value through calendar control

regards,

JOV

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2011-11-03 : 05:04:30

Thank you very much Visakh.
Btw, in my subscription i have the startdate and endddate.
the enddate is should always be the current date. do i need to check or uncheck the use default. is this automatically increment the date. ex. today is 11/03/2011 the tomorrow it should be now 11/04/2011. thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-03 : 05:24:09

why not set it to an expression to use Now() function

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2011-11-03 : 05:39:56

Again, Thank you very much for your help.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-03 : 07:33:33

wc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources