strage report/subreport behavior...

[spikepl]

It could have to do with the Sum function not having finished counting. As en experiment, try replacing it with a Dsum domain function, summing over appropriate records. Or for starters, just summing over anything, really.

 

[dmattarn]

i changed the contents of numEMP to =DSum("CountOfEmployees_EmpFull","POSummaryRates") which gives me a count of 9 which is correct for the total across all 3 purchase orders, 1+1+7. now the font size on all 3 pages is size 6.

now i just need to have it group by purchase order number and ill be all set

 

[spikepl]

ok so my theory might be right. If you could just make the criteria for the Dsum to correspond to the actual records ...

 

[dmattarn]

since this Dsum is in a control in a subreport, how would i set the criteria for it to match the POID(purchase order number) from its source query with the main reports POID for grouping?

 

[spikepl]

HUH ? You need to show me something - sql, criteria, whatever - I cannot guess just from wailings

There is another way to get a sum: in a report you can set a textbox pproperty to a cumulative sum, and if each added 1, then you'd have the count. PErhaps this count is counted properly at the time when used .,.. try it

 

[dmattarn]

ok so i got the DSum working using the following:

=DSum("CountOfEmployees_EmpFull","POSummaryRates","POID=" & [POID])

but the debug staetments are still showing that [POSummaryAvgRate].[Report]![numEMP], where numEMP is the DSum is always 1 so the font size is still not changing.

the numEMP field displays the correct numbers in report mode. I'm really at a loss for why i can't reference this value

 

[dmattarn]

i officially gave up. i made the text box where i was trying to resize the text twice as wide so it doesnt matter now. thanks for the efforts anyways