An underwater report cannot be displayed. Sub-report works separately - not with main report

Question

I have one main report with 5 supporting reports.

Sub report contains more than 10 parameters. (With 10 Multi valued parameters - So, I used the Join method to transfer the value from the Main report to the Sub Report )

I also tested the Sub-report separately, and everything works fine, showing the data and that's it.

I tried to make another main report and tried to put this supporting report in this newly created main report, but still did not succeed.

I also checked all parameter values ​​and data types, all of them are correct in accordance with my store procedure.

I tried to remove the multi-valued parameter one by one from the properties of the Sub-report in order to verify that the weather problem was caused by this multi-valued parameter or what!

When we send a value from the main report to the subreaction using the properties of the auxiliary report - here, when I clicked the multi-valued parameter, it has

=Parameters!ParameterName.Value(0) - (0)

Is it good or not? Since I use it as several selected values.

I am stuck in this problem and I am getting below the error,

Error: Subreport could not be displayed.

Any help please in advance.

Note:

I checked this one , but did not have time

I also checked this one but did not have time

Getting below error on main Report page,

I also tried to download all the SSRS 2012 reports, but did not succeed.

Answer 1

I believe that you have already found the cause of your problem.

I also checked this one , the nut failed

The message you are referring to has the following accepted lethaljd response:

This is a known bug in SSRS 2008 . I am not sure if this has been fixed, but it was fixed in SSRS 2012.

As you have found, a workaround is to use separate datasets.

https://connect.microsoft.com/SQLServer/feedback/details/648560/subreport-with-shared-dataset-throws-error

If you check the source provided by lethaljd, it shows that it has not been fixed and will probably never be, as it is no longer a problem in newer versions.

This means that you should probably use a newer version of SSRS or consider a workaround. I would like to help you think of a different approach, but, as I said in my initial comment, you will need to provide much more information. Since the question is now written, I don’t have enough details to give you any reasonable advice other than using a different version.

Thus, I do not want this answer to come as unconstructive or negative. I just want to help you on the right track.

Answer 2

You should check this:

• several parameters should be defined as multi-valued in the main report and in the subtitle (specify in the subreport to allow several values)
• when you pass several parameters to the subtitle, you have to pass it as [@param] and don't like =Parameters!ParamName.Value(0)

This blog explains how to post multiple values ​​to a subheading.

Answer 3

Besides checking the obvious steps, as mentioned above, (Some may say that this is also obvious) I had to make sure that the data types of the parameters (in the subtitle) correspond to the columns that they correspond to in the main report.

When you did this and you still get the error ...

I assume that you are using VStudio like me. This is how I clear the VStudio cache ...

Download the report Close VStudio Go to the report folder in WinExplorer. Backing up the solution folder Now go to the Project folder under the Solution folder Note that there are 3 types of files: -.rdl <- This contains the report definition ... Do not touch this ... -.rdl.data <- Contains cached data for report execution -.rds <- This is your data source definition ... Do not need to touch it -.rptproj <- This contains your project definitions ... Do not touch it -.rptproj.user <- do not touch it ... It contains the credentials for the data source. Then you have a folder with three subfolders ... Debug, Release and Debuglocal

Here's what you do: Delete all .rdl.data files Delete all files under bin / Debug / * and repeat for DebugLocal and Release.

This should clear the VStudio environment. Now open the solution ... Reboot the solution in VStudio and try again.

This fixed a number of these problematic data cache issues.

Answer 4

Right-click on the dataset and click Dataset Properties . Click the Parameters tab. Delete a parameter that is not in the correct format (i.e., a parameter without @ ).

Answer 5

I just had the same error (although I do not use multi-valued parameters), I added 2 new parameters to the subreport and set the parameter values ​​in the main report.

It turned out the parameters in the subreport! My 2 new parameters are for date and time, but when they were created by the wizard, they were set as text, after changing the date / time everything works fine.