Search results for query: *

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?

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

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

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.

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

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

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

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

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.

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.

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?

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

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

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

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

I logged in as administrator and I think I should have the permission to edit it.

Using BO 6.5 with SQL server 2000 Trying to edit full client report (desktop intelligence) from info view and pop-up windows says at the bottom "Error on Page" and therefore, the report could not be opened. What went wrong here?

why don't you try to put the following in your selection? iif({?yourparameter}="ALL",TRUE,{project}IN{?yourparameter})

BO XI R2, SQL server 2000/2005 How can I call a store procedure when building the universe?

BO XI release 2. I designed a universe in the test/development environment and when deployed, the universe will point to the production database, how is the connection switched?