Monday, March 26, 2012

Problems with Select Distinct on certain PCs

I have a report that showed the same on all PCs, but the data was not showing in the way that I needed. I changed the report by checking the "select distinct" checkbox and this corrected the way the data looked. I saved the report and copied it down to the users. Now, for about half of the users, the data shows the new way (the preferred way), but the other half of the users are still seeing the data as if the "select distinct" was never done.

I have hand-copied the new .rpt file down, and changed the title at the top, just so I know they are getting the new copy, but the data is still wrong.

Any ideas?

thanks.Well, what's between the report and the data?? ODBC??
Have you got different ODBC connections defined for the different PCs?
Maybe different versions of the ODBC driver?
Maybe, as we have at my current gig, the same basic driver but users can configure their connections (to our AS400) to operate in different ways, which will change the way the data is chewed up and spat out at the CR end.......:-)

Are you using a VB program or some other utility to generate the reports, or is each user running an instance of the CR Deveopment Environment? (Because that is sure to screw things up).

You really need to have an SOE (Standard Operating Environment) defined for these PCs.

Dave

No comments:

Post a Comment