and i've textboxes on report (one textbox on top, one on bottom, and one in the middle of the report)
Now, based on the ID, I have to show the Description on textboxes (report) i.e., if
ID =1, then description for id=1 must be displayed in the textbox which is located on the top of the report, and when
ID=2 the description for id =2 must be displayed in the textbox which is placed in the bottom.
In the same way I must show the data in textboxes.
Can it be done?
Drag a list from the toolbox, set the height width as per your need. Drag textbox for ID at the top and another one in the bottom for description inside the List control you've added. by going on the list properties set the dataset to that dataset you've
created. Now drag the dataset value [ID] from toolbox to and drop it on ID Textbox, do the same for description textbox.
drag any table,list etc in the body,,& then right click on the tablix properties ,set the dataset for the tablix (for table or list etc).. after setting the dataset ,then click on the right side of data rowthat will open the list of columns for the dataset,
as u have only 2 columns id & description ,so select one for one column of tablix,,,
later run the r eport u got the desired result,,, let me know if you have any issue....
Member
6 Points
68 Posts
Fetch Nth row data
Dec 26, 2012 01:44 PM|Anand Reddy|LINK
Hi,
I'm a newbie in ssrs.
I have a dataset with returns multiple records with 2 columns (ID, Description).
Here the column ID contains unique records.
On report I will place textboxes and now I want to set the expression to fetch Description based on the ID and show it in textbox.
say, if ID=1 then textbox1 must display the Description of ID = 1 ( in the same way i want to configure for each textbox)
Thanks & regards,
Anand
Participant
860 Points
303 Posts
Re: Fetch Nth row data
Dec 27, 2012 05:26 AM|Nishantg|LINK
Hi Anand,
I am considering the following.
1. You have one dataset(dsID) having ID & Description.
2. You have another dataset(dsMain) having ID with other columns.
If this is the case you can use Lookup function (SSRS 2008 R2).
Lookup(Fields!ID.Value, Fields!ID.Value, Fields!Description.Value, "dsID")
Thanks
Nishant
Member
6 Points
68 Posts
Re: Fetch Nth row data
Dec 27, 2012 12:56 PM|Anand Reddy|LINK
Hi,
I have only one dataset with ID & Description.
and i've textboxes on report (one textbox on top, one on bottom, and one in the middle of the report)
Now, based on the ID, I have to show the Description on textboxes (report) i.e., if ID =1, then description for id=1 must be displayed in the textbox which is located on the top of the report, and when ID=2 the description for id =2 must be displayed in the textbox which is placed in the bottom.
In the same way I must show the data in textboxes.
Can it be done?
Thanks & regards,
Anand
Contributor
3602 Points
1071 Posts
Re: Fetch Nth row data
Dec 28, 2012 12:17 AM|Ashutosh Pathak|LINK
Drag a list from the toolbox, set the height width as per your need. Drag textbox for ID at the top and another one in the bottom for description inside the List control you've added. by going on the list properties set the dataset to that dataset you've created. Now drag the dataset value [ID] from toolbox to and drop it on ID Textbox, do the same for description textbox.
Let us know if you have any concern(s).
Blog: http://catchcode.blogspot.com
MCP,MCAD,MCSD,MCTS
Member
231 Points
552 Posts
Re: Fetch Nth row data
Jan 01, 2013 02:37 AM|waqar1|LINK
hm,,, @anand happy new year
drag any table,list etc in the body,,& then right click on the tablix properties ,set the dataset for the tablix (for table or list etc).. after setting the dataset ,then click on the right side of data rowthat will open the list of columns for the dataset, as u have only 2 columns id & description ,so select one for one column of tablix,,,
later run the r eport u got the desired result,,, let me know if you have any issue....