Recent content by tfish

I am currently setting the SQL in my Crystal reports using the PESetSQLQuery API call and need to make a similar call for a subreport. I cannot solve the problem linking parameters, which is how I have been filtering data in my subreports. Does anyone have plausible solution to my conundrum?

Thanks for the assist, Ken. I've gone back to the drawing board and I'm re-writing the running total formula manually. I think I'm on the right track; it's only a matter of time at this point.

In my report, I have a calculated field that determines an account balance by two criteria (an account type and the sum of dr/cr's in the account). This is done with a series of IF, ElseIf statements. I want to sum the resulting column(s) independently but Crystal will not let me generate a...