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 March 3rd, 2005, 01:29 PM
Registered User
 
Join Date: Mar 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Unable to create SQL Query using parameters

I have created a parameter called "Sku_Name" with properties
Value type = string
Discrete Values
Allow multiple values is unchecked.

Then using the Report Expert I am trying to create a Parameterized SQL query.

SELECT Run.Sku_ID, Run.Run_Placement, Avg(Tag.Tag_Count), stdev(Tag.Tag_Count)
FROM Run, Tag
WHERE Run.Sku_ID = {?Sku_Name} And run.run_id=tag.run_id
GROUP BY Run.Sku_ID, Run.Run_Placement;

After creation, when I move to next screen in Report expert, no fields are returned for the Command.

As a check for the query, I replace the Parameter value with an actual value from the table and the fields were returned for the command.

I am thinking that there might be a problem in my syntax or have missed a certain step or my version of Crystal reports doesnot support Parameterized queries.

Please advise.

Thanks,

odyzeus





Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to create Macro valdetero Excel VBA 0 July 26th, 2007 02:58 PM
Unable to connect: incorrect log on parameters. Dmitriy ASP.NET 1.0 and 1.1 Professional 0 June 18th, 2007 07:53 AM
unable to pass parameters to crystal report ukumawat Crystal Reports 1 May 6th, 2006 09:08 AM
Chap 4 Unable to create user in SQL Exprs VictorVictor BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 0 January 23rd, 2006 12:10 PM
Unable to connect: incorrect log on parameters casjachan ASP.NET 1.x and 2.0 Application Design 2 July 25th, 2004 04:55 PM





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