Ad:

Visual Basic 4 / 5 / 6 Discussion Thread
Unsolved
Views: 7224

Feb 12th, 2007

Re: How to Create Product Registration Code for VB Application.

Expand Post »

IS there a way of generating reports from VB6 ( not through Data Reports & Crystal Reports ) which directly sends to a local printer and printing should be done fast, No matter what ever may be the font.

Similar Threads

generating one report from multiple tables in Visual Basic 4 / 5 / 6
Vb report generation in Visual Basic 4 / 5 / 6
Creating a form that display a continuous collection of pics in MS Access and FileMaker Pro
printing several objects in VB.NET
Help in understanding Adwords conversion tracking report in Search Engine Optimization

vsraju

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Feb 2007

Permalink

Feb 11th, 2009

Re: How to Create A Report In VB

hey did u get answer for ur query as i am also in need of the answer for the same query. plz reply asap.

suzz

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Feb 2009

Permalink

Feb 11th, 2009

Re: How to Create A Report In VB

So... Suzz. Let's not post to threads that are two years old.

Comatose

Team Colleague

Reputation Points: 361

Solved Threads: 214

Taboo Programmer

Offline

2,413 posts
since Dec 2004

Permalink

Feb 11th, 2009

Re: How to Create A Report In VB

I can think of 2 function that could able to help you.
#1 Printing by IE
#2 Print Any kind of File

' #1 Print By IE

vbnet Syntax (Toggle Plain Text)
Dim oIE
Dim FileName
FileName = "c:\myfile.txt" ' or .html or .xml depending on where you stored the data you want to print
oIE = CreateObject("InternetExplorer.Application")
oIE.Visible = True ' You can change this to False
oIE.Navigate2 (FileName)
While oIE.ReadyState <> 4
Wend
oIE.ExecWB 6, 0  ' Print
'oIE.ExecWB 7, 0 ' Print Preview
Dim oIE
Dim FileName
FileName = "c:\myfile.txt" ' or .html or .xml depending on where you stored the data you want to print
oIE = CreateObject("InternetExplorer.Application")
oIE.Visible = True ' You can change this to False
oIE.Navigate2 (FileName)
While oIE.ReadyState <> 4
Wend
oIE.ExecWB 6, 0  ' Print
'oIE.ExecWB 7, 0 ' Print Preview

#2 PrintFile Function

vb.net Syntax (Toggle Plain Text)
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
    (ByVal hwnd As Long, _
     ByVal lpOperation As String, _
     ByVal lpFile As String, _
     ByVal lpParameters As String, _
     ByVal lpDirectory As String, _
     ByVal nShowCmd As Long) As Long
 FileName = "c:\myfile.txt" ' Any kind of file (xls doc xml html )
 nRetVal = ShellExecute(0, "Print", FileName, "", "", 0)
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
    (ByVal hwnd As Long, _
     ByVal lpOperation As String, _
     ByVal lpFile As String, _
     ByVal lpParameters As String, _
     ByVal lpDirectory As String, _
     ByVal nShowCmd As Long) As Long
 FileName = "c:\myfile.txt" ' Any kind of file (xls doc xml html )
 nRetVal = ShellExecute(0, "Print", FileName, "", "", 0)

samir_ibrahim

Reputation Points: 69

Solved Threads: 19

Junior Poster

Offline

155 posts
since Sep 2008

Permalink

Feb 11th, 2009

Re: How to Create A Report In VB

I did not notice that this post is 2 years old.

Should I delete my answer?

samir_ibrahim

Reputation Points: 69

Solved Threads: 19

Junior Poster

Offline

155 posts
since Sep 2008

Permalink

Feb 12th, 2009

Re: How to Create A Report In VB

your syntax was written in .net. hahahah....
do u have any vb code to share?

please support this thread even it 2 year old posted. ^_^

jaasaria

Reputation Points: 10

Solved Threads: 1

Junior Poster

Offline

123 posts
since Jul 2007

Permalink

Feb 12th, 2009

Re: How to Create A Report In VB

Click to Expand / Collapse Quote originally posted by jaasaria ...

your syntax was written in .net. hahahah....

It is vb6 but I did not know what is [ code=What? ] [ /code ] to write in vb6 syntax

Quote ...

do u have any vb code to share?

Actually I don't have any vb code to share.

The above 2 examples are my code in Visual foxpro, and I convert them to vb6 when I saw this message

Quote ...

please support this thread even it 2 year old posted. ^_^

Did you try the above example and they did not work?

What do you need to know more ?

samir_ibrahim

Reputation Points: 69

Solved Threads: 19

Junior Poster

Offline

155 posts
since Sep 2008

Permalink

Sep 10th, 2010

Render HTML or XML/XSL as PDF

Click to Expand / Collapse Quote originally posted by vsraju ...

IS there a way of generating reports from VB6 ( not through Data Reports & Crystal Reports ) which directly sends to a local printer and printing should be done fast, No matter what ever may be the font.

How about a way to render directly to the browser a PDF from either a stream, or XML/XSL File. If you know of a way lmk.

astonvic

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Sep 2010

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: DoCmd.Close acForm, Me.Name closes Access instead of Form

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: SQL STATEMENT INSERT INTO .sdf db?

DaniWeb Message

Cancel Changes

User Name
Password