CODEWITHSUNDEEP
vb.netvisual-studio-2008printingreportviewer
Propeller
Propeller

Reputation: 2533

How to make rows invisible while printing reports?

I am using an .rldc file to define the layout of the reports from my program. The problem is, it is to be used for incremental printing. That means the paper will be used over and over as newer rows need to be printed. I'm attempting to approach it this way:

  1. List all corresponding data on the report view.
  2. Make the older rows invisible and only show the latest row.
  3. Print.

That way, the last row is already properly placed. The problem is, I don't know how to implement this. Can anyone help me out?

Upvotes: 2

Views: 326

Answers (1)

Jacob Siemaszko
Jacob Siemaszko

Reputation: 346

You could create an IIF(condition,true,false) statement in your report definition on the row visibility variable.

The best way i guess is to define in your data source something of a rank column.

example :

select col1,col2,col3,RANK() OVER (ORDER BY col3 DESC) AS 'rank' from table1

Then in your table or matrix, you click on the row or/and column that you want to make the borders and text white based on a expression.

Go to the properties and dropdown on bordercolor choose expression and type in (based on my example query)

=IIf(rank.value <> max(rank.value),White,Black) That will not remove the rows only make the borders white ( unvisible)

The same you can do with Font Color property.

I think this is your best shot at this issue. Other solution I could think of is to just hide unneccesary rows (which also replaces the visible row)

Then to move the table down by using a expression with a formula like nr of rows hidden before the actual row * height of 1 row, only I m not sure if this is applicable without programming an RDL extension..

Good Luck !

Upvotes: 1

Related Questions