May 30, 2007 at 12:10 pm
I have a stored procedure which returns three rows from the database into a dataset (two credits, one debit). My report has two tables (on a list); one for credits, one for debits. The list is associated with the dataset.
The expressions for the textboxes in the tables contain an "if" statement [iif(Fields!CRAmount.Value > 0, Fields!CRAmount.Value, Nothing) ...intended to display only the credits OR debits]. While this works, the report also reserves space for the rows of the dataset which do not meet the criteria in the if statement. In other words, the "Nothing" display appears to take space in the report.
Is there another way around this?
Appreciate any help I can get.
May 31, 2007 at 4:11 am
Use two tables instead of Text boxes. Using two identical datasources with a filter on one for >0 and the other with <0.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 6, 2007 at 10:07 am
Thanks, Jason.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply