Welcome to AspAdvice Sign in | Join | Help

May 2005 - Posts

Updating Crystal Reports .NET if You Change the XSD

Posted Friday, May 27, 2005 7:06 PM by rjdudley
One method of creating Crystal Reports is to use an ADO.NET Dataset (for good advice please read Reporting Off ADO.NET Datasets ). To create the report from a dataset, you have to model the dataset in an XML Schema Document, which has the .XSD extension. Read More...
27 Comments

SQL Server Reporting Services and Crystal Reports: A Competitive Analysis

Posted Thursday, May 26, 2005 11:46 PM by rjdudley
Brian Bischof , author of Crystal Reports .NET Programming , has posted a comparison of SQL Server Reporting Services and Crystal Reports : During 2004, Microsoft grabbed the attention of the Visual Studio .NET community by announcing a new reporting Read More...
4 Comments

Open PDF Outside of Browser

Posted Thursday, May 26, 2005 3:26 PM by rjdudley
This question has passed my threshold of answering as forum posts, so it's going on the blog: Does anyone know how to export a crystal report into a seperate adobe reader instead of embedding the reader into the current browser window? I am successful Read More...
5 Comments

MP3 Driving Directions

Posted Wednesday, May 25, 2005 6:23 PM by rjdudley
IPoding reports on MaP3 , which uses Text-to-Speech to convert driving directions into MP3 files. From Map3's website: MaP3 will give you the best driving route to take between any two addresses in the United States and Canada. While there are other websites Read More...
0 Comments
Filed under:

Thank You Mindsharp!

Posted Tuesday, May 24, 2005 8:48 PM by rjdudley
I received my free SharePoint posters today, and I can only say "Wow! Thanks Mindsharp !". They are detailed and yet still nicely laid out. My mental image of SPS configuration is no longer an endless maze with randomly moving walls (and no cheese). The Read More...
0 Comments
Filed under:

Deciphering Microsoft-ese

Posted Tuesday, May 24, 2005 1:30 AM by rjdudley
We're all familiar with MS's "marketecture", and its coopting of whatever buzzwords are hot in the newspapers at the time of announcement into strange acronyms. Generation X gave us "ActiveX", the Human Genome Project gave us "Windows DNA" (WTF?), and Read More...
0 Comments
Filed under:

Color Picker w/ Colorblindness Settings

Posted Tuesday, May 24, 2005 1:05 AM by rjdudley
On my CAPTCHA Images post, Patrick Santry mentioned he ran into one he couldn't decipher due to his colorblindness. I'm also colorblind, but have yet to hit one I couldn't figure out, and that may be due to luck, or varying degrees of colorblindness. Read More...
0 Comments
Filed under:

Where To Place Example Code for Article 525

Posted Monday, May 23, 2005 10:02 AM by rjdudley
The following question came via private comment in response to CodeSnip: Opening Crystal Reports in a New Window in ASP.NET : Reading your article as a newbie, could you provide me with a little more info of where to place this script. Also I am programming Read More...
0 Comments

Set Number Of Copies When Automatically Printing Crystal Reports .NET

Posted Sunday, May 22, 2005 12:40 PM by rjdudley
These questions were received as a private comment in response to my Automatically Printing Crystal Reports in ASP.NET article: Very useful and interesting article. Thanks a lot. I wanted to use this in a .Net app. Can we determine the number of copies Read More...
1 Comments

Deploying Crystal Reports .NET

Posted Sunday, May 22, 2005 7:56 AM by rjdudley
If you copied your reports files to a production server, and you get this error: File or assembly name CrystalDecisions.Enterprise.Framework, or one of its dependencies, was not found. Chances are, you didn't properly deply the application. There's Read More...
37 Comments

How to programatically check if SSL is enabled

Posted Saturday, May 21, 2005 10:37 PM by rjdudley
I've seen this question a couple times in various forums, so here's what I know. There are a few ways to tell if SSL is enabled. This isn't a comprehensive list, I'm sure--just the ways I know of. If you have another method, please add a comment. Thanks! Read More...
5 Comments
Filed under:

Protect PDF, DOC and other file types with Forms Authentication

Posted Saturday, May 21, 2005 10:27 PM by rjdudley
Forms Authentication is a great methodology to use, but it is limited in what files it secures. The only files that are protected by Forms Authentication are those that are processed by aspnet_isapi.dll. This is limited to file types like ASPX, ASCX, Read More...
13 Comments
Filed under:

Change Paper Size and Orientation in Crystal Reports .NET

Posted Friday, May 20, 2005 9:42 PM by rjdudley
Design tip of the sporadic time interval: If you need to change the size or orientation of a Crystal Report, you can do this in the VS IDE by right-clicking your report and navigating Designer >> Printer Setup. On the first tab, you can choose the Read More...
20 Comments

Visual Studio Goes To Hawaii

Posted Wednesday, May 18, 2005 3:37 PM by rjdudley
For those who just can't wait for the next big thing, I tease you with news of ' Hawaii ', the release of Visual Studio after Orcas. After Yukon, Whidbey, Whistler, etc., it's nice to see MS aim for warmer climates. I'm really more intersted in what will Read More...
0 Comments
Filed under:

Before You Recycle That IIS Process

Posted Wednesday, May 18, 2005 1:50 PM by rjdudley
Manually recycling the IIS process is unfortunately sometimes a fact of life. This can be a really disruptive action if you have a number of users logged on, and you use InProc session state. Before you go recycling the process, check out a little tool Read More...
2 Comments
Filed under:

Crystal Reports .NET Error: "Load Report Failed"

Posted Wednesday, May 18, 2005 1:18 PM by rjdudley
Days like today make me glad I have a commute long enough to consume copious quantities of caffeine before I walk in the door at work. Today I was greeted with the news our reporting site was down. The error being thrown was “Load Report Failed” Read More...
98 Comments

Koders.com now live

Posted Wednesday, May 18, 2005 12:58 PM by rjdudley
I'm a little behind on my blogging, to say the least. Anyhow, last November I found out about Koders.com , an open source code search engine. Basically, Koders.com has indexed the actual code on SourceForge and other repositories, and you can search for Read More...
0 Comments
Filed under:

"Query Engine Error" With Crystal Reports .NET

Posted Friday, May 13, 2005 5:03 PM by rjdudley
There are two main reasons this error is thrown when using the PUSH (dataset) method of getting data to a Crystal Report. 1) The schema of the datatable differs from what the report was designed from. This can be either a different field name, or a missing Read More...
63 Comments

Free SharePoint Posters

Posted Friday, May 13, 2005 10:21 AM by rjdudley
Mindsharp is offering as set of SharePoint posters free if you register at their site . There are three posters in the set: Windows SharePoint Services Object Model Poster The Windows SharePoint Services (WSS) object model consists of eighteen namespaces Read More...
1 Comments
Filed under:

Window.print and Dot Matrix Printers?

Posted Monday, May 09, 2005 11:47 AM by rjdudley
I received this comment to Automatically Printing Crystal Reports in ASP.NET will window.print command of javascript work with dot matrix printer?pls reply asap. I imagine it would if the proper drivers are installed. The JavaScript command only calls Read More...
5 Comments

Incorrect syntax near '.'

Posted Wednesday, May 04, 2005 3:14 PM by rjdudley
We're working on tuning some index rebuilds, and I found a great DBCC INDEXDEFRAG Stored Procedure from Tara Duggan that's a great help. I modified the sproc to use the DBCC DBREINDEX statement. Part of the plan is to store this sproc in a control database, Read More...
0 Comments
Filed under: