Order by in Parameter form for a formula col

Advertisement

Hi,
I have made a report for fast moving products and have ordered by on a formula column. Is there any way to select the order by (ascending or descending) in the parameter form at runtime for the same formula column. Instead of making two different reports one for ascending and one for descending, is there any way the user can select at runtime in the parameter form?
For the same report, how can I specify Top 100, Top 50, Top 25 etc.
Your reply or comments would be highly appreciated.
Thanks
Rgds
Fahad Hanif

Advertisement

I think by declaring one additional variable in which
u will ask from user in which order he requires the
outpu ascending/descending. and in second variable u
assign the order,
For exp
your query in as
select * from table
&<var 2>
if after parameter trigger of the report mention
if <var1>='asc'
<var2>:='Order by fieldname asc';
else
<var2>:='Order by fieldname desc';
if;
ill solve ur requirement.
Thanks
Shishu PaulHi,
Thanx for your reply but unfortunately it dint work. It dint show me any error as such but the ordering did not take place.
The issue is that I need to do the ordering on the Formula Column. Simply adding an order by statement like ' order by :cf_4 ' shows an error. Though routing it through the variable dint show any error it neither did serve the purpose.
I need to find a way in getting the ordering on the formula column. Then I need is Top n number of products to be displayed based on the order by of the formula column.
Pls help me out on this.
Thanks
Rgds
Fahad Hanif

October 11, 2015

Order by in Parameter form for a formula col

Hi, I have made a report for fast moving products and have ordered by on a formula column. Is there any way to select the order by (ascending or descending) in the parameter form at runtime for the same formula column. Instead of making two different

I am unable to get order by column name in oracle report parameter form

i created query like following in query builder SELECT CASE_NO, COURT_ID, CASE_TYPE, INITCAP(PLAINTIFF) PLAINTIFF,INITCAP( DEFENDENT) DEFENDENT, INITCAP(COUNSEL) COUNSEL, START_DATE, PREVIOUS_HEARING_DATE, NEXT_HEARING_DATE,INITCAP( DESCRIPTION) DESC

Show parameter form and then print directly to client printer

I have few reports that show parameter form for user entry. After the user enters the parameter and hits Submit query, the report should automatically get printed on the client's default printer. I tried to use ORARRP but I could get that to work onl

REP-52007 with parameter form

Hi, I've been trying to run parameter forms for 2 days now, and i'm getting desperate. For the moment, I can see the parameter form (not like it shows in Report Builder though...) When I give my two parameters (it are dates) into the parameter fuild,

Standard form for payment order creation

Hi, I got a requiremnt to create a form for payment order creation, can one plzzz guide me, do v hav any standard form available in sap, n also let me know the program for it. Regards ashwiniHi Aswini,            FPY1_CH_DTA_EZAG FPY1_CH_DTA_LSV FPY1

Calender for dates in parameter Form!!

Can we show calendar object on dates in Parameter Form in Reports6i. Please advise. Thanks a lot. Kind Regards Sardahello, the functionality for the reports parameterform is very basic. if you want to do more sophisticated parameter forms, you have t

Adobe Interactive Forms - for Travel Expense Booking

Hi: We are implementing Adobe Interactive Forms for Travel Expense Booking integrated with Portal (where user would download the form from portal locally to work offline and then upload it later when connected). For the form to function properly, our

REP-52007 Error and Web Parameter Form Format Problems

I am attemting to get Oracle 9i reports working. I created a super simple report just for test purposes. I am using the following URL to call it directly from the browser: http://myserver.com:8008/reports/rwservlet?server=repapp&report=jtest_rep.rdf&a

How to display  Reports parameter form in Oracle Forms 10g.

hello, am migrating from Forms 6i applications to Forms 10g. one of my application contain report, that report display parameter form I wrote below code for WHEN-BUTTON-PRESSED Trigger DECLARE pl_id      ParamList; v_report_id report_object; v_report

How to display a Report 9i from Forms if the Report has a Parameter Form?

Hi, could some one please post me a code sample to show how to call a (paper layout, RDF) Report from Forms if I would like it to display the Report's parameter form first? Thank you in advance. Tamas Szecsy I used the following code segment do achie

Cannot submit chinese character in Parameter Form

Hi all report professionals, when I tried to submit chinese character as an input parameter via the Online Report Parameter Form, the report server cannot recognise it as a chinese character. This scenario does not happened when I use Oracle Report D

Parameter form using LOV based on SQL  to pass param to Discoverer portlet

Hi all I have a design issue:- I want to create a parameter form in Oracle Portal to allow users to select the department using searchable LOV (like the torch that is there in various oracle products) and pass the selected parameter to the Oracle Dis

How to set a parameter id for SM37

Hi all,         i have one requirement, according to that we have to call the SM37  from the report then  •  Enter ‘*’ in the job name as well as user name. • Enter Dates; Select start – Previous date & time 15.30.00 till current date. • Select jobs

Not getting Reports Parameter Form in web-forms environ

I am not able to get a report parameter form to appear for a report called from forms via a 'run_product' command. It works fine in client/server mode. In web-forms the report just goes ahead and runs without the needed parameters. I have tried expli

How do I create a form in CS6 for Mac similar to a LiveCycle Designer form for Windows?

I have been creating quite a few forms in LiveCycle Designer at work (on Windows 7). I do a lot of scripting (99% JavaScript) in the background in order to make the form function as I need it to. I purchased CS6 for my Mac at home, and have a side pr

Standard PDF forms for plant maintenance

Hi all, Does anyone know standard PDF  forms for plant maintenance? AssafAs standard there is no option to save workshop papers in PDF format. However, have a look at [OSS Note 208271|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapno

Is there any way to tell which formulas a particular cell is in, reverse look-up style? That is, is there a way to search somehow for which formulas in a sheet contain a particular cell in them without opening all of them up? If not, it would be nice

Is there any way to tell which formulas a particular cell is in, reverse look-up style? That is, is there a way to search somehow for which formulas in a sheet contain a particular cell in them without opening all of them up? If not, it would be nice

Problem in reports6i parameter form customization

I am calling report developed under reports6i using rwservlet from j2ee web application. I was able to successfully customize the parameter form internal to report using Report Escapes properties, Before Form value and After Form value. I am using he

How do i create 2 parameter pages for 1 report?

Hi, I want to make a purchase order report. first: i need a parameter page to ask how many items that you want to order. second, once user enters a number(let's say 5), i want to have anoter parameter page show 5 empty fields that user can enter 5 it

Urgent! Using Reports parameter forms with RUN_REPORT_OBJECT on 9iAS

Hi all, I am migrating client-server to 3-tier with 9iAS Rel2 on AIX 5.1. The forms and reports are upgraded from Forms4.5 to forms9i and Reprots 2.5. We used to have user defined parameter in parameter form(e.g. articale no.) to select records appea