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

Notification

Icon
Error

Options
Go to last post Go to first unread
spoorthy  
#1 Posted : Monday, October 17, 2016 5:54:54 AM(UTC)
spoorthy

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.
epf  
#2 Posted : Monday, October 17, 2016 8:53:04 AM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 136 time(s) in 132 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.
spoorthy  
#3 Posted : Monday, October 17, 2016 8:59:20 AM(UTC)
spoorthy

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
epf  
#4 Posted : Monday, October 17, 2016 9:05:35 AM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 136 time(s) in 132 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...
spoorthy  
#5 Posted : Monday, October 17, 2016 9:08:57 AM(UTC)
spoorthy

Rank: Newbie

Groups: Registered
Joined: 10/17/2016(UTC)
Posts: 0
Location: Bangalore

ya i have added prompted restriction but still it showing error
epf  
#6 Posted : Monday, October 17, 2016 9:12:57 AM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 136 time(s) in 132 post(s)
Can you reproduce the problem with Northwind ?
I have tried to add Order Detail from Order Id without error...
spoorthy  
#7 Posted : Monday, October 17, 2016 9:14:48 AM(UTC)
spoorthy

Rank: Newbie

Groups: Registered
Joined: 10/17/2016(UTC)
Posts: 0
Location: Bangalore

okey il check with that
spoorthy  
#8 Posted : Monday, October 17, 2016 9:28:31 AM(UTC)
spoorthy

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
epf  
#9 Posted : Monday, October 17, 2016 10:01:07 AM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 136 time(s) in 132 post(s)
you are sure that you have set the property of your restriction: "Prompt restriction" to "Prompt at execution" ?
Users browsing this topic
Similar Topics
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)
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.