Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 4th, 2007, 10:13 AM
Registered User
 
Join Date: Oct 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Parameter help needed for reporting services

Hi,

I am writing a report with 2 datasets that pull data from an Oracle database, the problem is, I cannot make paramaters for this report. I hard coded the dates in the sql and it works, but if I try to put parameters in the report, it always errors out. I have tried both the :Startdate type and the @Startdate parameter syntax with no luck.

Any help would be greatly appreciated.

Chuck

  #2 (permalink)  
Old October 5th, 2007, 02:31 PM
Registered User
 
Join Date: Oct 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i could use some help folks

  #3 (permalink)  
Old October 5th, 2007, 02:51 PM
joefawcett's Avatar
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

Well I haven't worked with Reporting Services and Oracle but RS uses ADO.NET under the covers. Can you create a parameterised call to the Oracle procedure, in C# for instance? Take a look at the second post in this thread: http://p2p.wrox.com/topic.asp?TOPIC_ID=18096 and there's something here on using Oracle http://msdn2.microsoft.com/en-us/library/ms365174.aspx.

--

Joe (Microsoft MVP - XML)
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: SQL Server Reporting Services help needed! salmanshehbaz Reporting Services 1 April 4th, 2007 10:45 PM
Multivalue parameter Reporting Services 2005 aldwinenriquez Reporting Services 2 January 11th, 2007 03:41 PM
Reporting Services mikerowe SQL Server 2000 0 May 22nd, 2005 08:22 PM
Reporting Services Ben SQL Server 2000 3 February 8th, 2005 10:16 AM
reporting services msrnivas .NET Web Services 0 June 18th, 2004 04:52 AM



All times are GMT -4. The time now is 12:10 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.