No announcements
Found 2747491 threads
-
0 VotesLookup on two fields from datasets in SSRS 2008R2
Display data on a tablix from two datasets in ssrs report by joining on Multi columns Good Luck!Answered | 4 Replies | 4645 Views | Created by donalejandro - Saturday, January 16, 2016 6:25 PM | Last reply by Sanjeewan Kumar - Wednesday, January 20, 2016 5:48 AM
-
4 Votes
Dataset Linking in SSRS 2008
However, we can use Lookup function and join datasets in 2008R2.Answered | 4 Replies | 12556 Views | Created by Diganta_goswami - Monday, July 5, 2010 1:10 PM | Last reply by Andrew781 - Monday, September 16, 2013 5:44 PM -
0 Votes
Lookup function in SSRS 2008 R2 not returning a match from an oracle dataset
Such as the expression you are using to concat fields via lookup function to return value, and waht kind of dataset you are using for the report and so on.Answered | 3 Replies | 4883 Views | Created by mal0r - Tuesday, July 5, 2011 8:26 AM | Last reply by mal0r - Thursday, July 7, 2011 6:58 AM -
0 Votes
Subtracting two columns from two different datasets
Even if you have same fields, you can use them like like you use in a join.Answered | 8 Replies | 8179 Views | Created by Esmari - Tuesday, December 20, 2011 6:18 PM | Last reply by Esmari - Tuesday, December 20, 2011 7:35 PM -
0 Votes
Two Dataset
You can even create another dataset using SQL Join between the two query that you have specified in dataset1 and dataset2.Answered | 9 Replies | 977 Views | Created by Phil1988 - Tuesday, May 6, 2014 3:21 PM | Last reply by Phil1988 - Wednesday, May 7, 2014 1:59 PM -
0 Votes
ssrs 2008 using lookup feature
Hi midnight_car, To add 2 extra columns from the second dataset, it is possible to use the 'lookup' feature.Answered | 1 Replies | 706 Views | Created by midnight_car - Sunday, June 4, 2017 9:52 PM | Last reply by Henry Jiang - Monday, June 5, 2017 2:13 AM -
0 Votes
ADDING TOTAL AND SUBTOTAL FROM TWO DATASETS
Hi Ysabel1111, Based on my understanding, you are retrieving data from another dataset with Lookup() function within a tablix.Answered | 3 Replies | 1513 Views | Created by Ysabel1111 - Wednesday, February 11, 2015 2:44 PM | Last reply by Qiuyun Yu - Sunday, February 15, 2015 10:13 AM -
0 Votes
SSRS Sparkline category with Lookup
In SSRS, lookupset function returns the set of matching values for the specified name from a dataset that contains name/value pairs.Answered | 4 Replies | 1606 Views | Created by Ghees Alias - Tuesday, October 20, 2015 2:00 PM | Last reply by dssrams - Tuesday, November 3, 2015 9:09 AM -
0 Votes
Using two datasets to extract data in one report in SSRS 2008
While you want to retrieve the EmpID column’s value based on the Name column from the two datasets in SQL Server Reporting Service(SSRS) 2008.Answered | 2 Replies | 2598 Views | Created by nody88 - Wednesday, August 28, 2013 11:13 AM | Last reply by Heidi-Duan - Thursday, August 29, 2013 2:55 PM -
0 Votes
Can a Data Region in SSRS use two different data sets?
In SSRS report, can a Table or a Matrix have its fields coming from two different data sets?Answered | 4 Replies | 3889 Views | Created by shalini29 - Friday, December 30, 2011 12:29 AM | Last reply by Rajkumar Yelugu - Friday, December 30, 2011 9:07 AM -
0 Votes
Using Lookup function in SSRS Matrix Group.
countt.Value, "DataSet2"),",") I am not sure if SSRS suppports it, but all i want to do is use columns from second dataset(which is ...Answered | 9 Replies | 16404 Views | Created by PA Kumar - Thursday, September 26, 2013 9:11 AM | Last reply by PA Kumar - Monday, September 30, 2013 8:09 AM -
1 Votes
NO fields for dataset in ssrs 2008
it does nt work , but i followed this link it ...Answered | 3 Replies | 2341 Views | Created by Subathra-Subathra - Tuesday, November 20, 2012 9:32 AM | Last reply by Can TUFEKCI - Tuesday, November 20, 2012 2:27 PM -
0 Votes
Search in SSRS dataset or SSRS table for a specific value
Hi You can use the lookup function to do this, the lookup function will return the matching id value from table 1.Answered | 2 Replies | 9518 Views | Created by Sanjay Bollina - Friday, December 6, 2013 8:36 AM | Last reply by Nasa1999 - Friday, December 6, 2013 10:34 AM -
0 Votes
SSRS Report with two kinds of datasets
If you paste this query (without the WHERE and parameters) in SSRS query designer (that appears when you open the dataset) and execute, is it running without errors.Answered | 9 Replies | 6732 Views | Created by rahulSandy_sql - Friday, August 6, 2010 9:25 PM | Last reply by Mohamed Irshad - Wednesday, August 11, 2010 2:40 AM -
1 Votes
Using Fields from Multiple Datasets SSRS 2008 R2
However, we can use lookup function to achieve it in SQL Server Reporting Services (SSRS) 2008 R2 or later.Answered | 7 Replies | 7030 Views | Created by CSharp Enthusiast - Wednesday, October 24, 2012 11:07 PM | Last reply by CSharp Enthusiast - Thursday, November 1, 2012 6:40 PM -
0 Votes
Build Relationship with two datasets in SSRS
Hi Siera, From your history thread, I find that you are using SSRS2005, joining two different dataset in one report control is only supported by ...Answered | 3 Replies | 6724 Views | Created by siera_gld - Sunday, September 5, 2010 7:23 PM | Last reply by Challen Fu - Monday, September 6, 2010 2:43 AM -
0 Votes
Two Datasets
Hi Josephine - I assume you are wanting to display the total from both datasets in a textbox on your report, correct?Answered | 6 Replies | 3549 Views | Created by Josephine T - Wednesday, April 11, 2012 6:31 PM | Last reply by Dean Kalanquin - Thursday, April 12, 2012 6:31 PM -
0 Votes
How to perform a LEFT JOIN (lookup) function in SSRS
Hi Yvanlathem, According to your description, your report is containing two DataSets.Answered | 1 Replies | 3357 Views | Created by Yvanlathem - Tuesday, October 11, 2016 8:15 AM | Last reply by Xi Jin - Wednesday, October 12, 2016 7:02 AM -
0 Votes
Joining two datasets for one report
Fields can only be used in parameters by setting their value using "Get values from query".Answered | 6 Replies | 1268 Views | Created by Phil1988 - Thursday, May 15, 2014 8:19 AM | Last reply by Visakh16 - Friday, May 16, 2014 1:59 PM -
0 Votes
comparing 2 datasets in SSRS
Your best approach when you need to perform lookups, or any kind of join between two datasets in SSRS is to try to combine those datasets at the ...Answered | 3 Replies | 1774 Views | Created by Ravi Subbiah - Friday, March 8, 2013 8:22 AM | Last reply by Josh Ashwood - Tuesday, March 12, 2013 10:07 AM - Items 1 to 20 of 2747491 Next ›
No announcements
