Visual Basic 6 Data Report Question

[Me]

Hi all,

I have an app in which I need to create a packing slip. I have designed in
report designer. The data is pulled from a SQL database. My question is
how can I put information from the data base into the Page Header?
The way I have it setup right now the PageHeader contains the logo, title,
address. All of which are fine. Then under that I need to put the ship to
and bill to addresses, which are pulled from the data base. Then under that
I need to have the column headings for item number, qty ordered, etc...
These column headings are just labels. The packing slips are usually more
than one page. Because I had to put data from the database above the
headings I have had to put the headings into the detail section. That means
they only print on page 1. I would like them to print on subsequent pages.
The way I see this working I would need to have the page header somehow
include the ship to and bill to information. Any idea's? Am I making
sense?

Thanks for any help you can provide.

[Veign]

You have to use the Sections collection to get the header section and then
the Controls collection to change the controls caption or text.

like:
drMyReport.Sections("Section4").Controls("lblMyLab el").Caption = "Hello
World"

Where:
drMyReport is your Data Report
Section4 is the section where the controls you want to change reside
lblMyCaption is the name of the control you want to alter

--
Chris Hanscom - Microsoft MVP (VB)
http://www.veign.com
--

"Me" <yo*@me.com> wrote in message news:QK********************@rogers.com...

Hi all,

I have an app in which I need to create a packing slip. I have designed in report designer. The data is pulled from a SQL database. My question is
how can I put information from the data base into the Page Header?
The way I have it setup right now the PageHeader contains the logo, title,
address. All of which are fine. Then under that I need to put the ship to and bill to addresses, which are pulled from the data base. Then under that I need to have the column headings for item number, qty ordered, etc...
These column headings are just labels. The packing slips are usually more
than one page. Because I had to put data from the database above the
headings I have had to put the headings into the detail section. That means they only print on page 1. I would like them to print on subsequent pages. The way I see this working I would need to have the page header somehow
include the ship to and bill to information. Any idea's? Am I making
sense?

Thanks for any help you can provide.

[Me]

Thank you very much! I haven't done it yet but I am very appreciative of
your quick response. I have searched google for weeks looking for this.
"Veign" <[e-mail]> wrote in message
news:BA*****************@newsread3.news.atl.earthl ink.net...

You have to use the Sections collection to get the header section and then
the Controls collection to change the controls caption or text.

like:
drMyReport.Sections("Section4").Controls("lblMyLab el").Caption = "Hello
World"

Where:
drMyReport is your Data Report
Section4 is the section where the controls you want to change reside
lblMyCaption is the name of the control you want to alter

--
Chris Hanscom - Microsoft MVP (VB)
http://www.veign.com
--

"Me" <yo*@me.com> wrote in message
news:QK********************@rogers.com...

Hi all,

I have an app in which I need to create a packing slip. I have designed

in

report designer. The data is pulled from a SQL database. My question is
how can I put information from the data base into the Page Header?
The way I have it setup right now the PageHeader contains the logo,
title,
address. All of which are fine. Then under that I need to put the ship

to

and bill to addresses, which are pulled from the data base. Then under

that

I need to have the column headings for item number, qty ordered, etc...
These column headings are just labels. The packing slips are usually
more
than one page. Because I had to put data from the database above the
headings I have had to put the headings into the detail section. That

means

they only print on page 1. I would like them to print on subsequent

pages.

The way I see this working I would need to have the page header somehow
include the ship to and bill to information. Any idea's? Am I making
sense?

Thanks for any help you can provide.

[Me]

I tried it and it works great!! Move over Spiderman you are my new
superhero. Why is this information so hard to find?

"Veign" <[e-mail]> wrote in message
news:BA*****************@newsread3.news.atl.earthl ink.net...

You have to use the Sections collection to get the header section and then
the Controls collection to change the controls caption or text.

like:
drMyReport.Sections("Section4").Controls("lblMyLab el").Caption = "Hello
World"

Where:
drMyReport is your Data Report
Section4 is the section where the controls you want to change reside
lblMyCaption is the name of the control you want to alter

--
Chris Hanscom - Microsoft MVP (VB)
http://www.veign.com
--

"Me" <yo*@me.com> wrote in message
news:QK********************@rogers.com...

Hi all,

I have an app in which I need to create a packing slip. I have designed

in

report designer. The data is pulled from a SQL database. My question is
how can I put information from the data base into the Page Header?
The way I have it setup right now the PageHeader contains the logo,
title,
address. All of which are fine. Then under that I need to put the ship

to

and bill to addresses, which are pulled from the data base. Then under

that

I need to have the column headings for item number, qty ordered, etc...
These column headings are just labels. The packing slips are usually
more
than one page. Because I had to put data from the database above the
headings I have had to put the headings into the detail section. That

means

they only print on page 1. I would like them to print on subsequent

pages.

The way I see this working I would need to have the page header somehow
include the ship to and bill to information. Any idea's? Am I making
sense?

Thanks for any help you can provide.

[Veign]

Not common enough. The least a question is asked the harder it is to find
an answer...

Glad it worked for you..

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
--

"Me" <yo*@me.com> wrote in message news:VM********************@rogers.com...

I tried it and it works great!! Move over Spiderman you are my new
superhero. Why is this information so hard to find?

"Veign" <[e-mail]> wrote in message
news:BA*****************@newsread3.news.atl.earthl ink.net...

You have to use the Sections collection to get the header section and then the Controls collection to change the controls caption or text.

like:
drMyReport.Sections("Section4").Controls("lblMyLab el").Caption = "Hello
World"

Where:
drMyReport is your Data Report
Section4 is the section where the controls you want to change reside
lblMyCaption is the name of the control you want to alter

--
Chris Hanscom - Microsoft MVP (VB)
http://www.veign.com
--

"Me" <yo*@me.com> wrote in message
news:QK********************@rogers.com...

Hi all,

I have an app in which I need to create a packing slip. I have designed

in

report designer. The data is pulled from a SQL database. My question

is how can I put information from the data base into the Page Header?
The way I have it setup right now the PageHeader contains the logo,
title,
address. All of which are fine. Then under that I need to put the

ship to

and bill to addresses, which are pulled from the data base. Then under

that

I need to have the column headings for item number, qty ordered, etc...
These column headings are just labels. The packing slips are usually
more
than one page. Because I had to put data from the database above the
headings I have had to put the headings into the detail section. That

means

they only print on page 1. I would like them to print on subsequent

pages.

The way I see this working I would need to have the page header somehow
include the ship to and bill to information. Any idea's? Am I making
sense?

Thanks for any help you can provide.