I need to create Master-Detail report. It should show Master record and Detail records on the same page. HTML format prefered. The data is in SQL tables which I can join on JobID. It should look like this:

- - - Master record
Job_ID| Job_Name
12345 | name here

- - - Detail records
Cost_Code | Cost_Type | Amount
111111111 | 77777777 | 1,234
222222222 | 88888888 | 5,678

How can I do such layout (show Detail records below Master record)?

WebFocus 7.1.6 on WinXP using SQL2005

This message has been edited. Last edited by: Seva,

Seva

There are more ways to do this and it depends on how you want this to be displayed.

You have to create two separate reports first and then create a compound report that runs the two and displays it as one report.

If the first report in fact is just one line of info (and not a table of several records), you can put that master record also in the header of the detailed report.

This second method would be better if the report would look like

Job_ID| Job_Name
12345 | name here

Cost_Code | Cost_Type | Amount
111111111 | 77777777 | 1,234
222222222 | 88888888 | 5,678

Job_ID| Job_Name
34221 | an other job

Cost_Code | Cost_Type | Amount
122122112 | 82218199 | 5,445
232111123 | 53323127 | 2,678

next job....

to do it this way you can

TABLE FILE CAR
PRINT MODEL
SALES CNT.BODYTYPE
BY COUNTRY NOPRINT
ON COUNTRY SUBHEAD
"country:"
"<COUNTRY"
"------------"
ON COUNTRY SUBTOTAL AS ''
ON COUNTRY SUBFOOT
" "
" "
END

TABLE FILE MASTER
PRINT JOB_ID JOB_NAME
OVER COST_CODE COST_TYPE
END

I'm sorry to say PB, but that does not what Seva is asking for, it just prints a job_id and job_name on one line and on the next line a cost_code and a cost_type.
If these 4 fields are in the same record and there are more records with the same job_id and job_name, these 2 fields are repeating.

BTW would you also update your signature.....

Small example of how I might do it.

  
SET BYDISPLAY = ON 
SET STYLEMODE = FIXED
TABLE FILE CAR
PRINT CAR AS '' SALES  AS '' DEALER_COST AS ''
COMPUTE SOMEFILL/A6 = ' '; AS ''
BY COUNTRY NOPRINT
BY CAR NOPRINT
ON COUNTRY NOSPLIT
ON COUNTRY UNDER-LINE
ON COUNTRY SKIP-LINE
ON COUNTRY SUBHEAD
"Country File"
"<COUNTRY"
" "
"Car        <20>Sales      Dealer Cost"
END

yes what Leah did is better, since now you will get a header above the detailed report.

Thank you. It is almost what I'm looking for, but still not exactly what I need. The report formatting doesn't look good. I wish I can upload files here which have Master and Detail section the way I need them to be formatted. Can I upload files?

No - If you want more people to help you with your problem, it is better to illustrate your problem with the IBI Sample files, such as the CAR file.

I put the desired layout of report at the following link. You can see 1 Master line for Job Number on the top and 3 Detail lines below. I'd like to have it formatted similar to what you see, including formatting for column headers. How can I do this?
http://svaysband.freeservers.com/module1b_combined.htm
Thanks

Seva

your example is clear, it's a compound report.
It can be done the way I described this.

build your two separate reports
create a compound report that includes the two fexes, run the report.

how to create a cmpound report is pointed out several times here. Search for "compound"

And please update your signature or we won't help anymore...

Thank you for your help. How can I update my signature? What I try to do now is to follow example 'Embedding Reports and Variables Into One HTML Web Page' in WebFocus Developer Studio Online Help: TABLE FILE CAR "REPORT 1 - BY COUNTRY" PRINT CAR MODEL BODYTYPE BY COUNTRY ON TABLE HOLD FORMAT HTMTABLE AS REPORT1 ON TABLE SET STYLE *TYPE=HEADING,STYLE=BOLD,COLOR=RED,$ ENDSTYLE END TABLE FILE CAR "REPORT 2 - BY BODY TYPE" PRINT CAR MODEL COUNTRY BY BODYTYPE ON TABLE HOLD FORMAT HTMTABLE AS REPORT2 ON TABLE SET STYLE * TYPE=HEADING,STYLE=BOLD,COLOR=BLUE,$ ENDSTYLE END TABLE FILE CAR "REPORT 3 - BY MANUFACTURER" PRINT MODEL BODYTYPE COUNTRY BY CAR ON TABLE HOLD FORMAT HTMTABLE AS REPORT3 ON TABLE SET STYLE * TYPE=HEADING,STYLE=BOLD,COLOR=GREEN,$ ENDSTYLE END -HTMLFORM BEGIN !IBI.FIL.REPORT1; !IBI.FIL.REPORT2; !IBI.FIL.REPORT3; -HTMLFORM END However, I'm getting error - UNABLE TO LOCATE END OF !IBI ESCAPE SEQUENCE. Any ideas?

Seva, on the top navigation bar on this forum
click GO
then Personal_Zone
then Profile

See the 2nd sticky post at the top of the forum? Open it, and read what our moderator wants us to do.
and then, learn to use the code tags (rightmost button on the top of the Post-A-Reply page) to surround your code, when you paste it in a reply.
ok?

Thank you very much. I made changes to my profile / signature. I hope I did it right.
The latest issue I had is getting error UNABLE TO LOCATE END OF !IBI ESCAPE SEQUENCE when I followed example at 'Embedding Reports and Variables Into One HTML Web Page' in WebFocus Developer Studio Online Help. I was able to figure it out. The original code had at the bottom lines !IBI.FIL.REPORT1;
I used in my code !IBI.FIL.HOLDMASTER; and got error. I changed it to !IBI.FIL.HMASTER; and it works. It looks like there is a limitation - no more than 8 characters allowed in the name.

Seva

The signature is as it should be...
If your script is working now that would be great. The 8 characters sounds logic.