Search results for query: *

to give u more clear picture, my situation is amount1 = select posted_total_amt where subquery1 amount2 = select posted_total_amt where subquery22 amount3 = amount1-amount2 To define amount 1, i click on "expressions"->"add criterion"->"expression type" drop down box = number-> "expression...

Hi Notadba thanks for your response. Actually i have included the above query just as an example. My subquery does pull some amounts based on many criterions. The point is the variable "amount1" doesn't work whether it is just relabling "posted_amt_total" as "amount1" or getting an amount...

Hi I am trying to put the result of a subquery in a varible using 'expression' feature in peoplesoft query (version 8.4). i get a nasty sql error. if i use a database field instead of the variable it works. can u please tell if i am doing anything wrong here. code: SELECT A.BUSINESS_UNIT...

Hi I would like to know how much volume Crystal(PeopleSoft) can handle. It will be great even if you tell me an approximate value.(like 20000 records, 200000 records etc) We have a PeopleSoft Deivered crystal report (AMGL1000 - AM GL Re conciliation by department report) and we are making few...

Thanks skrandel. Unfortunately we cann't use webi. We will be upgrading these reports to Business Objects version 6.0. Since it is enterprise version with sdk can we achieve my goal in the version 6.0. thanks Sreedevi

try the following. In your Bo report go to Tools ->Options->Save tab . Disable the option " Refresh Document when opening"

Hi I am trying to link two Business object reports(version 5.1). I need to link a main report to a custom drill down report. If the main report contains account -id , and when user clicks on it, the user should be able to jump to the custom drill down report which has other details for that...

Thanks somuch for responding. ido Could you please explain how to insert subreport. Does Business Objects has a feature to do this or do I have to write any macro. pgtek I am not using crystal reports. I am using Business Objects version 5.1. thanks Sreedevi

Hi I am trying to link two Business object reports. I need to link a main report to a custom drill down report. If the main report contains account -id , and when user clicks on it, the user should be able to jump to the custom drill down report which has other details for that specific...