{"id":574,"date":"2006-02-08T15:13:44","date_gmt":"2006-02-08T07:13:44","guid":{"rendered":"http:\/\/foxpro.ntsl119.com\/scr\/?p=574"},"modified":"2007-10-09T04:10:49","modified_gmt":"2007-10-08T20:10:49","slug":"multiple-detail-band-in-visual-foxpro-9","status":"publish","type":"post","link":"https:\/\/foxpro.ntsl119.com\/scr\/archives\/574","title":{"rendered":"Multiple Detail Band in Visual FoxPro 9"},"content":{"rendered":"

After countless trials and errors, with each error pounding one of my faithful neurons, reading (and re-reading and re-reading), roundtrips to the Program Files\\VFP9\\Samples directory and pathetic attempts to have a crash course on ‘Absorbing the Mozart Effect 101’… I finally figured out how to make VFP9’s multiple detail band feature work on one of my reports.<\/p>\n

(And no, Mozart wasn’t helpful this time.)<\/p>\n

More than 77 neurons are off to meet their maker. I stopped counting though an hour and a half ago, so there’s probably more. (And we’re not even counting the injured and now-limb-less ones.) <\/p>\n

Yes I know… I’m quite late with this. Most VFP9 coders are now using the multiple detail band to extract data from different databases located in parallel universes while I have been using the dump N table records to one ‘cursor\/table holder’ with generic field names where I can extract data for reporting…<\/p>\n

… or firing up CrystalReports.<\/p>\n

Anyway at 1:37AM, I’m scribbling this down just in case an alien decides to teleport its presence here in this room, do some wholesome (I hope) experiments and decides to mind-wipe me afterwards, which might possibly corrupt this multiple-detail-band-eureka moments I have.<\/p>\n

Also this could probably help a coder out there who decides to google things after being mind-wiped by an alien.<\/p>\n

Just a basic overview… I’ll call these step by step ‘hints’ not a ‘guide’. (A User Guide expert would scream bloody hell when he sees this. (But trust me a programmer will understand. (Especially those mind-wiped by aliens.)))<\/p>\n

Given:
\nParent.dbf \/ Child01.dbf \/ Child02.dbf
\nRight click = Right click in the Report Designer. <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
<\/p>\n
<\/p>\n\n
1.<\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nFile. New. New report. (No wizards.) <\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
2. <\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nData Environment. Add the three (or more) tables.<\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
3. <\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nSet the relationships. (P » C01 and P » C02.)<\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
4.<\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nRight click. Select Data Grouping. <\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
5.<\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nData Grouping tab. Group Nesting Order box. Add. And add field from your parent table (Your primary key… for example: PARENT.CODENO) <\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
6.<\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nRight click. Optional Bands. In the Detail Bands box, Add another Detail Band. <\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
7.<\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nNow you have two bands. One for you, one for the alien.<\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
8.<\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nDouble click on the Detail 1 separator. The Detail Band Properties window pops out. (Or if you like the longer process… Report… Edit Bands… select Detail 1.) <\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
9.<\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nCheck Associated header and footer bands. (Trust me you need this. Aliens are allergic to this.) <\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
10.<\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nRepeat steps 8 – 9 for Detail 2. <\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
11.<\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nData Environment. Drag the fields to their appropriate bands. Parent fields on the Group Header. C01 fields in the Detail 1 band and C02 fields on the Detail 2. And aliens in the footer part. <\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
12.<\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nBTW… you should have saved your report already and instinctively press CTRL+S every now and then in case the aliens… <\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
13.<\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nNow double click the Detail 1 ‘bar’ (separator) again. <\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
14.<\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nDetail Band Properties. In the Target alias expression enter ‘child01’ or the name of your child database. (NOTE: Be sure to include the ”)<\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
15.<\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nDo the same with the other Detail bands. The Detail 1 band separator should now look like ‘Detail 1: Child01’.<\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
16.<\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nAdd appropiate headers, lines and all. Align things. <\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/p>\n
<\/p>\n\n
17.<\/div>\n<\/td>\n
<\/p>\n <\/td>\n<\/p>\nBeautify your report. Make it look professional. Nevermind if your clients are using a stone-age dot matrix printer. <\/td>\n<\/p>\n <\/td>\n<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/tr>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n

<\/font><\/td>\n<\/table>\n

Hope this helps.<\/p>\n

Now I’m off to re-inspect the protective shields of this room. <\/p>\n","protected":false},"excerpt":{"rendered":"

After countless trials and errors, with each error pounding one of my faithful neurons, reading (and re-reading and re-reading), roundtrips to the Program Files\\VFP9\\Samples directory and pathetic attempts to have a crash course on ‘Absorbing the Mozart Effect 101’… I finally figured out how to make VFP9’s multiple detail band feature work on one of […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,10],"tags":[],"class_list":["post-574","post","type-post","status-publish","format-standard","hentry","category-visual-foxpro","category-workblog"],"_links":{"self":[{"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/posts\/574","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/comments?post=574"}],"version-history":[{"count":0,"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/posts\/574\/revisions"}],"wp:attachment":[{"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/media?parent=574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/categories?post=574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/tags?post=574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}