Search results for query: *

Actually CR got back to me with the answer - There were 2 issues - here is the package and sp and they work fine - thanks for getting back to me SQL> create or replace package test_package_tables 2 as 3 TYPE test_type_record is RECORD 4 (acct_cd CRD.cs_fund.acct_cd%type...

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...

Thanks - went out there and got it....

Thanks - I was afraid of this! It was going too easily! I don't suppose you have example code for doing with RDC?

I am not aware of any way to do this since the code has to run on the production server. I will be watching this to see if someone knows how to do. Sure would come in handy for bypassing security.

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...

The following is out of the SHOW SQL. The two databases on the same server but are separate databases that are mirror images of each other in structure. The only difference is one database has daily info the other archive info. I make my connection to the daily database and make my links. I...

Thanks a lot - I will check out today!

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...

crystal doesn't like you to do this but I do it all the time. If I am NOT using stored procedures you can bring the various tables you need into the report. The ODBC will be connecting to either the current data OR the archived data. Once you have this all set up it is as easy as going into...

I contacted Crystal today about this issue. Basically, they said what synapsevampire said above. Don't use their product. I went over what it is I am trying to accomplish and said I needed to do it in a stored procedure - which is what I was trying to get around. anyway... I am not sure of...

Thanks - will do - tomorrow

Thanks, I agree. I do not have the code at home. I am unable to join the tables to get what I need. This is the situation. table 1 has 4 rows. key value to row 1 = A, row 2 = B, row 3 = C, and row 4 = D Table 2 has 40 rows 35 rows where key to table 1 = A 2 rows where key to table 1 = B...

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...

Thanks a lot, I will do that. Since the record set is realitively small, it is of no conscequence.

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...