December 23, 2015 at 3:42 pm
I could use a little help with an SSRS report (2008 R2+).
I have dataset with a parent group, and 2 different sets of child data being returned by a single query, for example:
SELECT
[ParentName]
, [ParentAge]
, [ChildName]
, [ChildAge]
, [PetName]
, [PetAge]
FROM [Family];
My desire is to have the parent name and age displayed and two separate (initially collapsed) row groups to display children names/ages and/or pet names/ages.
I've added a table for the query above with a parent group "ParentName" and 2 adjacent child groups for "ChildName" and "PetName".
Everything displays fine until both adjacent child groups are initially hidden (toggle by parent textbox click), in which case, I get no data on the report at all, not even parent group data. There are no expansions [+] displayed at all, all I get is a blank page.
I can set either adjacent child group to be initially visible, and I see my data and the toggle works fine, but the preference is to have both child groups collapsed initially. Any thoughts? I'm trying to avoid having to create sub reports for something that seems like a fairly simple report!
January 1, 2016 at 3:01 pm
I wonder whether it might have something to do with the way you've structured your original query. It might be worth looking at having a column called "subordinate type" (pet, child) and collapsing Pet Name and Child name into a single "name" column and same with Age. That way the adjacent groups will be independent of one another.
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply