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
15 days, 10 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
Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
It’s quite interesting for me as I worked with Excel using vb.net for some time.
Here are some topics which I know want to share with others whom this might help.
First of all if you are working with Excel then you need to Download the Following
…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex.
A simple solution to parsing a customized CSV fi…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.
How Percona can help
Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month15 days, 10 hours left to enroll
743 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.