Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server printing VB.NET , +
Hello Theree
these is my first writing here with you guys I hope it will not be the last as i'm loving this website as I learned a lot from it. so I just have a question i'm a newbie actually and I need to complete an application with VB.NET (it will help me at work)
anyway i'll start with my config :
Visual Studio 2012
SQL Server 2012
quiet a fortune lol
 
as you can see in the excel document attached :
is's a material consumption
i need to enter evey travel information for any of my vehicules at work.
I'm working now as you can see in excel
and I have to copy and paste that table for every vehicule.
so what i need to do is : enter the veihicule information (a table reservec only for vehicule information)
(in excel from line 7 to line 11)
 
and now when i want to enter a trip info for some of those vehicules i want to select just the registration N) or whatever is associated whith that car in a combobox
then enter all other information in the table date, counter info .. etc and hit save
 
that now pretty much the input process
 
about the printing it's quiet complicated for me.
i want when i select a vehciule in a certain year (time interval) i want it to show me the input info from the SQL server database and put it into the designed report.
that report I can't figure out how to design it to fit my needs , as I want it to be splited into to A4 pages, the first will end at the 51'th line (excel) the "Refer to total"
and the rest will be printed in the second page.
 
i think it's all, and i'll appreciate for you help.
Thank You so much
 
excel file
 
David
Posted 25-Mar-13 11:39am
Grafid386
Edited 25-Mar-13 11:40am
(no name)105.2K
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web04 | 2.8.1411022.1 | Last Updated 25 Mar 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100