New Blog Post: PDF/A and Metadata

Print subdata left to right instead top-down

edited December 2016 in General
Hi,

we have some data which consists 6 columns and upto 4 rows.
I am familiar with setting up a report with a subreport
display the rows top-down and columns left to right like this:

| |Column1|Column2|Column3|
------------------------------
|Row1| 11 | 12 | 13 |
------------------------------
|Row2| 21 | 22 | 23 |
------------------------------
|Row3| 31 | 32 | 33 |
------------------------------
|Row4| 41 | 42 | 43 |

Now our customers request a display
with columns top-down and rows left to right:

| |Row1|Row2|Row3|Row4|
-----------------------------
|Column1| 11 | 21 | 31 | 41 |
-----------------------------
|Column2| 12 | 22 | 32 | 42 |
-----------------------------
|Column3| 13 | 22 | 33 | 43 |
-----------------------------

My idea was to use a crosstab, but i did not get it to work.

Any suggestions or working examples?

Any help is appreciated

Tia Carsten




--


Hint: We altered the sources!Hint: We altered the sources!

Comments

  • edited December 2016
    Hi Carsten,

    If you have something simple like 4 rows with 6 fields, you could use the
    PageSetup dialog to define 4 columns and set the traversal to left to right.


    If the above is not helpful, please provide more details.

    What does the data look like? You have a query with 4 rows with 6 fields per
    row? Or something different?

    Crosstab you say 'did not work'. Can you provide specifics?



    Best regards,

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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited December 2016
    Nard Moseley (Digital Metaphors) legte dieses als Verknüpfung auf
    seinen Bildschirm :
    This is what is defined within our report in 5.56 and which is not
    working 17.02, see my post Subreport with backgroundpagelayer.

    My further question is, how I sould create a descriptive first column
    in front of the data columns, containing the labels for each row?
    Yes that the way data is. I will send some *.xps files to support@ to
    clarify the situation
    I tried to setup a crosstab but i could not manage it. Data was not
    displayed correctly.

    --


    Hint: We altered the sources!Hint: We altered the sources!
  • edited December 2016
    Hi Carsten,

    The solution is to set PageStyle UsePageSpace to False. Access the
    PageLayer workspace, select the Page Style tree node on the left and then
    you can set the property in the object inspector.

    I had to look this a while and research it. I then recalled we added a
    PageStyle UsePageSpace boolean property several versions ago to provide more
    control over this. Depending on the requirements developers were wanting it
    to work both ways.



    Best regards,

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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited December 2016
    Hi Nard,

    your solution does not work. I turned UsePageSapce off but a blank page
    still appears

    Changing in pagelayout->layout from left-> right to top->down and
    activating columbalancing works unexpectdly as desired.

    Tia Carsten

    Nard Moseley (Digital Metaphors) stellte die Frage :

    --


    Hint: We altered the sources!Hint: We altered the sources!
  • edited January 2017
    Hi Nard,

    we have updated to 18.0 and retried this issue.

    On using ColumnTraversal=ctLeftToRight there is still an empty page.
    Setting ColumnTraversal=ctTopToBottom does not create this empty page.

    Remember: Reports have been updated from 5.56 to 18.0, maybe there is
    an issue while converting the report?

    Carsten Eider dachte sehr stark über folgendes nach :

    --


    Hint: We altered the sources!Hint: We altered the sources!
  • edited January 2017
    Hi Carsten,

    I was able to modify the .rtm files you provided so they can run without
    data. That showed me the extra page issue.

    I created a patch for RB 18.0 that along with setting PageStyle.UsePageSpace
    to False, resolves the issue.



    Best regards,

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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited January 2017
    Fix works as expected, issue can be closed.

    Cheers Carsten

    Nard Moseley (Digital Metaphors) erklärte :

    --


    Hint: We altered the sources!Hint: We altered the sources!
  • edited January 2017
    Hi Nard,

    how can change UsePageSpace while converting?

    lChildReport.PageStyle.UsePageSpace:=false fails

    Any idea?

    Nard Moseley (Digital Metaphors) dachte sehr stark über folgendes nach
    :

    --


    Hint: We altered the sources!Hint: We altered the sources!
  • edited January 2017
    Hi Carsten,

    The correct code would be

    if lChildReport.PageStyle <> nil then
    lChildReport.PageStyle.UsePageSpace := False;


    For RB 18 that will compile for Delphi and RAP code.

    For RB 17 that will compile for Delphi code only.







    Best regards,

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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited January 2017
    "Nard Moseley \(Digital Metaphors\)" Wrote in message:

    Unfortunately lchildreport.Pagestyle always was nil.
    Maybe this was the First Run, but i did Not think that there are
    more Passes?

    How many are there?
    --


    ----Android NewsGroup Reader----
    http://usenet.sinaapp.com/
  • edited January 2017
    Fixed, solution works!

    Carsten Eider schrieb :

    --


    Hint: We altered the sources!Hint: We altered the sources!
This discussion has been closed.