July 16, 2012 at 2:29 pm
I have a main report (Report A) with a tablix. That tablix has a field that totals a column (Total A).
I have a subreport (Report B) wth a tablix. That tablix has a field that totals a column (Total B).
Is there a syntax that will allow me to subtract Total B from Total A?
I cannot figure out the syntax, nor do I know if this is even possible.
July 17, 2012 at 8:17 am
I don't think that there is a way to do that. I normally try to avoid subreports if I can. I'll often bring back all the data in one report and then nest tablixes (Hmm what's the plural of tablix?).
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 19, 2012 at 7:27 am
similar problem,
http://www.sqlservercentral.com/Forums/Topic1328723-150-1.aspx
i don't think you can use subreport field into main report, need to work out in your stored proc or query.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply