hi all,

i have issue here i have Table Called Enquiry that has MemberID[not primary Key and may to be repeated] and Date Column, i want to generate Report Contain Column called NumberOfENQ that count the Number FOR Each MemberID[how many repeated] and the Total then i want to Calculate the Percentage of Repeated Column with the Total?

i try with SQL Statment and Computed Field but it is not work?

Can you help me

Have a look at the following example based on the WebFocus TRADES database

The out put shows and might do what you want

Monthly totals
Total Number of trades per month
Total Number of trades per period
Percentage of Total trades for the period
Number of Active brokers per month

Broker statistics
Number of broker trades Within the month
Number of broker trades Within the period
Broker trades as Percentage of total trades for the month
Broker trades as Percentage of total trades for the period


TABLE FILE TRADES
COUNT TRADER_ID AS 'PERIOD_TRADES'
BY TRADER_ID
ON TABLE SET ASNAMES ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD AS PDTRADES FORMAT FOCUS INDEX TRADER_ID
END
-RUN
JOIN TRADER_ID IN TRADES TO TRADER_ID IN PDTRADES AS J1
DEFINE FILE TRADES
Period/A1=' ';
END
TABLE FILE TRADES
SUM CNT.TRADER_ID WITHIN MONTH AS 'Total Number ,of trades, per month'
CNT.TRADER_ID WITHIN Period AS 'Total Number ,of trades, per period'
PCT.CNT.TRADER_ID AS 'Percentage of,Total trades, for the period'
BY Period NOPRINT
BY MONTH
SUM
CNT.DST.TRADER_ID WITHIN MONTH NOPRINT
COMPUTE TRADERS1/I5 MISSING ON=IF MONTH NE LAST MONTH THEN C4 ELSE MISSING; AS 'Number of,Active brokers,per month'
TRADER_ID
CNT.TRADER_ID WITHIN TRADER_ID AS 'Number of,broker trades, Within the month'
FST.PERIOD_TRADES WITHIN TRADER_ID AS 'Number of,broker trades, Within the period'
PCT.CNT.TRADER_ID WITHIN MONTH AS 'Broker trades,as Percentage of total trades, for the month'
PCT.CNT.TRADER_ID WITHIN Period AS 'Broker trades,as Percentage of total trades, for the period'
BY Period NOPRINT
BY MONTH
BY TRADER_ID NOPRINT
ON TABLE SET NODATA ' '
END
-RUN

ThanX JG for reply
ilook for it;

JG, i want to Create Pie Graph for MemberID and Number_of_Enquiry:MemberID is numaric value like 117,111,112

i want to display as Corsponding Name such as Abraham,Daivaid,Araan
at the legend of Graph X-axis and the number of Enquiry as Perecentage to its Total

i apperciate for your help

Look at the following post, it should point you in the right direction.

https://forums.informationbuilders.com/eve/forums/a/...691033831#9691033831

ThanX very much JG for your Help

JG,

is there any way to do it from developer studio insted to Coding, Cuz am feel lost when i read your Post:

all i did i create the macro and i want to register it in WFServlet, i use WF 7.1.3 and i explore in Developer Studio in Option menue, there is Format tabe specified the Template will be used with Excel sheet but i think this template suposed to be register in WF.

can you guide me please.

If you have a valid Excel template that you want to use then it must be in one of the directories
in your APP PATH otherwise WebFocus will not find it.

You should be able to create the report via dev studio However you will not be able to open the
sample code in the report painter because even 713 cannot handle the MISSING ON on the COMPUTE statement.

Delete MISSING ON and it should open.

hi Tony,

i prepare the Excel Template with the *.XLT extension and i put it in Application path,

i generate Excel Report from WF Dev-Studio

but still WF cant find The Template to use it

Qalqili,

Try reading the documentation as well as the posts. You will find that the Excel file has to be saved as a web archive and not a template.

For reference, look at the tech documentation library accessible via the link at the top of each forum page.

T

ThanX Tony for fast reply

i will Serach in Publication Document