Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server ASP
|
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 2nd, 2003, 09:38 AM
ak ak is offline
Authorized User
 
Join Date: Sep 2003
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default benifit of crystal report with asp and sql server

Hi
Can some one tell me the benifits of using crystal report with sql server and asp ?
or examples of where it could be used ?
thanks
AK

ak
__________________
ak
 
Old September 3rd, 2003, 04:09 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

I'm not sure I understand your question, or what you information you are trying to get, but I can give you an example where we implemented a solution using the components you ask about.

The client was an investment management firm, and we produced a client asset performance statement for them using a VB front end, SQL Server for the database, and Crystal Reports as the reporting tool. They mail the statement, produced quarterly and printed on a color laser printer, to their clients.

They wanted the ability for their clients to connect to a web page and request any of their statements on line. We set up some ASP pages which validate the client and obtain parameters indicating which statement they want. We use Crystal on the web server, and the first time a client invokes a report file, Crystal downloads an ActiveX viewer control to the client. The control then renders the selected statement in the client's browser, exactly (almost) duplicating the printed version they receive in the mail.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
 
Old September 4th, 2003, 10:25 AM
ak ak is offline
Authorized User
 
Join Date: Sep 2003
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Jeff,
that gives me an idea.
Akthar

ak
 
Old September 24th, 2003, 12:47 AM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 171
Thanks: 0
Thanked 1 Time in 1 Post
Default

One benefit that I have found using Crystal 9.0, and it's not too difficult to do, is generate PDFs on the fly. It allows me to create documents (contracts, bills of lading) that my users cannot modify. Just print, sign, and send back. Invaluable!

 
Old February 3rd, 2005, 10:55 PM
Authorized User
 
Join Date: Feb 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have been using Crystal Report from version 3. Crystal Reports is a very nice tool for presenting data espacially in the broswer. There are several major advantages when you display data in the broswer over regular HTML.

1, There is no URL in page header and footer when you print the page.
2, You can have page break functionality very easily.
3, Easy to export the report to different format.
4, You can have hyperlink from version 8.5
5, Easy to use and call report from web. (version 8.0 below)

I found it is really hard to call report from web page from version 9.0. I don't know why they make thing so complicated. It doesn't make sence to me.

James Xing
Top-Ink.com
www.top-ink.com
 
Old February 21st, 2005, 12:38 AM
Registered User
 
Join Date: Aug 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Can anyone tell me the pros and cons of using Crystal Reports as opposed to ASP?

Cassandra
 
Old April 4th, 2005, 11:31 PM
Authorized User
 
Join Date: Jan 2005
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to askenkray
Default

Can Anyone Guide as to How to USe CR in ASP????

Ashwin S.Kenkare
Programmer
CMI
 
Old May 2nd, 2005, 06:14 AM
Registered User
 
Join Date: May 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to arif_iq
Default

After seeing your valuable discussion I got few ideas about Crystal Report

Regards
Mohammed Arif
Web Architect
http://www.mohammedarif.com
 
Old June 16th, 2005, 07:33 AM
Registered User
 
Join Date: Jun 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Need help with presenting report in client browser. I am using CR in ASP pages and this works fine on the server and even on my laptop(has CR installed) but not on the workstations of the clients that will be using the application. When they click to view report, they simply get a blank page with [X] on the top left hand corner. Please heeelp!!!
Sh.
 
Old November 24th, 2005, 09:14 PM
Registered User
 
Join Date: Nov 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to donel
Default

Quote:
quote:Originally posted by Shawnie
 Need help with presenting report in client browser. I am using CR in ASP pages and this works fine on the server and even on my laptop(has CR installed) but not on the workstations of the clients that will be using the application. When they click to view report, they simply get a blank page with [X] on the top left hand corner. Please heeelp!!!
Sh.
Hi Shawnie where you able to get a solution regarding this problem.
If yes kindly share it w/ me.






Similar Threads
Thread Thread Starter Forum Replies Last Post
how to call sql server function in crystal report arumugavel Access VBA 0 November 16th, 2006 12:05 AM
Connect Seagate Crystal Report with SQL Server 200 abypvarghese SQL Server 2005 6 June 23rd, 2006 03:10 AM
Using Crystal Report with SQL SERVER deepakbachelor Classic ASP Basics 0 June 23rd, 2006 03:02 AM
Calling Crystal report from BO XI server using ASP raajnselliah Crystal Reports 0 February 6th, 2006 09:31 AM
SQL Server 2000, ASP and Crystal Report quinn SQL Server ASP 0 March 9th, 2004 02:55 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.