Fields cannot be used in query parameter expressions
in [Reports]
|
From: GiJeet on 22 Jan 2010 16:29 Hello, using SQL Reporting Services 2008. I trying to allow users to enter parameters to filter a report so I'm using stored procedures....common right. But I want a parent/child relationship between 2 datasets. The first ds pulls records based on the visible parameters entered by the user. The 2nd ds needs to use a key field in the first ds to populate a hidden parameter linked to the 2nd ds but I keep getting and error: "Fields cannot be used in query parameter expressions" How to use 2 stored procs that create datasets and link them using PK/ FK relationship? I tried every which way but keep getting that error. There must be a way!!! Thanks in advance.
From: Bruce L-C [MVP] on 22 Jan 2010 17:04 What you need to do is to use sub reports. You cannot link two datasets together they way you are trying. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "GiJeet" <gijeet(a)yahoo.com> wrote in message news:e715d44f-34f1-48ee-b2cc-309bfe41d672(a)j14g2000yqm.googlegroups.com... > Hello, using SQL Reporting Services 2008. I trying to allow users to > enter parameters to filter a report so I'm using stored > procedures....common right. But I want a parent/child relationship > between 2 datasets. The first ds pulls records based on the visible > parameters entered by the user. The 2nd ds needs to use a key field > in the first ds to populate a hidden parameter linked to the 2nd ds > but I keep getting and error: "Fields cannot be used in query > parameter expressions" > > How to use 2 stored procs that create datasets and link them using PK/ > FK relationship? I tried every which way but keep getting that > error. There must be a way!!! > > Thanks in advance.
|
Pages: 1 Prev: Help needed to calculate % Total Next: SELECT/INSERT statements via the RS utility |