Search results for query: *

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...

Thanks LB, that formula works. Can you also suggest one more formula, I could have opened another thread but it is a similar one.pretty please? Second scenario is calculate monthly usage starting from cuuenrdate upto before 07/01(0r 06/30 but the dates I have are starting from 01 of every...

So instead of 2012...cant I write something like year(currentdate)+1. Adding parameter is something not in scope of the report design reqt. Thanks

Thanks LB, and next year will I have to mamually update the year to2013? Is there a way to make the formula general for all Years. Many Thanks!

Thanks LB, the formulae worked. I created a sub report and works great

LB, the formula doesnot show any error. My FY logic got changed, can i use same formula if I were to calculate usage from 07/01 - 06/31 ? Thanks