Search results for query: *

There is a outer join in my query. But it doesn't work. When using "Show SQL", I found out something like: select ... from a join .... right outer join b on .... join .... It seems that the join after my right outer join makes outer join cann't work correctly. I also test my thought by...

Cool! Thanks OWize1.

I have a CR report which will be print daily (schedule daily). For example: I want to print new contract every day. So I create a filter: contract_create_date = TODAY. But not every day there will be new contract coming in. So when no data fetched, a empty report will be printed. This...

I have about 60 columns in my table. This makes the table so wide that no enough space to display the whole table. Is there any setting can change the max page wide of Webi Report?

As I know, in CR, we can create two queries and join them by some column. But how to do this in Webi?

Got it, thanks.

[Background] DB: sql server 2000 There are two databases: ABC-production, ABC-test, whose database structures are same. When I insert a table into my universe: 1)if I set owner=dbo and qualifier=ABC-test, I can fetch the data from ABC-test. 2)if I leave owner and qualifier empty, I will fetch...

Nice to meet you again, what's a small world. Thank you very much!

Hi All, I want to implement such feture: whenever the Webi report is refreshed, prompt user to input something, such as Employee Id. Then this Employee Id will be displayed in the report as a text. As I know, @Prompt function can ask user to input some parameter for WHERE clause. But I don't...

Hi all~ Background: As we know, BO do i18n (internationalization) very well, which can support many language now. Question: My Windows is Chinese version, so BO software is in Chinese version automatically. But I really need an English version. I find out if I change my PC's "location and...