BO Stored Procedures

[legrev]

Hi!

I was trying to create a report in Business Objects with the following format,
account_name, sum of transaction amounts more than 20K USD, date and amount of last transaction. I'm only using Oracle 7.3 and scalar subqueries are not possible with this version.

Will it be possible in BO to invoke a procedure to truncate and populate a temporary table (this table would contain the account_name and sum of transactions more than 20K), then do a select from this temporary table and the main transaction table to get the date and amount of the last transaction?

I'm using BO version 4.1.7 and Oracle 7.3.

Thank you very much!!!

Vergel

 

[synapsevampire]

Did you mean to post in Crystal Reports, or the BO forum?

This seems easy in Crystal, so I'm guessing you posted in the wrong place.

-k

 

[legrev]

Hi! I can't find a forum for BO reporting, is there any?

thanks!

 

[synapsevampire]

Looks like you found the BO forum.

Since BO bought Crystal, I think that you'll discover a merging the technologies, which is good for BO reporting.

-k