PO release only printing for first line item - (Vantage 6.1, Win

Yahoo Archive
1
I am wondering what has changed, or is this a new modification to the PO form? New update to Windows? Did you say that it is happening on all PC's or just
a few of them? A couple of weeks ago I had an update to an anti-virus software on a client PC that caused a huge issue, so just trying to narrow down what changed
to help resolve it.
Anyway, Good Luck!
Julie


----- Original Message -----
From: b_ordway
To: vantage@yahoogroups.com
Sent: Wednesday, April 25, 2012 10:12 AM
Subject: [Vantage] Re: PO release only printing for first line item - (Vantage 6.1, Windows 7)



Your problem does sound pretty strange.
I've had link issues but nothing like what you describe.

Anyway...
Have you tried turning off Automataic Smart Linking in Crystal and removing, rejoining the tables?

--- In vantage@yahoogroups.com, "James" <jokeefe@...> wrote:
>
> Thanks Julie,
> Unfortunately it isn't an ODBC configuration issue. The clients are connecting fine. It is just not joining the tables properly. I have ran the Left Outer Join registry fix on the PCs, but they still aren't linking the tables correctly when the report is built. I can see that the data is there, but it just doesn't pull it in correctly. ugh!!!
>
> James
>
> --- In vantage@yahoogroups.com, "Julie Lehmann" <jlehmann@> wrote:
> >
> > James,
> > I did have this issue when I modified our PO's with a Crystal subreport. I had to connect my clients using ODBC in order to get all of the details to display and print.
> > I still have the instructions on how to do that, if you'd like to see them.
> >
> > Julie
> > Mercury Minnesota Inc.
> >
> >
> > ----- Original Message -----
> > From: James
> > To: vantage@yahoogroups.com
> > Sent: Monday, April 23, 2012 6:12 PM
> > Subject: [Vantage] PO release only printing for first line item - (Vantage 6.1, Windows 7)
> >
> >
> >
> > I have a good one here. I have a couple PCs that print Purchase Orders that only show releases for the first item. The releases on any other items do not print. I have narrowed it down to the POREL table not being linked correctly or something along those lines. The data is in the local copy of the POREL table that is created during the print, but for some reason the table is only being linked to the first item.
> >
> > I discovered that I had the problem on my PC. By uninstalling Crystal Reports 8.5 the problem went away. The other PCs don't have CR installed, so I cant fix them by removing it. I think it has to do with an ODBC driver version or something along those lines.
> >
> > I have been trying to find anything on my now working PC, that doesn't match the ones that aren't working, but I have yet to find a culprit.
> >
> > Has anyone seen anything like this?
> >
> > Thanks,
> > James
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>





[Non-text portions of this message have been removed]
2
I have a good one here. I have a couple PCs that print Purchase Orders that only show releases for the first item. The releases on any other items do not print. I have narrowed it down to the POREL table not being linked correctly or something along those lines. The data is in the local copy of the POREL table that is created during the print, but for some reason the table is only being linked to the first item.

I discovered that I had the problem on my PC. By uninstalling Crystal Reports 8.5 the problem went away. The other PCs don't have CR installed, so I cant fix them by removing it. I think it has to do with an ODBC driver version or something along those lines.

I have been trying to find anything on my now working PC, that doesn't match the ones that aren't working, but I have yet to find a culprit.

Has anyone seen anything like this?

Thanks,
James
3
James,
I did have this issue when I modified our PO's with a Crystal subreport. I had to connect my clients using ODBC in order to get all of the details to display and print.
I still have the instructions on how to do that, if you'd like to see them.

Julie
Mercury Minnesota Inc.


----- Original Message -----
From: James
To: vantage@yahoogroups.com
Sent: Monday, April 23, 2012 6:12 PM
Subject: [Vantage] PO release only printing for first line item - (Vantage 6.1, Windows 7)



I have a good one here. I have a couple PCs that print Purchase Orders that only show releases for the first item. The releases on any other items do not print. I have narrowed it down to the POREL table not being linked correctly or something along those lines. The data is in the local copy of the POREL table that is created during the print, but for some reason the table is only being linked to the first item.

I discovered that I had the problem on my PC. By uninstalling Crystal Reports 8.5 the problem went away. The other PCs don't have CR installed, so I cant fix them by removing it. I think it has to do with an ODBC driver version or something along those lines.

I have been trying to find anything on my now working PC, that doesn't match the ones that aren't working, but I have yet to find a culprit.

Has anyone seen anything like this?

Thanks,
James





[Non-text portions of this message have been removed]
4
Thanks Julie,
Unfortunately it isn't an ODBC configuration issue. The clients are connecting fine. It is just not joining the tables properly. I have ran the Left Outer Join registry fix on the PCs, but they still aren't linking the tables correctly when the report is built. I can see that the data is there, but it just doesn't pull it in correctly. ugh!!!

James

--- In vantage@yahoogroups.com, "Julie Lehmann" <jlehmann@...> wrote:
>
> James,
> I did have this issue when I modified our PO's with a Crystal subreport. I had to connect my clients using ODBC in order to get all of the details to display and print.
> I still have the instructions on how to do that, if you'd like to see them.
>
> Julie
> Mercury Minnesota Inc.
>
>
> ----- Original Message -----
> From: James
> To: vantage@yahoogroups.com
> Sent: Monday, April 23, 2012 6:12 PM
> Subject: [Vantage] PO release only printing for first line item - (Vantage 6.1, Windows 7)
>
>
>
> I have a good one here. I have a couple PCs that print Purchase Orders that only show releases for the first item. The releases on any other items do not print. I have narrowed it down to the POREL table not being linked correctly or something along those lines. The data is in the local copy of the POREL table that is created during the print, but for some reason the table is only being linked to the first item.
>
> I discovered that I had the problem on my PC. By uninstalling Crystal Reports 8.5 the problem went away. The other PCs don't have CR installed, so I cant fix them by removing it. I think it has to do with an ODBC driver version or something along those lines.
>
> I have been trying to find anything on my now working PC, that doesn't match the ones that aren't working, but I have yet to find a culprit.
>
> Has anyone seen anything like this?
>
> Thanks,
> James
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Your problem does sound pretty strange.
I've had link issues but nothing like what you describe.

Anyway...
Have you tried turning off Automataic Smart Linking in Crystal and removing, rejoining the tables?

--- In vantage@yahoogroups.com, "James" <jokeefe@...> wrote:
>
> Thanks Julie,
> Unfortunately it isn't an ODBC configuration issue. The clients are connecting fine. It is just not joining the tables properly. I have ran the Left Outer Join registry fix on the PCs, but they still aren't linking the tables correctly when the report is built. I can see that the data is there, but it just doesn't pull it in correctly. ugh!!!
>
> James
>
> --- In vantage@yahoogroups.com, "Julie Lehmann" <jlehmann@> wrote:
> >
> > James,
> > I did have this issue when I modified our PO's with a Crystal subreport. I had to connect my clients using ODBC in order to get all of the details to display and print.
> > I still have the instructions on how to do that, if you'd like to see them.
> >
> > Julie
> > Mercury Minnesota Inc.
> >
> >
> > ----- Original Message -----
> > From: James
> > To: vantage@yahoogroups.com
> > Sent: Monday, April 23, 2012 6:12 PM
> > Subject: [Vantage] PO release only printing for first line item - (Vantage 6.1, Windows 7)
> >
> >
> >
> > I have a good one here. I have a couple PCs that print Purchase Orders that only show releases for the first item. The releases on any other items do not print. I have narrowed it down to the POREL table not being linked correctly or something along those lines. The data is in the local copy of the POREL table that is created during the print, but for some reason the table is only being linked to the first item.
> >
> > I discovered that I had the problem on my PC. By uninstalling Crystal Reports 8.5 the problem went away. The other PCs don't have CR installed, so I cant fix them by removing it. I think it has to do with an ODBC driver version or something along those lines.
> >
> > I have been trying to find anything on my now working PC, that doesn't match the ones that aren't working, but I have yet to find a culprit.
> >
> > Has anyone seen anything like this?
> >
> > Thanks,
> > James
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>