Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Web Controls > Dynamic Crystal Reports

Reply
Thread Tools

Dynamic Crystal Reports

 
 
Andrew
Guest
Posts: n/a
 
      08-12-2004
Hey all,

Been working with the Crystal Report Viewer, and have run into a situation I
am hoping someone can help me get past. This may be more of a CR question,
but hoping for some CR gurus to stop by in here.

Crystal's knowledgebase has made available a bunch of examples for both
ASP.Net and VB.Net applications for download and review (I added the links
at the end of this post). One of the examples is how to pass in a parameter
to the form from the .aspx page so you can alter what is displayed.
However, on closer inspection, you find that the form pulls across a huge
set of records and merely filters out all records not in the group matching
the parameter passed in.

My snag is that I do not want to pull across a huge set of records, rather I
would prefer to use a stored procedure on the SQL Server that accepts a
parameter and returns only those records I want. The records are the same
structure every time, just the content may be different. While the example
shows how to pass in the parameter, I do not know how to set up the form to
utilize not just a Stored Procedure, but rather one that requires a
parameter.

In short: Create an ASP.Net page that displays a Crystal Report whose data
is determined by a parameter passed in to the report and used in a Stored
Procedure tying it to a SQL Server.

Has anyone in here run into this situation and can explain how to deal with
it?

-- Andrew



Crystal Decisions Project Examples:
--------------------------------------------
VB .NET Web Sample Applications
http://support.businessobjects.com/c...amples.exe.asp

VB .NET Windows Sample Applications
http://support.businessobjects.com/c...amples.exe.asp


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems using ASP and Crystal Reports 8.5 to create dynamic PDF reports PughDR@gmail.com ASP General 0 10-23-2006 02:50 PM
Is it possible to get Crystal Reports to print multiple reports in ASP.NET? Rod ASP .Net 2 05-25-2006 02:12 PM
How to launch reports (done with Crystal Reports) from a Java application? minjie@excite.com Java 2 03-15-2006 08:40 PM
First time crystal report user - How do i create a crystal reports from asp.net web form? Learner ASP .Net 1 01-11-2006 08:20 PM
Calling Crystal Reports in ASP.NET using the rptserver.asp given by Crystal Reports Peri ASP .Net 1 07-21-2005 12:56 PM



Advertisments