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
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...
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...
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...
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
(...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.