I have 2 reports that need to be printed together. The first report has a header and footer that will repeat (if necessary) on data overflow. The last page, which is a form to be sent back. I basically need a way to print the last page without the repeated header/footers from the first report, and send in parameters to be used in the...
Hello, I am so close to having this work, I am trying to directly embed one jasper subreport into the main report xml of the other. You'd think this would be easy, but I can't find a single example on doing it. Everyone seems to use files or resources or whatever. I have one report working straight from a string and I want it to conta...
I am having a paging issue with my RLDC report that has a SubReport. The report has a table that prints the header data, then has a SubReport that I placed in a detail cell row within the table to print several detail lines that relate to the header data. This works as I want. However, the SubReport can span more than one page and this ...
Hey all! I'm creating a 'master' report in SSRS 2008 that collaborates other reports about a person. Sometimes not all of the other reports are relevant and as such return nothing. I'd like to be able to exclude this from the master report so it does not leave a blank page. I'm aware of the 'no-rows-message' feature, but a whole page ...
I have created a crystal report called 'Order Details'. I used visual studio 2005 (crystal ver 10). The order details report uses a stored procedure to populate itself. It contains a subreport called 'ChildAssets' which calls a seperate stored procedure, the sub report needs a parameter. The parameter it needs is actually a field from ...
I am developing a report in Sql Server Reporting Services 2005, connecting to an Oracle 11g database. As you post replies perhaps it will help to know that I'm skilled in MSSQL Server and inexperienced in Oracle. I have multiple nested subreports and need to use summary data in outer reports and the same data but in detail in the inner ...
Hello, I wrote a procedure that compiles many of our invoices using MS SQL Server Reporting Services. The procedure cycles through all the invoices for the month, loads the RDLC file, and renders the report. Note that the report also includes a subreport. The rendered report is then converted to PDF and saved on the disk. This works fi...
i'm getting an error when trying to put a subreport inside a inside a 3rd level group of a table or list (it doesn't matter, same error) i have put a clean subreport withouth datasource without parameters, just a textbox when i put that subreport inside 1st or 2nd level group it's ok, when i put it inside a 3rd level group(or higher) i ...
I have a report with an embedded subreport. The subreport has a table on it that shows a list of values and is itself embedded in a table on the main report. The problem I am running into is that when there is one result in the subreport, it displays and works fine. If there is more than one result, I get the "Error: Subreport could not ...
I am trying to create a report in crystal reports 11 based on this sql query SELECT * FROM (table) OM, (table) OL, (table) C WHERE OM.ORDER = OL.ORDER AND OM.COMPANY = C.COMPANY AND (EXISTS (SELECT * FROM (table) OSD, (table) OSDD WHERE OSD.ORDER = OL.ORDER AND OSD.LINE = ...
when i put a subreport in my main report, the subreport comes on the right hand side of the screen [check first screenshot] the entire area of the subreport is clickable... when clicked, the same data opens with everything in proper alignment [check second screenshot] i want to remove the clickable behaviour of the subreport and also h...
My business analysts have created 7 reports (using Report Builder) they want merged into a MEGA-report. I've been trying to do this by wrapping them all in subreports (which you can't use in Report Builder 1.0). While all reports show up, the layouts are all over the place. The subreports seem to reorder themselves. I've dropped down to...
Hi! I have a Jasper Report and I want to create for this report a cover page. The cover page must contain some information coming from the DB, like Company name, etc. I am trying to do this using a subreport but I didn't succeed. I've created a main report which contains first the cover page as a subreport and then the whole report as a...
I have two reports. First reports selects a report type from a dropdownbox and accepts from/to dates and when click on the view report - lists customer names for this report type. When you click on the customername, the 2nd report is called ( action) passing 3 parameters - customername, datefrom and dateto as parameters to be used in th...
I have an unbound XtraReport that has a subreport control which contains another report. I call "unbound" to a report that has the definition of the fields using a schema but not actually bound to any DataSet, I create a DataTable using a Data Access Layer and then pass that object to the DataSource property of the report. So, I have th...
Hey All, I am working on a SSRS 2008 reporting solution and I am running into a problem with a subreport not interactively sorting columns with the asp.net report viewer control. The report itself is completely functional when it is not used as a subreport, but once I add it to another report as a subreport you cannot sort the columns w...
This is my first attempt at employing sub reports and my overall experience with reporting services is minimal (edits to existing reports, creation of some basic reports). I have added a sub report to a an existing report. The sub report returns in about 1 second when tested separately. The query that powers it returns in less than a s...
Every time I use a Microsoft product I feel like I'm delving deeper into some form of existential mental masochism. However, I'm forced to use the tools the company buys, anyway... I would like to use a sub report, since it gets used on many reports, in the header. However, sub reports won't go into the header and neither will field val...
I have a report which lists out a company detail. There are two sections to the company detail. The first portion lists out environmental data and the second is actually a subreport which lists out Cash flow details for every single year of the company. I have multiple companies i need to do this for--so i grouped the report by Company...
Often I'm creating reports in Visual Studio's Crystal Reports and want to have a master-detail or 1-many type thing. Something like this: Invoice Number 13245 Total: $1,000,000 Date Raised: 1-Jan-1989 Date Due: 1-Jan-2019 Line items: # Desc Cost 1 Hat 23.00 2 Gloves ...