 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / February 2007Reference to a second dataset in a second matrix within one report
Hello Everyone, I am attempting to create a report that contains two matrices. Each matrix will use it's own dataset. My problem is on the second matrix...I am unable to fiture out how to code the Value Property to refer to the field without First or Sum. When I drag and drop the fields into the cells, they appear like this; =First(Fields!ReportRow.Value, "Claims") or =Sum(Fields!ReportRowSeq.Value, "Claims") Is there any way I can get the field only without an aggregate? Something like; =Fields!ReportRowSeq.Value, "Claims"? Please help, I am new to Reporting Services and appreciate any help you can offer! Thank You, Tin From http://www.developmentnow.com/g/115_2007_2_0_0_0/sql-server-reporting-services.ht Posted via DevelopmentNow.com Group http://www.developmentnow.com > Hello Everyone, > [quoted text clipped - 19 lines] > > Posted via DevelopmentNow.com Groupshttp://www.developmentnow.com You should be able to just use: 'Fields!ReportRowSeq.Value' as long as the dataset 'Claims' is used as the main one in the matrix, it should work out fine. If you get unexpected results, you will need to re- evaluate the query you are using for the matrix. Hope this helps. Regards, Enrique Martinez Sr. SQL Server Developer In a matrix, the content cells are aggregates, grouped by the row and column headers. That is why the detail cell contents want to be sum, or first or max... I don't think it would work any other way.  SignatureWayne Snyder MCDBA, SQL Server MVP Mariner, Charlotte, NC I support the Professional Association for SQL Server ( PASS) and it''s community of SQL Professionals. > Hello Everyone, > [quoted text clipped - 20 lines] > Posted via DevelopmentNow.com Groups > http://www.developmentnow.com Thank you! I have now changed my code to use only one dataset. This has brought up another issue for me. I will ultimately have 5 matrices on this report and will have all the data within one dataset, but each matrix needs to use only it's data. How do I code an expression to pull only specific data from the dataset for each matrix From http://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=115&threadid=93631 Posted via DevelopmentNow.com Group http://www.developmentnow.com > Thank you! I have now changed my code to use only one dataset. This has brought up another issue for me. I will ultimately have 5 matrices on this report and will have all the data within one dataset, but each matrix needs to use only it's data. How do I code an expression to pull only specific data from the dataset for each matrix? > > Fromhttp://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=115&... > > Posted via DevelopmentNow.com Groupshttp://www.developmentnow.com If there is a distinguishing factor within the single dataset, you should be able to use a different filter for each matrix. Of course, you could always use separate datasets as well, since you can reference datasets outside of the location that they are used (in the same report). Regards, Enrique Martinez Sr. SQL Server Developer Thank you, Enrique! The filter works perfectly! I really appreciate your help! Regards, Tin From http://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=115&threadid=93631 Posted via DevelopmentNow.com Group http://www.developmentnow.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.