Recent content by fernanda

Hello... Is it possible to run a procedure with no arguments? I keep receiving the same error...

Hi! I have a report with 3 columns: "client", "paid ammount" and "to pay ammount". Imagine something like this: Client | Total amount | Paid amount ________________________________________ 1 | 100 | 15 2 | 200 | 25...

Hello, i am using @prompt function in the select clause, but the value in the corresponding column that appears in my report is weird. I mean, i ask the user for a month (1 to 12) and a value like 256 appears in the column. It´s not always the same number but i don´t have idea how it´s being...

Webi2002, i managed to do that, but i had to put something in the where clause otherwise BO returned me the error "Invalid table name" (i don´t understand it). I´m trying to make him choose a month between some specified in a certain filed table. This is what i have in select...

RMitchell, and there is one more other thing... Usually when i have a prompt dimension, i select something, and that is the column that appears in the report.. What will appear in this case? Thanks again Fernanda

Hello rmitchell, are you saying i should write somthing like "max(@Prompt('Escolha o mês','N','Meses\Id do mês',Mono,constrained))". BO doesn´t accept it: ORA-00903: invalid table name... I´ve checked all relations and they are ok.. Is there any restriction to do this?' Thxs...

PaulSGS, i never quite understood how to use two data providers or when to use them.. How can i apply that to my case.. Do you know any place where I can get information about data providers?

What i really wanted to do was something like: In the beginning of the report ask the user a question. I don´t want to use <field> = @promtp(..) because i will filter the result obtained from the query. After i ask the question i want to keep the result and use it to calculate some measures...

Hello! Usually when I use the prompt function i use something like &quot; <field> = @prompt(...)&quot; But can i prompt the user a question and not equal it to anything... Basically, what i would like to do os something like &quot; @prompt(....)&quot; without the &quot;<field>&quot; Thanks

Hello! This is the problem i am trying to solve. I´m trying to generate a report that has this behaviour. At report time, the user must have the chance to insert a year and a month that will be the references to the values he want to consult. In the designer, i´m thinking of do this using the...

Hello! When i put in a dimension: &quot; << table field>> IN @Prompt('Choose month','A','<<the right dimension>>',Multi,constrained) &quot;, is there a way i can use the result chosen by the user in other dimension? Suppose the user chose 'January'. If I have several measures that depend of...