subreport

determine which page an object is on in Reporting Services

I need to do this for a 'Table of Contents' (sub)report. Methinks it is not possible. Any ideas? e.g. Table 1 starts on page 2 Table 2 starts on page 7 Is there, perhaps, a way of tapping into the Document Map? ...

Pass data from ssrs subreport to parent

1 Is it possible to pass data from ssrs 2005 subreport to its parent report? 2 If yes, how? Thanks so much Philip ...

SSRS 2008 - inclusion of subreport causes main report to return no data

I have a report which worked perfectly. I inserted a subreport at the top (basically a cover sheet) Now the rest of the report runs, but has "no data available" all over it What is going on?! ...

Multiple unrelated in JasperReports

I am using iReport with JasperReports. I want to include multiple subreports that have unrelated sql queries. I would like to be able to put these all on one report. The problem I am facing is that when I leave the master report sql query empty, none of my subreports have any data. There isn't really anything that the master report...

How can I remove the blank line caused by an empty sub-report? (Digital Metaphors Report builder)

I created a report with a sub-report but not every line in the main report has something in the sub-report. So when it prints the empty sub-report prints a blank line. How do I get rid of the blank lines? ...

In Crystal Reports, use an external shared subreport against different database tables?

We have several reports that have a header that looks exactly the same but each report pulls its header information from a different database table. Is it possible to use a single shared/external subreport for the formatting but pull from a different table depending which main report the subreport is hosted on? ...

SSRS 2008 Interactive Sorting in Sub-Report not working as expected

I have a (parent) report that has a list. The details group of this list contains one sub-report. So basically if the list has 10 records (rows) the sub-report is executed 10 times. The problem seems to be with interactive sorting in the Sub-Report. It has 4 columns with interactive sorting enabled. When I run the parent report and try ...

Crystal Reports - Passing a current value of grouping field into a subreport as a parameter

Hello All! I have a query with grouping on one of the fields in Crystal Reports. My question is - is there a way to pass that value into a subreport? I.e. if there are three values in that field, there will be three groups in report. I want a subreport in every group to have that value as its parameter. Is that possible to accomplish ...

How to change the background color of cell containing subreport in RDLC report

I have an rdlc report containing two sub-reports in the same row (side by side). I am using alternating color for rows (setting background-color to "=iif(RowNumber(Nothing) mod 2, "Gainsboro", "White")") but when the one report is shorter than the other (a common occurrence), the background color of the cell containing the sub-report ha...

Crystal Report->subreport->C#

Hi, I want to know if is there any way to disable the new tab when I click on the subreport? Confused? OK.. when we click on subreport, the report for that report comes out like when you click on abc.rpt where abc.rpt is a subreport. In a new tab, abc.rpt itself comes out. Any way to disable that? ...

Crystal Reports: How can I avoid nested subreports in this case?

I have a main report which contains user information -- and a subreport that contains multiple items for said user. Question is, I need the main report to duplicate as many times as necessary for the number of users I feed into the DataSource -- how can I do this, so that it results in one large report (containing multiples of the main ...

Covering Subreport with Text Object PROBLEM

What can I do for subreport so that When i click on it, it won't appear on the seperate page? I actually found a way but it is really ugly and not convenient for long reports. My way is that.. I cover the subreport with a text object. And extends the length of text object depends on how many rows the subreport have. It is work fine ti...

Relative path for the Subreport

Hi, I'm working with iReport 3.5.0, and I'm using a subreport inside my main report. I don't want to give the absolute path for the subreport expression, but for example if I just give "bpSubReport.jasper" as the subreport expression (because sub and main are in the same directory), then iReport can find bpSubReport.jasper and compile th...

Grouping data in an RDLC

I'm sorry if this seems silly, but I'm new to using Report Definition Language (RDLC) files and I'm looking for advice on the best "plan of attack" for a report I must create. THE REPORT The report (itself) must display a table of data above a related set of calculations for each a grouping (of data). I'm hoping to keep one group per p...

ASP.net: Crystal Reports - Subreport over multiple pages

I have a Crystal Report that has a header and a subreport with the height locked at a exact amount so the subreport will display a maximum of 20 rows on the page. However, this limitation has restricted the use of the system, and the users now require an unlimited number of rows in the subreport. I wish to keep the same layout as the r...

SSRS 2005 Subreporting Performance Concern

I have a report which, when rendered on its own, has the following performance times (taken from ExecutionLogStorage table): TimeDataRetrieval: 6776 TimeProcessing: 142 TimeRendering: 30 When this report is used as a sub-report which is repeated 34 times, the performance of the overall report comes out as follows: TimeDataRetrieva...

Adding a subreport to Active Reports

I'm writing a report in VB .NET (using Active Reports) that displays details about a location, and then displays a bunch of images, which are stored in a database. The images are displayed in my main report via a subreport. However, I can't get the images to load. I have two files, the main report (rptMain) and the image subreport (rpt...

Crystal Reports - adding same footer to multiple reports

I have multiple reports all of which require the same footer (company address, VAT no etc). Is there a simple way to write this information once and apply it to all of my reports? I thought I could do this with a simple subreport but this just seems to copy the subreport to the main report and any changes in the 'footer report' aren't ...