Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - suriakumar

#1
Programming / calculated fields
March 04, 2025, 05:37:04 AM


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

suriakumar
#2
Programming / Re: functions
February 26, 2025, 04:54:01 AM


J.SURIAKUMAR
#3
Programming / functions
February 22, 2025, 06:37:22 AM
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
#4
Programming / Re: REPORT WRITER
February 17, 2025, 09:25:05 AM
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



#5
Programming / REPORT WRITER
February 11, 2025, 12:33:52 AM
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
#6
ODBC / Re: More than 1 INI file ina Catalog
February 07, 2025, 02:24:10 AM
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
#7
ODBC / More than 1 INI file ina Catalog
February 06, 2025, 01:27:10 AM
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


#8
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
#9
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
#10
Web Services / Re: BROWSER IP ADDRESS
February 17, 2021, 05:48:05 AM
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
#11
Web Services / BROWSER IP ADDRESS
February 16, 2021, 01:05:25 AM
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