?
Solved

load crystal report from client machine

Posted on 2009-05-04
12
Medium Priority
?
592 Views
Last Modified: 2013-12-17
Hello,

I work for a large organisation and they have tasked me to make a website for the display of there crystal reports. I am not authorized to upload the reports to the server so I must get Crystal Report viewer to read from the clients local machine C:\GISDATA\Reports\....rpt. how can i do this as the app thinks I am referencing a file from the c:\ on the server..???

Thanks
0
Comment
Question by:Small_Balls
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 3
12 Comments
 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 320 total points
ID: 24301713
If it is running on the server, I don't think you can unless you can identify the machine by ip address or name.

Any particular reason you aren't allowed to put the reports on the server?

mlmcc
0
 
LVL 4

Assisted Solution

by:bleach77
bleach77 earned 240 total points
ID: 24301880
I'm not sure about this, but if a client share the files in network, you can try call the report using "\\ip_address\folder\rptfiles"

Or maybe if it will be from only one client, you can set the client to be another server and call it on there.
0
 

Accepted Solution

by:
Small_Balls earned 0 total points
ID: 24302068
mlmcc:
If it is running on the server, I don't think you can unless you can identify the machine by ip address or name.

Any particular reason you aren't allowed to put the reports on the server?

Govt agency! (enough said lol)

bleach77:
I'm not sure about this, but if a client share the files in network, you can try call the report using "\\ip_address\folder\rptfiles"

Or maybe if it will be from only one client, you can set the client to be another server and call it on there

I unless i looks for the ip addess that won't work as it needs to target all that log in for agencies in govt department endless number of possible ips

also refer to this post as covered ground (same post)

http://forums.asp.net/p/1418970/3140580.aspx#3140580
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 4

Assisted Solution

by:bleach77
bleach77 earned 240 total points
ID: 24302155
First of all, a webpage alone can't access (read/write) a client files. enough said.
So you can't put the rpt on clients hard drive neither can you read the rpt from client hard drive.

So what are you trying to accomplish here is not possible.
0
 
LVL 4

Assisted Solution

by:bleach77
bleach77 earned 240 total points
ID: 24302170
My best solution would be for you to setup another server , maybe your computer, and from the main server, it will called the rpt files from your computer.
0
 

Author Comment

by:Small_Balls
ID: 24302336
I don't take not possible as an answer and the cost involed in equipment, time, effort and parts is not an option

to you think this will work??
            string reportPath = (@"C:\GISDATA\Reports\");
            string[] reports = Directory.GetFiles(reportPath, "*.rpt");

Open in new window

0
 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 320 total points
ID: 24304496
I worked for the government for almost 30 years and never had a problem getting permission to put shared files on network drives.

Normally you will have a shared drive that all users have access to for saving files that need to be shared.  You could put the reports on that drive in a special folder and reference them with the full path as
//Server-Name/CrystalFolder/myreport.rpt

Another way to do this would be to embed the reports into the application.  Thus there is no need for the report files.

I see a major issue with putting them on the clients.  Unless a report is used by only 1 user there is a huge update issue when a report is changed to ensure all users have the latest version.  Also if a report file is on a users machine there is the potential that they could change the report.

Have you considered using Crystal Report Server or some similar product to run reports and control access?

mlmcc
0
 

Author Comment

by:Small_Balls
ID: 24304822
Crystal Report Server is in the pipe line but red tape between here and there in the meantime i need to access the report from the client machine as if it was on the server it would not be up to date in a few months and staff do not have access to change them they are distributed to C:\GISDATA\Reports via a network up date.

all I need is a way to tell the server to read from the clients machine and not its own drives and with out             string reportPath = ("http://" + Response.Write(Request.ServerVariables("remote_addr"))+"/GISDATA/Reports/");

0
 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 320 total points
ID: 24305417
Sorry, that is the way the interface is written.  It cannot be done since the applicatiion by default is going to look on the machine it is running on for C:.  You will need to put the name of the machine or the IP in the path.

mlmcc
0
 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 320 total points
ID: 24318859
As stated in the EE Help sometimes the correct answer is it can't be done
http://www.experts-exchange.com/help.jsp?hi=405

WIth that in mind the full points should be awarded to the first 2 comments or perhaps use
http:Q_24302170 - bleach77 since that is the solution you have chosen to pursue.

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 24321915
there is a solution and we have given it to you.

The only way a web application that is running on the server can address a client box is through the fully qualified box name or the ip address for that box.

The other solutions are to use an existing network drive to hold the report files or as you are planning to do add a new server/network store and use it.

mlmcc
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question