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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Grouping issue in SSRS 2008 report
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 03/26/2013 :  02:57:00  Show Profile  Reply with Quote
hi i have an issue related to pdf file in c# code so would like to handle this issue through SSRS and require some assistance in this regard,
i have 5 hierarchy levels down the lane and hierarchy levels down the lane populate data based on prior level values selected.

asia pacific->india->delhi->nehru place->ramesh
europe->spain->barcelona->nau camp->messi

Now i require a the data in pdf format as follows
when europe gets selcted i want
asia pacific->india->delhi->nehru place->ramesh information in one table

and the second table(can be join of first table also) will have information of ramesh

likewise if i pick Asia pacific i would like the information of europe in first table and joining table should have info related to messi..

i got this functionality in c# but the requirement is a pdf file through ssrs report.
the report does populate data in ambiguous manner , i am not familiar with grouping functionality of ssrs which can resolve this issue
can someone guide me on this, happy to explain the issue if require more details from my side.

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 03/26/2013 :  14:39:09  Show Profile  Reply with Quote
sorry i cant understand your requirement . how will selection of value populate data for another hierarchy? can you explain with some sample data?

SQL Server MVP

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000