473,320 Members | 1,933 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.

Viewing Multiple Crystal Reports

07.02.2007 / 2020 hours.

I am basically working as an astrologer, and have developed my own
software in VB6.0 + Access + Crystal Report 4.6.1.0

What ever I select (I enter code, which automatically displays name on
Label) and after clicking Command button, crystal report is displayed on
screen.

Subsequently I close the report and go in for some other name and view
another report. If this process is continued for 3-4 times, I
experience system (PC) getting hanged.

Could you please suggest me ways and means enable me to come out of this
problem (PC getting hanged).

Data1.DatabaseName = App.Path & "\ASTRO_INFO.mdb"
crystalreport1.ReportFileName = App.Path & "\KUNDALI.rpt"
crystalreport1.DiscardSavedData = True
crystalreport1.SelectionFormula = "({ASTRO_DATA.CODE}) ='" +
txtpatcode.Text + "'"
crystalreport1.WindowState = crptMaximized
crystalreport1.Action = 2

I would be grateful to you all, if you can help me / guide me in this
matter and oblige.

Thanks once again.

Sher Dil.
pa***********@yahoo.co.in

*** Sent via Developersdex http://www.developersdex.com ***
Feb 7 '07 #1
1 2634
If you are using an "Access" database to store data that you retrieve in
your VB6 program, that is a misnomer, and you are actually using a "Jet"
database, which happens to be the default database engine used by Access.
Access is the database UI and development tool, and can use other database
engines, too.

VB6 and Access have a superficial similarity and share the core VBA library
of the programming language, but because the object models are quite
different, you can't always do the same thing in both and expect the same
result.

Further, because Access itself has such a capable Reporting facility, almost
no one uses Crystal Reports with Access, so an Access newsgroup is not
usually a productive source for questions about Crystal.

Larry Linson
Microsoft Access MVP
"Sher Dil" <pa***********@yahoo.co.inwrote in message
news:45*********************@news.qwest.net...
07.02.2007 / 2020 hours.

I am basically working as an astrologer, and have developed my own
software in VB6.0 + Access + Crystal Report 4.6.1.0

What ever I select (I enter code, which automatically displays name on
Label) and after clicking Command button, crystal report is displayed on
screen.

Subsequently I close the report and go in for some other name and view
another report. If this process is continued for 3-4 times, I
experience system (PC) getting hanged.

Could you please suggest me ways and means enable me to come out of this
problem (PC getting hanged).

Data1.DatabaseName = App.Path & "\ASTRO_INFO.mdb"
crystalreport1.ReportFileName = App.Path & "\KUNDALI.rpt"
crystalreport1.DiscardSavedData = True
crystalreport1.SelectionFormula = "({ASTRO_DATA.CODE}) ='" +
txtpatcode.Text + "'"
crystalreport1.WindowState = crptMaximized
crystalreport1.Action = 2

I would be grateful to you all, if you can help me / guide me in this
matter and oblige.

Thanks once again.

Sher Dil.
pa***********@yahoo.co.in

*** Sent via Developersdex http://www.developersdex.com ***

Feb 8 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Lewis via DotNetMonster.com | last post by:
I've created an program that uses crystal reports and have no problems on the machine that I created it on but when viewing the app on another machine I get teh error message "File or assembly name...
3
by: lee_mcknight | last post by:
I am using Crystal Enterprise V9. I have a report that needs to have multiple datasets as the datasource(s) on a single subreport (some common lookup data I need to join to is stored in a seperate...
6
by: James Radke | last post by:
Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing...
2
by: Atley | last post by:
I have imbedded a report in my project (added a report to my project and set some fields) How the heck do I access the report in my program? I have looked on MSDN and searched for a...
4
by: John R. Dougherty | last post by:
I have developed an application with VB.NET, which includes the Crystal Reports (Visual Studio .NET 2003 edition) controls. I can run the application on my PC and it does work fine, but on any...
1
by: monskie | last post by:
Hello to all, I have a problem which could be trivial to you guys. This concerns opening several crystal reports on the a crystal viewer on an ASPX page by calling window.open. My...
3
by: ian_jacobsen | last post by:
First let me start by saying that this problem is not consistently reproducible. I have a windows service that creates reports for a group of entities. This service can process multiple groups at...
2
by: Rod | last post by:
We've got an old VB6 application which has 9 Crystal Reports it can print. These 9 reports are considered by our users to be in essence one "report", in the sense that they are all related and they...
0
by: r0ckster | last post by:
Hi! I have an asp application that is using crystal report 10/crystal report viewer to view reports on the web. This app works well in windows 2k but when i migrated the code to xp, the error...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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)...
0
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.