stavros_mrg

I have one mai report with 2 subreports. I need to create a background only for the main report. But i cannot find any print when expression which prevent the background from not printing on the subreports. Any ideas?

Hello jphaptar and tank you for your reply. Finally, i managed to tackle the issue with a combination of the issue you provided and page breaks. Thank you very much!

Hello everyone, I need to tackle the following issue. I have a Group Header with Footer, and a Column Footer. In the Group Footer there is a subreport. The report is printed in multiple pages and when the Group comes to the end the Footer with the subrerport is printed, too. Now, i want the Group Header and Column Footer to be printed only in the pages before the subreport is printed. In other words, in the page where the Subreport is printed i don't want to see the Group Header and Column Footer. I have managed to solve this only for the Column Footer, using a return value ($V{FooterLvl2_} - integer) which returns the value '1' in the page of the main report which prints the subreport. In all other pages is null. Then, in the print when expression of the Column Footer, I type $V{FooterLvl2_}.equals( 1 )==false. It worked! However, the same expression for the Group Header it doesn't work. The same return value is always null there. I ve tried with all Reset Types but no joy. Any suggestions?

You are a genius! The replacement of & with & worked! However, it doesnt calculate at once. I have to Ctrl+X the formula and paste it in the formula bar again in order it returns results.

Hello Everyone, I am trying to export the following formula in a cell of a paginated .XLSX file. However, when i export the report and then try to open the .xlsx file, that comes with errors and the pages which contain the formula are blank. The strange thing is that when i export to .XLS the formula is placed properly. The formula mentioned is this =SUMPRODUCT(SUMIF(INDIRECT("'"&$K$3:INDIRECT(ADDRESS(3,COLUMN()+J3))&"'!"&"K:K"),C6,INDIRECT("'"&$K$3:INDIRECT(ADDRESS(3,COLUMN()+J3))&"'!"&"I:I"))). It does make the sumif from multiple sheets of the workbook. Any ideas?

Hello everyone, I have the following challenge. I want to create a report which displays the costs of line items from an estimating project (page '14' of screenshot attached) and then at the end of each Group Code Level 1 i want to have a page displaying the summaries from all Group Code Levels 2 (page '15' of screenshot attached). Imagine that in real life we have more Levels 1 with many levels 2 in differennt pages. The page 14 was not the challenge (it is only multiple group levels and a page footer). The page 15 is The Challenge. How i can carry over the costs and page references from the previous sheets? And how i could have at the end of the report (last page) a page displayig the summaries from all Levels 1? Thank you in advance!

Hello folks, I am new in the community, however i have been using iReport for years, creating simple reports. Recently, i accepted a challenge. I was asked to create a report for a table that has some items under group code levels (e.g. 01, 01.01,......, 02, 02.01,....., 03, 03.01,.....). I managed to put the items under the group codes but i want to have also the subtotals at the end of each first level and before starting the next one. For examble, let's assume that i have 100 items uner the group code 01, and these items are displayed in the first 10 pages of the report, before the start of 02. I want at the the 11th page have a summary table 2 x10 (Page number - Page Total Cost) - (1st page - 10,000$, 2nd page - 20,000$, etc..) etc... So i would be really greatful, if you could help me. S.M.