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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.