Re: Use of Variables in Formula (GRR3 Report)

11-30  Source: Network gathering  Views:0 

I have defined a report in the GRR3 transaction (Report writer) and am trying to use a variable in one of the columns. By reading the advice, it says you can enter the variable (0F-RP00 for example) as '&0F-RP00' and it should work, i am doing this but it keeps on telling me that it is incorrect. Can anybody tell me what i may be missing?
The Variable is created of course. In fact, its standard 0F-RP00.
Related articles
  • Re: Use of Variables in Formula (GRR3 Report) 11-30

    Hello, I have defined a report in the GRR3 transaction (Report writer) and am trying to use a variable in one of the columns. By reading the advice, it says you can enter the variable (0F-RP00 for example) as '&0F-RP00' and it should work, i am doing

  • Using Bind variables in SQL PLUS Report 10-11

    using Bind variables in SQL PLUS Report. This report gets the arguments from the application concurrent program. Now my need is to convert the start_date and end_date to bind Variables to improve the performance. I have commented the original code in

  • Use of variable to generate a report 10-11

    Hi, Can anyone help! I've created a selection list with submit, which displays a list of applications, the return value is the name of the remote database table which holds exceptions associated to the chosen application. This is in a html region cal

  • Using bind variables in a portal report 10-11

    I'm using a portal 3.0.9 report with bind variables. I also use LOV to let the user choose his own parameters for these variables. When user click Apply on the customization form of the report, the selection is always "set to default"Hi Please g

  • Using Text variables in Formula 10-11

    Hi all, I wanted to know if there is a known problem with using a text variable in a formula's title??? Every time I try to use the text var. in formula with the same technique i do in the selction,  i recieve the message : 'No Valye found for text v

  • Using bind variables in Shared Component Reports not working 11-30

    I've created a report query as a shared component in my APEX application. I'm calling the report on a page via a button. The query behind the report has bind variables for period and entity fields which are both defined on Page 0. I can run the query

  • Using bind variables in user defined reports 11-30

    How do I go about using a bind variable in a user defined report? Here's a trivial example in SQL*Plus: var ublocksize number begin select value into :ublocksize from v$parameter where name = 'db_block_size'; end; select :ublocksize from dual; This c

  • How to declare and use a variable in BI Publisher report 10-11

    Hi Experts , I have to groups of serial numbers and both group are put in same table and same row one after another , and i have a condition that if no serial number is present in both group than the line of that table should not be appeared ,i used

  • Report Painter - variables in formulas 10-11

    Dear all, we try to use value variables in formulas within Report Painter reports which should not influence the selection. Example: the benchmark of a daily rate is 975 € - and the report should calculate the variance between the effective daily rat

  • Use subreport total in formula in main report 11-30

    Hi, I have a subreport which is a total figure. I just want to muliply this by a number in a field on the main report, can this be done? Any help appreciated!Symptom A report contains a subreport. Data from the subreport is required for calculations

  • Conditional suppression using substitution variable in Hyperion financial r 10-11

    Hi all, Is there a way that I can suppress a column using substitution variable in hyperion financial reporting? For eg, i want to suppress the column if the value of the substitution variable curr_mnth = jun. Is there a way to do this? In conditiona

  • Create New Variable for COPA Drilldown Reports in KE3E 11-30

    Hi, How can we create a formula variable for COPA Drill down reports in KE3E? In standard global variables formula variable is not avaiable, I need to create a formula variables like ...from period, to period, last fiscal year and next fiscal year..

  • ALL variables in one single report 10-11

    Hi Experts, I have one requirement, i am creating report on multi provider , so i have to create report to include all variable and it's definition(for wht purpose the variables are created means with description in report.). So is there any posibili

  • How to use System Variable SY_ROW in the Process Instruction Category 11-30

    Hi , I want to assign a value of System variable SY_ROW to a Normal Variable in the Process Instruction Category and use it in the formula. Please help me with the Syntax in the Process Instruction Category to get the System Variable: SY_ROW value in

  • How to use Value Variable in Report Painter Column defined as Formula 10-11

    Hi Gurus, In report painter, how can I add one field (exchange rate) in selection screen, so that user can provide the exchange rate to be used, then execute the report, the exchange rate will used to multiple local currency amount. The reason for th

  • How to use user variable in Member Formula 10-11

    Hi All I have to write a member formula for %linearity quarter for a weekly application.This member will be used in reports and we do not want to do this calculation in reports, hence need to write member formula. The formula is Week1 of Q1 forecast

  • Issue in using presentation variable as filter condition in the reports 10-11

    Hi, I have an issue in using presentation variable as filter condition in my reports the details are as follows: Details : We want to implement the Max and Min variables through Presentation variables only.we do not want to implement it through sessi

  • How to assign a variable value to crystal report viewer formula with CR2008 10-11

    Hi , I am using crystal reports 2008 and i am not able to find how to assign  variable value  to crystal report viewer formula. In CR 8.5 , i used to have crystalreport1.Formulas(0) = variable1                                          crystalreport1.

  • Report painter variables in formula columns 11-30

    Hello, I need to insert variable in column formula to create  average month result. using syntax 'variable' or &variable is Incorrect formula component message . How can i enter variables in formula columns? Thanks , RanHi I suspect you are not able

  • Report Using Bind Variables 10-11

    Hey Everyone, I'm having a bit of trouble creating a report. I need the FROM part of the code to use bind variables. I have come up with this peice of code below but im getting the following error: failed to parse SQL query: ORA-06550: line 1, column