nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Parameter reqiurements in report

235383

[font="arial, sans-serif;"][color=rgb(34,34,34);]Hi,[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]Feeling good to post my query here in this forum which is always been helpful for me.[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]My query:[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]I have the dataset as below.[/color][/font] [font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]ID1 ID2 Value Status[/color][/font][/font][font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]1 11 AAA Active[/color][/font][/font][font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]1 12 BBB Active[/color][/font][/font][font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]1 13 CCC Cancelled[/color][/font][/font][font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]1 14 DDD Cancelled[/color][/font][/font][font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]2 21 EEE Active[/color][/font][/font][font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]2 22 FFF Cancelled[/color][/font][/font][font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]2 23 GGG Active[/color][/font][/font][font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]2 24 HHH Cancelled[/color][/font][/font] [font="arial, sans-serif;"][color=rgb(34,34,34);]In report design, I have the parameters as below.[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]Parameters:[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]1) Enter the ID1: Text box[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]2) Select the ID2: List box[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]3) Status: (Active) or (Active and cancelled) List box[/color][/font] [font="arial, sans-serif;"][color=rgb(34,34,34);] If i enter the ID1 value as 1, the values corresponding to 1(i.e 11, 12, 13, 14) has to be displayed automatically in ID2 in list box. I have to select more than one values form displayed ID2.[/color][/font] [font="arial, sans-serif;"][color=rgb(34,34,34);]If i select more than 3 vaues, it has to throw an error or warning message to indicate that more than three values should not be displayed.[/color][/font] [font="arial, sans-serif;"][color=rgb(34,34,34);] The Status will be having two values as 'Active' and 'Active and cancelled' in list box.[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]If i select Active, only active members has to be displayed where as if i select 'Active and cancelled' all the values corresponding to the 1 has to should be displayed.[/color][/font] [font="arial, sans-serif;"][color=rgb(34,34,34);]Ex: 1[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]ID1:1[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]ID2: 11, 12, 13[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]Status: Active[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]The result should be [/color][/font] [font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]ID1 ID2 Value Status[/color][/font][/font][font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]1 11 AAA Active[/color][/font][/font][font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]1 12 BBB Active[/color][/font][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]Ex: 2[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]ID1:1[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]ID2: 11, 12, 13[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]Status: Active and Cancelled[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]The result should be[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);] [/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]ID1 ID2 Value Status[/color][/font][/font][font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]1 11 AAA Active[/color][/font][/font][font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]1 12 BBB Active[/color][/font][/font][font="arial, sans-serif;"][color=rgb(34,34,34);][font="calibri;"]1 13 CCC Cancelled[/color][/font][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]Would be grateful, if someone could help me with a sample design.[/color][/font] [font="arial, sans-serif;"][color=rgb(34,34,34);]Thanks[/color][/font][font="arial, sans-serif;"][color=rgb(34,34,34);]Guruprasad. B[/color][/font]

Find more posts tagged with

Comments

GLO_FR

Hi , You can do it with cascading parameter and some SQL syntax in the WHERE clause.If you know the business rules/conditions, you can easily create query which will return exactly what you're looking for. The only thing which I'm not sure is the error message if you select more than 2 rows in the second parameter.You can catch and prevent this, but I really don't know if displaying a warning or a popup is possible or not.