I have a report with two columns a,b and two filters c-checkbox, d-list.
I have to include c and d as hidden columns in my report to filter by them using the checkbox and list.
The problem is that when I include c and d in the report, the aggregation (by) is impacted as the report is now aggregating by a,b,c,d. I only want to aggregate by a,b and ingnore c,d.
How do I do that?This message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 8.0.7 Windows, All Outputs
March 20, 2014, 04:18 AM
MichaelBalle
Can your please send the code example with the TABLE FILE CAR .... END
WebFOCUS 7.6, 7.7 Windows, All Output formats
March 20, 2014, 05:58 AM
Dave
Amisol,
You do not have to add hidden columns in your report to filter them...
TABLE FILE CAR
SUM SALES
BY CAR
WHERE COUNTRY EQ 'ITALY'
END
Works fine...
COUNTRY is not in the report, but a filter is active...
...unless you mean something completely different with 'filter'.
Greets, Dave
_____________________ WF: 8.0.0.9 > going 8.2.0.5
March 20, 2014, 10:13 AM
AmiSol
Dave - I'm referring to the ability to filter a grid in a dashboard using either list/checkbox/dropdown...
From what I understand, the columns I want to filter by has to exist in the grid.
Example:
-*Do not delete or modify the comments above ENGINE INT CACHE SET ON SET PAGE-NUM=NOLEAD SET EMPTYREPORT=ON
SET COMPONENT=Table_1 -*component_type report -DEFAULTH &WF_SUMMARY='Summary'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; TABLE FILE CAR SUM CAR.BODY.SALES BY CAR.COMP.CAR BY CAR.ORIGIN.COUNTRY BY CAR.BODY.BODYTYPE NOPRINT ACROSS CAR.CARREC.MODEL
ON TABLE NOTOTAL ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET SQUEEZE ON ON TABLE SET EMPTYREPORT ON ON TABLE SET HTMLCSS ON ON TABLE SET HTMLENCODE ON ON TABLE SET CACHELINES 100 ON TABLE SET BYDISPLAY ON ON TABLE SET STYLE * INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$ TYPE=REPORT, TITLETEXT='Report1', SUMMARY=&WF_SUMMARY.QUOTEDSTRING, PAGESIZE=E, ARGRAPHENGINE=JSCHART, $ ENDSTYLE END
COMPOUND END
Results: Car Country Sales.... Alfa Romeo Italy ... Alfa Romeo Italy ... Alfa Romeo Italy ...
I want to see Alfa Romeo once.
WebFOCUS 8.0.7 Windows, All Outputs
March 21, 2014, 02:51 AM
Dave
Amisol,
that's a different kind of filter then I had in mind.
But since it's an AHTML I guess the filtering is done at the client. The fields you want to filter have to be available in the dataset at the client.
I've tried sorting groups, but doesn't seem to work with ahtml...
Sorry, can't help you here :-(
_____________________ WF: 8.0.0.9 > going 8.2.0.5
April 02, 2014, 10:52 AM
AmiSol
Can anyone else help?
WebFOCUS 8.0.7 Windows, All Outputs
April 04, 2014, 02:01 PM
J.L. Hinds
Can you write to a hold file prior to running the report?
WebFOCUS 7.6 Windows, All Outputs
April 11, 2014, 04:44 PM
J
remove the following line:
ON TABLE SET BYDISPLAY ON
this will give you:
Alfa romeo Italy...
Italy...
Italy...
If that isn't what you want, please be more clear.
WebFOCUS 7.7.03/8.0.08 Dev Studio 7.7.03/8.0.08 App Studio 8.0.08 Windows 7 ALL Outputs