Three things to try:
1. reboot, and re-start the install clean
2. check for another instance of the server running
3. in the directory
C:\ibi\DEVSTU~1\srv76\wfs
look for the edapth traces, as it says:
09/12/2009 20:55:51 cannot create shared memory, see reason in edapth traces at...
Is your problem the placement, or getting the total number of pages? If the latter, just create a string object that contains the token: <ibi-total-pages/> For example:
COMPOUND LAYOUT
section=s1, $
pagelayout=1, $
component=report1, ..., $
object=string, position=(6 1), text='Page...
Normally, when displaying less precision than the data has, you'd WANT to round, but that's not the case here.
Using 'D' format actually holds 'as much precision' as possible, rounding on display. So, you don't WANT a 'D' format. You only want to hold 2 decimal places. So, I'd recommend using...
If you use a COMPUTE to get the third column, then use 'ON TABLE SUMMARIZE' , the COMPUTE calculation will be redone using the summed values of columns 1 and 2.
You're JOINing from BPDNEW to BIFIL and CRFILL08. Since both JOINs are 'unique' (you haven't secified 'All' or 'MULTIPLE' to indicate there may be multiple children), we ASSUME that you should only get AT MOST oner child iunstance from each segment for a given parent, and pass the JOIN to the...
Can you provide some example of WHAT is being duplicated? Is it an entire record, or just parts of it?
Your request does no sorting or aggregation, so you're just getting the detail records from the retrieval.
Also, you're JOINing from the parent table to TWO different child tables. What if a...
...established, so it knows what days are holidays?
Assuming everything is set correctly, here's sample code to get what you want:
DEFINE FILE CAR
-* the next 3 define are to get a date-time field
IDATE/I8YYMD = DECODE COUNTRY (ENGLAND 20080101 FRANCE 20080201 ITALY 20080301...
...NOPRINT
COMPUTE CSUM/D6 = IF CAT EQ 'C' THEN SUM ELSE 0;
COMPUTE BSUM/D6 = IF CAT NE 'C' THEN SUM ELSE 0;
COMPUTE CPCT/F6.2S% = CSUM*100/XSUM;
BY DEPARTMENT
ON DEPARTMENT SUB-TOTAL
BY CAT
ON TABLE NOTOTAL
END
It uses the 'WITHIN' operator to get the subtotal values on each detail...
...has to allow for the MAXIMUM possible width of each column (we don't know how large the totals will be). Since we ALSO need the total literal (*TOTAL or whatever you use), to avoid overlaying data, we move the totals down one line.
Another way to resolve this issue, is to add a 'dummy' sort...
With HTML, we assume 'infinite width' on the output. Unfortunately, there's no way, in the HTML code, to specify the print orientation. It has to be done in the pronit dialogue.
I need a little more detail. What platform, and what release?
I tried the following on a 7.6.4 server, and it worked as expected:
TABLE FILE CAR
PRINT CAR BY COUNTRY PAGE-BREAK
HEADING
"COUNTRY:<COUNTRY"
FOOTING BOTTOM
"END OF COUNTRY <COUNTRY"
END
Could you try this code? If it works, themn...
In your request, are you SELECTING (using WHERE) on the DEFINEd fields? If so, and the calculation can't be passed to the engine, then all records must be returned, so it can be evaluated by the client. If you look at the trace (assuming it's SQL based), you should see a message that...
You should be able to pass the value of your output type as an additional parameter to the called FEX that does the drill-down. When you pass a parameter, you can pass an AMPER variable to the called procedure by enclosing the amper variable (in your case, the format) in single quotes. It might...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.