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...
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...
Hi! Thanks!
I have a form that deletes a re-populates a table depending on a paramater. That table is the one being used by the pivot table. The pivot table would then be opened in excel but it always shows the previously ran report, it does not refresh according to the new set of data on the...
Hi! I created a pivot table that accesses data from a table. the problem is, it does not automatically refreshes everytime I updated the data and open the pivot table. Would it be possible to auto-refresh the pivot table? Thanks!!!
Hi! Yes, there is something wrong with the sql... The sql contains a select from a query that has parameters and it seems that it is not possible to have that. I took out that query, made some work-arounds and it worked...
Thanks anyway guys for your help!!!!
thanks guys!!!
here's the sql
SELECT DISTINCT Sum(IIf([TblPledge].[PledgeAmountUSD]=0 Or [TblPledge].[PledgeAmountUSD] Is Null,IIf([TblPledge].[PledgeExchangeRate]>0,[TblPledge].[PledgeAmount]/[TblPledge].[PledgeExchangeRate],0),[TblPledge].[PledgeAmountUSD])) AS USDAmountSum...
Hi! I'm quite new to Access coding, I hope someone can help me with this problem. Below is my function and I keep getting the error "No value given for one or more required parameters".. Hope someone could help me out..
Thank you very much in advance!
Function GetCountryTotal(Country As...
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.