VB 6.0 How to display report with pic.

Asked By anonymous 7060 points N/A Posted on - 03/17/2012

How to display reports with pictures for each record along with other data saved in my database?

Please help me.

• Status: Open
• Question Views: 1046
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Visual basic

Best Answer by Sharath Reddy

Go To Solution

Answered By Kanhai Else 0 points N/A #82737

VB 6.0 How to display report with pic.

Visual Basic Data Reports cannot display Images stored for each record in database. However some fixed images can be displayed. In order to display such records you may try to create files in HTML format from Visual basic and open the report using Internet  Explorer. The best way is to

1. Open files in text mode

2. Assign necessary html elements and tags.

3. Put the database variables in proper position in the html document.

4. Save it and open with Internet Explorer.

5. Dim xx as new Internet Explorer

6. xx . openUrl(< file name>)

Else Another option Is to Install Crystal Reports which is easily accessible through Visual Basic.

Thanks.

About Kanhai Else

Questions
0

Answers
56

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 03/18/2012
• Question Category: Visual basic

Best Answer

Best Answer

Answered By Sharath Reddy 590495 points N/A #82738

VB 6.0 How to display report with pic.

 

Since you want visual representations of your database, you can use Crystal Report. It is a reporting program that will let you produce reports coming from different data sources. With it you can make reports, print preview as well as print. It works on SQL Server and VB.NET. For an example, here is a brief explanation of creating a Crystal Report using VB.NET.

• Start Visual Studio .NET then create or choose a new project. Click Project, Add New Item, and then select Crystal Report.
• Select the report type from the Crystal Reports Gallery, accept the default settings, and then hit OK.
• In “Create New Connection”, select OLE DB [ADO]. This sets the proper connection to your SQL database server.
• Choose Microsoft OLE DB Provider for SQL Server.
• Select the SQL Server Name and then enter your user ID and password. Next select your Database Name, click Next followed by Finish.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 05/04/2013
• Question Category: Visual basic