Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
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
Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should. An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way.
I've always enjoyed working with graphics, but it's never too clever to re-invent …
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 …
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data.
But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses
Course of the Month10 days, 5 hours left to enroll
610 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.