how to display newspaper columns in a sub report

Stephen

unread,

Nov 15, 2006, 8:54:52 AM11/15/06

to

I've got a sub report containing 2 fields and I want it to be displayed on 2
columns.
I've set the value "Newspaper Columns Across" to 2 and modified the Columns
width too but it never appears on 2 columns. What am I doing wrong?

I want it displayed from left to right and I would prefer the report not to
be in the "label" format.

Data1a, Data1b --> Data2a, Data2b
Data3a, Data3b --> Data4a, Data4b
Data5a, Data5b --> Data6a, Data6b
Data7a, Data7b --> Data8a, Data8b

Chris Pollach

unread,

Nov 15, 2006, 9:03:19 AM11/15/06

to

Stephen;

Are you using a N-Up or Tabular report format?

Thanks ... Chris

"Stephen" <smar...@cbgi.qc.ca> wrote in message
news:455b2a3c$1@forums-1-dub...

Stephen

unread,

Nov 15, 2006, 9:20:43 AM11/15/06

to

I was using the tabular report format but i've just tried the N-Up and it
works... not as I expected (i'm used to MS Access)

Thanks to you

"Chris Pollach" <cpol...@travel-net.dot.com> wrote in message
news:455b2c37$1@forums-1-dub...

Chris Pollach

unread,

Nov 15, 2006, 9:26:59 AM11/15/06

to

Great .. have a super day! -:)

"Stephen" <smar...@cbgi.qc.ca> wrote in message

news:455b304b$1@forums-1-dub...

Stephen

unread,

Nov 15, 2006, 10:28:27 AM11/15/06

to

Hi again!

Everything was fine until i've been told that what we want is not from left
to right but from top to bottom on 2 columns. i'm using the N-up report that
i've created earlyer.

how do I change that?

"Chris Pollach" <cpol...@travel-net.dot.com> wrote in message

news:455b31c3$1@forums-1-dub...

Chris Pollach

unread,

Nov 15, 2006, 11:15:00 AM11/15/06

to

Ahhh .. then it would be back to the Tabular format and then use the
"Newspaper Columns Across" in the Print Specifications tab. Do not forget to
play with the "Newspaper Column Width" to fine tune and add the appropriate
sorting option to your SQL or DW property.

"Stephen" <smar...@cbgi.qc.ca> wrote in message

news:455b402b$1@forums-1-dub...

Stephen

unread,

Nov 15, 2006, 11:37:52 AM11/15/06

to

In the menu, Design/Options
on the tabpage "Generation", there's an option called "Presentation Style"
CrossTab is selected. If I change that to Tabular nothing happens and the
setting isn't saved at all.. I guess that I cannot change the presentation
style that way and that i've got to recreate the report. Am I wrong?

"Chris Pollach" <cpol...@travel-net.dot.com> wrote in message

news:455b4b14$1@forums-1-dub...

Stephen

unread,

Nov 15, 2006, 11:56:06 AM11/15/06

to

meanwhile... i've recreated the report in Tabular Format.
2 fields (Code, Description)
i've changed the newspaper columns across to 2
the width was automatically set to 1600.

I've unchecked the option "autosize height" for the Subreport and adjusted
the height so I can have 4 records per line.

Run the app... all i can see is 4 rows in column1 and nothing in column2.
What am I doing wrong this time... it seems so easy and it doesn't work.

"Chris Pollach" <cpol...@travel-net.dot.com> wrote in message

news:455b4b14$1@forums-1-dub...

Chris Pollach

unread,

Nov 15, 2006, 12:00:16 PM11/15/06

to

Correct .. you will have to recreate the Report as a Tabular. There is no
facility currently to convert from one DW presentation Style to another.

"Stephen" <smar...@cbgi.qc.ca> wrote in message

news:455b5070$1@forums-1-dub...

Chris Pollach

unread,

Nov 15, 2006, 12:23:17 PM11/15/06

to

Steve;

To see the full effect of what will actually be printed, use the
Run/Preview on the DWO in the System Tree. Then, when running the DWO
independently - toggle the File => Print Preview menu option to see the
full effect of the News Paper column settings.

Regards ... Chris

"Stephen" <smar...@cbgi.qc.ca> wrote in message

news:455b54b6$1@forums-1-dub...

Stephen

unread,

Nov 15, 2006, 12:59:15 PM11/15/06

to

When you say "what will be printed" you mean on paper or on screen too
because I need to see it on screen.

Here's what i've done:
1 - File: Run/Preview... The File: "print preview" option is checked and
disabled so I cannot modify it
2 - Select sub report(dw_subreport)... there's no data...
3 - Rows: Retrieve... The report asks for a parameter.
4 - I enter 100... Data is retrieved

All the data is in 1 column.

Re-do steps 1 to 4 for dw_Report which contains the subreport
After the data is retrieved, the data from the subreport is still on 1
column. I tried to print it to see if it was going to be on 2 columns but it
was not.

There's still something missing.
any idea?

"Chris Pollach" <cpol...@travel-net.dot.com> wrote in message

news:455b5b15$1@forums-1-dub...

Chris Pollach

unread,

Nov 15, 2006, 1:22:42 PM11/15/06

to

Steve;

For the screen viewing add the statement (after you init the DWO) ...

DC.Object.DataWindow.Print.Preview='Yes'

Then the user will see it as it would be on a piece of paper.

HTH

Regards ... Chris
PS: I admit though - this is a confusing feature.

"Stephen" <smar...@cbgi.qc.ca> wrote in message

news:455b6383@forums-1-dub...

Stephen

unread,

Nov 15, 2006, 2:28:18 PM11/15/06

to

nope...
only 1 column is displayed.
there's something else.

can you tell me if i forget something

STEPS: Creating the sub report
create datawindow (Tabular format)
add Retrieval Argument: Arg_id Number
Select Code, Description from table2 where parent_code = :Arg_id)

set Newspaper Columns across = 2
Newspaper Columns width will be set automatically
Save as dw_SubReport

Creating the Report
create datawindow
add Retrieval Argument: Arg_id Number
Select ... lot of fields... from table2 where Main_code = :Arg_id)
insert Report object dw_SubReport
adjust its height so it can contain 4 rows
adjust its width so it can contain 2 columns
define Argument 1.expression = Arg_id //we pass the argument from the
report to the subreport

Save as w_report

Create window
in the constructor event put this code:
this.settransobject(SQLCA)
this.Object.DataWindow.Print.Preview='yes'
this.retrieve(100)

call that window from the main program.

Run app and hope it works. :)

so... what's missing?

thanks for your time !
Stephen

"Chris Pollach" <cpol...@travel-net.dot.com> wrote in message

news:455b6902$1@forums-1-dub...

Stephen

unread,

Nov 15, 2006, 2:41:07 PM11/15/06

to

I'm using Powerbuilder 10.5 build 4523
i'm downloading the ebf to upgrade to build 5079 in case it works in that
version...

Stephen

unread,

Nov 15, 2006, 3:32:54 PM11/15/06

to

Nope it still doesn't work... have you checked the last message I wrote?
Maybe it could help you find what I do wrong.

"Stephen" <smar...@cbgi.qc.ca> wrote in message

news:455b7b63@forums-1-dub...

Chris Pollach

unread,

Nov 16, 2006, 7:37:57 AM11/16/06

to

Do not waste your time with the EBF's - it works great for me with PB 10.5
GA (build 4523 )

Can you export the DW you are trying to use and post it here to the NG? I
can then look at it for.

"Stephen" <smar...@cbgi.qc.ca> wrote in message

news:455b7b63@forums-1-dub...

Chris Pollach

unread,

Nov 17, 2006, 10:03:20 AM11/17/06

to

OK ... I am confused - what is the problem again?

"Stephen" <smar...@cbgi.qc.ca> wrote in message

news:455cc098$1@forums-1-dub...
> I see the problem!!!
>
> check this... you'll understand what's wrong.

>
>
>
> "Chris Pollach" <cpol...@travel-net.dot.com> wrote in message

> news:455cb2db@forums-1-dub...
> >
> > hmmm .. works well for me (see attached).

> >
> >
> >
> >
> > "Stephen" <smar...@cbgi.qc.ca> wrote in message

> > news:455c9227@forums-1-dub...
> >> I've recreated it without arguments to make things easier for you but
it
> >> still doesn't work.

> >>
> >>
> >> "Chris Pollach" <cpol...@travel-net.dot.com> wrote in message

> >> news:455c69b5$1@forums-1-dub...

Stephen

unread,

Nov 21, 2006, 8:50:36 AM11/21/06

to

Ok, i'll explain from the start.
The data in the subreport is not displayed in 2 columns as I want (from top
to bottom for each column).
I need 4 records in the left column and 4 on the right column.
The example you sent me was filled with a lot more records than I have.
That's why your subreport was filling the entire left column (like if it was
a 8½ x 11 sheet) and continued to the right.
With only 8 records, I cannot fill a 8 ½ x11 sheet( from top to bottom).
That's why it doesn't continue to the right column. The subreport sheet
should be something like 8½ x 3 inches.. but I don't know how to do that.

is it clearer?

"Chris Pollach" <cpol...@travel-net.dot.com> wrote in message

news:455ddd48$1@forums-1-dub...

Chris Pollach

unread,

Nov 22, 2006, 6:56:59 AM11/22/06

to

Ahhhh ... so you want to balance out number of items listed on the left vs
the RH side?

"Stephen" <smar...@cbgi.qc.ca> wrote in message

news:4563123c$1@forums-1-dub...

Stephen

unread,

Nov 23, 2006, 11:07:46 AM11/23/06

to

Yes!
I thought that reducing the size of the subreport object would do that but
it is not the case.
Do you know what I should do?

"Chris Pollach" <cpol...@travel-net.dot.com> wrote in message

news:4564491b$1@forums-1-dub...

Chris Pollach

unread,

Nov 23, 2006, 12:36:07 PM11/23/06

to

What I normally do for this is create two nested reports (in your case from
the same DWO). Then at run time load the entire ResultSet into a work DS.
Copy the 1st 50% of the DS's buffer to nested DWO #1 and the balance of the
DS's buffer to nested DWO #2.

"Stephen" <smar...@cbgi.qc.ca> wrote in message

news:4565d562$1@forums-1-dub...