473,320 Members | 1,766 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,320 software developers and data experts.

Crystal Report 8.5 and Visual Basic 6.0 Problem

Hello guys,

I am having a difficult time connecting VB6 to CR 8.5... I have tried adding Crystal report 8.5 in my project and use it as a designer tool.. i am successful designing the report, here's my question...

1. How can i view my report?
2. is there any connection needed?
3. before i did this, there is an error message saying: "Failed to add viewer".
4. what could be the impact of this eror?
5. does the error related to my problem in viewing the report?
6. How can i get rid this error?

Thanks guys!
Jan 10 '08 #1
7 2752
debasisdas
8,127 Expert 4TB
add a crystla report viewer to the form

try the sample code (this is for connection to Oracle)

Expand|Select|Wrap|Line Numbers
  1. Public Sub ReportDisplay(Query As String)
  2.  
  3. Set CRXReport = visitordetails
  4. Set CRXDb = CRXReport.Database
  5. CRXReport.DiscardSavedData
  6.  
  7. inti = 1
  8. Do Until inti = CRXReport.Database.Tables.Count + 1
  9. CRXReport.Database.Tables.Item(inti).SetLogOnInfo strdblocation, "das", "debasis", "debasis"
  10. inti = inti + 1
  11. Loop
  12.  
  13. visitordetails.SQLQueryString = Query
  14.  
  15. With FrmReport1
  16. .Show
  17. .CRV1.ReportSource = CRXReport
  18. .CRV1.ViewReport
  19. End With
  20.  
  21. Set CRXReport = Nothing
  22. End Sub
  23.  
  24.  
Jan 10 '08 #2
Hi Sir,

i forgot to tell you...My database back-end is MS Access...will this code work for me??

Thanks,
Jan 10 '08 #3
debasisdas
8,127 Expert 4TB
Please find a related discussion here.
Jan 10 '08 #4
Hi sir,

Why is it that i can't find the .ViewReport, .EnableExportButton, .EnableCloseButton and .ReportSource??

is there a problem with my .dll's?

How can i solve this problem?

Thanks!
Jan 10 '08 #5
lotus18
866 512MB
Hi sir,

Why is it that i can't find the .ViewReport, .EnableExportButton, .EnableCloseButton and .ReportSource??

is there a problem with my .dll's?

How can i solve this problem?

Thanks!
I think you need to add a reference to it : )

Rey Sean
Jan 10 '08 #6
QVeen72
1,445 Expert 1GB
Hi sir,
Why is it that i can't find the .ViewReport, .EnableExportButton, .EnableCloseButton and .ReportSource??
did you add "Crystal Viewer" Control to your form...?

-Veena
Jan 10 '08 #7
Hehehe.. Thanks guys!

whoooo!
Jan 11 '08 #8

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

Similar topics

0
by: Dr. Indera | last post by:
hello, i previously posted the questions below on several crystal reports newsgroups, including the one for the company that makes crystal reports, but never got an answer, so i'm hoping that...
6
by: Dr. Indera | last post by:
hello, much to my surprise, the version of crystal that comes with visual studio.net 2003 does not have a report preview window. i found out that i have to build a form in visual basic.net and...
5
by: BStorm | last post by:
I have a transaction log file where the DataSet table's Description column is actually delimited into "subcolumns" based upon the transaction id. I would like to parse these into separate fields...
2
by: http://www.visual-basic-data-mining.net/forum | last post by:
Hi, I wrote a program in VB.Net 2003. The program includes some reports made with Crystal Reports for Visual Studio.Net 2003. On my computer (with Win XP Pro) the program runs as it should do. ...
2
by: GC | last post by:
HI, I'am using Crystal Report with visual Studio .NEt 2003 When i make a report using a store procedure, I can not see all the fields of the store proc and i'm suppose to see those fields. I'm...
4
by: Wendy Elizabeth | last post by:
I would like to know how to print a crystal report that was generated in the ..NET framework using a Visual Basic.NET web application and/or a Visual basic.NET windows application. When crystal...
6
by: Robin Cushman | last post by:
Hi all, I need some help -- I'm working with an A2K database, using DAO, and am trying to read records into a Crystal Report and then export it to a folder on our network as an Excel...
0
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...
1
by: Serenityquinn15 | last post by:
Hi! I'm a newbe in Crystal Report, and it is my first time to use it in my Visual Basic.. I just wonder how I can Install Crystal Report 8.5 for use in Visual Basic 6.0 also connect it to...
3
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...
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...
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...
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: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.