Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How to keep the size of a list static. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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 Karl Tuesday, September 8, 2015 2:15 PM Looking for the proper forum.
    Monday, September 7, 2015 1:20 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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 8, 2015 2:14 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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 8, 2015 2:15 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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 8, 2015 2:34 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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 8, 2015 6:38 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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 8, 2015 6:42 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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 8, 2015 6:43 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thank you for your replies.

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

    Regards

    Wednesday, September 9, 2015 4:18 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    • Proposed as answer by Mike Laughlin Wednesday, September 9, 2015 11:37 AM
    • Marked as answer by Just Karl Friday, September 18, 2015 3:47 PM
    Wednesday, September 9, 2015 4:20 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you  Dave.
    Wednesday, September 9, 2015 6:14 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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 9, 2015 2:32 PM