error in the report parameters

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

error in the report parameters

Author

Topic

shm
Yak Posting Veteran

86 Posts

Posted - 2009-01-20 : 00:50:49

hi

am trying to display the parameter values which is comma separated value..that is in the parameter multiple select projectnames more than 1 like a,b,c
i should display this in the report layout i tried to display in the header or details or footer it is displaying #error wt i should give in the layout table.

and in more report parameter i have given multiple select it il select but it il take only 1 value...

ra.shinde
Posting Yak Master

103 Posts

Posted - 2009-01-20 : 01:16:36

use JOIN(<parametername>.value,',')

Rahul Shinde

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-20 : 02:59:40

quote:
Originally posted by ra.shinde

use JOIN(<parametername>.value,',')

Rahul Shinde

it should be

JOIN(Parameters!parametername.value,",")

shm
Yak Posting Veteran

86 Posts

Posted - 2009-01-20 : 03:39:03

hi
ya it is taking in the parameter but am not able display that in the layout..i want that to display by keeping the table..that is in the layout i should get the value wtever i have selected

shm
Yak Posting Veteran

86 Posts

Posted - 2009-01-20 : 06:14:25

hi,

thank u for the reply ..ya it is working fine..but i want that separatrely not comma separated..that is
if i select a,b,c projects in the parameter.it should display this projectnames in the layout as one by one like

+a subreport
+b subreport
+c subreport

like this i want

ra.shinde
Posting Yak Master

103 Posts

Posted - 2009-01-20 : 06:19:39

Split the commseparated parameter so that you will get each value in one row. then left join with result of your report query, which you are using to pass the values to subreports

Rahul Shinde

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-20 : 09:13:39

quote:
Originally posted by shm

hi,

thank u for the reply ..ya it is working fine..but i want that separatrely not comma separated..that is
if i select a,b,c projects in the parameter.it should display this projectnames in the layout as one by one like

+a subreport
+b subreport
+c subreport

like this i want

but this you can retrieve from data itself in dataset. just retrieve project name field also from table along with data and place it as a first item in table cell. for getting + mark just use display property toggle based on report item for other row and give the first cell as item (one containing project name)

ra.shinde
Posting Yak Master

103 Posts

Posted - 2009-01-20 : 09:27:09

quote:
Originally posted by visakh16

quote:
Originally posted by shm

hi,

thank u for the reply ..ya it is working fine..but i want that separatrely not comma separated..that is
if i select a,b,c projects in the parameter.it should display this projectnames in the layout as one by one like

+a subreport
+b subreport
+c subreport

like this i want

but this you can retrieve from data itself in dataset. just retrieve project name field also from table along with data and place it as a first item in table cell. for getting + mark just use display property toggle based on report item for other row and give the first cell as item (one containing project name)

If for one of the item(a,b and c), data is not reurned then it will not appear in report. if this what is intended then above solution is OK.

Rahul Shinde

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-20 : 09:41:03

whats the purpose of showing an item if there is not any data for it. Ok if you want it as a place holder, then you need to create a temporary table with all distinct projects and use it as master table and take left join with other tables in query for dataset

shm
Yak Posting Veteran

86 Posts

Posted - 2009-01-21 : 23:43:30

hi visakh

as visakh said i tried that it is coming but i there is gap between the two projects..am trying to remove that..
if 5 members for A project then there il be space between A and B proejct

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-22 : 12:41:52

quote:
Originally posted by shm

hi visakh

as visakh said i tried that it is coming but i there is gap between the two projects..am trying to remove that..
if 5 members for A project then there il be space between A and B proejct

nope. it wont if you give detail fields for project as next row of table and toggle hidden property of second row based on your main row (one containing project names)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-22 : 12:50:16

http://www.devx.com/dbzone/Article/37703/1954

shm
Yak Posting Veteran

86 Posts

Posted - 2009-01-23 : 02:47:32

hi
ya am getting the report correct now..thank u very much

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-23 : 12:57:33

welcome