sub report - error in connecting Options  Email this topic  Watch this topic  Print this topic » Normal Threaded

Previous Topic Next Topic

spoorthy		#1 Posted : Monday, October 17, 2016 5:54:54 AM(UTC)
Rank: Newbie Groups: Registered Joined: 10/17/2016(UTC) Posts: 0 Location: Bangalore		hi all, i am getting error as : unable to add this sub report the report does not contain any prompted restriction bbelonging to the table. please don answer me.
User Profile View All Posts by User View Thanks

	Wanna join the discussion?! Login to your Seal Report Forum forum accountor Register a new forum account.

epf		#2 Posted : Monday, October 17, 2016 8:53:04 AM(UTC)
Rank: Administration Groups: Administrators Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)		yes, to go from a column to another report, the other report (= the sub report) must have a restriction prompted on this column... You can use the wizard to create a basic sub-report and understand how it works. Good luck.
User Profile View All Posts by User View Thanks

spoorthy		#3 Posted : Monday, October 17, 2016 8:59:20 AM(UTC)
Rank: Newbie Groups: Registered Joined: 10/17/2016(UTC) Posts: 0 Location: Bangalore		thanx for the reply, what i am supposed to give in prompted restriction in sub report
User Profile View All Posts by User View Thanks

epf		#4 Posted : Monday, October 17, 2016 9:05:35 AM(UTC)
Rank: Administration Groups: Administrators Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)		You have to prompt a restriction based on the column: e.g. If the sub-report is from OrderId, you must have a sub-report with a restriction prompted on OrderId. I have just checked and it looks like the <Create Sub-Report> helper does not work, will be fixed in next release...
User Profile View All Posts by User View Thanks

spoorthy		#5 Posted : Monday, October 17, 2016 9:08:57 AM(UTC)
Rank: Newbie Groups: Registered Joined: 10/17/2016(UTC) Posts: 0 Location: Bangalore		ya i have added prompted restriction but still it showing error
User Profile View All Posts by User View Thanks

epf		#6 Posted : Monday, October 17, 2016 9:12:57 AM(UTC)
Rank: Administration Groups: Administrators Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)		Can you reproduce the problem with Northwind ? I have tried to add Order Detail from Order Id without error...
User Profile View All Posts by User View Thanks

spoorthy		#7 Posted : Monday, October 17, 2016 9:14:48 AM(UTC)
Rank: Newbie Groups: Registered Joined: 10/17/2016(UTC) Posts: 0 Location: Bangalore		okey il check with that
User Profile View All Posts by User View Thanks

spoorthy		#8 Posted : Monday, October 17, 2016 9:28:31 AM(UTC)
Rank: Newbie Groups: Registered Joined: 10/17/2016(UTC) Posts: 0 Location: Bangalore		if we try to add in northwind we are getting it, but if do in our reports i am getting that error
User Profile View All Posts by User View Thanks

epf		#9 Posted : Monday, October 17, 2016 10:01:07 AM(UTC)
Rank: Administration Groups: Administrators Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)		you are sure that you have set the property of your restriction: "Prompt restriction" to "Prompt at execution" ?
User Profile View All Posts by User View Thanks

Users browsing this topic

Guest (5)

Similar Topics

Pass two or three restrictions selected values to Sub report (Reports) by Sekharg 10/9/2022 7:57:30 AM(UTC)

some sub report question (Reports) by simon75117 12/17/2021 2:09:41 AM(UTC)

Sub Reports - Path (Reports) by cyracks 7/3/2020 3:45:38 PM(UTC)

Open existing Sub Reports (Bug Reports) by cyracks 6/27/2020 9:42:23 PM(UTC)

How to add Sub Reports (General Discussions/Other) by Bhaskar Naveen 5/24/2018 12:30:51 PM(UTC)

linking problem in sub report (Reports) by Ravi Chauhan 6/1/2017 1:47:29 AM(UTC)

Pass multiple restriction to sub report (Reports) by gaurav11 4/19/2017 2:16:23 PM(UTC)

sub reports (General Discussions/Other) by spoorthy 10/17/2016 5:11:44 AM(UTC)