473,326 Members | 2,090 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

CRYSTAL REPORT TO Sql SERVER WITH vb6.0

103 100+
HI ALL,

i want to know that how to connect crystal report to Sql SERVER with vb6.0

i'm trying to get rid of this probs sine last 2 days but not succeded.

Can someone suggest me a website which does contain method ( i mean the form piccs)to connect or please give me a step by step procedure for connection between crystal report and sql server....

i hope you will help me...............
waiting for quick reply....

:confused:

ThanKs in Advance

Nick
May 16 '08 #1
12 11057
debasisdas
8,127 Expert 4TB
What version of CRYSTAL REPORT you are using ?

Try to create a DSN and connect to Sql SERVER .
May 16 '08 #2
Vbbeginner07
103 100+
What version of CRYSTAL REPORT you are using ?

Try to create a DSN and connect to Sql SERVER .
that too is not connecting.....
May 16 '08 #3
debasisdas
8,127 Expert 4TB
what is the error that you are getting ?

are you able to connect to the sql server directly ?
May 16 '08 #4
Vbbeginner07
103 100+
what is the error that you are getting ?

are you able to connect to the sql server directly ?
yes i able to connect it directly and i have succeded in that,but to view this using vb6....how can i do that.....
i have a kept a "print" command button...please help me to write the code.....i have already done the rept that too directly....


please sugest me the code.
Thanks in advance.
NICK
May 17 '08 #5
Vbbeginner07
103 100+
yes i able to connect it directly and i have succeded in that,but to view this using vb6....how can i do that.....
i have a kept a "print" command button...please help me to write the code.....i have already done the rept that too directly....


please sugest me the code.
Thanks in advance.
NICK
i am after this for a couple of days please help..........

NIKHITA.....
May 19 '08 #6
debasisdas
8,127 Expert 4TB
what exactly is the error that you encounter ?

how are you trying to display the report ?
May 19 '08 #7
gpl
152 100+
i am after this for a couple of days please help..........

NIKHITA.....
Back in 2001 I had a similar trouble, the report viewer in VB6 would not render our reports.

After a lot of searching, it turned out that we needed a component from VB6 SP4 installed, after that it worked well.

I am sorry but after so long, the actual details are forgotten and the source code has been consigned to the scrap heap.

Do a Google search and you may find the answer -- what version of Crystal are you using ??

Graham
May 19 '08 #8
QVeen72
1,445 Expert 1GB
Hi,

You never mentioned Version of your CR...
You succeeded in Creating Report means,
You must have created the ODBC properly and is Previewed Data showing properly...?

Without mentioning these details, how can anyone help you...?

Regards
Veena
May 20 '08 #9
Vbbeginner07
103 100+
Hi,

You never mentioned Version of your CR...
You succeeded in Creating Report means,
You must have created the ODBC properly and is Previewed Data showing properly...?

Without mentioning these details, how can anyone help you...?

Regards
Veena
sorry for not giving the correct infm let me telll u veena,i have done the same as u explaind
.............now i need to view the report of the employees within a range and individually
by pressing a button.....
im using sql server 7.0

my queries:

1) how do i connect sql with crystal report(7.0)......im gettn as a crys.report viewer.

2) is it possible to me to get report as :

name
Nikhita
id 100
working hours 10
Overtime hours 5
Salary 30000



please clear my queries


...Thanks in advance:
NICK
May 21 '08 #10
QVeen72
1,445 Expert 1GB
Hi,

use this code to show the report in VB:

Place the Crystal Report control on the form...

Expand|Select|Wrap|Line Numbers
  1. CrystalReport1.ReportFileName = App.Path & "\MyReportName.rpt"
  2. CrystalReport1.Connect = "DSN=MyDSNName"
  3. CrystalReport1.Action = 1
  4.  
Yes you can print the report in that format..
Go to Report Designer, Open the Report, and Increase the Detail Section (add few lines) and Place the Fields one below another.. save and View report

Regards
Veena
May 21 '08 #11
what im guessing is that he has connected CR to a sql server and can view the reports in cystal.

now he wants to view the reports in vb6 when he clicks a button.

ive tried this before but failed so i cant give you any help past this :( sorry
May 21 '08 #12
Vbbeginner07
103 100+
Hi,

use this code to show the report in VB:

Place the Crystal Report control on the form...

Expand|Select|Wrap|Line Numbers
  1. CrystalReport1.ReportFileName = App.Path & "\MyReportName.rpt"
  2. CrystalReport1.Connect = "DSN=MyDSNName"
  3. CrystalReport1.Action = 1
  4.  
Yes you can print the report in that format..
Go to Report Designer, Open the Report, and Increase the Detail Section (add few lines) and Place the Fields one below another.. save and View report

Regards
Veena

Hi,
but i have a crviewer,i have got errors while at runtime......

[vb code:]

Private Sub cmdRpt_Click()
Set report = crystal.OpenReport("C:\Program Files\Seagate Software\Crystal Reports\report.rpt")
Form1.CRViewer1.DisplayBorder = False
Form1.CRViewer1.DisplayTabs = False
report.DiscardSavedData
report.Database.SetDataSource rs

ERROR:

Run-time Varaible 91
Object variable or With block variable not set.....




Thanks
Nikhita
May 23 '08 #13

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: rAGHU | last post by:
Hi, In my ASP.NET web application project we need to design crystal reports with Crystal Reports version 8.5 enterpraise edition(Please Note:It is not the Crystal Reports that comes with...
4
by: Grant Stanley | last post by:
I'm developing an application in VS.Net 2003 using C#, which uses Crystal Reports. When creating each report, crystal asks where the database to use is, so I specify our SQL server using the ADO...
7
by: Phin | last post by:
I need your HELP! I've seen all the posts on using Crystal Reports within vs.net (vb.net) and changing a SQL query at runtime. When I tried to pass in a dataset into the crystal report at...
2
by: airkart | last post by:
Hello, I've scoured groups and the web, and haven't found a question like mine answered. I'm using Visual Studio 2003 with the Crystal Reports it comes bundled with and SQL Server 2000....
2
by: Karun Karunakaran | last post by:
Hi, I am using the Crystal Enterprise .NET assemblies to generate and display a crystal report in a webform. This report connects to an SQL server (running locally) using a specific username and...
3
by: Milan Todorovic | last post by:
Hello, I need help. I have experience in ASP.NET programming, but this is my first dealing with Crystal Reports. I'm trying to make the most basic report purely for testing purposes: connect to...
1
by: bthomas71chevy | last post by:
I have just setup a WebServer and all the applications work fine, but when every any of the applications try to generate a Crystal Report the page errors out. "File or assembly name...
9
by: Altman | last post by:
I am currently using ASP.Net 2003 and will be upgrading to 2005 sometime in the near future. I have been having issues with using Crystal Reports that were included with .Net to handle my...
2
by: microsoft . public . sqlserver | last post by:
I am a Web developer. I am new to VB 6.0 and Crystal Report. I have joined an organisation where there is an application running(developed in VB6 and crystal report 7). I have to modify one report....
2
by: Simone | last post by:
Hello I am new to this :) I have created a crystal reports and tried using the Crystal Report Viewer but when I try to preview the report it prompts me for a user name and password. I am using...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.