Total of unknown categories in SSRS 2005

Posted by Lijo on Stack Overflow See other posts from Stack Overflow or by Lijo
Published on 2010-04-05T07:54:35Z Indexed on 2010/04/05 8:03 UTC
Read the original article Hit count: 344

Filed under:

ssrs-2005

Hi,

I am working with SSRS2005. I have requirement to display total in the footer. We have to display the total of each category. What I used to do is, write expression for all category names and hide those totals that are not having any value in the current selection.

Mango Count = sum(iif(fields!Category.Value = “Mango”,0,1)) Apple Count = sum(iif(fields!Category.Value = “Apple”,0,1))

However, in the new requirement, I don’t have the knowledge of categories. It could be any number of categories. Is it possible to write an expression for this?

Please help

Thanks

Lijo Cheeran Joseph

Related posts about ssrs-2005

Error in Visual Studio 2008 with SSRS 2005 report projects

as seen on Stack Overflow - Search for 'Stack Overflow'
Has anyone found a good workaound for opening or editing an SSRS 2005 report project with Visual Studio 2008 yet? Will the SQL server 2008 tools be the migration path for these report projects in the future? I really dont want to have to keep VS2005 installed forever just to update SSRS reports… >>> More
SSRS 2005 tabs/newline characters display in table

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How can i get a column in an SSRS 2005 report to render control chars like new lines and tabs? For example: SELECT VW.System_name + CHAR(13) + CHAR(9) + ' > ' + VW.PTS_NAME + CHAR(13) + CHAR(9) + CHAR(9) + ' > ' + VW.FEED_NAME as Name In SSRS (and SSMS Results to Grid Mode) table… >>> More
SSRS 2005 - Cascading parameters and default value update problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a report with cascading parameters. The first parameter is Finanical Period Type, being either Month or Week. The second parameter is a list of either financial months or weeks depending on what was selected for the first parameter. This all works well and selecting a series of different Financial… >>> More
How do I convert an INT into HH:mm:ss using SSRS 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Ok I need to display total talk time of an agent that is coming into SRSS 2005 from SQL 2005 as an INT. For the life of me I cannot figure out what combination of expression editing or format editing I need to use. For the detail portion I can use: =DATEADD("s", SUM(Fields!Talk_Time.Value), CDate("00:00")) And… >>> More
How to pass Multivalued parameters through URL in SSRS 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I have main matrix report and I want to navigate my sub report from main report by Jump To URL:(Using below JavaScript function) method. ="javascript:void(window.open('http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fKonsolidata_Data_Exporting_Project%2fEXPORT_REPORT_TEST&rs:Command=Render&RP_cntry="+Fields… >>> More

Developer IT