RDLC with dynamic hidden columns

munters
munters Member Posts: 6
edited 2013-06-04 in NAV Three Tier
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

Comments

  • Johannes_Nielsen
    Johannes_Nielsen Member Posts: 206
    edited 2013-05-30
    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. :wink:
    Best regards / Venlig hilsen
    Johannes Sebastian
    MB7-840,MB7-841
  • munters
    munters Member Posts: 6
    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
    mdPartnerNL Member Posts: 802
    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
    Vincent_Vancalbergh Member Posts: 10
    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.
    Senior Technical Consultant at Edan Business Solutions/Sphinx IT
    Owner of V-Kwadraat (see my blog about Programming and my feed about Gaming!)
  • munters
    munters Member Posts: 6
    Hello Vincent
    Why didn't I think of that.. I will try it
    Thanks
  • munters
    munters Member Posts: 6
    Hello Vincent

    Cool... Works perfectly

    Thanks again
    Marcel

Categories