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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by buck149

  1. buck149

    Would the dashboard work with Cognos Report

    Thanks. Are you telling me that the only way you can do the dashboard is to export Cognos to Excel then build the dashboard against the spreadsheet?
  2. buck149

    Would the dashboard work with Cognos Report

    BO XI, Xcelsius 4.5 Is this version capable of pulling data directly out of Cognos report?
  3. buck149

    Combine groups onto one line

    go to your first group head and click section expert, check underlay following section.
  4. buck149

    How to group by non-existing future date

    I want to group by this formula on yearly basis and all retirement calculation will be also based on this formula for each every future year.
  5. buck149

    How to group by non-existing future date

    Crystal XI/Oracle 10g I am doing a report counting eligible retirement for the next 10 years. My database is updated monthly and each update is represented by an "as of id" which is a numeric field like "200709". This field will also be used as user input paramter. What I want to do is to...
  6. buck149

    is there a way to do this?

    Crystal XI, Oracle 10g database I have to convert a mainframe report to Crystal. The mainframe report look like the follows: agency count promoted count departed count AC 1 YES 3 DEC. 11 167 CD 15 YES 3 OCT. 09 5 YES 14...
  7. buck149

    Suppression Formula Suppressing Too Much

    it should be (@SeqAcct) = (Next(@SeqAcct)) so that all unique records will be display. Your way is supressing all unique records and displaying duplicates
  8. buck149

    get rid of trailing zeros

    Sorry that I messed it up. it should be: totext({your number value}, 0, "")
  9. buck149

    get rid of trailing zeros

    for each of your displayable number value, use a formula like follows: totext({your number}, "", 0) in the formula, the double quotes will eliminate the thousand separator while the 0 will take out the trailing 0s.
  10. buck149

    Crystal XI "+" sign shwoing up in an sql query

    I think " sql_fund1" is an alias for your "sql_fund" table if you refer to the table twice in your query. "+" looks to me like an outer join though.
  11. buck149

    How to refer to prompts in your report title

    BO 6.5, SQL server Database I have two prompts (start Date and end date) that I want to refer in my report title and how to do it?
  12. buck149

    How to do this

    No, the universe remains untouched. Only the report. Some of my fellows developer suggested that I can re-arrange the sequence of conditions within the report and somehow, when the report was exported to the repository, it worked. The uncertainty is that I will never know when it will work or...
  13. buck149

    How to do this

    A client of mine wanted a modification of a full client report which I did. The report was fine when I ran it from my local. When the report is exported to the repository and run, the following error popped up: "COM error during call to BusinessObjects server Process (BOMGR0070). Based on error...
  14. buck149

    How to do this

    Using BO 6.5 and SQL 2000 database. Came across a weird situation that one of my desktop intelligence report is modified and exported back to repository but could not run. Call for BO tech support and they suggested that I delete manually all universe cache and report cache (which I have not...
  15. buck149

    InfoView

    Yes, I can use "retrieve from..." to do editing...
See more

Part and Inventory Search

Back
Top