The following package and stored procedure works without any problems
create or replace PACKAGE Test_Package2
AS TYPE Test_Type IS REF CURSOR;
END Test_Package2;
create or replace PROCEDURE eam_get_position_reports (
Report_Cursor IN OUT eam_get_position_reports_pkg.rpt_type,
Account_Code IN...
Pretty straight forward problem....
I have a simple little VB 6 app that allows the user to key in report parameters. The app has all the business rules in it. Everything works great with one exception.....
When I have a parameter that allows for multiple entries I can not get it to work...
I use the crpe automation object all the time when connecting natively against access db's. But now I need to use ODBC.
I am positive I have the dsn's set up correctly. I make the initial connection ok but when I run the report (no parameters) I get the 'can not open sql server' message...
I created a new query using the query designer. It has one parameter. WHen I run in the query designer it works just fine. I then saved the .qry
When I create a new crystal report 8.5 using this query the parameter does not show up anywhere!&$*(&$
Any idea's as to what I am doing wrong.
I...
If the query does not have any input prompts I can create a new report using the query.
As soon as I add a variable to the query I do not 'see' it when I add a new report.
if query
WHERE Scores.`H1Score` > 0 AND
Scores.`ScreenName` = "xxx" AND
(Scores.`ScoreLevel` = 1 OR...
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.