SSRS Reports: Drill down with custom columns in each sub-grouping

I want to be able to group information (no problem) but be able to show a completely different set of columns when the grouping icon ('+') is selected. For Instance, lets say the top level report is:

DEPARTMENT | MANAGER | BUDGET # | TOTAL SALES

Expand DEPARTMENT and get

MANAGERS | COST CENTER | NUM EMPLOYEES | Q1 SALES | Q2 SALES | Q3 SALES | Q4 SALES | ANNUAL TARGET

and so forth; there could be one or 2 more drill downs each with different columns. Is this possible? Thanks in advance.

Category:reporting services Views:4 Time:2011-11-28

Related post

  • SSRS Report Parameter Custom DataTypes 2010-08-17

    Our ASP.Net application connects to the a SSRS 2008 web service. The categories and reports are listed in a tree view in our application populated from a call to retrieve the list of reports from the web service. When a user selects a report the para

  • CRM 2011 : Creating GUID of a custom entity record to a SSRS report 2011-08-24

    I am using a Stored procedure to genearte a SSRS report in CRM 2011 , My stored procedure is using one i/p parameter as GUID . Is it possible to run this report for a particular Custom entity record in crm CRM . Thanks, Sheen --------------Solutions-

  • How do I sort a column in an SSRS report alphabetically AND numerically? 2012-02-08

    I know nothing about SSRS I have an SSRS report with a column containing text and numbers. I want the column sorted with all the text first sorted alphabetically, then all the numbers sorted numerically. The data as it stands is all just strings. Is

  • Slanted column heading - SSRS reports 2012-02-22

    Can anyone please tell me if it is possible to create an SSRS 2008 report which has slanted/angled column headers like in the screenshot below? I've searched for a solution to this, but haven't found anything of use. --------------Solutions----------

  • Can I include additional columns in the export that are not visible in the SSRS report viewer? 2014-01-02

    The additional columns are included in the dataset query, but not added to the table. Does anyone know if it is possible to display additional columns in the export that are not visible in the SSRS report viewer? --------------Solutions-------------

  • SSRS Report Custom Prompt Layout 2009-07-17

    Is it possible with business intelligence development studio to create an SSRS report and easily customize the way that the prompt fields are laid out (mainly the location)? It looked like it defaults to grouping them horizontally, I would want to pe

  • How do I dynamicaly create an SSRS Report? 2010-10-20

    Im trying to create a report in SSRS. The report calls a stored procedure for its data. I want to display the data in a table. But the thing is, the result from the stored procedure differs from time to time, because every customer has its own 'templ

  • Reuse my formula in a SSRS report 2011-03-15

    i'm just starting out with ssrs, and i have a little calculation on two fields in my dataset in textbox A (so the content of textbox A is dataset1.field1 * dataset1.field2) Now i want to add that number to the another number, and put it in textbox B.

  • How to display time value in a given string format within SSRS report? 2011-06-10

    I want to Display time duration in SSRS report My DB field is time in SQL. It converts Timespan in SSRS. format is : 1:00 PM - 3:50 PM How can i do this ? Fields!StartTime.Value.ToString() + " PM - " + Fields!EndTime.Value.ToString() + " PM" is not w

  • Adding Row click event or a check box to each of the rows in a SSRS report 2011-07-13

    I'm new to SSRS. These may be very trivial questions. I've a SSRS report, which shows employees in row by row format. Is there any way that I can double click on a row and get the corresponding employeeID of the row. And another question is can I hav

  • Customize SSRS report on the fly 2011-09-16

    We have a requirement to represent the data on SSRS report in a simple manner. i.e. the sql query for this report will look like this. Select col1, col2,....col8 from Table where Date between date1 and date2. So the user will run this report by selec

  • SSRS Report Manager javascript fails in non-IE browsers for Drop Down Menus 2011-10-20

    I've been debugging the ReportingServices.js file using Firefox and Firebug. I've found that the reason SSRS (SQL Server Reporting Services) Report Manager (web front end for Reports) doesn't work in Firefox (v7.0.1) is that it's using javascript .la

  • Radio buttons in SSRS Report 2008-11-21

    How do I add radio buttons as my parameter type in SSRS reports? Thanks in advance, Anna --------------Solutions------------- If you are referring to the Reporting Services web interface, you can't. Selectable value lists appear as dropdown lists. Yo

  • Can we hide or delete report rows in SSRS report while we render it to excel? 2009-04-24

    Is it possible to delete or hide a particular row in a table item just in excel rendering of the report. I have a summary report , which has a link to its detail report(drill through), when i export the summary report to excel i would like to delete

  • SSRS Report from Oracle DB - Use stored procedure 2009-07-06

    I am developing a report in Sql Server Reporting Services 2005, connecting to an Oracle 11g database. As you post replies perhaps it will help to know that I'm skilled in MSSQL Server and inexperienced in Oracle. I have multiple nested subreports and

  • SQL Server Reporting Services - Report Model: API (build custom report builder) 2009-08-06

    I am looking into the idea of creating a custom report builder and data tool to replace the ssrs report builder. I am wanting something more like a query builder and data export tool rather than reporting. The thing I want to use is the report model.

  • SSRS report page break problem 2009-09-01

    I need look at a problem with page breaks in an SSRS report, and I'm by no means an expert. This is in the XML mark up to provide a page break: <TableGroups> <TableGroup> <Grouping Name="AdjustmentPageBreakGroup"> <PageBreakAtEnd

  • How do you reference a field in the Embedded Code of an SSRS report 2009-09-09

    Is there a proper way to reference the fields of a ssrs report from the embedded code of an ssrs report? When I try to use Fields!Program.Value I get the following error -- There is an error on line 3 of custom code: [BC30469] Reference to a non-shar

  • How to add an image to an SSRS report with a dynamic url? 2009-12-02

    I'm trying to add an image to a report. The image src url is an IHttpHandler that takes a few query string parameters. Here's an example: <img src="Image.ashx?item=1234567890&lot=asdf&width=50" alt=""/> I added an Image to a cell and th

Copyright (C) dskims.com, All Rights Reserved.

processed in 0.128 (s). 11 q(s)