Databases
StackOverflow2013
Postsdbo
PORDLC Local Report (Visual Studio 2012 Report Designer) - Multiple column flow
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORDLC Local Report (Visual Studio 2012 Report Designer) - Multiple column flow
    primarykey
    data
    text
    <p>I am converting some reports that run within a Windows application to use a local SQL report, rather than a legacy custom report builder, written a fair few years ago.</p> <p>The reports are not especially complex, but I have hit a question, that I want to avoid hacking around if possible.</p> <p>I need to create a two column layout that will flow, from top to bottom of left column, to top to bottom of right column, for any number of pages.</p> <p>Something like</p> <pre><code>List Column One [sub report?] *Contents End Column One Column Two [sub report?] *Contents End Column Two End List </code></pre> <p>So I would be expecting to pass a report dataset into the parent List, and have the contents flow through column one and then onto column two, and then repeat the List on the next page, until all data consumed.</p> <p>Is it possible to obtain this kind of 2 column flow?</p> <p>The only solution I can think of is to pre-process a dataset so that blocks of content are already organised into pages, columns and positions. But this sounds hugely rigid, especially when it comes to fitting content to a page.</p> <p>so I might create</p> <pre><code>Data.Page = 1 Data.Column = 1 Data.Position = 1 Data.FormattedHeading = "blah" Data.FormattedBody = "Blah..." Data.ImageBytes = [***] Data.Page = 1 Data.Column = 1 Data.Position = 2 Data.FormattedHeading = "blah" Data.FormattedBody = "Blah..." Data.ImageBytes = [***] Data.Page = 1 Data.Column = 1 Data.Position = 3 Data.FormattedHeading = "blah" Data.FormattedBody = "Blah..." Data.ImageBytes = [***] Data.Page = 1 Data.Column = 2 Data.Position = 1 Data.FormattedHeading = "blah" Data.FormattedBody = "Blah..." Data.ImageBytes = [***] Data.Page = 1 Data.Column = 2 Data.Position = 2 Data.FormattedHeading = "blah" Data.FormattedBody = "Blah..." Data.ImageBytes = [***] </code></pre> <p>etc ...</p> <p>And then layout in a list operating on unique Data.Page, which contains 2 sub reports for each Data.Column, which will filter on Column and contain a List that orders by Data.Position</p> <p>Might be some minor details astray, but something like that is the solution that my brain is offering me. But it makes assumptions about the size of content, and seems "hacky".</p> <p>What have I missed? Is there a better way?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGavin
    1. USGavin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload