Display data horizontally

hajanhajan
edited June 2010 in FastReport .NET
Hi there...

The normal reports are in layout like

R Month - #Total
1 Jan 10
2 Feb 20
3 Mar 30
4 Apr 05

...

How can I display this on the following way:

Jan Feb Mar Apr
10 20 30 05
...
etc?

I was searching to find option, but still no success.

I can create custom objects for each month and using function to get the concrete Total depending of which month is, but this seems quite static rather than dynamic. Is there any other (maybe) better approach?

Thanks

P.S. Once I have succeeded with this when I've created SQL query that counts for each Month the totals and dispalys the months as the Column/Field names. But this case, I cant use the months in the Charting Diagrams so I have had to change the query, but now, the other problem came out. If there is no standard option to display the data on horizontal line, I will need to make workaround :/.

Comments

  • hajanhajan
    edited 7:05PM
    hajan wrote: »
    Hi there...

    The normal reports are in layout like

    R Month - #Total
    1 Jan 10
    2 Feb 20
    3 Mar 30
    4 Apr 05

    ...

    How can I display this on the following way:

    Jan Feb Mar Apr
    10 20 30 05
    ...
    etc?

    I was searching to find option, but still no success.

    I can create custom objects for each month and using function to get the concrete Total depending of which month is, but this seems quite static rather than dynamic. Is there any other (maybe) better approach?

    Thanks

    P.S. Once I have succeeded with this when I've created SQL query that counts for each Month the totals and dispalys the months as the Column/Field names. But this case, I cant use the months in the Charting Diagrams so I have had to change the query, but now, the other problem came out. If there is no standard option to display the data on horizontal line, I will need to make workaround :/.

    For now, I've resolved the issue with two queries. One for the TABLE, another for the CHART. Anyway, if there is an option for my above-mentioned question, I will be glad to see it.

    Thanks.
  • AlexTZAlexTZ
    edited 7:05PM
    Hello,

    Please look at the TableObject:
    http://fast-report.com/documentation/UserM...tableobject.htm

    Example report (from the demo.exe): Table/Column Datasource.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport .NETComment As ...

© Vanilla Keystone Theme 2024