Re: Subreport w/ External Foxpro DBF by Dan
Dan
Wed Mar 03 09:22:02 CST 2004
I wanted to thank you again for your help, it gave me a new perspective on
the problem.
Once I started with a new report only using the same data source, it became
very clear it was not using the datasource I was expecting. Now I need to
find out how to change the datasource of a subreport programmatically. Time
for some homework.
Thx again,
Dan
"Dan Tallent" <dtallent@NOTEarthlink.net> wrote in message
news:epHa5rIAEHA.3308@TK2MSFTNGP10.phx.gbl...
> I appreciate your quick response, and advise. I'll start working on it
> right away.
> Thx again
> Dan
>
>
> "Bob Holmes" <rholmes@REMOVEmmwec.org> wrote in message
> news:uyy$jnIAEHA.1452@TK2MSFTNGP09.phx.gbl...
> > Hi Dan,
> > You might have to change it depending on what you need to get.
Right
> > now all three conditions have to be true in order for any data to be
> > returned to your report. If this not what you expect then it needs
> changing
> > otherwise it is a legitimate formula. As a means of troubleshooting, if
> you
> > have another querying tool, like SQL Server's query analyzer, copy your
> sql
> > statement from the subreport into this tool and see what results you
get.
> > You will have to change the "Where" clause to accommodate the parameter
> > values. If the query returns data, then we have to start looking at the
> > report. Create a brand new report using the same data source as the
> > subreport. Does it return records? If yes, then add a parameter. Does
> it
> > still work? IF yes, then add all three parameters and make sure your
> > selection formula looks like the subreport. Does it still work? If so,
I
> > would continue to build this report into what you would expect your
> > subreport to look like. Then, try to bring this existing report into
your
> > main report as a subreport and make the links. You've got a little work
> to
> > do to try and troubleshoot this, but it shouldn't be very hard.
> >
> > Bob Holmes
> >
> > "Dan Tallent" <dtallent@NOTEarthlink.net> wrote in message
> > news:OGbXgZIAEHA.2512@TK2MSFTNGP11.phx.gbl...
> > > I have tried to refresh for just the subreport and it does not work.
It
> > > asked for the values of the three parameter fields, then it acts the
> same
> > as
> > > it does when I run the main report. The fields from the cs_equip
> (second
> > > file) do not show up. I have tried deleting the subreport and
creating
> a
> > > new subreport from scratch (same result). The fields are of numeric
> type
> > > (10,0)
> > >
> > > Do I need to change the selection formula (record) on the subreport?
> > > It is currently: (This is what the Link Window does on its own)
> > >
> > > {cs_equip.ncompany} = {?Pm-customer_history.ncompany}and
> > > {cs_equip.njobnumber} = {?Pm-customer_history.njobnumber}and
> > > {cs_equip.nsite_equipid} = {?Pm-customer_history.nsite_equipid}
> > >
> > > Thx again for your help,
> > > Dan
> > >
> > >
> > >
> > > "Bob Holmes" <rholmes@REMOVEmmwec.org> wrote in message
> > > news:erc2jRIAEHA.3056@TK2MSFTNGP11.phx.gbl...
> > > > Hi Dan,
> > > > If you edit the subreport and try to refresh, what happens? It
> > should
> > > > ask you for any values that it was expecting to get from the main
> report
> > > and
> > > > then process the subreport as a standalone report. If this is not
> > > > happening, then there is some issue with the subreport itself. If
> this
> > > > works, then there is a problem with the linking aspect. Possibly a
> > > > difference in data type between the data in the main report and that
> in
> > > the
> > > > subreport.
> > > >
> > > > Bob Holmes
> > > >
> > > > "Dan Tallent" <dtallent@NOTEarthlink.net> wrote in message
> > > > news:uwO#VMIAEHA.3256@TK2MSFTNGP09.phx.gbl...
> > > > > I'm having a problem with a report.
> > > > >
> > > > > I have a problem getting my subreport linked to my main report. I
> > have
> > > a
> > > > > primary file used for the main report, and a second (stand alone)
> file
> > > for
> > > > > the subreport.
> > > > > The subreport is not showing any information from the second file.
> > I'm
> > > at
> > > > a
> > > > > loss, and could use some advise. I have included some details
> below.
> > > > >
> > > > > I have a file that includes multiple fields that are used in the
> main
> > > > > report:
> > > > > customer name, customer number, job number, company number, and
> > > equipment
> > > > > id.
> > > > >
> > > > > I have a second file which is a list of equipment used on a given
> job:
> > > > > (subreport)
> > > > > job number, company number, equipment id, serial number, model #
> > > > >
> > > > > These files are not joined in the report, I wish to use subreport
> > links
> > > to
> > > > > join the two together.
> > > > > The second file will list the detail info for a given piece of
> > equipment
> > > > and
> > > > > for a given job. I setup the links as follows:
> > > > > ?Pm-Customer_history.ncompany = cs_equip.nCompany
> > > > > ?Pm-Customer_history.nsite_equipid = cs_equip.nsite_equipID
> > > > > ?Pm-Customer_history.njobnumber = cs_equip.njobnumer
> > > > >
> > > > > The selection formula (record) on the subreport was left as it was
> > > created
> > > > > by the SubReport Links window.
> > > > >
> > > > >
> > > > > --------------------------------
> > > > > Thx in advance,
> > > > > Dan Tallent
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>