subreport

2 Topics

SSRS Subreport not showing
I am using Microsoft SQL Server Reporting Services Version 15.0.1103.12 (i.e. SQL Server 2019 Reporting Services). I am creating a report using the standalone Report Builder (v15.0.20283.0). I am querying an Oracle DB data source. I have a report that I would like to create that is a collation of other reports, i.e. a collation of sub-reports. However, I am running into an issue where the sub-report(s) do not show. There is no error or any indication that there is a problem, the sub-report simply doesn't show. Each of the sub-reports is basically a Tablix, and they do have a NoRowsMessage populated, so even if no rows are returned, a message should display (and a message does display when opening the sub-report on its own). What I would like to do, ideally, is populate the parameter of each sub-report with a parameter in the main report. So what I started with is a sub-report directly on the Body surface, and configured the subreport parameter "Year" to be associated with the main report parameter "Year". This seems to work. However, when I add an additional subreport, nothing displays. No error message(s), no subreport(s) - nothing. Basically, when I add a single subreport, it seems to work. Then, I add another subreport, and I get the error message below and if I refresh, no subreports display. Exception of type 'Microsoft.ReportingServices.ReportProcessing.ReportProcessing+DataCacheUnavailableException' was thrown. The data cache for the report edit session is not valid. Rerun the report to create a new and valid data cache. (rsDataCacheMismatch) Sometimes, I won't see a subreport when there is only one subreport as well, but I assume that is some problem with the cache after having added and then removed a second subreport. On the other hand, this does occasionally occur even when I refresh the report and I assume that clears the cache. I've gone through all the iterations / implementations I can think of, and which I could find through a Google search, but I'm not having any luck. It seems like most of the information out there is for older versions of SQL Server Reporting Services as well, so I am left unsure why this is a problem. Any advice or insight would be greatly appreciated!
Solved
jdc136
1 year ago Place Report Server
7.1KViews
0likes
7Comments
multiple Tablixes per page
i have 2 dataset the first is a list of courses, terms, and grades per student id studentId course term grade 1 Math Semester 1 90 1 Science Semester 1 80 1 Math Semester 2 80 1 Science Semester 2 85 2 English Semester 1 50 2 Art Semester 1 100 2 English Semester 2 90 2 Art Semester 2 95 then i have a list of student demographics including name, site, and birthdate studentId name site birthdate 1 John Doe Harvard 3/11/2000 2 Sally Johnson MIT 2/1/2000 and i want to create a report card that has 2 tablixes that each repeat on each page to get me something like: Page 1: student id 1 name John Doe site Harvard birthdate 3/11/2000 course term grade Math Semester 1 90 Science Semester 1 80 Math Semester 2 80 Science Semester 2 85 Page 2: student id 2 name Sally Johnson site MIT birthdate 2/1/2000 course term grade English Semester 1 50 Art Semester 1 100 English Semester 2 90 Art Semester 2 95 i have the bottom Tablix exporting correctly—each page is a different student, but i can’t seem to get the top Tablix setup correctly such that it will repeat at the top of each page before the grades i have tried 2 workarounds, and 1 works, the other i cannot get to work: utilize Text boxes within the Header this works, but i’d like to try to utilize 2 Tablixes for this process if possible utilize a Subreport i cannot get this to work unless i make the Sub report and the 1 Tablix side-by-side. if i stack them 1 on top of the other, Power BI separates them onto different pages also, i can’t seem to match them up, even though i set a parameter in the subreport to match the same id number of the current page thoughts?
mmeyers
2 years ago Place Report Server
3.6KViews
0likes
3Comments