I don't know if this would be applicable to your case, but you might consider using the Report Writer as it can create HTML output.
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.
#2
Programming / Re: calculated fields
March 04, 2025, 09:45:38 AM
For more information on Calculated Fields, see:
https://manual.pvxplus.com/page/Report%20Writer/Designing%20a%20Report/Defining%20the%20Data/Calculated%20Fields.htm
Or check out the new training manual at:
https://home.pvxplus.com/files/7068/Introduction_to_PxPlus_-_A_Hands-On_Training_Guide_for_Developers.pdf
and search for 'calculated fields', or go to page 218.
https://manual.pvxplus.com/page/Report%20Writer/Designing%20a%20Report/Defining%20the%20Data/Calculated%20Fields.htm
Or check out the new training manual at:
https://home.pvxplus.com/files/7068/Introduction_to_PxPlus_-_A_Hands-On_Training_Guide_for_Developers.pdf
and search for 'calculated fields', or go to page 218.
#3
Programming / Re: calculated fields
March 04, 2025, 09:34:45 AM
Suriakumar,
There are two types of calculated fields:
There are two types of calculated fields:
- Formula - Contains a PxPlus expression that will be evaluated when the report is being generated. You can then define a Filter that will use the calculated field in its condition. For example, you could create a calculated field TOTALCOST that calculates COST+TAXES which can then be displayed on your report. Or you could define a Filter to only display the records where, for example, TOTALCOST > 1000. Or you could use it to set up different Cell or Line displays.
- Translation - This allows you to specify several conditions which will determine what is displayed on the report. For example, you could create a translation called MyMessage where the condition BALANCE>0 returns "Balance Due" and the Default returns "Paid".
#4
Programming / Re: REPORT WRITER
February 18, 2025, 09:34:42 AM
SURIAKUMAR,
The code you show is for adding parameters dynamically at run-time when the report is being generated. They exist while the report is generated and are not being saved.
My question is this: Are the parameters required for the report always the same? That is, are you always requesting the COMPANY in this case. If so, you would define that as a parameter in the report definition using the Report Designer. See the Data > Parameter menu item.:
https://manual.pvxplus.com/PXPLUS/Report%20Writer/Designing%20a%20Report/Defining%20the%20Data/Parameters.htm
After you have defined your parameter here it will appear in the data pane of the Report Designer, where you can include it in the report, or use it in filters, etc.
At run-time when you are generating the report, if you generate it using the CALL method with the runreport program, it will automatically display an interactive panel to enter a value for the parameter. If you want to enter the value programmatically, after you open the report you can use the 'SetParameter(parmName$,value$) method to set the value, where parmName$ is the name you gave the parameter and value$ is the value to be assigned for the report.
The code you show is for adding parameters dynamically at run-time when the report is being generated. They exist while the report is generated and are not being saved.
My question is this: Are the parameters required for the report always the same? That is, are you always requesting the COMPANY in this case. If so, you would define that as a parameter in the report definition using the Report Designer. See the Data > Parameter menu item.:
https://manual.pvxplus.com/PXPLUS/Report%20Writer/Designing%20a%20Report/Defining%20the%20Data/Parameters.htm
After you have defined your parameter here it will appear in the data pane of the Report Designer, where you can include it in the report, or use it in filters, etc.
At run-time when you are generating the report, if you generate it using the CALL method with the runreport program, it will automatically display an interactive panel to enter a value for the parameter. If you want to enter the value programmatically, after you open the report you can use the 'SetParameter(parmName$,value$) method to set the value, where parmName$ is the name you gave the parameter and value$ is the value to be assigned for the report.
#5
Programming / Re: REPORT WRITER
February 11, 2025, 09:13:24 AM
The input source can be any native PxPlus file with an embedded data dictionary, a PxPlus View, a Query Definition, or any other data source whose data can be accessed using a Custom Data Source Object. External databases, such as ODBC, Oracle or DB2, can also be accessed via Views or Data Dictionary defintions. So if you are not using a Data Dictionary, you could create a manual query to supply the data or a report writer Custom Data Source Object to supply the data.
The Report Writer does not have global variables and functions like *web/start_up. You pass values into the Report Writer using parameters.
If you are running a report interactively, you can use the default interactive parameter interface to enter parameter values. If the report is not interactive, you can enter the parameter values programmatically using the 'AcceptParameters() method.
The Report Writer does not have global variables and functions like *web/start_up. You pass values into the Report Writer using parameters.
If you are running a report interactively, you can use the default interactive parameter interface to enter parameter values. If the report is not interactive, you can enter the parameter values programmatically using the 'AcceptParameters() method.
#6
Programming / Re: Calendar in grid input?
October 21, 2024, 10:26:25 AM
Here's a sample non-nomads program that creates a grid with cells that use a calendar query:
PRINT 'CS',
mygrid=1000
GRID mygrid,@(20,12,40,10)
mygrid'columnswide=3,mygrid'rowshigh=5
mygrid'row=0
mygrid'colno=0,mygrid'columnwidth=10
mygrid'colno=1,mygrid'celltype$="lookup" ! can edit cell
mygrid'colno=2,mygrid'celltype$="query" ! cannot edit cell
WHILE 1
OBTAIN (0,SIZ=1)'ME',*,'MN'
IF CTL=-1999 OR CTL=4 \
THEN BREAK ! X or ESC
IF CTL=mygrid \
THEN GRID READ mygrid,mycol,myrow,myVal$,myEOM$;
IF mycol<3 AND myEOM$=$FF$ \
THEN GOSUB Do_Calendar \
ELSE MSGBOX myVal$,"Value" ! the EOM for the lookup/query button is $FF$
WEND
END
!
Do_Calendar:
PROCESS "Calendar","*win/calendar.en",myVal$
GRID LOAD mygrid,mycol,myrow,myVal$+SEP
RETURN
PRINT 'CS',
mygrid=1000
GRID mygrid,@(20,12,40,10)
mygrid'columnswide=3,mygrid'rowshigh=5
mygrid'row=0
mygrid'colno=0,mygrid'columnwidth=10
mygrid'colno=1,mygrid'celltype$="lookup" ! can edit cell
mygrid'colno=2,mygrid'celltype$="query" ! cannot edit cell
WHILE 1
OBTAIN (0,SIZ=1)'ME',*,'MN'
IF CTL=-1999 OR CTL=4 \
THEN BREAK ! X or ESC
IF CTL=mygrid \
THEN GRID READ mygrid,mycol,myrow,myVal$,myEOM$;
IF mycol<3 AND myEOM$=$FF$ \
THEN GOSUB Do_Calendar \
ELSE MSGBOX myVal$,"Value" ! the EOM for the lookup/query button is $FF$
WEND
END
!
Do_Calendar:
PROCESS "Calendar","*win/calendar.en",myVal$
GRID LOAD mygrid,mycol,myrow,myVal$+SEP
RETURN
#7
Nomads / Re: SHOW CONTROL
October 21, 2024, 09:04:26 AM
To HIDE/SHOW something on a panel, I find it easy to use Dependency Definitions:
https://manual.pvxplus.com/page/NOMADS%20Graphical%20Application/Panel%20Designer/Options%20and%20Utilities/Dependency%20Definitions.htm
A dependency definition will hide/show controls automatically based on a condition.
Note: To use a Dependency for fonted text you would first have to assign it to a group, and hide the group.
https://manual.pvxplus.com/page/NOMADS%20Graphical%20Application/Panel%20Designer/Options%20and%20Utilities/Dependency%20Definitions.htm
A dependency definition will hide/show controls automatically based on a condition.
Note: To use a Dependency for fonted text you would first have to assign it to a group, and hide the group.
#8
Programming / Re: Calendar in grid input?
October 17, 2024, 08:58:52 AM
Yes. In the grid presets set the Property to 'Query", set your Column and Row to specify the cells to be affected, and click the query button in the Value/Expression cell to set the Query Display. The Query Type would be Panel, the library would be *win/calendar.* and the panel would be CALENDAR.
#9
Nomads / Re: Report Writer key range
October 17, 2024, 08:52:45 AM
Yes, you can use static filters and parameters to set up the range. The report generating logic will analyze the key segment fields against the key fields used in the static filters to see if a reading range can be set up.
#10
Nomads / Re: SELECTING A LINE OR LINES FROM A LIST BOX
October 17, 2024, 08:44:30 AM
Mike,
I'm not sure I follow. If the 'Multiple Selections' attribute is set for the list box, then all the rows selected will be highlighted automatically. (See example below.)
I'm not sure I follow. If the 'Multiple Selections' attribute is set for the list box, then all the rows selected will be highlighted automatically. (See example below.)
#11
Nomads / Re: SELECTING A LINE OR LINES FROM A LIST BOX
October 16, 2024, 09:26:09 AM
By default, list boxes require double clicks or Enter to select something. If it is doing a selection on a single click, then the Automatic (Signal all changes) attribute is set. You can filter as James suggested, where the single click is $01$.
#12
Nomads / Re: Default Panel Background/fonts colour not being retained
October 07, 2024, 09:23:03 AM
An issue where Library Default FG/BG colors are not used in sub-panels has been reported and fixed for the next release.
#13
Programming / Re: New Query Problem, not returning correct value
September 27, 2024, 09:13:31 AM
We'll look into it.
#14
Programming / Re: New Query Problem, not returning correct value
September 26, 2024, 08:39:41 AM
Martin,
I have responded to your ticket with a possible fix, but have not heard back from you. I just wanted to check with you since previously you did not receive the auto ticket response.
I have responded to your ticket with a possible fix, but have not heard back from you. I just wanted to check with you since previously you did not receive the auto ticket response.
#15
Language / Re: SVN Linux?
September 24, 2024, 01:22:47 PM
You can set up a Linus SVN server as Mike described earlier. That is where the repository would reside.
As for the clients using the repository on the server, each client would have their own sandbox on their own Windows machine. Each client would install the Tortoise SVN client on their Windows machine, as well as PxPLus and their application. This is where they would do their development. When the administrator completes this, they would import the application into the repository. The rest of the clients would then checkout the source from the repository.
So all development is done on each developer's own machine, then committed to the repository when done, where other developers can update their source/app directories from there. Since each developer has their own work area on their Windows computer, this is not really a WindX style set up.
As for the clients using the repository on the server, each client would have their own sandbox on their own Windows machine. Each client would install the Tortoise SVN client on their Windows machine, as well as PxPLus and their application. This is where they would do their development. When the administrator completes this, they would import the application into the repository. The rest of the clients would then checkout the source from the repository.
So all development is done on each developer's own machine, then committed to the repository when done, where other developers can update their source/app directories from there. Since each developer has their own work area on their Windows computer, this is not really a WindX style set up.