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!

  • Congratulations strongm 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. fernanda

    Procedures with no arguments

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

    Calculating rates!

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

    Strange result of @prompt function!

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

    Can i use prompt without equal the result to anything??

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

    Can i use prompt without equal the result to anything??

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

    Can i use prompt without equal the result to anything??

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

    Can i use prompt without equal the result to anything??

    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?
  8. fernanda

    Can i use prompt without equal the result to anything??

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

    Can i use prompt without equal the result to anything??

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

    Calculating measures depending on others!

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

    Get the result from @prompt function!

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

Part and Inventory Search

Back
Top