Is there any way at all to do anything with an oracle long data field besides display it?
I have an oracle long data field used for text input that I need to parse for a name. Is there no way to do that in Crystal?
Thanks.
I have a main report with a single subreport. The subreport is placed in the report footer. The main report is linked to the subreport by start date and end date parameters (entered by the user for the main report and passed to the subreport). The main and subreport use the same tables, but...
I just upgraded from Crystal 7.0 to Crystal 8.5. I opened some reports to an Oracle 8.1.7 database. When I try to run them, I get an ODBC error "ORA-01830: date format picture ends before converting entire input string". Then I get a dialog box that says "Error detected by...
Is there any way to change a table name globally?
I have a set of reports that use a certain table and I want to change the reports to use a view with the same field names, but obviously a different table name. Is there any way to do this aside from recreating the reports with the new view...
Hi all.
I have a report in crystal 7 going to an oracle database. Within the select expert, I've set up a few criteria and also have set up date criteria for a date range. The problem is that the report does not use this criteria, nor does is show up when "Show SQL Query" is chosen...
I am running crystal 7 with oracle 8.1.7 and would like to put the following type of query in a crystal report:
select a.name, b.street
from a, b
where a.key = b.key (+)
and b.type (+) = 'HOME'
I understand how to do the outer join with the field linking, but I don't know how to do it in the...
Sorry this is posted in a few places - I'm new and trying to find the right forum for this problem.
I have a VB6 program that is calling an Oracle stored procedure. The problem is that the IN/OUT parameter is returning the correct string, but with garbage on the end of the string up to the...
I'm not sure if this post belongs here or in the VB forum, but haven't heard anything in VB, so here I am...
I have a VB6 program on a Win2000 box which is calling an Oracle stored procedure. The problem is that the IN/OUT parameter is returning the correct string, but with garbage on the end...
I have a VB6 program on a Win2000 box which is calling an Oracle stored procedure. The problem is that the IN/OUT parameter is returning the correct string, but with garbage on the end of the string up to the buffer size. This code was works fine with 7.3.4, but does not work with 8.1.7...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.