Conditional value from subreport to main report?

[aellistechsupport]

There are several fields on the subreport I want on the main report.

I'm able to put the value from the subreport to the main report EXCEPT when I'm trying to add a condition.

=IIf(([InStateTaxSummary subreport].[Report]![SalesTaxGroup])="City",[InStateTaxSummary subreport].[Report]![SalesTaxAmount],0)

It's producing $0 when it should be $283.76.


When I do a simple query to verify the IIF statement it works, but not in the main report.
What am I doing wrong?

SalesTaxGroup	SalesTaxAmount
City	$283.76
County	$139.55
RTA	$113.54
State	$329.14

[ranman256]

Do you actually mean when [SalesTaxGroup]=" the word "CITY" (as in your sample)

or do you mean then the city in [SalesTaxGroup]= the city name in FIELD: [CITY]

??

[pbaldy]

You're trying to refer to a specific row in the subreport, which will be unpredictable. You're probably getting the last row (test for "State" and see). You could put a textbox in the footer that sums only city, and refer to that.

[ranman256]

But why do the decision in the report, it should be made in the query.

[aellistechsupport]

Ok, so I have a summary tax report in which each of the taxes shown is placed in a different part of the main report.

So I want to place the value for the SalesTaxGroup = "City" on a certain place of the main report.

The State on another part of the main report and so on.

Paul is correct in that it is displaying the last one, the State value of $329.14 when I place the SalesTaxGroup field.
Why I'm trying to say when it equals one of them to be placed on a certain location on the main report until all of the four are placed displaying the correct value from the subreport.

If there is an easier way to do this, please share. Thank you!


Oh, on that note.
Here's the full query:

Tax %	SalesTaxGroup	SalesTaxAmount	CountyTaxable
2.5%	City	$283.76	$11,345.54
1.23%	County	$139.55	$11,345.54
1%	RTA	$113.54	$11,345.54
2.9%	State	$329.14	$11,345.54

I'll also need to place the above formatted like this and having issues since a cross-tab query subreport isn't working right either.

County 1.23%			RTA 1.00%			State 2.90%
$11,345.00 $139.55			$11,345.00 $113.54			$11,345.00 $329.14