Peter's Gekko

Sponsors

The Lounge

Wicked Cool Jobs

Syndication

Recent Posts

Tags

View more

News

Links

Archives

Advertisement

Peter's Gekko » Crystal reports roundup
Images in this post missing? We recently lost them in a site migration. We're working to restore these as you read this. Should you need an image in an emergency, please contact us at imagehelp@codebetter.com
Crystal reports roundup

Getting Crystal Reports to work on a webserver is a bumpy road. Solving parts of the puzzle is usualy worth a (well read) blog post Here's a roundup of my main problems with Crystal :

Peter

Posted Tue, Feb 24 2004 6:18 PM by pvanooijen

[Advertisement]

Comments

Enjoy Every Sandwich wrote Take Outs: The Digital Doggy Bag of Blog Bits for 24 February 2004
on Tue, Feb 24 2004 1:09 PM
Take Outs: The Digital Doggy Bag of Blog Bits for 24 February 2004
Shaheen wrote re: Crystal reports roundup
on Fri, Apr 2 2004 3:23 PM
i am still working on it
John wrote re: Crystal reports roundup
on Mon, Apr 5 2004 2:56 PM
I just got an email about a new reporting product called XtraReports - it seems to do web deployment.
Peter van Ooijen wrote re: Crystal reports roundup
on Tue, Apr 6 2004 2:01 AM
He John ! Or should I say Developper Express ? This is an ad, not a comment. I know DevExpress as a companay with some very good people working there. But I'm not sure about this "comment". Should I delete it ?
Peter's Gekko wrote Merging webapps. Moving (typed) Crystal reports from one application to another.
on Mon, Jun 7 2004 10:16 PM
Merging webapps. Moving (typed) Crystal reports from one application to another.
Peter's Gekko wrote Grown up in public: 2 years of blogging
on Fri, Jun 3 2005 12:47 AM
 Today is a celebration. Exactly two years ago my first blog-post showed up on the dotnetjunkies....
Peter's Gekko wrote Web reporting tools: get rid of Crystal and yourself a life
on Thu, Jul 21 2005 1:49 AM
Having used both Crystal Reports (CR) and SQL Reporting Services (RS) for a web-app I'm fully convinced....
Peter's Gekko wrote Web reporting tools: get rid of Crystal and yourself a life
on Thu, Jul 21 2005 2:09 AM
Having used both Crystal Reports (CR) and SQL Reporting Services (RS) for a web-app I'm fully convinced....
Peter's Gekko wrote Web reporting tools: get rid of Crystal and get yourself a life
on Thu, Jul 21 2005 5:51 AM
Having used both Crystal Reports (CR) and SQL Reporting Services
(RS) for a web-app I'm fully convinced....
Peter's Gekko wrote Using SQL reporting services in an asp.net application with some notes on
on Tue, Nov 15 2005 6:49 AM
In the Crystal days adding reports to an asp.net application could give you quite a hard time. Having ...
Peter's Gekko wrote Using SQL reporting services in an asp.net application with some notes on
on Tue, Nov 15 2005 6:49 AM
In the Crystal days adding reports to an asp.net application could give you quite a hard time. Having ...
Peter's Gekko wrote Using SQL reporting services in an asp.net application with some notes on
on Tue, Nov 15 2005 8:12 AM
In the Crystal days adding reports to an asp.net application could give you quite a hard time. Having ...
Peter's Gekko wrote Using SQL reporting services in an asp.net application with some notes on report parameters
on Tue, Nov 15 2005 8:58 AM
In the Crystal days adding reports to an asp.net application could give you quite a hard time. Having ...
Peter's Gekko wrote Using SQL reporting services in an asp.net application with some notes on report parameters
on Sun, Jan 1 2006 4:44 AM
In the Crystal days adding reports to an asp.net application could give you quite a hard time. Having ...
Peter's Gekko wrote Using SQL reporting services in an asp.net application with some notes on report parameters
on Sun, Jan 1 2006 4:44 AM
In the Crystal days adding reports to an asp.net application could give you quite a hard time. Having ...
ronak wrote re: Crystal reports roundup
on Sat, May 20 2006 11:47 AM
hi ! my application with crystal report is working very fine on my machine but when we install it on custmer's machine it is giving some error of JIT, what is that , i am running my application on client machine through .exe file !! what to do please do needful i hav to submitt it to client!
pvanooijen wrote re: Crystal reports roundup
on Sun, May 21 2006 4:57 AM
@ronak. Does your client have (the right version !) of CR installed ?
I'm afraid it's to late to advise you to switch to Reporting services :?
Davion wrote re: Crystal reports roundup
on Mon, Jul 24 2006 1:55 PM
I have a problem with my crystalreportviewer. Whenever i put date parameters that very long for instance a month or a year it displays page cannot be found after a while, but i if the date parameters are short it displays the report. the reports are access data from databases. Can you help?

Davion
pvanooijen wrote re: Crystal reports roundup
on Mon, Jul 24 2006 3:55 PM
Check the parameters of your SQL query ?
victor wrote re: Crystal reports roundup
on Wed, Sep 27 2006 3:18 PM

When I click on the three links in Crystal reports roundup post, I get Page Not Found :(

pvanooijen wrote re: Crystal reports roundup
on Thu, Sep 28 2006 3:01 AM

Links have been fixed. Thanks for reporting.

GURDEEP wrote re: Crystal reports roundup
on Sun, Jun 1 2008 7:40 PM

Hi I am using VS 2005 & SQL Server 2005 for developing my windows Application.

Its the combination of C# & VB.net... Everything works fine except crystal reports.

Actually I start developing this app on my laptop, Where the crystal Reports were working fine... When I install the app along with Crystal reports Redistribution X86.. The form which contains cyrstal report open but not able to Load the report... It Always promot for Server, Database, UID & Password on each client machine.

Intersetigly The servername Field is readonly and its still My Laptop Name Where I Orignally Develop this App.

I follow all Tutorials form all over the web Including Business Objects But NO LUCK

I have the report designed using usuall wizard & ADO.net connection for SQL server

Here is the code I am using

----------------------------------------------------------

Dim myTable As CrystalDecisions.CrystalReports.Engine.Table

       Dim myLogin As CrystalDecisions.Shared.TableLogOnInfo

       Dim crTableLogonInfos As TableLogOnInfos = New TableLogOnInfos()

       Dim crpt As crManifest

       crpt = New crManifest()

       For Each myTable In crpt.Database.Tables

           myLogin = myTable.LogOnInfo

           myLogin.ConnectionInfo.Password = My.Settings.Sql_Password

           myLogin.ConnectionInfo.UserID = My.Settings.Sql_User_Name

           myLogin.ConnectionInfo.DatabaseName = My.Settings.Sql_Database

           myLogin.ConnectionInfo.ServerName = My.Settings.Sql_Server_Name

           myTable.ApplyLogOnInfo(myLogin)

           crTableLogonInfos.Add(myLogin)

           myTable.Location = My.Settings.Sql_Database & ".dbo." & myTable.Location.Substring(myTable.Location.LastIndexOf(".") + 1)

       Next

       CRVMain.LogOnInfo.Clear()

       CRVMain.LogOnInfo = crTableLogonInfos

       CRVMain.ReportSource = crpt

-------------------------------------------------------------

I Tried to take out the lines such as

myTable.ApplyLogOnInfo(myLogin)

           crTableLogonInfos.Add(myLogin)

           myTable.Location = My.Settings.Sql_Database & ".dbo." & myTable.Location.Substring(myTable.Location.LastIndexOf(".") + 1)

BUT THERE ARE STILL ERRORS

I simply want that  report shoud run smooth without any login prompt & Fast data Load.... STILL IN MY DREAMS...

Can Anyone provide HELP???????????????

Add a Comment

(required)  
(optional)
(required)  
Remember Me?
Devlicio.us