Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by TeyBrady

  1. TeyBrady

    Goodbye for now

    Enjoy your retirement!
  2. TeyBrady

    Crystal Rpts; Problems trying to call Oracle Stored Proc with In and Out Parameters

    I'm not sure why it is not rerunning your update. In my example where I keep adding 7 days to the date it initially ran when I first told it the stored procedure to use and crystal inspected it. Then every time I hit refresh on the report in crystal it would rerun sp_test and the update...
  3. TeyBrady

    Crystal Rpts; Problems trying to call Oracle Stored Proc with In and Out Parameters

    I'm glad that worked! I try to avoid using ODBC connections with Oracle because when the report is scheduled on the server it has to have the same ODBC set up as the one the developer used. When native connections are used nothing special is needed on the server(s) other than a valid...
  4. TeyBrady

    Crystal Rpts; Problems trying to call Oracle Stored Proc with In and Out Parameters

    I'm using crytal reports 2008 SP3. I am not using an ODBC connection to Oracle. I am using a native Oracle connection. So if I create a new report I select Oracle Server as the connection type. I enter the server, userid and password. Then I drill to the user/schema, stored procedures and...
  5. TeyBrady

    Crystal Rpts; Problems trying to call Oracle Stored Proc with In and Out Parameters

    I think the problem is that you are calling a stored procedure to do the update. I meant that you could have an update statement in the stored proc for the report. I jsut made this change to my stored procedure and tested it. I have a table called fatigue_date with one column called end_date...
  6. TeyBrady

    Crystal Rpts; Problems trying to call Oracle Stored Proc with In and Out Parameters

    They are separate. You will need to create the package once and then never touch it again. The stored procedure refers to the package. You could write a second stored procedure for another report but you would not need to write a second package. You do need to make sure your stored procedure...
  7. TeyBrady

    Crystal Rpts; Problems trying to call Oracle Stored Proc with In and Out Parameters

    Here is how I report off Oracle Stored procedures. Hopefully it will work for you too. In my example below you should be able to slap your SQL in the stored procedure like I explain to do it below. I recommend that you run a report just like the one that I talk about below to prove that it...
  8. TeyBrady

    Testing for TODAY in Add Command SQL query

    I'm sorry I was thinking Oracle.
  9. TeyBrady

    Testing for TODAY in Add Command SQL query

    If you are using a command object you will probably want to be using sysdate inside the command object and not outside in crystal. I think you are bringing back all records and making crystal filter them. Let the database do the work. You will probably want to use trunc(sysdate) to avoid...
  10. TeyBrady

    Warning after adding an Add Command

    I think you should be writing one SQL statement in the command object that does everything you need it to do. There is no point in passing the results of two separate queries back to crystal to let it do the join unless the queries are coming out of different databases. Let the database do the...
  11. TeyBrady

    Info View Interface

    Thanks for the response. I was afraid that was the answer I would get. I don't like the position SAP has put me in.
  12. TeyBrady

    Info View Interface

    We have been using the Info View from BO XI Release 2 and are in the process of upgrading to BO XI 3.x. The new info view no longer shows links for view latest instance, history, properties etc. You need to either select the report and right click to get to these links or select the report and...
  13. TeyBrady

    Number sorting

    You answered your own question. Right("000" + aisle, 3)
  14. TeyBrady

    SQL Command Limit

    You can do things like this too. I have forced all the records from the first query to sort before the second query and I also sorted only the second query by deptid. I also renamed the full_name field to foo and used foo as the sort field. select 1 qry, emplid, full_name foo, ' ' dept...
  15. TeyBrady

    SQL Command Limit

    Double win! I'm glad it helped.
See more

Part and Inventory Search

Back
Top