Wrox Programmer Forums
|
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 December 6th, 2005, 09:23 AM
Authorized User
 
Join Date: Mar 2005
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Where Clause

Hi guys, i am kind of entry level to both vb.net and just getting started with crystal reports.
1)i want to build the SQL Where clause on the front end in vb.net(windows based form) based on the user input and pass the entire where clause to crystal reports as a parameter string.Would appreiate if anyone could please help me with some samples or alterntive ways to do it.
2)i want to repeat the page header information on all pages of the report. please help.
Thanks you so much in advance.
Sud

 
Old December 31st, 2005, 05:48 AM
Registered User
 
Join Date: Dec 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

1. see reportselectionformula property of report
document.

2. by default, page header displays in all pages.
what is your problem
 
Old January 11th, 2006, 10:01 AM
Authorized User
 
Join Date: Mar 2005
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your help,i had placed the page header information in the report header.so was having the problem. Appreciate your help.Thanks.






Similar Threads
Thread Thread Starter Forum Replies Last Post
USING SQL IF Statement in WHERE clause rit01 SQL Server 2000 17 March 15th, 2007 08:33 AM
User Value in TextBox be passed in SQL LIKE Clause Vinay Chugh ASP.NET 1.0 and 1.1 Professional 1 June 12th, 2006 07:22 AM
More than 1 WHERE clause? onlyu2 MySQL 1 March 26th, 2004 01:48 PM
datagrid control and specific sql where clause Krosser VB.NET 2002/2003 Basics 0 July 25th, 2003 07:05 AM
How to simulate DISTINCT clause in SQL SERVER debsoft SQL Server 2000 6 June 30th, 2003 06:29 PM





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