Is it possible to use IF statement,  SWITCH CASE Statement, while loop  etc.  in the CALCULATED FIELD OF Report writer.

suriakumar

J.SURIAKUMAR

IS it possible to add global functions OR Functions in the REPORT WRITER Library.


Is there anybody knows how to use the following function.  Example code needed. 

SetExpression(Expr$)
SetLibrary(LibraryFile$)
SetTranslationValue(idx,Value$[,isExpression$[,Type$]]
IsTranslationValueExpression(idx)
AddTranslationValue([idx])


Just need more information with example for how to use these commands.
But i am  struggling to add functions.

Is there any way to add this in REPORT WRITER

J.SURIAKUMAR

I tried to add the parameter programmatically.  It is not displaying in the parameter list

LET REPORTNAME$="C:\PXPLUS\ABCdef.pvr"

00130 LET RPT=NEW("*rpt/pvxreport"); IF RPT=0 THEN END
00131 LET RPT$=STR(RPT)
00132 IF RPT'OPEN(REPORTNAME$)=0 THEN MSGBOX "Could not open report file:"+SEP+SEP+MSG(ERR)+SEP+MSG(-1),"Initialization error","!"


00261 RPT'CLEARPARAMS()
00270 LET P=RPT'ADDPARAM()
00280 LET P'NAME$="COMPANY"
00290 LET P'DESCRIPTION$="COMPANY NAME"
00300 LET P'TYPE$="S"
00310 LET P'LENGTH=30
00320 LET P'VALUE$="ABC & CO"



I tried with above code.   After this when i looked into the definition it does not show the new parameter in the parameters list.


Method 2
========

Alternatively i saved the above code ( from 261 to 320) in a separate program and stored it in REPORT_OPTIONS--->CUSTOM_INTERFACES--->PARAMETER_INTERFACES---->PROGRAM

It is not working.

"ANY EXAMPLE/CODING  TO ADD PARAMTER PROGRAMATICALLY

SURIAKUMAR

Sir


1) How do i pass (SEND)  Global Variables and Global Functions  to  REPORT WRITER

Like *WEB\START_UP is there anyway to pass Global Variables and Global Functions in REPORT WRITER
We are using Non-Normalized (Legacy) Files.  Also we do not have Data Dictionary


2)  How do i pass the Report Parameter  (Like From Range,  To Range) etc. To REPORT WRITER.   

Once again we do not use Data Dictionary.  We are using Legacy (Non-Normalized) Data files

J.SURIAKUMAR

I AM having huge amount of tables.  Each INI file has 25 tables.  so i have multiple ini's.

Your documentaion does not have example such example.  Even the ALTERNATE ini also runs into error

SURIAKUMAR

Sir

We are using Leagacy files (Non-Normazlized data file)

Each module has more pxplus data files.

Each Pxplus data file has Huge amount of Record typeS (Each record type has seperate MUSTBE value.  You have a attribute called "MUSTBE" when we create INI file).

Since each pxplus data file has multiple record type,  i am in a position to create huge amount of DATA TABLES to convert it.   I can not depend on single INI file to create all the tables.  IE.,  INI table has huge amount of table definition.  without depending on single INI file i am in a position to create multiple INI files for a single MODULE. 

So it is possible to use multiple INI files in a single catalog of PXPLUS SQL Server ? .  We have a CATALOG option in PXPLUS SQL SERVER Configuration where we use this ini file. IN this CATALOG field is it possible to enter more number of INI files ?  .  If not what are the other options to solve my problem.

SURIAKUMAR

Sir,

I am not using windx and i have mouse connected with my laptop.  Also i am getting the error in the following line

PROCESS  "ABC","SUABC.EN"

J.SURIAKUMAR

Sir,

I am unable to run my old program developed in Nomads in the new version of pxplus.

It says an error "not a graphical device -- can not use nomads panels"

how do i solve this error ?

J.SURIAKUMAR

Sir,

In Which VERSION of pxplus you have the global variable %X_FORWARDED_FOR$ ?. I am using PXPLUS version 11.65.   This variable is not available in this Version.    The WEB SERVER Version is 1.3.17.  Or In case if you have introduced in your latest version of web server please inform me the WEB SERVER Version

J.SURIAKUMAR

Sir,

I want to get the browser's IP Address.  The Global variable %REMOTE_IP$ does not work.  It contains server's ip address.  It does not contain Browser's IP Address.   Please inform me how to get the Browser's IP address through PXPLUS