Recent content by lynnd

I think you can pass nothing through the URL as in: http://<servername>/reportname.rpt?user0=user&password0=pwd&prompt0=&prompt1=value... etc. I have done this using the Native Oracle driver (we have Oracle 8.1) and it works; I don't know about 9... Let me know if that works for you, or what...

We are not passing any datetimes. We have a main report with 2 parameters (number and string) and six subreports. The fourth subreport that is accessed is based on a stored procedure that takes 2 parameters (cursor and number). When calling the report through a URL, the values for the...

Did you ever get this situation resolved? I also am having trouble passing values through the URL to my stored procedure.

Did you ever get this situation resolved?

Hi! Just wanted to update you on one note you made earlier: &quot;EXECUTE IMMEDIATE is essentially a call to another stored procedure, which crystal doesn't support with Oracle.&quot; Because I needed to alter my table, I found I couldn't use temp tables anyway. But I did find that the 'Execute...

So is this 'permanent Global temp table' persistant beyond the session? (i.e. Do you only create it once outside of your stored procedure, then insert data into it inside of your sp, and then only the rows are deleted at the end of the session?) My concern is that there will be many different...

I have accessed the above document and it has been a big help, but the snag I'm working on right now is creating a temporary table. When I try to add the procedure to a report, I get a very non-descriptive &quot;Not Supported&quot; error. Here's my procedure...(keep in mind that more SQL will...

I did consider a sub-report, but because time to execute/performance is a big factor, I'm trying to stay away from them. Do you have any experience with stored procedures from Oracle? We've not used them here before, and I'm trying to do some experimenting with them right now, but keep hitting...

I'm also still using 8.5... I may have had it working earlier without realizing it--the query took so long to execute that I thought I was locking up Crystal. When I ran the same query in SQL Plus, it took over 10 min. I know I didn't wait that long!!! I'm now working with our DBA to optimize...

I'm feeling your pain... I didn't realize I relied so much on the Keyword Search for information!

Hello, I am trying to create a report using a correlated sub-query. I'm connecting to an Oracle db via ODBC, and need the option to 'perform grouping on server'. Has anyone used a sub-query and gotten it to work? I really need a method of how to set it up--I tried modifying the SQL directly...

With Access 2000, ADO is the default instead of DAO (as it was with older versions). You will need to check which references you are using. If you do not have &quot;Microsoft DAO 2.5/3.51 Compatibility Library&quot; checked, then you need to fully quality your database and recordset objects as...

What version of Access are you using?

You need to include more information in your question for others to fully understand your problem. (Also, please turn off your Caps Lock!) If you are trying to use the Set command on a variable that is not an object you will get a type mismatch error. That's as helpful as I can be with the...

a little late... This error probably means that you have the MSAccess database open. Try closing it and then linking to it.