Recent content by nb4884

Thanks LB, I made all objects the same size and work around the guidelines and also there were some fields in sub report , which were placed in the details sections but I did not want to show them. Removing these fields and making the fields the same size, checking guidelines worked. Thanks

Sorry my subreport is in gp footer 1a and Sum is in GP footer 1b. There is no GP footer 2

GP 2 displays a column for sum from 2 sub reports. It is singlw value. (My previous post on how to add data from subreports and display in main report) All other fields inlcuding 2 subreports are in GP_1 Also I noticed that the gp_2 value not only displays where it should be but also displays...

All, I have about 20 columns in my report . When export to excel it displays 12 columns in one one row but other 8 columns are in row 2. What could be causing this? I have all 19 columns in gp_1 and 1 column in gp_2. gp_1 has underlay following sections checked in. One column that is in...

Thanks

Bruce, What does it mean "Must be in a section after the subreport." I cant place subreports and the subtotal from subreports in same section , which is group footer? I have placed 2 sub reports in main report in main report's grp footer. I want to place the sum from these 2 reprots next to...

Subreports are located in Group Footer. Want to display the sum from supreports in group footer as well. Thanks

Hi All, I have a report which has 5 phases. 1,2,3,4,5. Each project has a phase. Project has costs in multiple phases For ex: Data for costs in phase 5 project is Phase Department $$ 3 HR 500 5 Accounts 100 5 Admin 200 2 Accounts 300 1...

Hi All, Is there a way to get data from 2 subreports and add them as a column in main report ? Here is what my data looks like: Subreport 1 Formula 1, Formula 2 Subreport 2 Formula 3, Formula 4 I have these 2 subreports in main report where Subreport 1 displays Formula 1 in a column in...

Thanks LB:) You are awesome !!!

I used the same formula as : if year({table.date}+184) = year(currentdate+184) and {table.date} > currentdate then ( if month({table.date}) <> month(currentdate) then {table.monthlyusage} else ( {table.monthlyusage}/ day( dateserial(year(currentdate), month(currentdate)+1,1)-1 )* ( day (...

It does not show me the balance of the current month. Only shows data starting from 12/1 onwards. Thanks

Thanks LB, but the formula does not pick the data for the remaining month of Nov. (Like in the 1st formula it ends calculating for Nov- averaged on remaining days) It does not average on Nov i.e starting from currentdate. It starts calculating only from 12/01 onwards. Although it works on the...

Thanks LB, The formula appears to be the same as one above (15 Nov 11 17:00) I am getting ) missing error. Added a ) but then got an error as "not too many ..." Pls suggest

Thanks LB , I get the same error ) is missing. And when I added ) i got an error"Too many Arguements..." highlighting "dateserial(date(year(currentdate), month(currentdate)+1,1)-1" Please note that this reverse formula for calculating from todays date to 6/30 or 07/01 is for a different date...