Problem Deploying Subreports With Main Report

Feb 26, 2007

Hi All,

Here's my problem. I have an SSRS report with subreports on it. The main report and subreports work fine on my machine when I run the main report. However, when I deploy them to our test server and change the server name of the shared datasource, only the main report brings back data. The subreports show an error of something like "Error in displaying the subreport" for each subreport. The subreports require parameters that I believe I am supplying from the main report. What am I doing wrong? Is it really necessary to deploy the subreports with the main report to the new server. With Crystal Reports, I didn't have to do this. Any thoughts or suggestions would be appreciated.

View 3 Replies


ADVERTISEMENT

Display Subreports With In A Main Report

Apr 12, 2007

Hello All,



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.



Can anyone suggest me on this one?

Thanks,

Rashi

View 6 Replies View Related

Deploying A Report To The Main Server

Oct 5, 2007



I have created several reports using SSRS which is installed in my local machine. But source data base is in the main server. Data source connection works properly. Report manager is also configured to local machine.

Now I tried to deploy these reports to main server. So I changed the target URL to http://mainservername/reportsserver in the internal report property change box. But it was not succeeded. I get a error message like this.



------ Build started: Project: Partner Reports -Internal, Configuration: Production ------

Build complete -- 0 errors, 0 warnings

------ Deploy started: Project: Partner Reports -Internal, Configuration: Production ------

Deploying to http://derby/ReportServer

Error rsRPCError : The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)

Deploy complete -- 1 errors, 0 warnings

========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========


Reporting services was already installed in main server. Do I have to change settings of report configuration manager in my local machine?

View 4 Replies View Related

Reporting Services :: Add Sub-report To Main Report Using Report Builder?

Sep 9, 2015

I just created a report builder. I have a main report and i wanted to create a sub report. why i cant or i cant view the path or the folder of my  .rdl file to be use as my sub report.

View 5 Replies View Related

Reporting Services :: Passing Cascaded Parameters From Main Report To Drill Through Report In SSRS?

Sep 16, 2015

I am trying to develop a report from cube,and it has one drill through report.when i click on sales amount field on main report,then it open the drill through report with details.Here i passed the **(category,subcat,product)parameters(Cascaded)** to drill through report in action part of main report.In my main report i have two columns .

columns are **Level**  and              **Salesamount**.  

Values are like  

**[-]category**              **100**
    **[-]subcat**             **50**
         **product**          **30**

when i click on 100, parameters are passed & it open the detail report correctly, but when i click on 50,the values for subcat parameter is not getting values in detail report and same as the product also.

Here i used the expressions in parameter values

**pCategory**----iif(inscope(category),!fields.category.value,split(join(Parameters!category.value,","),","))

**psubcat**----iif(inscope(subcat),!fields.subcat.value,split(join(Parameters!subcat.value,","),","))

**pproduct**----iif(inscope(product),!fields.product.value,split(join(Parameters!product.value,","),","))

View 3 Replies View Related

Reporting Services :: SSRS Linked Report Based On Calculated Field From Main Report

Oct 6, 2015

How do I get data on my linked report based on my grouped subtotal and grand total from the main report.  The subtotal and grand total are calculated columns.

I have a 3 columns in my matrix in the SSRS summary report. Actn_COAST, ActnCITY and NumbOfAccts.  

The following is code for my summary report.  The results are shown below.

SELECT Distinct ActnCITY, Count(ACCT) as NumbOfAccts,
CASE WHEN ActnCITY in ('NY', 'OH', IN, 'NJ', 'SC', 'NC') THEN 'EAST COAST'
WHEN ActnCITY IN ('CA'. 'NV', 'UT', 'WA', 'OR') THEN 'WEST COAST'
ELSE 'OTHER'
END AS Actn_COAST

FROM tbl1
where ACTNDATE between @STARTDT and @EndDT

Code for my detail report contains the following SQL

SELECT * FROM tbl1 where ACTNDATE between @STARTDT and @EndDT AND @ActnCITY = ActnCITY

I have linked my report based on the NumbOfAccts column.  I am able to get data if I click any of the NumbOfAccts values related to the state I want.  However when I am not sure how to make the subtotal and grand total work.  I want when I click on the subtotal of either coast, I should be able to see records of that coast e.g., if I select 37 I should be able to see all the records in East Coast.  If I click on the Grand Total, I only want data related to those 2 coasts.

View 2 Replies View Related

Reporting Services :: To Suppress Whole Main Report When Sub Report Has No Data

Apr 21, 2015

I have a SSRS report with 4 sub reports embedded. Previously i faced a situation where sub reports was getting displayed with static data even if there is no data being pulled from data set. I solved this problem according to solution provided in my previous post here. Now blank space is getting displayed in place of empty sub report. But still the main report that hosts empty sub report (Which has a header with header name coming from main data set) is getting displayed. Is there any way wherein the whole main report can be suppressed when the sub report  has no data?

View 3 Replies View Related

Reporting Services :: How To Add Sub-Report From Main-Report In RDLC

Jun 26, 2014

I have 11 records in the Main report.I want to make Imagebutton for only the 11 record.If click on Imagebutton then the subreport show in the below.But there is no relationship between MainReport and SubReport.

View 2 Replies View Related

Pass The Parameters From Main Report To Drillthrough Report

Nov 28, 2007

Good morning, all

I have a really cool Budget report which has two matrices on it. One is used/visible if the user selects four levels of grouping, and one is used if the user selects only three levels of grouping. The four choices for grouping are four fields, Par, FERC, Point, and Resource.

Since grouping is optional, I need a way to pass the parameter for a field that is not grouped on from the main report to the drillthrough report. For example if the user chooses to group on all fields but Point, I need to pass the report parameter that was used by the main report for Point to the drillthrough report as a report parameter.

So, I tried testing the three grouping levels values and if none were equal to "Point" then pass in the parameter by putting the following expression in the Parameter Value box for the Point parameter on the Navigation tab of the datacell of the main report that is the drillthrough link:


=iif(
Parameters!GroupLevel1.Value <> "Point"
and
Parameters!GroupLevel2.Value<>"Point"
and
Parameters!GroupLevel3.Value<>"Point"
,
Join(Parameters!PNTPoint.Value,",")
,
Fields!Point.UniqueName
)

But this is not working; the drillthrough report shows a blank dropdown for the Point parameter and I have to manually set it. Does anyone see an error in the syntax of the iif statement?

Any references, links, resources or good clean jokes would be greatly appreciated.

Thanks,
Kathryn

View 1 Replies View Related

Displaying Sub Report Header When Part Of Main Report.

Dec 27, 2006

Does anyone know a way to display the header of a sub report when the sub report is part of a main report? Im able to get the main report and the sub report to display properly, but the header of the previously developed/tested sub report will not display when embedded in a main report.

Thanks,

MP

View 4 Replies View Related

Pass Dataset From Main Report To Sub-report

Apr 17, 2008

Hi

Don't know if this is possible or not - Need to produce a report and the main report has a grid in it.

For every row in the main report, in one of the grid fields there are n images. So to do this, I am using a sub-report. But there is a problem with going to the database for every row to fetch images that if the user does a report spanning more than about 6 months, there will be thousands of records each with the potential to have many images and the constant round trips to the db server would probably kill it.

So what I want to achieve is to fetch the dataset in the main report with just one trip to the database and then pass the dataset filtered by a uniqueidentifier to each row of the subreport.

Could someone please let me know if this or something like it is possible and how to go about it?

Thanks
Steve

View 5 Replies View Related

Additional Area In Main Report After Sub-report

Jul 17, 2006

I have a main report that has 17 sub-reports in it. I have had some problems with additional space in the main report, after sub-reports that have no data in them. In the actual sub reports I have expressions set up for each line in the tables to hide the row if there is an empty string in it. (IIF(Fields!FieldName.Value = "", True, False)).

Is there a way to set up in the main report is the sub report has no data in it to hide the sub-report, and not show the additional space in them. I have tried putting the sub reports in the main report by themselves, and also put them into a table, and have encountered the same results each time.



I did find a site that suggests referencing a Field in the expression for that row, but this would involve us changing the stored procedure and adding additional Fields into the main report stored procedure. Also each sub-report has its own stored procedure to return the data needed for that sub report.

Any ideas?

View 5 Replies View Related

Report Services Multiple Subreports

Sep 6, 2007

Hi
I can add a single subreport to a report using the code


Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

AddHandler ReportViewer1.LocalReport.SubreportProcessing, AddressOf SetSubDataSource

reportViewer1.LocalReport.Refresh()

End Sub

Public Sub SetSubDataSource(ByVal sender As Object, ByVal e As SubreportProcessingEventArgs)

e.DataSources.Add(New ReportDataSource("DataSet1_tblReportExport", ObjectDataSource1))

End Sub


but i cant add anymore as when i try i get the error

Error: subreport cannot be shown.

Anyone knownhow i add another subreport?

Thanks a lot for your time

View 4 Replies View Related

Adding Subreports To Master Report At Runtime

Mar 12, 2007

Hi guys,

Is it possible at runtime to decide what subreports you want in your master report. Is this possible in RS?. Many Thanks in advance.

View 6 Replies View Related

Report With Subreports And Data-Driven Subscriptions?

Feb 7, 2008

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?

Thanks,

View 3 Replies View Related

Exporting Report To Excel With Subreports Problem

Mar 8, 2007

Hello,

I got a error when exporting to excel one report that has a table and in a column it has a subreport.

Is this possible to do?

What is the work around?

The error that i got it is the following.


Server Error in '/Reports' Application.
--------------------------------------------------------------------------------

For more information about this error navigate to the report server on the local server machine, or enable remote errors
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors]

[Exception: An error occurred during rendering of the report.]
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +489
Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +959
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +143
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +75
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64






--------------------------------------------------------------------------------

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210



Thank you


View 2 Replies View Related

Blank Pages In Report With Matrix And Subreports.

Mar 4, 2008

Hi,

I have a master report that contains 4 sub reports. The first two subreports contains matrix controls that can (and will) spill over to a second page. With 5 columns of data the matrix subreports fit nicely onto one page, 6 or more columns and they will spill into a second page. The second two subreports will always fit onto one single page. All four subreports are inside a list control which will repeat for each structure. e.g. Each subreport will be rendered once per structure.

The master report renders perfectly (with no blank pages) whenever the two subreports with the matrix controls fit on one page each. However, whenever the matrix control subreports spill into a second page it causes the master report to insert a blank page after subreport 3 and 4, bare in mind subreport 3 and 4 both fit perfectly on a single page. I've check all margins and page widths etc.

The blank page problem only occurs whenever the matrix needs to span two pages.

Anybody encountered this problem or have any ideas how to fix it? I'm beginning to think it is a bug with reporting services.

Regards,
Adrian.

View 3 Replies View Related

Combining Multiple Subreports Into A Single Report

Oct 2, 2006

The goal is to produce a single PDF consisting of a number of subreports. Some are landscape, others are portrait. The subreports may also be run as independent reports. The master report that contains them defaults to the width of the widest subreport, which is landscape. This causes all portrait subreports to spill over producing blank pages. Are there any work-arounds to concatenate multiple, single report PDFs into a single PDF and have page numbering too?


Thanks!

View 11 Replies View Related

Adding Landscape And Portrait Subreports Into A Single Report

Sep 27, 2006

The goal is to produce a single PDF consisting of a number of subreports. Some are landscape, others are portrait. The subreports may also be run as independent reports. The master report defaults to the width of the widest subreport, which is landscape. This causes all portrait subreports to spill over. Your suggestions / comments are appreciated.

Thanks!

View 1 Replies View Related

Page Header And Page Footer Not Loading Report Items In The Main Report When Subreport Called?

Apr 2, 2007

Hi All,



I am having a main report having two subreports, say M1,S1 and S2 respectively.

The issue is S2 normally tend to go beyond one page, for all pages except first page of the of the subreport I am getting the page header and footer blank,

Actually this is not loading the ReportItems that are used in main report but it shows text boxes containing strings for eg . "My Name" and date functions eg Today()

Any Solution?





Thanks and Regards

Pragash

View 1 Replies View Related

How To Pass The Value From Sub Report To Main Report

Feb 4, 2008

I have un report(mainreport) within a subreport(subreport).
With reporting services, how to pass the value from Sub report to main report?

thanks

View 3 Replies View Related

Deploying A Report Services Application To The Local Host; Error:A Connection Could Not Be Made To The Report Server

Feb 23, 2007

I installed SQL reporting services 2005 and successfully configured reporting services.After designing the report using Bussiness Intelligence Studio, i tried to deploy my reporting services application to the localhost , I got the below mentioned error :

TITLE: Microsoft Report Designer
------------------------------

A connection could not be made to the report server http://localhost/ReportServer.

------------------------------
ADDITIONAL INFORMATION:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

------------------------------

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)

Can anybody provide a solution for this issue....

Thanks in advance

Nirupa

View 4 Replies View Related

Report Definition Error When Deploying Report To RS 2000 In VS .NET 2003

Jan 15, 2007

Using MS SQL 200 SP4 with Reporting Services 2000 SP2 on Win 2003 Server SP1

Visual Studio .NET 2003 on different PC (Win XP SP2)

No problem creating reports or building solutions.
Problems develop when deploying report to Report Server.

Here is the Output:

------ Build started: Project: From CD, Configuration: Debug ------

Build complete -- 0 errors, 0 warnings



------ Deploy started: Project: From CD, Configuration: Debug ------

Deploying to http://<server name>/ReportServer?%2f2nd
Deploying data source '/2nd/AdventureWorks2000'.
Deploying report 'Vendor Purchase Orders'.
The report definition is not valid. Details: Could not find schema
information for the element
'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Report'.
Deploy complete -- 1 errors, 0 warnings



---------------------- Done ----------------------

Build: 1 succeeded, 0 failed, 0 skipped
Deploy: 0 succeeded, 1 failed, 0 skipped

These are my first attempts using report services. In a previous deployment
attempts it created the folder (named 2nd), but in another attempt (saving it
to the existing folder) I got the same result as you see above (I have also
tried with a new folder but no luck). This above output is from my last
attempt.

The Build error Task List states:

The Report Definition is not valid. Details: Could not find schema
information for the element
'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:report'.

The shema URL as above returns HTTP 404.
If I remove :report, I receive the page for Report Definition Language
Schema May 2004

Looking at the .rdl code the schema URL is as above without :report.

As you can imagine with a limited skill set in this area I am quite
confused. I have been doing alot of research but found nothing to help (or
that I understand will help) so far.

If anyone can help me get through this I would appreciate it.

Bill

View 1 Replies View Related

Login Prompt When Deploying Solution/report To Report Server

Aug 10, 2007



Hi there,

I've seen some similar posts to this one, however none with an answer and I'm wondering if anyone has actually figured out what causes this issue. I'm running SQL Server 2005 Reporting Services.

I'm attempting to implement a folder structure for the report server, therefore am creating individual solutions in Visual Studio for each folder. At the top level i.e http://servername/reportserver/ I am able to deploy reports no problem.

However creating a folder at the next level in the tree and then deploying to that level such as http://servername/reportserver/ManagementReports causes a Reporting Services Login prompt to appear. No matter what user credentials I enter they are not accepted. I have full administrator rights the server, the site and the folders in question.

Has anyone else experienced this? Does anyone have any suggestions?

Thanks
Matt

View 4 Replies View Related

Reporting Services :: Error When Exporting Report With Multiple Subreports To PDF

Oct 23, 2015

I have a report in SSRS 2008 R2 that has multiple subreports, in fact the report uses the same subreport twice with different parameters.  Then that subreport also has a subreport, which has a subreport.  (It's a complex data scenario with a hierarchy that can go up to three layers deep.)  The report renders fine in report viewer, but when I try to export to PDF I get the following error:

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.Reporting.WebForms.ReportServerException: Object reference not set to an instance of an object.

Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

[Code] ....

Each subreport renders correctly to PDF, and if I remove either subreport from the main report, it also renders correctly.  But the two subreports together on the report cause the error.

Removing the third hierarchy layer (the final one) fixes the issue.  Is there a limit to the number of nested subreports when rendering to a pdf?

View 2 Replies View Related

Problem Deploying Custom Report Item. Items Shows In Preview Screen In VS, But Not In Server Deployed Report

Nov 29, 2006

I have developed a custom report item that works fine in design and preview mode while in Visual Studio. I cannot get it to show up on my deployed reports. Here's what I have done so far:

1. Deployed the report using Visual Studio

2. updated the rsreportserver.config file with the following entry:

<ReportItems>
<ReportItem Name="PedigreeChart" Type="Uabr.Rap.PedigreeChart.PedigreeChartRenderer, Uabr.Rap.PedigreeChart" />
</ReportItems>

3. Updated the rssrvpolicy.config file with the following entry.

<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Description="This code group grants Uabr.Rap.PedigreeChart.dll FUllTrust permission. ">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinUabr.Rap.PedigreeChart.dll" />
</CodeGroup>

I've also tried using the StrongNameMembershipCondition with no better results.

4. The dll and its dependencies are copied to the bin directory of the report server.

5. When I load a report with this custom report item on it, the report loads fine with no errors or warnings in the log file (even with verbose tracing). The area where the custom item should be is just white. It's almost like Reporting Services isn't registering the item correctly.

This is particularly frustrating because the report works fine in Visual Studio - apparently I configured that correctly. Any suggestions would be greatly appreciated. I'm stumped.

View 6 Replies View Related

Reporting Services :: Deploying Report With Subscriptions With New Report Having Same Name

Oct 30, 2015

Here is the scenario:

1. have report called report_a.rdl with subscriptions attached to it
2. developed a new report called report_b.rdl with the same parameter list as report_a.rdl
3. i would like to replace report_a.rdl with report_b.rdl without losing the subscriptions.

I think this is the workflow:

1. rename report_a.rdl to report_a_old.rdl in BIDS
2. rename report_b.rdl to report_a.rdl in BIDs
3. deploy report_a.rdl to reporting server

Will that work even though the ReportID GUID will change?

View 2 Replies View Related

Report Viewer In ASP.NET - Subreport Page 2 Goes Back To Main Report Page 2 On Paging

Nov 22, 2007

What we've found is that when you have two reports where one navigates to the other, if you click on the second page of the second report, it takes you to the second page of the original report. If you navigate over to the subreport again and click for the second page, it works appropriately. This is definitely a no-go for production code and this may delay our ship date because I would think this is definitely undesirable.

Conditions:

ASP.NET Report Viewer using Remote Reports
Report that links to another report
Both reports return more than one page
Reporting Services installed
Steps to Reproduce:


Download the source code here.

Follow the directions (near the bottom of the post) to get the project set up.

Run it and click on a link in the first report to go to the second report.

Click the arrow for page 2 of the second report.

Notice how it takes you back to page 2 of the first report (this doesn't happen when you are in preview mode in the Reporting Services project and I don't believe it does this in a smart client application).

Click on a link in the first report to go back to the second report.

Click the arrow for page 2.

Notice how it takes you to page 2 of the second report.


Here is a link with source code and a more detailed explanation: http://geekswithblogs.net/robz/archive/2007/11/21/Reporting-Services-2005-BUG-Report-Linking-and-Paging---ASP.NET.aspx

So what I am looking for is both a workaround for now and if this is determined to be a bug, to be fixed in the next service pack.

View 6 Replies View Related

Carrying Values From A Subreport To A Main Report

Mar 22, 2007

How can I carry a value over from a subreport to a main report?

If I have a total in a sub report, I want to use that total in expression on the main report.

Any ideas?

View 4 Replies View Related

Compare Values Within Subreport To Main Report

Oct 10, 2006

I was wondering if anyone knew how to take a value from a subreport and
compare it to a value iwthin the main report. We are trying to see if
the value in the subreport is greater than the value returned in the
main report. We want to make the value test red if it is greater than.
I know how to compare these values if they were in the same report, but
when it comes to subreports I am lost. Any ideas? Thanks in advance.

View 4 Replies View Related

Refering To An Item In Main Report From Subreport

Apr 1, 2008

Hi All,

I have 2 reports where 1 is a subreport and the other one is a main report.
Can i change or refer to a control(item) in the main report depending on the value of an item in the subreport, when the subreport is being run?

Any comments are appreciated.


Thanks in advance.
payal

View 2 Replies View Related

Access Subreport Field In Main Report

Apr 11, 2008

Hi,

Is there anyway that i can access subreport field in main report? I just want it to be displayed. Thats it. I can not put subreport field in main report bcz it is based on the parameter passed by main report.

View 1 Replies View Related

Subreport Doesn't Show On The Main Report

Jun 5, 2007

Here's my problem. I have a subreport that shows data and labels if data is returned. However, if no data is returned, the subreport doesn't show at all. I have a message on the subreport I would like to show if no data is returned, but the subreport won't show at all. Any ideas??



Thanks

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved