URGENT: crystal report and oracle 10g

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
gildan2020Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
frodomanConnect With a Mentor Commented:
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
0
 
gildan2020Author Commented:
hi, i've tried that but it gave me this error...

Query Engine Error: 'C:\DOCUME~1\gildan\LOCALS~1\Temp\temp_235e...blah blah lbah.rpt'

wat do i do?


gildan2020
0
 
frodomanCommented:
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.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
gildan2020Author Commented:
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
0
 
gildan2020Author Commented:
update: i just tested it with a datagrid and there seems to be no problem, it fetches all the data correctly

gildan2020
0
 
Bob LearnedCommented:
Are you using the Oracle provider to access your Oracle database?

Bob
0
 
gildan2020Author Commented:
yes, i'm using the oraoledb...btw i'm using oracle 10g
0
 
Bob LearnedCommented:
Not the OleDb provider, the OracleDataAdapter, OracleCommand, OracleConnection, etc.

Bob
0
 
gildan2020Author Commented:
oh sorry, i'm using the oracle connection
0
 
Bob LearnedCommented:
Do you have Visual Studio.NET 2003?  It has the OracleDataAdapter.

Bob
0
 
gildan2020Author Commented:
i'm using visual studio .net 2002
0
 
Bob LearnedCommented:
Okay, back to business.

What was the full error when you tried to connect Crystal Reports to the dataset?

Bob
0
 
gildan2020Author Commented:
i get something like this...

Query Engine Error: 'C:\DOCUME~1\gildan\LOCALS~1\Temp\temp_235e...blah blah lbah.rpt'

the temp is too long and full of alphanumeric characters
0
 
Bob LearnedConnect With a Mentor Commented:
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
0
 
gildan2020Author Commented:
ok, i'm gonna need some time to find out about this

i'll keep u posted, thx

gildan2020
0
 
Bob LearnedCommented:
Did you find out anything yet?

Bob
0
 
gildan2020Author Commented:
hi, sorry for replying this late

i finally got it to working
thx a lot

gildan2020
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.