Dear Ibass,
I like to show report from one table only.
with grouping as:
Group A: Status
Group B: Worker code
And group summary for Group A & Group B
and Grand Summary at the bottom of page.
Here i don't want to show "Group A" summary if it is equal to "(C) Spot Commission" in Grand Summary...
Finally i done but in grand total its included while summing up.
i mean: i can able to show empty figure for the required group head's summary. But in grand total its included.
How can i remove a particular group head summary in grand summary.
expecting your valuable reply in this regard please.
Thanks for your valuable reply.
i inset this formula in detail section
if {TempNewComm.Status} <> "(C) Spot Commission"
then {TempNewComm.PrdVlu}
else 0
but it says that the formula is wrong - required boolean.
please help me to solve this.
Can any one help me solve an issue in VB6:
dim C1,C2 as double
C1=15
C2=17
By executing a query i will get an integer (field name Wrnk) (ex: 1 or 2)
with that i assign as C2=C2-C1
like:
C & Int(SQL!Wrnk) = C & Int(WSQL!Wrnk)-C1
in coding i can able to see SQL!Wrnk=2
but its not concatenate...
Thanks for your valuable reply - its working fine but still i need some more information to reach my expected result.
as in the above example group B summary can be avoided through your help tip.
But in grand summary its showing along with group B summary.
expecting your valuable support in...
for clear understanding, i am assigning your address line to a variable x
x = "Anaheim, CA"
x = Mid(x, InStr(x, ",") + 1, Len(x))
output of x = " CA"
regards,
thiru(dot)in(at)gmail(dot)com
Hi,
Can any one help me to find a solution for the follwing:
i don't want to show a selected group summary - how to do this?
Ex:
Group names are: A, B, C, D
all the above groups having sum() in its group footer.
here i don't want to show sum() of Group B and the rest
should be...
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.