Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Display table with fixed number of columns but variable number of rows

edited August 2008 in General
Hi,

SQL Server Reporting Services has a component called "Table" that allows you
to define a table/grid with fixed columns but variable amount of rows.

Is there one like that with ReportBuilder?

Regards,

A

Comments

  • edited August 2008

    "Abdullah Kauchali"



    We are currently evaluating ReportBuilder among other Delphi reporting tools
    and require functionality to display tabular data with the ability to
    position such control at exact X, Y coordinates of the page. (Similar to
    SQL 2005 Reporting Services Table control.)

    Does ReportBuilder support this? If not, are there any plans to introduce
    such controls in future versions?

    Many thanks in advance,

    A
  • edited August 2008
    Hi Abdullah,

    Sorry for the delay in this response.

    Depending on your needs, you may be able to use the CrossTab feature of
    ReportBuilder. Take a look at the CrossTab demos located in the
    \RBuilder\Demos\2. CrossTabs\... directory for some good examples of what
    can be done.

    Although I'm not familiar with the SQL Server Table feature, it sounds as
    though it is a stand along grid that displays the field names as columns and
    each row of data below. This can easily be done using ReportBuilder by
    simply placing the columns (field names) in a band above the detail band and
    placing the actual data fields inside the detail band. If you have more
    than one data source, you can use subreports to traverse that data as well.

    All components can be individually positioned inside a band or at a
    specified location on a page in ReportBuilder.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2008
    Some options for creating table format style reports....

    1. Use the Report Wizard to quickly build the layout for any report or
    subreport

    2. Use the Data Tree drag-and-drop tools for any report or subreport. Use
    the Layout tab of the Data Tree to configure how you like the Labels and
    DBTexts to be created and then multi-select any number of fields and drag
    them onto the layout workspace. There is a tutorial in the Developers Guide
    that covers this.

    3. There is Grid Pack for ReportBuilder available from Planit Technologies.

    http://www.planitechnologies.com/index.html



    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited August 2008

    "Nard Moseley (Digital Metaphors)"


    Fantastic! Thanks, got it working! :)

    (Very much like MSAccess subreports.)



    I noticed this last night. But they haven't seemed active for the latest
    versions of ReportBuilder!

    Many thanks, once again.
  • edited August 2008

    "Nico Cizik (Digital Metaphors)"

    Thanks Nico!



    Yup, sub-reports are it. :)
This discussion has been closed.