.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Creating Matrix report to show totals, need subreport to show details...

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :ASP.Net
I've created a perfect matrix report using the nifty wizard and it's exactly what the client wants, but they would also like to see the detail for each row. I'm able to create subreports and pass parameters and all that jazz, but I'm having a hard time setting up a subreport for this matrix. It's pretty much this format                      MakeOfCar                      ModelOfCar LotLocation   Count of cars   This would return:                         Ford           Ford                        Mustang      F150 Location A:         5                0 Location B:         2                3    

View Complete Post

More Related Resource Links

what kind of a report to be created in SSRS when the requirement is to show the Summary and Details

I have some reports to be developed where I need to show the Summary and the details of Students/Particular Product, Please advice what kind of Report format/ drill down or is there a way that on clicking on the summary it would show Details in a child report using SSRS 2008. it would be helpful if there are some tutorial links too thanks in advance for response.

Can someone show me how to remove blank columns from a matrix report with parameters?


I have a drilldown matrix report with 5 parameters that I group on. The users have the option of selecting any of these parameters when they preview the report. They can also select No grouping as one of the parameter option.   When I run the report and select for example, 4 parameters and the No grouping option, I get blank columns.  When I select no grouping, no data is displayed.  As a result, I get blank columns.  Is there a way to hide the blank columns?  I would appreciate any suggestions.  See table example below:



report builder 3.0, how to show a int type field(like id) in matrix format report


it always asking for the aggregate or sum, count ... I just want to show plain value like

1 myval1 myval2 myval3

2 myval2 myval2 myval2

not lile

(blank) myval1 myval2 myval3

(blank) myval2 myval2 myval2

2       (blank) (blank) (blank)

Expand rows in a data grid to show details in the same page

<asp:templatecolumn headertext="Purchase Order"> <headerstyle horizontalalign="center"></headerstyle> <itemstyle horizontalalign="center"></itemstyle> <itemtemplate> <%# DataBinder.Eval(Container.DataItem, "PurchaseOrder") %> </itemtemplate> </asp:templatecolumn> <asp:templatecolumn headertext="Order"> <headerstyle horizontalalign="center"></headerstyle> <itemstyle horizontalalign="center"></itemstyle> <itemtemplate> <a href="OrderDetail.aspx?Order=<%# DataBinder.Eval(Container.DataItem, "OrderNumber")%>"> <%# DataBinder.Eval(Container.DataItem, "OrderNumber") %> </a> </itemtemplate> </asp:templatecolumn> <asp:templatecolumn headertext="Ack Date"> <headerstyle horizontalalign="center"></headerstyle> <itemstyle horizontalalign="center"></itemstyle> <itemtemplate> <%# DataBinder.Eval(Container.DataItem, "AcknowledgeDate") %> </itemtemplate> </asp:templ

SSRS Report based on SSAS Cubes doesn't show NULL values correctly

I have a SSRS report which is based on an SSAS Cube. In the Cube the formating of numeric fields that NULL values are properly shown as NULL values. In the Cube Browser and Excel this is shown correctly. However when I design the report already the query against SSAS shows these fields as "0" instead of NULL. Is there a way to fix this or is this a bug ?  

Report Builder 2.0: duplicate rows do not show on reports

Hello,Created a report using a report model.the problem is that duplicate rows do not show on the report.Why?And also how can this be fixed?the report shows product ids, that may or may not have serial numbersticket numbers can have mulitple products associated with them and they may or may not have serial numbersthe report data row is as follows:example:order number, ticket number, product id, manufacturer id, serial number123                  456               dsl_router 12  cisco123                  456               dsl_router 12  ciscothe above data shows as one row on the report, thus, showing it to be one product, but really there are 2 products and there should be 2 rows.is this a bug?how can this be fixed?Thanks.

Report Builder 2.0 and Matrix Sub totals

Hi All, Hope someone can assist... I am busy building a complex Financial report and have to deal with lots of Sub Totals etc. I basically have 2 questions: 1. I have 2 Matrixes and wan't to "SUM" the sub total from one matrix with the sub total from another (both will have seperate groupings, is this even possible. 2. How do i add the Value of "TextBox1" to the value of "TextBox2", the expression will be appriciated ? Regards  

report manager parameters , back button do not show

Hi, not sure this is an expected behavior.  My drill through reports have parameters that are passed from the first report.  once drill through, somehow the parameters are not showing in report manager.  also the Back arrow is also missing from the second report.  is this expected?thanks

How to show the image in crystal report 9 in asp.net 2.0

Hi, I'm using crystal report 9 in asp.net 2.0 web site. i couldn't display the image in report. is anyone having idea about this? i put the image using Insert Picture. in my web config , i put following codes,<httpHandlers> <add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/> </httpHandlers> <appSettings> <add key="CrystalImageCleaner-AutoStart" value="true" /> <add key="CrystalImageCleaner-Sleep" value="60000" /> <add key="CrystalImageCleaner-Age" value="120000" /> </appSettings> Thanks S.Shangar

SSRS report, doesnt show default value in paramaters when viewed in reportserver

Hi   We have a problem where we have a report that we have deployed to the production SSRS server, when I view the paramater list on the production reporting srver the particular report has the HAS Default paramater ticked, but the default value drop down selected value is blank yet the values are available in the drop down.   When looking at this in system test the default value is loaded.   When comparing the two RDL's they are identical and when loading the report files in Development tools the default value is selected, has anyone come accross this before ?   Ben

Javascript in Datalist .... on click of Button Show details in Another DIV

Hello Experts My Question is how to Set / call javascript in a Datalist , Where to define / Add Attrbutes for that / My Functionatilty requires on click of a button i have to show details in another DIVThanks ... Any Code Example is Much appreciated .. Thanks

Contact Details web parts on pages won't show any more than 7 pictures



For each new person that is added to a company department, we add a contact details webpart and their picture to the departmental page. We can't seem to add any more than that, the contact details webpart and their name shows up, but no picture. The other 7 pictures do continue to show up. Is there a limitation on the contact details webpart?

How to show varbinary data on the report builder normally?


Hi everyone,

The varbinary column type data will show #error on the report builder, is there a way to show it correctly? convert or other?


Where there is great love, there are always miracles.

How to show the content of two tables in one report?


Hi there,

I am working with reporting services for the first time and I have a very basic question, but can't find a solution for it anywhere. I use Visual Studio 2008 and SQL Server 2005.

Here is the problem:

I have two SQL data tables, one consisting of general data about a person (name, age,..) and one containing their employment data (joining date, salary, ...). I now want to show both tables for one particular person in one report such that the general data as well as the employment data each have their own section, such as


Name: Thomas Mueller

Age: 27

sql profiler doesn't show mdx report parameter values


Hi All,

Is there any way that I can afterwards see the members selected as parametervalues in an SSRS report. 

Maybe I'm missing something, but to me its looks as if SQL Profiler is capturing the mdx dataset queries exactly as specified in the report definition, but SQL Profiler does not show the parameter values selected by the end-user.

For analysis puposes I need to figure out what parameter values have been selected by my end-users on report-execution.

Any suggestions/workaround for this ?

Kind regards,



Please remember to mark replies as answers or at least vote helpfull if they help and unmark them if they provide no help.

How to show a "document map" in reporting services 2005 report viewer


Hi there,

I am wondering how to show a "document map" in reporting services 2005 report viewer. Under


it is stated that there should be a document map icon that I can click on to show my report map but this icon does not exist. Is there anything I have to do to enable it?

Best wishes



How to show group totals only at the last page?


Hi All,

I am facing difficulty to show the group totals in the SSRS 2008.

I have group on feilds country,state,city with details group suppose i have choosen country as India,then the state have two values then i need show the report with totals like below.

O/p for state1




col1 col2 col3 col4

city totals

State totals

O/p for state 2




col1 col2 col3 col4

city totals

State totals

Country totals

the difference b/w two outputs is like i need to show the country totals only at the last state totals.

thanks in advance.

Veeren :)

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend