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. 4 7253
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.Sect ions("Section4" ).Controls("lbl MyLabel").Capti on = "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******** ************@ro gers.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.
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" <me@home.com> wrote in message
news:BA******** *********@newsr ead3.news.atl.e arthlink.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.Sect ions("Section4" ).Controls("lbl MyLabel").Capti on = "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******** ************@ro gers.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.
I tried it and it works great!! Move over Spiderman you are my new
superhero. Why is this information so hard to find?
"Veign" <me@home.com> wrote in message
news:BA******** *********@newsr ead3.news.atl.e arthlink.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.Sect ions("Section4" ).Controls("lbl MyLabel").Capti on = "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******** ************@ro gers.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.
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******** ************@ro gers.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" <me@home.com> wrote in message news:BA******** *********@newsr ead3.news.atl.e arthlink.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.Sect ions("Section4" ).Controls("lbl MyLabel").Capti on = "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******** ************@ro gers.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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John |
last post by:
I have a problem, it's not with any code I have because... there is no code.
When I run a blank visual basic 6 form, it opens up just fine. When I add a
text box, a caption, and a button... it gives me an error from microsoft's
error report and asks me to send or not send the error, i chose and then it
quits. The error report won't let me copy the data, but i gather it's pretty
useless information unless you have the source code to visual...
|
by: Corrie Meyer |
last post by:
Announcement: SwiftReports standard edition 1.0 for Visual Studio
..NET 2003 released by UniSwift.
We are pleased to announce the first release of a fully-managed
reporting
tool for the Microsoft .NET framework. SwiftReports provides complete
code integration with the Visual Studio .NET 2003 environment.
Developers can use Visual Studio .NET 2003 to write code in either C#
or Visual Basic .NET for report control and event handling.
|
by: harish |
last post by:
I want to give a page break when my one of the field
change to some different value.
I want separte page for different value at run time.
|
by: praful pathak |
last post by:
i
i am praful pathak,porbandar
i want to develop my own cross tab report in visual basic 6 i know what
developed query from ms access but how to coded in visual basic in
designing time and how to construct it
plz solve this problem
query from ms access
TRANSFORM Sum(Temp.SumOfS_Qty) AS SumOfSumOfS_Qty
|
by: CAM |
last post by:
Hello,
I am wondering if someone can give me some pointers. Currently I am using
Access 2002 I developed an inventory tracking database, which this database
is used in California and in Florida. Unfortunaley Access is not very good
as an enterprise wide database, accessing the data from one side of the
United States to the other its so slow. About 5 years ago I developed a
database using Visual Basic 6 as the front end and Crystal...
| |
by: DUNXALEARE |
last post by:
Hello everyone!
I have a new assignment. I just dont know how to create a data report using ms excell.
I need to search particular group of data/records using Visual basic 6. in MS Access and transfered this selected data in MS Excel. to generate a report.
Please can anyone give me a tip or I'd rather say the syntax on how to edit,delete,add,search data in ms access using visual basic 6 without using Adodc component. (you see im having...
|
by: ranesmitas |
last post by:
i want to use crystal report in visual basic as i am new , i want to know i create crytal report in visual basic . we want to create designer (crystal report) in visual basic or in seagate crystal report ?
and please tell how i display report .please tell step by step
|
by: subratamaji |
last post by:
Hi,
I am new to crystal report.
Can any one plz guide how to use crystal report 11.5 with visual basic 6.0.
Is it already included in visual basic 6.0 or will have to include it from outside.
HOW CAN I SHOW DATA FROM ORACLE 9i IN VISUAL BSIC 6.0, THROUGH
CRYSTAL REPORT 11.5.
|
by: firozfasilan |
last post by:
I am new to visual basic 2008. In the past I have used vb6 to display an existing crystal report. I would like to accomplish the same with vb.net. However I am not clear on the syntax to display a crystal report using the crystal report viewer or crystal report document. Here is my code from vb6
Private Sub Form_Load()
CrystalReport1.Connect = "DSN=perfection;UID=crystal;PWD=crystal"
CrystalReport1.ReportFileName = "e:\Nittany...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |