RDLC with dynamic hidden columns

munters

I'm trying since a while to build a report 204 with hidden columns (like line discount) when no data (no discount) and expand description field size if less columns on page.
It tooks quite some time to do so but now my problem is, the hidden fields to expand the description (I just use if another column is not visible) make the report with wider then the printpage and i have empty pages.

I attached 3 files where you can see the max columns 204 and min columns 204_2 with wider description field and 204_3 with the table (2cm to wide) and footer in page size.

Is there a way to not have empty pages?

Thanks
Marcel

Johannes_Nielsen

I don't understand your situation completely except that your output gets to wide and causes blank pages.

My experience is that RDLC controls does'nt ever "release space", that might be your problem.

So a solution might be, to make the decision what columns you need and stick with em.

munters

Yes I know this would be the easy way but if I stick with all I need then the Pricelist descriptions need to be shortened a lot (up to over 1000 Char ) and there are around 200 000 articles and over 10000 with more then 500 Char. that's the reason I try to do it that way. Maybe I have to write the report temporarly in a XML and then rerun it with the fields in use or so.
I just don't like this way because of performance.
I still hope there is another way.
But thanks for your input.

mdPartnerNL

Don't think this will help you but a few days ago I saw a demonstration about reports from Claus. In it he repeatedly notices "do not go beyond 18 cm (portrait) and always type in 17,99cm. If you don't you will have blank pages".

Vincent_Vancalbergh

You can use the trick of the Classic Report Designer. There you'd make two header sections and two body sections and use CurrReport.SHOWOUTPUT(TRUE/FALSE) to select which set to show.

You can do the same in RDLC and manipulate the "Hidden" property of the rows.

munters

Hello Vincent
Why didn't I think of that.. I will try it
Thanks

munters

Hello Vincent

Cool... Works perfectly

Thanks again
Marcel