Rick,
Believe me, I don't know Crystal very well, but having just recently struggled through a subreport with 6.1 myself, possibly I can help.
My first thought is about your formatting of the subreport field. This one still baffles me, but when I was adding a field into the PO form,
I was getting it pretty close and then formatted my field nice & neat so it would fit and all of a sudden - my entire form was blank. I
thought there must be something wrong with my links and re-did it several times. Finally, really not intentionally, I left my formatting until
last and that's what it was. Why formatting that one (new) field would cause my entire form to display a blank page, is beyond me, and the
fact that you mention that when you eliminate your field - the rest displays fine is what causes me to wonder if that could be your issue also.
If not, I do have my notes from how I got it all to work, so unless you get someone else who's much more knowledgeable than I, I could try
to assist.
Julie
Mercury Minnesota Inc.
Believe me, I don't know Crystal very well, but having just recently struggled through a subreport with 6.1 myself, possibly I can help.
My first thought is about your formatting of the subreport field. This one still baffles me, but when I was adding a field into the PO form,
I was getting it pretty close and then formatted my field nice & neat so it would fit and all of a sudden - my entire form was blank. I
thought there must be something wrong with my links and re-did it several times. Finally, really not intentionally, I left my formatting until
last and that's what it was. Why formatting that one (new) field would cause my entire form to display a blank page, is beyond me, and the
fact that you mention that when you eliminate your field - the rest displays fine is what causes me to wonder if that could be your issue also.
If not, I do have my notes from how I got it all to work, so unless you get someone else who's much more knowledgeable than I, I could try
to assist.
Julie
Mercury Minnesota Inc.
----- Original Message -----
From: Richard
To: vantage@yahoogroups.com
Sent: Tuesday, October 05, 2010 10:39 AM
Subject: [Vantage] Re: Customizing Canned Reports in Vantage 6.1
Aimee,
I have to believe the connection is right. If I eliminate the fields from the new table the rest of the sub-report data displays fine. I too had a document from Epicor about adding fields to canned reports but it seems to suppose that the new fields are from tables that are already in the report. Hopefully someone else will have an answer for me. Thanks for your help.
Rick
--- In vantage@yahoogroups.com, "aimee.grebe" <aimee.grebe@...> wrote:
>
> Hmmm...it has been a long time since I had to do it that way. Hopefully someone else running 6.1 can chime in and give you specific steps. Are you sure the ODBC connection is set up correctly? It needs to be set up on the server and the PC you are working on (and eventually on every computer that will run the report). Then you add the subreport to the Traveler Crystal report. Depending on what you are trying to do, you may need to create some variables to pass the values from the subreport back to the main report. Are you seeing any data from the ODBC connection?
>
> Sorry I can't be more specific. I do remember there was a "how to" document that I got from Epicor that I used. I know it's hard to get support from Epicor for 6.1 but that document was surprisingly useful.
>
> Thanks,
> Aimee
> --- In vantage@yahoogroups.com, "Richard" <rgraf@> wrote:
> >
> > Hi Aimee,
> > Thanks Aimee. That's ecxactly what I had to do but I'm still struggling with the table not populating the working database. I went through an entire litany of steps that were supposed to validate the database but nothing changed. Any other ideas?
> > Rick
> >
> > --- In vantage@yahoogroups.com, "aimee.grebe" <aimee.grebe@> wrote:
> > >
> > > If I remember correctly from my 6.1 days....
> > >
> > > If this is a Crystal Report and you are trying to add a field from a new table that is not in the original dataset, you will need to add a subreport using an ODBC connection.
> > >
> > > Thanks,
> > > Aimee
> > >
> > > --- In vantage@yahoogroups.com, "Richard" <rgraf@> wrote:
> > > >
> > > > I need to add fields to a canned report from a VB form in a table not originally part of the canned report. I'm having a ton of problems because the new table isn't part of the working database that's populated when a canned report is run. Please, I need some help with this. The report looks perfect now with this exception and the manager is losing patience with me. He needs the data and I need some advice. Thanks.
> > > >
> > >
> >
>
[Non-text portions of this message have been removed]