tag:blogger.com,1999:blog-8905997490259569264.post3430725217885551194..comments2024-03-06T07:38:54.040-05:00Comments on Gulfsoft Consulting Blog: BIRT Tip: Dependent Parameters in your reportsFrank Tatehttp://www.blogger.com/profile/16464603721492040411noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-8905997490259569264.post-73722039755282311362014-09-02T17:14:25.971-04:002014-09-02T17:14:25.971-04:00Amit,
Adding additional parameter should be stra...Amit, <br /><br />Adding additional parameter should be straight forward as well. <br /><br />For example, to add a City/State/Country cascading parameter, you will have to create three datasets.<br /><br />1. Country datasets (gets all the countries)<br />2. State datasets (gets all the States in the specific country).<br />3. City dataset (gets all the Cities in the specific State AND specific Country). <br /><br />4. In cascading parameter group, you'd add all three datasets just as mentioned in the blog. <br /><br />5. You will then edit the parameter binding of the State dataset so that Country parameter is bound to Countries parameter in cascading parameter group.<br /><br />6. Edit the parameter binding of the Cities dataset so that Country parameter is bound to Countries parameter AND State parameter of the dataset is bound to State parameter of the cacading parameter group.<br /><br />Now, you have a dependent parameter that works for three different datasets.<br /><br />PS: I couldn't post images in comments, but let me know if this is not clear, I will publish a blog article with screenshots.<br /><br />-VenkatAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8905997490259569264.post-26517858024923803652014-09-02T17:14:25.341-04:002014-09-02T17:14:25.341-04:00Amit,
Adding additional parameter should be stra...Amit, <br /><br />Adding additional parameter should be straight forward as well. <br /><br />For example, to add a City/State/Country cascading parameter, you will have to create three datasets.<br /><br />1. Country datasets (gets all the countries)<br />2. State datasets (gets all the States in the specific country).<br />3. City dataset (gets all the Cities in the specific State AND specific Country). <br /><br />4. In cascading parameter group, you'd add all three datasets just as mentioned in the blog. <br /><br />5. You will then edit the parameter binding of the State dataset so that Country parameter is bound to Countries parameter in cascading parameter group.<br /><br />6. Edit the parameter binding of the Cities dataset so that Country parameter is bound to Countries parameter AND State parameter of the dataset is bound to State parameter of the cacading parameter group.<br /><br />Now, you have a dependent parameter that works for three different datasets.<br /><br />PS: I couldn't post images in comments, but let me know if this is not clear, I will publish a blog article with screenshots.<br /><br />-VenkatAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8905997490259569264.post-26063187480602486982014-08-28T10:29:31.962-04:002014-08-28T10:29:31.962-04:00i have two parameters in reports that depend on a ...i have two parameters in reports that depend on a single parameter<br />for example country ,city ,state.<br /><br />but in my case city depends on country and one more parameter that is also depends on country at the same time. with cascade i can handle only i.e city. how to handle that that one also Amit Malyanhttps://www.blogger.com/profile/09080742359450707570noreply@blogger.com