Custom SQL Report Rendering Differently On Different Clients

Yahoo Archive
1
I wasn't able to get the Crystal Reports standalone viewer to display
it.



However the Logicity viewer displays it perfectly on the two systems
I've tried it with. I can even create a RRD file in the Logicity tool,
deploy that to the menu as an external program, and if the user has the
viewer installed it displays without any extra work (relying on the
shell's file association logic). If they don't, Vantage tells you that
you don't have an application installed to view the file which seems
like a graceful way to degrade.



I could write a launch script that checks to see if the required
prereqs are installed and tell the user what to do as well.



I think this is a reasonable workaround, but the real question in my
mind is why the Epicor crystal reports viewer fails to render the report
when the Logicity one works fine.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com





[Non-text portions of this message have been removed]
2
I posted this last week as a message about "Custom Reports and
Authentication" but I don't think this is an authentication issue.



I have a custom Crystal report that connects to MSSQL via SQL Native
Client which generates a custom Bill of Materials listing. It has a
main report that calls a stored procedure, and two subreports, one which
just queries Part and PartRev directly for the header information, and
another one which calls a stored procedure to get the list of
attachments for the part.



It renders beautifully on my computer, both from within Crystal
Reports Developer and the runtime in Vantage.



On other clients, it renders partially. In particular the Part
Description in the header is missing on other clients, the logo is
sometimes missing, and the footer subreport showing the attachments is
missing the filenames and sometimes the subreport header. That is to
say, its not as if those subreports aren't rendering, but rather they're
not showing all of their data.



If I print the report from the Crystal viewer in Vantage the output is
similarly missing those fields (although the logo shows at least).



I've updated the CR runtime to the 03/05/2008 version and rebooted on
one of my test clients that is showing the problem. That computer also
has CR XI developer on it and the report similarly looks fine in the CR
tool but renders improperly in the Vantage runtime.



I tried downloading the CR 2008 viewer and showing the report that
way, but it yells at me that I don't have any data saved with the
report. The report is supposed to prompt you for the necessary
parameters to generate the output.



Any ideas? I'm assuming that Epicor support is going to tell me I'm
on my own and I'm feeling like I'm in the weeds with this one.



-brian



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





[Non-text portions of this message have been removed]
3
Can't help you with your problem - sorry - but I do recall reading
that you shouldn't install the runtime on a PC that already has CR XI
on it.


--- In vantage@yahoogroups.com, "Brian W. Spolarich "
<bspolarich@...> wrote:
>
> I posted this last week as a message about "Custom Reports and
> Authentication" but I don't think this is an authentication issue.
>
>
>
> I have a custom Crystal report that connects to MSSQL via SQL
Native
> Client which generates a custom Bill of Materials listing. It has a
> main report that calls a stored procedure, and two subreports, one
which
> just queries Part and PartRev directly for the header information,
and
> another one which calls a stored procedure to get the list of
> attachments for the part.
>
>
>
> It renders beautifully on my computer, both from within Crystal
> Reports Developer and the runtime in Vantage.
>
>
>
> On other clients, it renders partially. In particular the Part
> Description in the header is missing on other clients, the logo is
> sometimes missing, and the footer subreport showing the attachments
is
> missing the filenames and sometimes the subreport header. That is
to
> say, its not as if those subreports aren't rendering, but rather
they're
> not showing all of their data.
>
>
>
> If I print the report from the Crystal viewer in Vantage the
output is
> similarly missing those fields (although the logo shows at least).
>
>
>
> I've updated the CR runtime to the 03/05/2008 version and
rebooted on
> one of my test clients that is showing the problem. That computer
also
> has CR XI developer on it and the report similarly looks fine in
the CR
> tool but renders improperly in the Vantage runtime.
>
>
>
> I tried downloading the CR 2008 viewer and showing the report that
> way, but it yells at me that I don't have any data saved with the
> report. The report is supposed to prompt you for the necessary
> parameters to generate the output.
>
>
>
> Any ideas? I'm assuming that Epicor support is going to tell me
I'm
> on my own and I'm feeling like I'm in the weeds with this one.
>
>
>
> -brian
>
>
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced
Photonix /
> Picometrix
>
> bspolarich@...
> <mailto:bspolarich@...> ~ 734-864-5618 ~
> www.advancedphotonix.com <http://www.advancedphotonix.com>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>