Print subdata left to right instead top-down

rbuser

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!

nardmoseley

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

rbuser

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!

nardmoseley

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

rbuser

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!

rbuser

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!

nardmoseley

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

rbuser

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!

rbuser

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!

nardmoseley

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

rbuser

"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/

rbuser

Fixed, solution works!

Carsten Eider schrieb :

--


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