Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
|
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports 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 January 21st, 2004, 08:54 AM
Registered User
 
Join Date: Jan 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default reports with parameters

I am trying to make a report with parameters. I have added the parameter fields and the formula fields but I still do not see the parameters when loading the report. Does anyone have any ideas?

 
Old January 21st, 2004, 12:26 PM
Authorized User
 
Join Date: Dec 2003
Posts: 81
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Typically the report gets its paramaters from a query...set up a paramater query and then construct your report off of the query...when you open the report the query will prompt for the designated paramaters.

Let me know if this helps and if you need additional input

John

 
Old January 22nd, 2004, 09:43 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default

there r many articles, & questions about this mather in this forum! read them!

Always:),
Hovik Melkomian.
 
Old January 23rd, 2004, 07:04 AM
Registered User
 
Join Date: Jan 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

After adding paramter fields to the report, you need to refer the fields in report. Once you have parameter field being used somewhere in the report, you will be asked for parameters when as you refresh the report.
 
Old January 26th, 2004, 12:55 PM
Registered User
 
Join Date: Jan 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi John--thanks for your help. Could you tell me how to create a parameter query. Do I do this on the database or somewhere in visual studio .net? How do I link the default parameters to the query? Also is there a way to bypass entering parameters? For example when someone presses cancel the whole report is shown.
thanks Lauren

Quote:
quote:Originally posted by jrwlkn
 Typically the report gets its paramaters from a query...set up a paramater query and then construct your report off of the query...when you open the report the query will prompt for the designated paramaters.

Let me know if this helps and if you need additional input

John






Similar Threads
Thread Thread Starter Forum Replies Last Post
parameters into sub reports alandimech BOOK: Professional Crystal Reports for VS.NET 1 October 30th, 2007 11:17 AM
Crystal Reports - Parameters pramesh_it Crystal Reports 1 April 12th, 2006 04:21 AM
Parameters & reports aware Access 6 September 16th, 2005 06:47 AM
Crystal Reports Parameters Amadago Crystal Reports 1 April 12th, 2004 11:35 PM
Passing parameters to reports jammykam Access 2 October 8th, 2003 02:24 PM





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