I have a main report and I plan to use a drop-down box to select one of four different sub-reports, at a time, based on the selection. These subreports are all based on their different data-sets, due to too complicated conditions which could not be accomodated in a single SQL select. In addition, there are about 9 different filters which are common to all the four sub-reports. These data filters are in drop-down boxes and get populated through their own datasets. I have created and tested the subreports.
My problem is bringing these subreports together in the main report and making them visible based on their selection or otherwise in the main report. Can I use the same parameter I am using to select the subreports, in the drop-down box in the main report, to be passed down to the subreports ? HOW (could someone provide sample code of the lif or IIF statements) ? How does the main report know which dataset to switch to ? And how do I make visible or invisible the individual reports ?
Any help, suggestions and code samples explaining things would be appreciated.
Here's my dilema. Our organization has two db servers. One is Oracle and the other is SQL Server. Oracle contains our HR information on all employees and SQL Server contains information on various projects that we are undertaking. The HR system (Oracle) contains Employee ID's, Names, addresses, phone numbers, etc. SQL Server has information about the varous projects and Employee ID's of who is assigned to those projects. I have a report that has two data sources (one to each server) and two datasets (each populated from the two datasources). I would like to have a single table that displays the project and the name of the person who's assigned to that project. This would be achieved by linking the tables on similar information, which is the Employee ID. I've received responses in various news groups etc. saying this can be done by using subreports and query parameters but it's never explained how to go about it. Kind of like, I can tell you what you use to fly to the moon, but I can't tell you how to actually go about building the rocket that gets you there. :)
Is the functionality that I'm looking for possible in SSRS 2005??
I have a report (A) that has a list where a subreport (B) is displayed. This subreport includes nested sub-reports (C) which have other nested subreports (D) (globally there are 3 levels of subreports). When I try to preview report A in Visual Studio I get the "Object not set to an instance of an object" but when I try to preview report B everything is ok. I have RS SP1 installed and I have already tried to include a dummy query in the subreports so that they always have a result....
I am trying to create a report with subreport this way:
1) create report
2) create subreport. Set parameter @AccountName in the SQL query (...WHERE account.name = @AccountName) and in the parameters collection - AccountName, data type string
3) place the subreport into the report and set parameters AcountID = =Fields!name.Value, so that the WHERE clause in the subreport should filter the content according to the field Fields!name.Value.
So far, I suppose this should work. Nevertheless, I get this result in Visual Studio .net:
An error occurred while executing the subreport €˜subreppp€™: An error has occurred during report processing.
Cannot read the next data row for the data set DatasetXYZ.
When I publish the reports into our CRM, I get the main report but the subreports shows: "#Error: The subreport could not be shown".
What can I do to make this work properly?
Any help would be VERY appreciated as I have already wasted several hours with this issue.
I am new to Rs2005. I have 4 seperate reports, r1, r2, r3, r4,.....etc. I want these reports to be called in sequence in a Master report. I want to make all 4 reports 1 big report. Can this be done, and if so can somebody please point me in the correct direction. Many Thanks in advance.
1. Can we acess Datasets from main report to sub report in SSRS 2005?
2. While i preview the report main report and navigate to the sub report the "Back to Parent Report" icon is displayed in the toolbar of the sub report but when i deployed and viewed in Internet explorer it cannot see the "Back to Parent Report" icon. Whether i have do any settings while deployment?
Is it possible to set up a subreport so that I can determine which report it displays based on parameters? From what I've seen, the report that a subreport displays must be hardcoded... Anyone got any workarounds?
Hi everybody, I've got a quick question.....hopefully :) I have two reports based on two different stored procedures, they both need the user to enter a begining and end date as parameters. I would like to have one main report and add my two other reports as subreports. The problem I have by doing that is it asks for the parameters for the first subreport and then for the second and these parameters are the same for each subreport.
Could someone tell me how to have the parameters asked only once ?
Thank you all any help will be greatly appreciated.
I have a main report that calls subreports. When a subreport has enough data such that it will not fit into the remaining area of the current page the renderer inserts a page break leaving alot of ugly white space. Is there any way to sop this behaviour? This seems like a very basic thing.
I am trying to create a dashboard that is split into the five main focus areas of Customer, Finance, Management, People and Innovation. Each focus area has a main report and a series of subreports (within a panel). I use the €˜Jump to report:€™ property at the domain level €“ which works well.
My problems arise when dealing with the subreports. For example, in the €˜People€™ focus area €“ the panel contains 4 subreports covering; contractor vs. fte trends, gender balance trends, compliance trends and investment trends.
Ideally I would like to have four €˜tabs€™ which when clicked would show the relevant subreport. I know this can be done via a full report refresh, but it looks clumsy and is more complex and costly to maintain.
I am happy for any method that might change the €˜Subreport€™ property dynamically or set the visibility of the objects. I want to avoid using the toggle capability as this could result in two or more subreports conflicting and being visible at the same time.
We have a bunch of small single pupose reports (individual charts, tables, etc.) that we used as subreports across several larger reports. I want to sperate the subreports into their own folder on the Reporting Server and I tried to tdo this by creating a solution with subprojects and specifying different publishing folders. That seems to be going well, but when I want to add a subreport from one project to a report in another project Visual Studio doesn't seem to like this at all. It won't let me drag them to the layout surface.
Shoudl this work? Is there something different I need to be doing since I'm working with multiple projects now?
i was created report with 6 sub reports for muliple columns driil down as based on client requirements, and also iam using one subreport with in the all 6 sub reports,when run the report i got the correct data. my report output having total 11 fields. with in the 6 fields iam using the 6 sub reports, with in the 6 sub reports iam calling the another sub report.
while exportin my report into excel sub reports are not shown, in the place of sub reports i got the error that is " subreports within a table or matrix cells are ignored"
my client must need report output in excel format, so how to solve this problem. in my analysis excel is not support sub report feature, is there any diffrent method or is there or any third party control is there
please give me solution how to solve this probelm.
We have a recurring project status report that uses a matrix (each matrix group is for an individual project). The name of the project renders fine and displays in the group, but when we try to pass this same value as a parameter to a subreport (a graph) which we also want to display in the matrix the subreport is only renderd for the last instance of the matrix group (i.e. 4 of 4 has it but 1-3 show a blank field in the matrix).
I assume this has something to do with using parameters within the matrix control, but didn't find any posts about that.
I should add another way we've tried to do this is with a list instead of a matrix and it also fails in the same way (doesn't render all of the subreports).
Hi, I am creating some earned value reports that display project budget, actual cost to date, projected cost, and earned value. I have all of the data stored by month so I am using the Running Value function to display the data on a graph such that at any given point on the graph, it is showing total dollars as of that date. This works great for a single project or a summation of projects.
I also want the ability to create a batch set of reports for a series of projects, basically they input a list of project numbers, and a new graph is generated for each one. To do this, I created a "batch report" that has a subreport in a table's group with project id being the grouped on field, it passes that project id to the subreport as input.
I get exactly what I want - a new report for each project, but the problem is, running value on the graphs is not working across the projects. It's fine for the first project, but all subsequent projects are getting messed up. For instance, one project with a max budget of 200K is showing with a max budget of 400K, actuals are getting nulled out, etc. It's as if for some reason, the RunningValue isn't getting reset across the subreport....
An example of my value field on one of the lines (not copy and pasted so forgive any syntax errors - I'm not on my development box):
(The point of the max is so that the graph stops on months without actuals - that is months that haven't occured yet)
My FakeSeries is just on projectID and is just for the purpose of resetting the Running Value (or so I thought).
Does anyone have any input or advice on how to get this working? Why is RunningValue getting messed up across subreports? If I only give the batch report one project ID, the data is great. (I know it's the running value because if I take out running value and just graph the SUM - all the values are correct). If anyone has an alternate way of doing this sort of batch report I'm all ears as well!
One of the columns within a table on my parent page contains data that increases the height of the row, (a 'comments' field). Unfortunately a subreport within that table does not expand to fill the entire height of the cell it is in because of the expanded row height, therefore leaving "white space" below it. Some rows have a different background color depending on a certain fields' value but in the column where the subreport is, I can't set the background color in the properties window because that attribute has been removed.
Everything with my report works correctly but I just can't seem to get that white space to change to the correct color.
I've tried the following so far with no luck:
1. Setting the background color of the table row. This option is not available within the properties dialog box. I assume because the row has a subreport nested in it. (Can I set the background color somewhere else?)
2. I passed the row color variable as a parameter to the subreport but obviously that only colors the subreport and not the whitespace underneath it within the table row.
My report looks goofy with a whole row one color except for the whitespace under my subreport in each row so if anyone could point me in the right direction I'd appreciate it.
I'm looking for advice on how to approach a reporting task I've been given. The report needs to be grouped by one of the fields in a view. The view contains patient data. Within each group, the report has to show the results when the view is processed for patients under 18 and another set of results when processed for patients 18 or older. Should I create a subreport for each age group? How would I show both age group sections under the same group? I've heard that subreports are resource-intensive. Is there a better way? Data regions? How would that work?
For a project I'm working on right now we issue a bunch of 2-4 page PDF reports (a main page and a subreport) for every entity within a retail hierarchy. Our client would like to have some of those reports rolled up into a single file so that starting in the second level of the hierarchy there is one file for each member and all its ascendants/descendants. In order to do this, I'm putting the existing report into a list on a new template (as a subreport) and creating a dataset for the list to pass the parameters into the subreport. I initially had to do this for 1000+ stores and realized that it was going to take a LONG time (the main page report can take as long as a minute to run as it's kicking off stored procs that retrieve a ton of data from a cube), so I stopped it and restricted my list's dataset to 3 rows to create a 3-report rollup for testing. When I previewed the report, it showed up after a minute or so and it looked fine - everything was where I expected it to be, pages were breaking properly, etc. However, when I tried to export that into PDF it hung forever. I cut the dataset back to 2 records and had the same problem, so then I cut it back to 1 record and it exported just as quickly as it always does. Does anyone have any information on why this is happening and what I can do to get around it? It's going to be a pretty critical component of this project for us.
I have a subreport that has interactive sort on one of the columns in a table. The interactive sort works well when i run the subreport. But when i run the parent report that contains the subreport then the interactive sorting does not work.
Has anyone come across this issue, any help will be greatly appreciated.
I have 4 subreports that I need to display in the main report. I can pull a sub-report with in the main report howevere the subreport doesn't display any data. It just gives me a blank template like:
Customer name Customer # Address 1 Address2 city
The subreport itself is not empty when I open it otherwise it shows me a list of all the customers however, no data when I call it as a part of main report.
I have what at first site should be a simple reporting services issue but cannot resolve:-
I have a complex report comprising over 90 pages of various sections but when analysed in detail , 80% of it follows a simple pattern i.e. it comprises around 100 instances of the same sub-report bound to the same data source BUT grouped and filtered on different groupings and filter values.
The pattern is as follows:-
Each sub-report instance is bound to an SSAS cube which has fields L1, L2...L7
Each sub-report instance groups the data dynamically by one or more groups G1,G2..G7, the actual fields to be used being defined by the parent report (i.e. one instance may group by fields L7, L3, L4, another by L2,L3 etc)
Each sub-report instance has up to 7 filters defined (F1..F7) may filter the data i.e. the parent may pass a filter stipulating that L7="A", L3="B". To do this, the parent sets filter parameters F7="A" and F3="B"
The approach I have adopted is to set up parameters in the sub-report for dynamically grouping the data i.e. the sub-report has 7 parameters defined G1..G7 and the parent report populates G1..G7 with the grouping breakdown required for any given instance. This works fine!!!!
However what I am trying to do is prevent each sub-report performing major round trips to the underlying cube for each sub-report instance by specifying the filter as part of the MDX query by defining the 7 filter parameters as query parameters. (I could of course not filter the query and place the filter in the report but this would almost certainly lead to performance issues). Instead what I am struggling to do is to create the MDX query in such a way that when a filter is not supplied by the parent, the MDX query does not filter the data.
Can anyone advise on this. I guess my question is more of an MDX question than a reporting services one.
strange behaviour in our production environment, while in the test servers all goes ok:
web application with web report viewer, the report is fine but clicking on "preview" or "print" an error 0x800C008 occurs.
The report include 3 subreports, and here's the problem: after some attempts i realized that each subreport (alone in the master report) works fine, but more than 1 in the same master report produces the error!
w3wp!library!7!04/17/2007-11:23:55:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Errore interno nel server di report. Per ulteriori informazioni, vedere il log degli errori., un-named assertion fired for component processing; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Errore interno nel server di report. Per ulteriori informazioni, vedere il log degli errori.
I have a report that contain at least 7 subreports. Each with their own datasource. I have set the subreports datasource to the correct datasource and on a few of them passed in parameters.
however, upon running it I noticed that the reports would show "SubReport cannot be shown". I made sure my parameters were being passed and its of the same type.
I googled and found a lot of examples that used the 'LocalReport_SubreportProcessing' event to populate the datasources for each subreport.
Is this the right way to go about it? I cannot find any good examples of how to populate a subreport. I need to justify putting the logic like this inside the ReportViewer form rather than someplace else.
Could someone please shed some light on this for me?
I am using VS 2005 C#, Sql 2k, on Windows Server 2003. I am using Reporting Services however the reports in my project are .rdlc files not .rdl they are inside my Windows Project not a Reporting Project...if this matters.
I have problem with using a data-driven subscription on a report with subreports. It works fine when I remove the subreport and generates error even when I add a subreport which only consists of one textbox.
I just was curious to know if using data-driven subscription on a report with subreports is supposed to work?
