Reports hyperlinking to Part Drawings, etc

Yahoo Archive
1
Michael,

Adding "file://" before the path allows the hyperlink to work in
Crystal Enterprise. Good call there. It does still open in a
browser rather than lauching the program. Since I'm not actually
working on a use for this at the moment I'm going to leave it there.
We haven't heard back from Jim, who posed the original question, on
any of the feedback to know which direction he is heading or what
further assitance he may need.

Thanks for the help with the HTML.

Brian


--- In vantage@yahoogroups.com, "Podlin, Michael"
<michael.podlin@v...> wrote:
> Because its defined in the report as a hyperlink, crystal is adding
the
> default "http://path" reference. In order to make it work as a
file, the
> HTML reference should really be set to "file://path".
>
> The fact that it opens in the browser and not the application, is
due to the
> browser you are using at the time and how it is designed to
handle "file://"
> links. MS IE tries to find an extension association in the
registry of the
> pc and then launch that application in a browser format.
>
> I ran across this whole problem here with the additional issue of
not
> knowing the extension of the file. The only possible way I found
around
> this was to use visual basic to read a directory structure using
wild cards.
> If it found something I could then read the extension from the
directory
> dump. Then search the pc registry for a exe association for that
extenstion
> and execute the application and loading that file. I believe it
would be
> possible using the browser OCX/DLL control in your own application
and
> trapping the "before navigate" to read the url and if it was a file
> attachment, read the registry and find the associated app to launch
the
> program and load the file.
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Wednesday, September 29, 2004 8:18 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Reports hyperlinking to Part Drawings, etc.
>
>
> Yesterday afternoon I tried running my test report through our
> Crystal Enterprise to test distribution. The report ran fine, but
> when I clicked on the hyperlink the browser address changed to
> http://servername/virtualdirectoryname/The Path the hyperlink was
set
> for.
>
> For some reason the server name and virtual directory name are
being
> added to the beginning of the hyperlink address and thus I receive
a
> Page cannot be found error. If I remove the extra from the
beginning
> of the address manually, the browser does open the document I
wanted,
> although it opens it in a browser and not the program it was opened
> with in design mode. So I don't know how you'd get Excel to open.
>
> Does anyone have any experience using Hyperlinks in Crystal Reports
> with Crystal Enterprise? Any ideas why clicking the Hyperlink
would
> cause the Server Name and Virtual Directory name to be added to the
> path?
>
> Jim, what is your distribution method for Crystal Reports?
>
> As an alternative to Crystal, you might trying doing it in Access.
I
> tried a quick test and if you create a hyperlink field in a table
> along with the rest of the data you want, you can set up a form,
> (hyperlinks don't work in Access Reports), to view the data, then
> clicking on the hyperlink will open the appropriate file in Excel.
>
> Brian Stenglein
> Clow Stamping Co.
>
> --- In vantage@yahoogroups.com, "Brian Stenglein" <bstenglein@c...>
> wrote:
> > Jim,
> >
> > Sounded like an interesting problem so I did a quick and simple
> test
> > to see if I could do anything with hyperlinks in Crystal. I have
> > digital photo's of our parts in a network folder that I used as
the
> > destination for the hyperlink. I created a simple report listing
> the
> > PN's and created a formula field to turn the PN into the correct
> > path. "f:\photos\"+[PN]+".jpg" My path was simpler than yours
> will
> > be, but you should be able to turn your PN into a string that
> > identifies the location of your file. Let me know if you need
help
> > with that. Then you can go into the Format Editor for the PN
> field,
> > click on the hyperlink tab, choose file, and for the hyperlink
> > information, click the formula button to the right. Insert the
> name
> > of the formula you used to identify the location, don't forget
the
> > file extension, and then run your report. Clicking on the PN
> should
> > open your file. I've only tested this in the Crystal Designer,
and
> > not with any distribution method.
> >
> > Brian Stenglein
> > Clow Stamping Co.
> >
> > --- In vantage@yahoogroups.com, "Jim Horton" <jim.horton@m...>
> wrote:
> > >
> > > Has anyone successfully linked a Crystal or Progress Report to
a
> > procedure which can identify a
> > > specific filename... based on a current field referenced by the
> > current
> > > table in the Report? I'd love to discuss details with you if
> > possible.
> > >
> > > We would like to have a Report which does the following:
> > >
> > > 1. From the Report screen, with PartNum "2602m12" selected,
> > > 2. Click the "hyperlinked" PartNum 2602m12.
> > > 3. Which finds folder "2600" them subfolder "2602" then
retrieves
> > the "2602m12.xls" file from the server and opens it in Excel.
> > >
> > > Does anyone know or have an example of a Crystal or Progress
> > procedure would do such a thing?
> > >
> > > Jim Horton
> > > Mol-Son, Inc.
> > > jim.horton@m...
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
2
Has anyone successfully linked a Crystal or Progress Report to a procedure which can identify a
specific filename... based on a current field referenced by the current
table in the Report? I'd love to discuss details with you if possible.

We would like to have a Report which does the following:

1. From the Report screen, with PartNum "2602m12" selected,
2. Click the "hyperlinked" PartNum 2602m12.
3. Which finds folder "2600" them subfolder "2602" then retrieves the "2602m12.xls" file from the server and opens it in Excel.

Does anyone know or have an example of a Crystal or Progress procedure would do such a thing?

Jim Horton
Mol-Son, Inc.
jim.horton@...
3
Not sure about Crystal, but the report screen in Report Builder is basically
a text view (hyperlinks will not work while viewing the report). I have
however created reports in Report Builder that generate webpages using HTML
tags. These reports are then automatically run and update themselves on the
Intranet site, these can and do contain hyperlinks to other links and such
to other information. I've also created/imbedded a web browser OCX/DLL
control into a Progress program. I use this to launch ASP pages from
VBForms which then link to other resources and databases using variables
pulled from the Vantage VBForm/current table record. One of the main
functions is to pull the specific operation documents (from the list of all
documents associated to the job) and either view on the screen or send them
to the local printer. Another example is from the job in Vantage, we can
call up and view all tooling transactions pulled from the tooling vending
machine against that job number.

-----Original Message-----
From: Jim Horton [mailto:jim.horton@...]
Sent: Monday, September 27, 2004 9:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Reports hyperlinking to Part Drawings, etc.



Has anyone successfully linked a Crystal or Progress Report to a procedure
which can identify a
specific filename... based on a current field referenced by the current
table in the Report? I'd love to discuss details with you if possible.

We would like to have a Report which does the following:

1. From the Report screen, with PartNum "2602m12" selected,
2. Click the "hyperlinked" PartNum 2602m12.
3. Which finds folder "2600" them subfolder "2602" then retrieves the
"2602m12.xls" file from the server and opens it in Excel.

Does anyone know or have an example of a Crystal or Progress procedure would
do such a thing?

Jim Horton
Mol-Son, Inc.
jim.horton@...
4
Jim,
I did similar in a VB Form with a button. From Part Tracker, you click
a button and it brings up Internet explorer and goes to a specific web
address based on the part number and the contents of a VB field.
Granted this is not a report, but it is a progress procedure that might
fit into what you are trying to do.
Let me know if you would like more info.
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: Jim Horton [mailto:jim.horton@...]
Sent: Monday, September 27, 2004 10:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Reports hyperlinking to Part Drawings, etc.



Has anyone successfully linked a Crystal or Progress Report to a
procedure which can identify a
specific filename... based on a current field referenced by the
current
table in the Report? I'd love to discuss details with you if
possible.

We would like to have a Report which does the following:

1. From the Report screen, with PartNum "2602m12" selected,
2. Click the "hyperlinked" PartNum 2602m12.
3. Which finds folder "2600" them subfolder "2602" then
retrieves the "2602m12.xls" file from the server and opens it in Excel.

Does anyone know or have an example of a Crystal or Progress
procedure would do such a thing?

Jim Horton
Mol-Son, Inc.
jim.horton@...


Useful links for the Yahoo!Groups Vantage Board are: ( Note:
You must have already linked your email address to a yahoo id to enable
access. )
(1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129geeop0/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1096381807/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com>

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=105780498>


________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
5
Jim,

Sounded like an interesting problem so I did a quick and simple test
to see if I could do anything with hyperlinks in Crystal. I have
digital photo's of our parts in a network folder that I used as the
destination for the hyperlink. I created a simple report listing the
PN's and created a formula field to turn the PN into the correct
path. "f:\photos\"+[PN]+".jpg" My path was simpler than yours will
be, but you should be able to turn your PN into a string that
identifies the location of your file. Let me know if you need help
with that. Then you can go into the Format Editor for the PN field,
click on the hyperlink tab, choose file, and for the hyperlink
information, click the formula button to the right. Insert the name
of the formula you used to identify the location, don't forget the
file extension, and then run your report. Clicking on the PN should
open your file. I've only tested this in the Crystal Designer, and
not with any distribution method.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "Jim Horton" <jim.horton@m...> wrote:
>
> Has anyone successfully linked a Crystal or Progress Report to a
procedure which can identify a
> specific filename... based on a current field referenced by the
current
> table in the Report? I'd love to discuss details with you if
possible.
>
> We would like to have a Report which does the following:
>
> 1. From the Report screen, with PartNum "2602m12" selected,
> 2. Click the "hyperlinked" PartNum 2602m12.
> 3. Which finds folder "2600" them subfolder "2602" then retrieves
the "2602m12.xls" file from the server and opens it in Excel.
>
> Does anyone know or have an example of a Crystal or Progress
procedure would do such a thing?
>
> Jim Horton
> Mol-Son, Inc.
> jim.horton@m...
6
Yesterday afternoon I tried running my test report through our
Crystal Enterprise to test distribution. The report ran fine, but
when I clicked on the hyperlink the browser address changed to
http://servername/virtualdirectoryname/The Path the hyperlink was set
for.

For some reason the server name and virtual directory name are being
added to the beginning of the hyperlink address and thus I receive a
Page cannot be found error. If I remove the extra from the beginning
of the address manually, the browser does open the document I wanted,
although it opens it in a browser and not the program it was opened
with in design mode. So I don't know how you'd get Excel to open.

Does anyone have any experience using Hyperlinks in Crystal Reports
with Crystal Enterprise? Any ideas why clicking the Hyperlink would
cause the Server Name and Virtual Directory name to be added to the
path?

Jim, what is your distribution method for Crystal Reports?

As an alternative to Crystal, you might trying doing it in Access. I
tried a quick test and if you create a hyperlink field in a table
along with the rest of the data you want, you can set up a form,
(hyperlinks don't work in Access Reports), to view the data, then
clicking on the hyperlink will open the appropriate file in Excel.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "Brian Stenglein" <bstenglein@c...>
wrote:
> Jim,
>
> Sounded like an interesting problem so I did a quick and simple
test
> to see if I could do anything with hyperlinks in Crystal. I have
> digital photo's of our parts in a network folder that I used as the
> destination for the hyperlink. I created a simple report listing
the
> PN's and created a formula field to turn the PN into the correct
> path. "f:\photos\"+[PN]+".jpg" My path was simpler than yours
will
> be, but you should be able to turn your PN into a string that
> identifies the location of your file. Let me know if you need help
> with that. Then you can go into the Format Editor for the PN
field,
> click on the hyperlink tab, choose file, and for the hyperlink
> information, click the formula button to the right. Insert the
name
> of the formula you used to identify the location, don't forget the
> file extension, and then run your report. Clicking on the PN
should
> open your file. I've only tested this in the Crystal Designer, and
> not with any distribution method.
>
> Brian Stenglein
> Clow Stamping Co.
>
> --- In vantage@yahoogroups.com, "Jim Horton" <jim.horton@m...>
wrote:
> >
> > Has anyone successfully linked a Crystal or Progress Report to a
> procedure which can identify a
> > specific filename... based on a current field referenced by the
> current
> > table in the Report? I'd love to discuss details with you if
> possible.
> >
> > We would like to have a Report which does the following:
> >
> > 1. From the Report screen, with PartNum "2602m12" selected,
> > 2. Click the "hyperlinked" PartNum 2602m12.
> > 3. Which finds folder "2600" them subfolder "2602" then retrieves
> the "2602m12.xls" file from the server and opens it in Excel.
> >
> > Does anyone know or have an example of a Crystal or Progress
> procedure would do such a thing?
> >
> > Jim Horton
> > Mol-Son, Inc.
> > jim.horton@m...
7
Because its defined in the report as a hyperlink, crystal is adding the
default "http://path" reference. In order to make it work as a file, the
HTML reference should really be set to "file://path".

The fact that it opens in the browser and not the application, is due to the
browser you are using at the time and how it is designed to handle "file://"
links. MS IE tries to find an extension association in the registry of the
pc and then launch that application in a browser format.

I ran across this whole problem here with the additional issue of not
knowing the extension of the file. The only possible way I found around
this was to use visual basic to read a directory structure using wild cards.
If it found something I could then read the extension from the directory
dump. Then search the pc registry for a exe association for that extenstion
and execute the application and loading that file. I believe it would be
possible using the browser OCX/DLL control in your own application and
trapping the "before navigate" to read the url and if it was a file
attachment, read the registry and find the associated app to launch the
program and load the file.

-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Wednesday, September 29, 2004 8:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Reports hyperlinking to Part Drawings, etc.


Yesterday afternoon I tried running my test report through our
Crystal Enterprise to test distribution. The report ran fine, but
when I clicked on the hyperlink the browser address changed to
http://servername/virtualdirectoryname/The Path the hyperlink was set
for.

For some reason the server name and virtual directory name are being
added to the beginning of the hyperlink address and thus I receive a
Page cannot be found error. If I remove the extra from the beginning
of the address manually, the browser does open the document I wanted,
although it opens it in a browser and not the program it was opened
with in design mode. So I don't know how you'd get Excel to open.

Does anyone have any experience using Hyperlinks in Crystal Reports
with Crystal Enterprise? Any ideas why clicking the Hyperlink would
cause the Server Name and Virtual Directory name to be added to the
path?

Jim, what is your distribution method for Crystal Reports?

As an alternative to Crystal, you might trying doing it in Access. I
tried a quick test and if you create a hyperlink field in a table
along with the rest of the data you want, you can set up a form,
(hyperlinks don't work in Access Reports), to view the data, then
clicking on the hyperlink will open the appropriate file in Excel.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "Brian Stenglein" <bstenglein@c...>
wrote:
> Jim,
>
> Sounded like an interesting problem so I did a quick and simple
test
> to see if I could do anything with hyperlinks in Crystal. I have
> digital photo's of our parts in a network folder that I used as the
> destination for the hyperlink. I created a simple report listing
the
> PN's and created a formula field to turn the PN into the correct
> path. "f:\photos\"+[PN]+".jpg" My path was simpler than yours
will
> be, but you should be able to turn your PN into a string that
> identifies the location of your file. Let me know if you need help
> with that. Then you can go into the Format Editor for the PN
field,
> click on the hyperlink tab, choose file, and for the hyperlink
> information, click the formula button to the right. Insert the
name
> of the formula you used to identify the location, don't forget the
> file extension, and then run your report. Clicking on the PN
should
> open your file. I've only tested this in the Crystal Designer, and
> not with any distribution method.
>
> Brian Stenglein
> Clow Stamping Co.
>
> --- In vantage@yahoogroups.com, "Jim Horton" <jim.horton@m...>
wrote:
> >
> > Has anyone successfully linked a Crystal or Progress Report to a
> procedure which can identify a
> > specific filename... based on a current field referenced by the
> current
> > table in the Report? I'd love to discuss details with you if
> possible.
> >
> > We would like to have a Report which does the following:
> >
> > 1. From the Report screen, with PartNum "2602m12" selected,
> > 2. Click the "hyperlinked" PartNum 2602m12.
> > 3. Which finds folder "2600" them subfolder "2602" then retrieves
> the "2602m12.xls" file from the server and opens it in Excel.
> >
> > Does anyone know or have an example of a Crystal or Progress
> procedure would do such a thing?
> >
> > Jim Horton
> > Mol-Son, Inc.
> > jim.horton@m...




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links