Last edited by: Tony A, Ma04:40 AMĮven if i remove the two style statements for compute columns.then also those two columns are not getting formatted according to the report. Try uncommenting the GRANDTOTAL styling and see the difference, also switch between SUBTOTAL and COLUMN-TOTAL to see differences. TYPE=REPORT, COLUMN=PCNT, BACKCOLOR=RGB(200 200 255), COLOR=WHITE, TYPE=REPORT, COLUMN=NOTA, BACKCOLOR=RGB(200 200 255), COLOR=WHITE, ON TABLE COLUMN-TOTAL AS 'Totals' SALESX SEATS *ON TABLE SUBTOTAL SALESX SEATS AS 'Grand Total'
Grandtotal app code#
The example, too, uses the COLUMN= and functions just fine.Įxtending the example above to provide your column-total syntax, this code - TABLE FILE CARĬOMPUTE PCNTS/D12.2 = (SALESX / BHP) * 100 NOPRINTĬOMPUTE PCNTS/D12.2 = (SALESX / BHP) * 100 AS '' where I am!).ĭid you try the example I gave you? That does work and is close to what you are attempting.
Grandtotal app Offline#
The trouble with tinypic is that it is an offline storage site and is often blocked by some companies firewalls and content filters (e.g. ON TABLE COLUMN-TOTAL AS 'APPLICATIONS THAT SUPPORT MULTIPLE BPO''S' SALESX SALESD "APPLICATION PORTFOLIO PLANNING REPORT ON TABLE SET PAGE-NUM OFF ĬOMPUTE PCNTS/D12.2 = ( SALESX / TOTAL_NO_APPS ) * 100 NOPRINTĬOMPUTE PCNTA/D12.2 = ( SALESX / TOTAL_NO_APPS ) * 100 This sounds simple.but i have been tryin this for the past 1 week.īelow is the code which shows the structure of the report.
adn i am not able to format the title and font of the compute column and synchronize the font with the rest of the report structure. I have 2 compute columns which are to be displayed at the end of a CROSSTAB report. I can get this to work no problem if individual columns are on a report but not when the columns are generated repeatedly as in the original example It doesn't even work if you conditional format the Totals in Resource painter. There just doesn't seem to be anything logical,Īll I want to do is format the items in the Totals that are below zero to Red. (FOC3219) A SINGLE COLUMN MUST BE SPECIFIED (FOC3202) BAD VALUE IN STYLESHEET FILE AT LINE WHEN = TOTAL(Var) LT 0 it returns an Error May 09, 2005, 06:30 AM OK after changing the code toįormat the whole totals row as red including the word TOTAL ! Use ROWTOTAL(*) to select all row total columns in the report. Use ROWTOTAL(field) to select the row total column for a particular field. Use ROWTOTAL(n) to select a particular total column.
When used with ACROSS and multiple display commands, ROWTOTAL generates multiple total columns. ROWTOTAL Identifies a column of row totals generated using ROW-TOTAL. Or field(*) to select all occurrences of the field. When a field occurs more than once, use field(n) to select a particular occurrence To determine the value of n, count only vertical sort (BY) fields,įield Identifies a column by its field name. Do not count vertical sort (BY) fields or ROW-TOTAL fields.īn Identifies a vertical sort (BY) column by its position in the report. To determine the value of n, count only display fields from left to right, To determine the value of n, count vertical sort (BY) fields,ĭisplay fields, and ROW-TOTAL fields from left to right.Ĭn Identifies a display column by its position in the report. Pn Identifies a column by its position in the report. To determine this value, count vertical sort (BY) fields,ĭisplay fields, and ROW-TOTAL fields, from left to right, Nn Identifies a column by its position in the report. May 06, 2005, 01:42 PM to answer the first 2 these are the guide lines
0 kommentar(er)
