Search results for query: *

Enjoy your retirement!

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

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

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

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

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

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

I'm sorry I was thinking Oracle.

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

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

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.

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

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

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

Double win! I'm glad it helped.

There is a limit to what you can put in a command object and you are not close to the limit. When you get to the limit the editor will not take any more characters. I think your problem is the order by statement. When you are doing a union or union all the order by is for all of the SQL...

In the formatting toolbar there is an icon to increase and reduce the decimals. You could also format field and customize the rounding and decimals.

A Horizontal bar chart works pretty well when you are comparing a large number of items like you are or even as few as two items. Having the data ordered when doing this is usually a good idea. Make sure you keep all the bars the same color since the different colors will have no meaning. A...

Groups are sorts so your data will be ordered by location and then patient ID. You may not need the group on patient ID at all and could replace it with a sort on the date or change the group to be by the date. I'm not really sure what you are trying to do.

If you are in the SQL Expression it is looking at Oracle syntax. Split is not an oracle function. If you are looking for the characters between the 1st and 2nd dash in a string this type code will work. select substr('11-aa-333-44-555-6666', instr('11-aa-333-44-555-6666', '-', 1, 1) + 1...