We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
3 days, 18 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
URGENT: crystal report and oracle 10g
Posted on 2004-04-29
hi, i need some help with vb.net's crystal report
i'm using oracle 10g as the database for my prog, right now i need to produce a report based on SQL QUERIES that accepts values from users
i know how to establish connection between vb.net and oracle 10g, but i dunno how to do so between crystal report and oracle 10g
pls help...
thx,
gildan2020
i'm using oracle 10g as the database for my prog, right now i need to produce a report based on SQL QUERIES that accepts values from users
i know how to establish connection between vb.net and oracle 10g, but i dunno how to do so between crystal report and oracle 10g
pls help...
thx,
gildan2020
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
9
6
2
17 Comments
I would advise that you create your dataset with vb.net and just pass it to the crystal report.
It's possible to create a crystal report that connects to oracle, but if your results are based on user values that's going to be more difficult or impossible (depending on the specifics) to do. It will be much more efficient to handle the user values in your application and send the completed dataset to crystal.
Here's a walkthru for doing this: http://support.businessobjects.com/communityCS/TechnicalPapers/rtm_reportingoffadonetdatasets.pdf.asp
It's possible to create a crystal report that connects to oracle, but if your results are based on user values that's going to be more difficult or impossible (depending on the specifics) to do. It will be much more efficient to handle the user values in your application and send the completed dataset to crystal.
Here's a walkthru for doing this: http://support.businessobjects.com/communityCS/TechnicalPapers/rtm_reportingoffadonetdatasets.pdf.asp
hi, i've tried that but it gave me this error...
Query Engine Error: 'C:\DOCUME~1\gildan\LOCALS
wat do i do?
gildan2020
Query Engine Error: 'C:\DOCUME~1\gildan\LOCALS
wat do i do?
gildan2020
Query Engine Error can mean just about anything.
Make sure your dataset is being populated correctly - maybe attach it to a datagrid or something to verify that the correct data is being pulled in.
Make sure your dataset is being populated correctly - maybe attach it to a datagrid or something to verify that the correct data is being pulled in.
well...i can't prove much but with the same steps on a different type of database, such as Access
i can pull everything out correctly, into the crystal report without any errors. so, i doubt that the dataset has any problems in it.
gildan2020
i can pull everything out correctly, into the crystal report without any errors. so, i doubt that the dataset has any problems in it.
gildan2020
update: i just tested it with a datagrid and there seems to be no problem, it fetches all the data correctly
gildan2020
gildan2020
Okay, back to business.
What was the full error when you tried to connect Crystal Reports to the dataset?
Bob
What was the full error when you tried to connect Crystal Reports to the dataset?
Bob
i get something like this...
Query Engine Error: 'C:\DOCUME~1\gildan\LOCALS
the temp is too long and full of alphanumeric characters
Query Engine Error: 'C:\DOCUME~1\gildan\LOCALS
the temp is too long and full of alphanumeric characters
Have you seen this:
Err Msg: "Query Engine error..." when running a .NET app on a client computer
http://support.businessobjects.com/library/kbase/articles/c2011164.asp
Bob
Err Msg: "Query Engine error..." when running a .NET app on a client computer
http://support.businessobjects.com/library/kbase/articles/c2011164.asp
Bob
Featured Post
For Any Use & On Any Platform
Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Introduction
When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
- Document Management
- Printers and Scanners
- Document Imaging
- Software-Other
- Images and Photos
- Adobe Acrobat, Photos / Graphics Software, Security, OCR, *PDF
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses
Course of the Month3 days, 18 hours left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.