I have 2 textbox in my detail table. I want to be able to minus textbox1 with textbox2. In each of those textbox is a subreport that contains a stored procedure. Here's my intended output.
Example:
ID Sales Cost Gross
123 $23.00 $15.00 $8.00
421 $20.00 $8.00 $12.00
Any ideas?
Did you try using the VBScripting capability of the report ?
|||
I hope that someone corrects me since I don't like my work around but...
You can not pull information out of a sub-report (I am pretty sure). The work around that I have been using is the create a view in SQL and then use the views to equate the total that I am looking for.
Good luck I hope that helps.
No comments:
Post a Comment