Welcome Guest! To enable all features please Login or Register.



Go to last post Go to first unread
#1 Posted : Friday, September 08, 2017 9:30:49 AM(UTC)

Rank: Newbie

Groups: Registered
Joined: 9/8/2017(UTC)
Posts: 1

Hello all,

So I've created a table and corresponding model for each of my "subreports." However, I would like to create a parameter that I could use as a restriction in each of these sub report queries. How do I reference a parameter I've created in one model in another?

For example. I've created a parameter that I prompt the user for in model1 and use it to restrict information given in column x. How do I then use that same parameter in model2 in order to restrict its column x (containing the same data as column x in model1) in its query?

#2 Posted : Friday, September 08, 2017 5:14:18 PM(UTC)

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 527

Thanks: 7 times
Was thanked: 72 time(s) in 70 post(s)
Actually, you can check the Dashboard sample:
several models have the same restriction, only one restriction is prompted and its value is applied to all model.

if you change the restriction label, 2 restrictions will be prompted.
Users browsing this topic
Similar Topics
How to pass two parameters to subreport (General Discussions/Other)
by Bhaskar Naveen 5/28/2018 5:31:55 AM(UTC)
Input Parameters in SQL Statement for main Table (Data Source Creation)
by barrosw 4/19/2017 2:21:20 PM(UTC)
Passing dynamic parameters while calling the report via URL (Feature Request)
by vicky 4/4/2016 9:22:29 AM(UTC)
Pass Filter parameters from .NET (General Discussions/Other)
by dhaval_bi 3/22/2016 11:27:06 AM(UTC)
Linking report with restriction parameters (Reports)
by beppino21 7/9/2015 8:22:24 AM(UTC)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.