Multiple detail band in VFP

Hi All,

I have this reporting scenario where by I have one master table and 2 detail
tables. I tried to use multiple band but encountered a problem when the
records of 2nd detail tables overflow to second page. Somewhat one of the
record of 2nd detail table is missing. I do not understand why.

Does multiple band works on relationship of one to many detail tables or it
works on one-many-many? Also is there anyway to pagebreak once all records in
1st detail is printed and start 2nd detail table in a new page?

--
Eric Lim

EricLim
Thu Aug 25 00:44:01 CDT 2005

Hi All,

Checked the support website and discovered that there is a hotfix available
for this problem. But somehow I need to call them or email them for the fix.
Hmm.. very frustrating but what to do?

--
Eric Lim


"Eric Lim" wrote:

> Hi All,
>
> I have this reporting scenario where by I have one master table and 2 detail
> tables. I tried to use multiple band but encountered a problem when the
> records of 2nd detail tables overflow to second page. Somewhat one of the
> record of 2nd detail table is missing. I do not understand why.
>
> Does multiple band works on relationship of one to many detail tables or it
> works on one-many-many? Also is there anyway to pagebreak once all records in
> 1st detail is printed and start 2nd detail table in a new page?
>
> --
> Eric Lim

Leemi
Thu Aug 25 09:28:31 CDT 2005

Hi Eric:

You cal call Product Support at 800 936 3500 from 9:00AM-6:00PM EDT to open
a support case to obtain the hot fix. (This assumes you are in the US or
Canada.) You can also open an e-mail case by going to

http://support.microsoft.com/default.aspx

The hot fix is not available for public download.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

>Hi All,

>Checked the support website and discovered that there is a hotfix
available
>for this problem. But somehow I need to call them or email them for the
fix.
>Hmm.. very frustrating but what to do?

--
>Eric Lim

Ook
Thu Aug 25 09:38:36 CDT 2005

Lee, I have the hotfix, and I don't believe it fixes this exact issue. The
hotfix is specifically for when a detail band starts at the top of the page.
In this case, only the first record appears. His description sounds like the
detal band continues to the second page and then drops records, but I don't
think English is his native tongue and he may not have described it
accurately.

Is there another hotfix for his issue? We are using multiple detail bands
for a large complex mission critical report, and it would be *extremely* bad
if what is happening to him happened to us.



"Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
news:iiSMHFYqFHA.1208@TK2MSFTNGXA01.phx.gbl...
> Hi Eric:
>
> You cal call Product Support at 800 936 3500 from 9:00AM-6:00PM EDT to
> open
> a support case to obtain the hot fix. (This assumes you are in the US or
> Canada.) You can also open an e-mail case by going to
>
> http://support.microsoft.com/default.aspx
>
> The hot fix is not available for public download.
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 HAS ARRIVED!! --*
> Read about all the new features of VFP9 here:
> http://msdn.microsoft.com/vfoxpro/
>
> *--Purchase VFP 9.0 here:
> http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
> 69-4500-8bf2-3f06689f4ab3&type=ovr
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/gp/lifeselectindex
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>>Hi All,
>
>>Checked the support website and discovered that there is a hotfix
> available
>>for this problem. But somehow I need to call them or email them for the
> fix.
>>Hmm.. very frustrating but what to do?
>
> --
>>Eric Lim
>

man-wai
Thu Aug 25 09:40:17 CDT 2005

> The hot fix is not available for public download.

Why?

(I am a bit disappointed by the report writer enahnacements in VFP9. I
did expect more ....)

--
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.31
^ ^ 10:39pm up 2 days 2:16 load average: 1.49 1.27 1.23

Ook
Thu Aug 25 10:28:13 CDT 2005


"man-wai chang" <toylet.toylet@gmail.com> wrote in message
news:uXCZoLYqFHA.2696@TK2MSFTNGP11.phx.gbl...
>> The hot fix is not available for public download.
>
> Why?
>
> (I am a bit disappointed by the report writer enahnacements in VFP9. I did
> expect more ....)
>

Being a hotfix, it probably hasn't gone through extensive regression testing
and therefore represents a high risk of destabilizing your app. Though to be
honest I too don't know why they don't make them available to the public
with appropriate disclaimers.

The VFP9 report writer isn't bad for a first version, but being a first
release it's also buggy as hell. We came real close to scrapping it. If
there is a VFP10, I would bet that the report writer in that version is
going to be a lot smoother.

Leemi
Thu Aug 25 10:44:28 CDT 2005

Hi Ook:

There are no new hot fixes for the Report Designer in VFP 9.0 as of this
time.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003


>Lee, I have the hotfix, and I don't believe it fixes this exact issue. The
>hotfix is specifically for when a detail band starts at the top of the
page.
>In this case, only the first record appears. His description sounds like
the
>detal band continues to the second page and then drops records, but I
don't
>think English is his native tongue and he may not have described it
>accurately.

>Is there another hotfix for his issue? We are using multiple detail bands
>for a large complex mission critical report, and it would be *extremely*
bad
>if what is happening to him happened to us.



>"Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
>news:iiSMHFYqFHA.1208@TK2MSFTNGXA01.phx.gbl...
> Hi Eric:
>
> You cal call Product Support at 800 936 3500 from 9:00AM-6:00PM EDT to
> open
> a support case to obtain the hot fix. (This assumes you are in the US or
> Canada.) You can also open an e-mail case by going to
>
> http://support.microsoft.com/default.aspx
>
> The hot fix is not available for public download.
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 HAS ARRIVED!! --*
> Read about all the new features of VFP9 here:
> http://msdn.microsoft.com/vfoxpro/
>
> *--Purchase VFP 9.0 here:
>
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
> 69-4500-8bf2-3f06689f4ab3&type=ovr
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/gp/lifeselectindex
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>>Hi All,
>
>>Checked the support website and discovered that there is a hotfix
> available
>>for this problem. But somehow I need to call them or email them for the
> fix.
>>Hmm.. very frustrating but what to do?
>
> --
>>Eric Lim
>

Dan
Thu Aug 25 10:47:36 CDT 2005

They need to track who receives it.

Dan

man-wai chang wrote:
>> The hot fix is not available for public download.
>
> Why?
>
> (I am a bit disappointed by the report writer enahnacements in VFP9. I
> did expect more ....)

Ook
Thu Aug 25 14:47:51 CDT 2005

That helps. In that case, either he didn't describe his problem very well,
or the hotfix won't help - or - the hotfix does more then they say it will.


"Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
news:clJllvYqFHA.1208@TK2MSFTNGXA01.phx.gbl...
> Hi Ook:
>
> There are no new hot fixes for the Report Designer in VFP 9.0 as of this
> time.
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 HAS ARRIVED!! --*
> Read about all the new features of VFP9 here:
> http://msdn.microsoft.com/vfoxpro/
>
> *--Purchase VFP 9.0 here:
> http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
> 69-4500-8bf2-3f06689f4ab3&type=ovr
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/gp/lifeselectindex
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>
>>Lee, I have the hotfix, and I don't believe it fixes this exact issue. The
>>hotfix is specifically for when a detail band starts at the top of the
> page.
>>In this case, only the first record appears. His description sounds like
> the
>>detal band continues to the second page and then drops records, but I
> don't
>>think English is his native tongue and he may not have described it
>>accurately.
>
>>Is there another hotfix for his issue? We are using multiple detail bands
>>for a large complex mission critical report, and it would be *extremely*
> bad
>>if what is happening to him happened to us.
>
>
>
>>"Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
>>news:iiSMHFYqFHA.1208@TK2MSFTNGXA01.phx.gbl...
>> Hi Eric:
>>
>> You cal call Product Support at 800 936 3500 from 9:00AM-6:00PM EDT to
>> open
>> a support case to obtain the hot fix. (This assumes you are in the US or
>> Canada.) You can also open an e-mail case by going to
>>
>> http://support.microsoft.com/default.aspx
>>
>> The hot fix is not available for public download.
>>
>> I hope this helps.
>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> Sincerely,
>> Microsoft FoxPro Technical Support
>> Lee Mitchell
>>
>> *-- VFP9 HAS ARRIVED!! --*
>> Read about all the new features of VFP9 here:
>> http://msdn.microsoft.com/vfoxpro/
>>
>> *--Purchase VFP 9.0 here:
>>
> http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
>> 69-4500-8bf2-3f06689f4ab3&type=ovr
>>
>> Keep an eye on the product lifecycle for Visual FoxPro here:
>> http://support.microsoft.com/gp/lifeselectindex
>> - VFP5 Mainstream Support retired June 30th, 2003
>> - VFP6 Mainstream Support retired Sept. 30th, 2003
>>
>>>Hi All,
>>
>>>Checked the support website and discovered that there is a hotfix
>> available
>>>for this problem. But somehow I need to call them or email them for the
>> fix.
>>>Hmm.. very frustrating but what to do?
>>
>> --
>>>Eric Lim
>>
>
>

Ook
Thu Aug 25 14:47:24 CDT 2005

Why?

"Dan Freeman" <spam@microsoft.com> wrote in message
news:eKIXSxYqFHA.364@TK2MSFTNGP11.phx.gbl...
> They need to track who receives it.
>
> Dan
>
> man-wai chang wrote:
>>> The hot fix is not available for public download.
>>
>> Why?
>>
>> (I am a bit disappointed by the report writer enahnacements in VFP9. I
>> did expect more ....)
>
>

Dan
Thu Aug 25 15:37:08 CDT 2005

Legal liability, I'd imagine.

They said they needed to keep track, and that's all I needed to know.

Dan

Ook wrote:
> Why?
>
> "Dan Freeman" <spam@microsoft.com> wrote in message
> news:eKIXSxYqFHA.364@TK2MSFTNGP11.phx.gbl...
>> They need to track who receives it.
>>
>> Dan
>>
>> man-wai chang wrote:
>>>> The hot fix is not available for public download.
>>>
>>> Why?
>>>
>>> (I am a bit disappointed by the report writer enahnacements in
>>> VFP9. I did expect more ....)

EricLim
Thu Aug 25 20:55:03 CDT 2005

Hi,

Sorry for the confusion and let me explain it properly. The 2nd detail band
I am doing only show one record per page so to say the first record always
start at the top of the the page. However when preview, it shows only one
record although there are more than one records in it. The hoxfix explains
the problem and I think it will fix the issue. I have not initiated the
support but I will soon.

Do note that this problem occurred in 2nd detail band only.

--
Eric Lim


"Ook" wrote:

> Lee, I have the hotfix, and I don't believe it fixes this exact issue. The
> hotfix is specifically for when a detail band starts at the top of the page.
> In this case, only the first record appears. His description sounds like the
> detal band continues to the second page and then drops records, but I don't
> think English is his native tongue and he may not have described it
> accurately.
>
> Is there another hotfix for his issue? We are using multiple detail bands
> for a large complex mission critical report, and it would be *extremely* bad
> if what is happening to him happened to us.
>
>
>
> "Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
> news:iiSMHFYqFHA.1208@TK2MSFTNGXA01.phx.gbl...
> > Hi Eric:
> >
> > You cal call Product Support at 800 936 3500 from 9:00AM-6:00PM EDT to
> > open
> > a support case to obtain the hot fix. (This assumes you are in the US or
> > Canada.) You can also open an e-mail case by going to
> >
> > http://support.microsoft.com/default.aspx
> >
> > The hot fix is not available for public download.
> >
> > I hope this helps.
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> > Sincerely,
> > Microsoft FoxPro Technical Support
> > Lee Mitchell
> >
> > *-- VFP9 HAS ARRIVED!! --*
> > Read about all the new features of VFP9 here:
> > http://msdn.microsoft.com/vfoxpro/
> >
> > *--Purchase VFP 9.0 here:
> > http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
> > 69-4500-8bf2-3f06689f4ab3&type=ovr
> >
> > Keep an eye on the product lifecycle for Visual FoxPro here:
> > http://support.microsoft.com/gp/lifeselectindex
> > - VFP5 Mainstream Support retired June 30th, 2003
> > - VFP6 Mainstream Support retired Sept. 30th, 2003
> >
> >>Hi All,
> >
> >>Checked the support website and discovered that there is a hotfix
> > available
> >>for this problem. But somehow I need to call them or email them for the
> > fix.
> >>Hmm.. very frustrating but what to do?
> >
> > --
> >>Eric Lim
> >
>
>
>

EricLim
Thu Aug 25 21:11:01 CDT 2005

Hi Mitchell,

Thanks for the information and I am from Singapore. It is just a setback in
a sense because the new report engine is what we were looking forward to. We
are programmers and we know it is hard to get a bug free system in the first
go but with the staff strength of Microsoft and years of development such bug
should not passed the quality controls.

I mean it is true that one should not use a new version until the first
service pack is released for each product? But take into credit of the great
improvement in the reporting engine... okay. We skipped VFoxpro v8 completely
as v9 was out before we could implement it.

--
Eric Lim


"Lee Mitchell" wrote:

> Hi Eric:
>
> You cal call Product Support at 800 936 3500 from 9:00AM-6:00PM EDT to open
> a support case to obtain the hot fix. (This assumes you are in the US or
> Canada.) You can also open an e-mail case by going to
>
> http://support.microsoft.com/default.aspx
>
> The hot fix is not available for public download.
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 HAS ARRIVED!! --*
> Read about all the new features of VFP9 here:
> http://msdn.microsoft.com/vfoxpro/
>
> *--Purchase VFP 9.0 here:
> http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
> 69-4500-8bf2-3f06689f4ab3&type=ovr
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/gp/lifeselectindex
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
> >Hi All,
>
> >Checked the support website and discovered that there is a hotfix
> available
> >for this problem. But somehow I need to call them or email them for the
> fix.
> >Hmm.. very frustrating but what to do?
>
> --
> >Eric Lim
>
>