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

Previous Topic Next Topic

spoorthy		#1 Posted : 9 years ago
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 : 9 years ago
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 : 9 years ago
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 : 9 years ago
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 : 9 years ago
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 : 9 years ago
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 : 9 years ago
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 : 9 years ago
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 : 9 years ago
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

Similar Topics

Pass two or three restrictions selected values to Sub report (Reports) by Sekharg 3 years ago

some sub report question (Reports) by simon75117 3 years ago

Sub Reports - Path (Reports) by cyracks 5 years ago

Open existing Sub Reports (Bug Reports) by cyracks 5 years ago

How to add Sub Reports (General Discussions/Other) by Bhaskar Naveen 7 years ago

linking problem in sub report (Reports) by Ravi Chauhan 8 years ago

Pass multiple restriction to sub report (Reports) by gaurav11 8 years ago

sub reports (General Discussions/Other) by spoorthy 9 years ago