Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. legrev

    Help on Date Conversion

    Hi! I'm quite new to BO... Can anyone help me on converting numbers to months (eg. 1 -> January)? Thanks in advance!!!
  2. legrev

    Help on BO Stored Procedures

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

    BO Stored Procedures

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

    BO Stored Procedures

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

    Help: Pivot Table auto-refresh problem

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

    Help: Pivot Table auto-refresh problem

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

    VBA Module help "No value given for one or more required parameters"

    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!!!!
  8. legrev

    VBA Module help "No value given for one or more required parameters"

    Hi! It goes to the err_handler right after rs= .execute.
  9. legrev

    VBA Module help "No value given for one or more required parameters"

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

    VBA Module help "No value given for one or more required parameters"

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

    date to timestamp conversion

    Hi Guys! Does anyone know how to convert a date to a timestamp? I've been stuck with this problem for quite some time.. Thanks in advance!! Legrev
    • legrev
    • Thread
    • Replies: 1
    • Forum: Java

Part and Inventory Search

Back
Top