none
How to keep the size of a list static.

    Question

  • Hi I have a few list's under each other on a report. Within the lists are tables, which can have varying numbers of records. I know how to display only  a certain amount of records per table (I set the Hidden property of the detail group as =IIf(RowNumber(Nothing) <= 12, False, True) ).

    My problem is that I want the lists to be static in size regardless the size of the tables in them. Is there a "Can grow" or similiar property for lists?

    Regards

    • Moved by Just KarlModerator Tuesday, September 08, 2015 2:15 PM Looking for the proper forum.
    Monday, September 07, 2015 1:20 PM

Answers

All replies

  • Hello,

    The TechNet Sandbox forum is designed for users to try out the new forums functionality. Please be respectful of others, and do not expect replies to questions asked here.

    As it's off-topic here, I am moving the question to the Where is the forum for... forum.

    Karl


    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer.
    My Blog: Unlock PowerShell
    My Book: Windows PowerShell 2.0 Bible
    My E-mail: -join('6D73646E5F6B61726C406F75746C6F6F6B2E636F6D'-split'(?<=\G.{2})'|%{if($_){[char][int]"0x$_"}})

    Tuesday, September 08, 2015 2:14 PM
    Moderator
  • Hello,

    What sort of report is this?

    Karl


    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer.
    My Blog: Unlock PowerShell
    My Book: Windows PowerShell 2.0 Bible
    My E-mail: -join('6D73646E5F6B61726C406F75746C6F6F6B2E636F6D'-split'(?<=\G.{2})'|%{if($_){[char][int]"0x$_"}})

    Tuesday, September 08, 2015 2:15 PM
    Moderator
  • They can probably help you over here.

    http://answers.microsoft.com/en-us/office/forum/access?

     

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    Tuesday, September 08, 2015 2:34 PM
    Moderator
  • Hi Karl, Thank you for your reply. And thank you for moving my question to the correct forum - my apologies.

    I am trying to re-create the following report. Basically it is six element repeated to fit unto an A4 paper.

    My idea was to create a list and put two tables in it, and restrict the table rows.

    Everything works fine, however my problem arises when the table shrinks to less records

    that I've set with the expression in the group detail hidden property :=IIf(RowNumber(Nothing) <= 12, False, True).

    The list shrinks with the table. How do I "fix' the size of the list, or should I do it with the table?

    And how?

    Regards

    Tuesday, September 08, 2015 6:38 PM
  • This is "where is" forum for direction on where to ask questions. If you're using msaccess then I'd try them over here.

    http://answers.microsoft.com/en-us/office/forum/access?

     

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    Tuesday, September 08, 2015 6:42 PM
    Moderator
  • Hi,

    Right now your question in is the 'Where is the Forum For...?' forum, so the best we can really do is point out which forum would be best to post in.

    To do that we'll need to know what application are you using to create these reports.


    Tuesday, September 08, 2015 6:43 PM
  • Thank you for your replies.

    Which forum should I use I ask questions about Report Builder 3.0?

    Regards

    Wednesday, September 09, 2015 4:18 AM
  • Thank you for your replies.

    Which forum should I use I ask questions about Report Builder 3.0?

    Regards

    You can ask them over here.

    https://social.technet.microsoft.com/Forums/sqlserver/en-us/home?forum=sqlreportingservices

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    Wednesday, September 09, 2015 4:20 AM
    Moderator
  • Thank you  Dave.
    Wednesday, September 09, 2015 6:14 AM
  • You're welcome.

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    Wednesday, September 09, 2015 2:32 PM
    Moderator