Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #12876 > unrolled thread

ReportPro 2.17i is not showing fields of child tables when called from the VO application

Started by"Pedro M. Espinosa" <pmespinosa@gmail.com>
First post2020-02-28 17:07 -0800
Last post2020-03-10 19:23 -0700
Articles 8 — 2 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  ReportPro 2.17i is not showing fields of child tables when called from the VO application "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2020-02-28 17:07 -0800
    Re: ReportPro 2.17i is not showing fields of child tables when called from the VO application Franz Rachbauer <office@rachbauer.org> - 2020-02-29 08:50 +0100
      Re: ReportPro 2.17i is not showing fields of child tables when called from the VO application "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2020-03-02 10:21 -0800
        Re: ReportPro 2.17i is not showing fields of child tables when called from the VO application Franz Rachbauer <office@rachbauer.org> - 2020-03-03 12:28 +0100
          Re: ReportPro 2.17i is not showing fields of child tables when called from the VO application "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2020-03-03 10:08 -0800
            Re: ReportPro 2.17i is not showing fields of child tables when called from the VO application Franz Rachbauer <office@rachbauer.org> - 2020-03-08 07:42 +0100
              Re: ReportPro 2.17i is not showing fields of child tables when called from the VO application Franz Rachbauer <office@rachbauer.org> - 2020-03-08 09:44 +0100
                Re: ReportPro 2.17i is not showing fields of child tables when called from the VO application "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2020-03-10 19:23 -0700

#12876 — ReportPro 2.17i is not showing fields of child tables when called from the VO application

From"Pedro M. Espinosa" <pmespinosa@gmail.com>
Date2020-02-28 17:07 -0800
SubjectReportPro 2.17i is not showing fields of child tables when called from the VO application
Message-ID<7ee12c67-b861-40b4-b5bf-3ed94a1f01d2@googlegroups.com>
Hi,
When I print a report from the design program it shows the data from the child tables but when I print it from within my VO program, it doesn't show the data from the child tables

[toc] | [next] | [standalone]


#12877

FromFranz Rachbauer <office@rachbauer.org>
Date2020-02-29 08:50 +0100
Message-ID<r3d54h$a9c$1@gioia.aioe.org>
In reply to#12876
More infos please: which methods are called before print / printPreview?
Regards, Franz

Am 29.02.2020 um 02:07 schrieb Pedro M. Espinosa:
> Hi,
> When I print a report from the design program it shows the data from the child tables but when I print it from within my VO program, it doesn't show the data from the child tables
> 

[toc] | [prev] | [next] | [standalone]


#12887

From"Pedro M. Espinosa" <pmespinosa@gmail.com>
Date2020-03-02 10:21 -0800
Message-ID<f81fc070-8352-4c41-be3f-317d13a471fe@googlegroups.com>
In reply to#12877
On Saturday, February 29, 2020 at 1:50:45 AM UTC-6, Franz Rachbauer wrote:
> More infos please: which methods are called before print / printPreview?
> Regards, Franz
> 
> Am 29.02.2020 um 02:07 schrieb Pedro M. Espinosa:
> > Hi,
> > When I print a report from the design program it shows the data from the child tables but when I print it from within my VO program, it doesn't show the data from the child tables
> >

These are the methods called (in the sequence shown):
oReport:Connect2Source()
oReport:SetVariableValue()
oReport:SetVarUpdateExpression()
oReport:PrintPreview() or
oReport:Print()

[toc] | [prev] | [next] | [standalone]


#12890

FromFranz Rachbauer <office@rachbauer.org>
Date2020-03-03 12:28 +0100
Message-ID<r3lf1i$11k4$2@gioia.aioe.org>
In reply to#12887
Hi Pedro,
can you send report and used tables in sql export format?
Franz

Am 02.03.2020 um 19:21 schrieb Pedro M. Espinosa:
> On Saturday, February 29, 2020 at 1:50:45 AM UTC-6, Franz Rachbauer wrote:
>> More infos please: which methods are called before print / printPreview?
>> Regards, Franz
>>
>> Am 29.02.2020 um 02:07 schrieb Pedro M. Espinosa:
>>> Hi,
>>> When I print a report from the design program it shows the data from the child tables but when I print it from within my VO program, it doesn't show the data from the child tables
>>>
> 
> These are the methods called (in the sequence shown):
> oReport:Connect2Source()
> oReport:SetVariableValue()
> oReport:SetVarUpdateExpression()
> oReport:PrintPreview() or
> oReport:Print()
> 

[toc] | [prev] | [next] | [standalone]


#12894

From"Pedro M. Espinosa" <pmespinosa@gmail.com>
Date2020-03-03 10:08 -0800
Message-ID<73861dbe-be35-4ca2-8b54-3c415c31ad9d@googlegroups.com>
In reply to#12890
On Tuesday, March 3, 2020 at 5:28:52 AM UTC-6, Franz Rachbauer wrote:
> Hi Pedro,
> can you send report and used tables in sql export format?
> Franz
> 
> Am 02.03.2020 um 19:21 schrieb Pedro M. Espinosa:
> > On Saturday, February 29, 2020 at 1:50:45 AM UTC-6, Franz Rachbauer wrote:
> >> More infos please: which methods are called before print / printPreview?
> >> Regards, Franz
> >>
> >> Am 29.02.2020 um 02:07 schrieb Pedro M. Espinosa:
> >>> Hi,
> >>> When I print a report from the design program it shows the data from the child tables but when I print it from within my VO program, it doesn't show the data from the child tables
> >>>
> > 
> > These are the methods called (in the sequence shown):
> > oReport:Connect2Source()
> > oReport:SetVariableValue()
> > oReport:SetVarUpdateExpression()
> > oReport:PrintPreview() or
> > oReport:Print()
> >

I sent you a reply privately  in order to include the files.

[toc] | [prev] | [next] | [standalone]


#12913

FromFranz Rachbauer <office@rachbauer.org>
Date2020-03-08 07:42 +0100
Message-ID<r4245m$1kki$1@gioia.aioe.org>
In reply to#12894
Hi Pedro,
sent you back testapp and infos on march 4th, did you receive it?
Franz

Am 03.03.2020 um 19:08 schrieb Pedro M. Espinosa:
> On Tuesday, March 3, 2020 at 5:28:52 AM UTC-6, Franz Rachbauer wrote:
>> Hi Pedro,
>> can you send report and used tables in sql export format?
>> Franz
>>
>> Am 02.03.2020 um 19:21 schrieb Pedro M. Espinosa:
>>> On Saturday, February 29, 2020 at 1:50:45 AM UTC-6, Franz Rachbauer wrote:
>>>> More infos please: which methods are called before print / printPreview?
>>>> Regards, Franz
>>>>
>>>> Am 29.02.2020 um 02:07 schrieb Pedro M. Espinosa:
>>>>> Hi,
>>>>> When I print a report from the design program it shows the data from the child tables but when I print it from within my VO program, it doesn't show the data from the child tables
>>>>>
>>>
>>> These are the methods called (in the sequence shown):
>>> oReport:Connect2Source()
>>> oReport:SetVariableValue()
>>> oReport:SetVarUpdateExpression()
>>> oReport:PrintPreview() or
>>> oReport:Print()
>>>
> 
> I sent you a reply privately  in order to include the files.
> 

[toc] | [prev] | [next] | [standalone]


#12914

FromFranz Rachbauer <office@rachbauer.org>
Date2020-03-08 09:44 +0100
Message-ID<r42b8l$sa9$1@gioia.aioe.org>
In reply to#12913
Hi Pedro,
I made a simple MDI App and included method GeneraReporte with fix 
params and when I start it looks the same as starting from designer! You 
can download it from http://www.rachbauer.org/ReporteMovimientos.zip

I think that RP2 cannot find CDX files:

-> Look at properties / section / Relationship which index file name and 
path it uses (are DBF and CDX files on runtime in this path?)

-> Sometimes I had problems with index files and I patched path with Hex 
Editor MX (C:\ADMCOND\CONTACTOS.CDX -> CONTACTOS.CDX)

-> As you say another way would be dbfSwap, I often used this

Regards, Franz

Am 08.03.2020 um 07:42 schrieb Franz Rachbauer:
> Hi Pedro,
> sent you back testapp and infos on march 4th, did you receive it?
> Franz
> 
> Am 03.03.2020 um 19:08 schrieb Pedro M. Espinosa:
>> On Tuesday, March 3, 2020 at 5:28:52 AM UTC-6, Franz Rachbauer wrote:
>>> Hi Pedro,
>>> can you send report and used tables in sql export format?
>>> Franz
>>>
>>> Am 02.03.2020 um 19:21 schrieb Pedro M. Espinosa:
>>>> On Saturday, February 29, 2020 at 1:50:45 AM UTC-6, Franz Rachbauer 
>>>> wrote:
>>>>> More infos please: which methods are called before print / 
>>>>> printPreview?
>>>>> Regards, Franz
>>>>>
>>>>> Am 29.02.2020 um 02:07 schrieb Pedro M. Espinosa:
>>>>>> Hi,
>>>>>> When I print a report from the design program it shows the data 
>>>>>> from the child tables but when I print it from within my VO 
>>>>>> program, it doesn't show the data from the child tables
>>>>>>
>>>>
>>>> These are the methods called (in the sequence shown):
>>>> oReport:Connect2Source()
>>>> oReport:SetVariableValue()
>>>> oReport:SetVarUpdateExpression()
>>>> oReport:PrintPreview() or
>>>> oReport:Print()
>>>>
>>
>> I sent you a reply privately  in order to include the files.
>>
> 

[toc] | [prev] | [next] | [standalone]


#12920

From"Pedro M. Espinosa" <pmespinosa@gmail.com>
Date2020-03-10 19:23 -0700
Message-ID<eb050783-0bb9-482d-a2e7-1b2f365b7ed7@googlegroups.com>
In reply to#12914
On Sunday, March 8, 2020 at 2:44:08 AM UTC-6, Franz Rachbauer wrote:
> Hi Pedro,
> I made a simple MDI App and included method GeneraReporte with fix 
> params and when I start it looks the same as starting from designer! You 
> can download it from http://www.rachbauer.org/ReporteMovimientos.zip
> 
> I think that RP2 cannot find CDX files:
> 
> -> Look at properties / section / Relationship which index file name and 
> path it uses (are DBF and CDX files on runtime in this path?)
> 
> -> Sometimes I had problems with index files and I patched path with Hex 
> Editor MX (C:\ADMCOND\CONTACTOS.CDX -> CONTACTOS.CDX)
> 
> -> As you say another way would be dbfSwap, I often used this
> 
> Regards, Franz
> 
> Am 08.03.2020 um 07:42 schrieb Franz Rachbauer:
> > Hi Pedro,
> > sent you back testapp and infos on march 4th, did you receive it?
> > Franz
> > 
> > Am 03.03.2020 um 19:08 schrieb Pedro M. Espinosa:
> >> On Tuesday, March 3, 2020 at 5:28:52 AM UTC-6, Franz Rachbauer wrote:
> >>> Hi Pedro,
> >>> can you send report and used tables in sql export format?
> >>> Franz
> >>>
> >>> Am 02.03.2020 um 19:21 schrieb Pedro M. Espinosa:
> >>>> On Saturday, February 29, 2020 at 1:50:45 AM UTC-6, Franz Rachbauer 
> >>>> wrote:
> >>>>> More infos please: which methods are called before print / 
> >>>>> printPreview?
> >>>>> Regards, Franz
> >>>>>
> >>>>> Am 29.02.2020 um 02:07 schrieb Pedro M. Espinosa:
> >>>>>> Hi,
> >>>>>> When I print a report from the design program it shows the data 
> >>>>>> from the child tables but when I print it from within my VO 
> >>>>>> program, it doesn't show the data from the child tables
> >>>>>>
> >>>>
> >>>> These are the methods called (in the sequence shown):
> >>>> oReport:Connect2Source()
> >>>> oReport:SetVariableValue()
> >>>> oReport:SetVarUpdateExpression()
> >>>> oReport:PrintPreview() or
> >>>> oReport:Print()
> >>>>
> >>
> >> I sent you a reply privately  in order to include the files.
> >>
> >

I finally found the problem, it was caused by the cPath parameter that cannot be empty.
Thanks a lot for all your help

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web