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 June 20th, 2006, 10:11 AM
Registered User
 
Join Date: Jun 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default on Crystal designer help..?

Hi, iam very new in Crystal. is it same where condition & promt (parameter field). in the where condition we filter the data & in parameter field we filter the data right.. what the diff.. & can pls pls guide me how to apply the Joins & where conditon in RDC( at the time of report designing. is it possible.

Thanks in Advance
Megana

 
Old June 23rd, 2006, 01:35 AM
Friend of Wrox
 
Join Date: Dec 2004
Posts: 221
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello,

As of mY knowledge,

Where Condition: is related to the SQL Query what you have for your present report.
If any changed here, it gets the data as needed w.r.t to SQL Statement.

Prompt (Parameter field): is for the SQL Stored Procedure. These the the IN Parameters of the SQL stored procedures and gets the data as needed by the SQL
lines of code written Stored Procedure.

But tell me onething, what RDC has to do with your reports? If you be more
specific and clear in explaining the difficulty you have know, It will help
all the readers to give the proper answer. Just let us know what you want.

Hope this helps.

With Regards,
Raghavendra Mudugal
 
Old June 23rd, 2006, 10:10 AM
Registered User
 
Join Date: Jun 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

Thanks for reply, Actualy iam confusing on " Where Condition". Crystal Sample Reports - Database menu - when i pressed "Show SQL Query" command it shown SQL Query. In That i seen very big Where Condition, for that iam confusing how to pass where Condition. In my knowledge..Through Front end Code we can send the Query..From that we pass the Where condition. Is there any feature is supported to pass where class Through Crstal Design time..

One more problem here iam facing. In the DataBase table columns are changed..that we can set using by "verify database" as per my knowledge..
But, Previous in the database Table one column is Primary key, Now they added one more column and set to primary key.. Previous one modified to Non key column..
My existing report is pointing to old key (Primary Key,, in that query that key was paired with 7 tables).. now i need to change that one to current primary column.How to change that one. Iam doing R& D through "Data Export" command..

Please help me..

Thanks in advance

Megana

 
Old June 26th, 2006, 09:29 AM
Registered User
 
Join Date: Jun 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi pls reply as soon as posible to u. Thank'Q'

 
Old June 27th, 2006, 10:25 AM
Friend of Wrox
 
Join Date: Dec 2004
Posts: 221
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello,

(sorry in bit delau in replying)

As of my knowledge, I did'nt find any way to set the SQL query.

If you using the CR with .NET then, rather than using SQL Query,
use SP and pass the parameter to the where condition. This is the better
and recommanded way.

ELSE

If you are using CR with VB6.0 then make a reference to the
Crystal Active X object, check the below code.

Dim b As CRQUERYENGINE.QEFields
Dim c As New CRAXDDRT20.Application
Dim d As Report
'Dim e As GroupNameFieldDefinition
d = c.OpenReport("c:\c.rpt")
'e = d.GroupNameFields(0)
'e.GroupNameConditionFormula
d.SQLQueryString
'd.FormulaFields(0).Value

Here you cant assign the values to the "WHERE" clause of the sql statement.
You have to assign the complete SQL Statement with all proper parameters
of the WHERE condition.

These are the two ways I use. and in .NET i always go with SP, no matter the
report is simple or complicated.

For the your SECOND case;

If there where 7 tables related, i always prefer to SP, create the table as needed
and put the data of 7 tables in one table and organize them is such a way that
while creating the report becomes easy. Even I have report which come from 9 tables, where i use SP.

Try checking "Report Experts" there will be a option in binding relationship in
the CR level. you will get that screen when you create a new report its somewhere
in 7th to 9th tab in between. OR right click on the report and in Reports menu
choose "Report Experts". There you might get some idea to fix.

I came across such situation where i had two tables and was trying to do what you are doing now, but it did'nt helped much, so i again went back to SP style. now i have no problem.

Hope this helps.

With Regards,
Raghavendra Mudugal
 
Old June 30th, 2006, 04:22 PM
Registered User
 
Join Date: Jun 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

ThankQ 'U' very much Raghavendra. I did using Database Expert.

Megana






Similar Threads
Thread Thread Starter Forum Replies Last Post
vb file for crystal reports designer sasidhar79 ASP.NET 2.0 Professional 0 February 13th, 2007 01:25 AM
Crystal Reports ActiveX Designer : Logon failed. thangna BOOK: Professional Crystal Reports for VS.NET 2 November 24th, 2004 06:37 AM
Crystal Reports ActiveX Designer Logon failed thangna Crystal Reports 1 November 11th, 2004 08:40 PM
crystal reports .net designer login failed error dilshan Crystal Reports 3 September 23rd, 2004 01:38 PM
Crystal Report Designer in Java Rajeev Khurana Crystal Reports 1 April 21st, 2004 11:35 AM





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