Who is online?  0 guests and 0 members
Home  »  search results

Search Results: LookUp function

13 results found
  • SSRS – Using Lookup Function for Multiple Column Join
    When SQL Server 2008 R2 was released several new Reporting Services expressions were made available that would help join multiple datasets together. Those functions were the Lookup Function , LookupSet Function and the MultiLookup Function . My general re
    Author: DevinKnight DevinKnight     Date: 7/27/2012     Section: Blog
  • LookUp and LookUpSet Functions New in SSRS 2008 R2
    With the release of R2 came a couple of pretty nifty new expressions in SSRS. The LookUp function allows us to perform a look up against a separate data set in our report using a field in our source data set where there is a 1 to 1 relationship. Likewise,
    Author: DustinRyan DustinRyan     Date: 7/27/2011     Section: Blog
  • Dynamic Lookup and Fuzzy Lookup or alternative
    There is no way to do this using transformation. If you intend to use SQL 2008 R2, you can do that using script task and the use newly introduced Fuzzy Lookup functions. Refer this blog post for the functions dscribed above.
    Author: nitya nitya     Date: 12/21/2009     Section: Forum
    tags : fuzzy lookup
  • How to Use Two DataSourceViwes in Single ReportModel Using SSRS 2008 R2
    If your requirement is set in stone that it must have two models, then you will not be able to do what it is that you are asking. You cannot join two models. Sorry. You may be able to use the lookup functions to join from both. Please mark as answered so
    Author: briankmcdonald briankmcdonald     Date: 12/17/2010     Section: Forum
  • SSIS Data Source Flow Efficiency
    OK... Thanks again for your help. I worked through the tasks you suggested, so that I now have a source for my flow (my new SQL table containing the subgroup of Active patients is my source). Next I use a lookup function in SSIS to link to the results tab
    Author: daveddvf daveddvf     Date: 2/5/2013     Section: Forum
  • combine two fields
    Which version of SSRS do you have deployed? If you have 2008 R2 or 2012, then you can use the Lookup function.
    Author: KathiKellenberger KathiKellenberger     Date: 4/21/2013     Section: Forum
  • Create a chart showing current and previous year
    SQL Server Reporting Services (SSRS) has several features that you can use to create visualizations of your data like charts, gauges, KPIs, and maps. These features are great for creating dashboards. The chart feature can be used to show multiple data poi
    Author: KathiKellenberger KathiKellenberger     Date: 3/10/2013     Section: Blog
  • Mixing Data Sets in Tables or Lists
    David, If you are using R2, you can use the lookup functions ( http://msdn.microsoft.com/en-us/library/ms170438.aspx#Aggregates ). If you are not using R2, maybe you can combine the two results sets into one query. Just create a table variable with your U
    Author: briankmcdonald briankmcdonald     Date: 1/18/2011     Section: Forum
  • Multiple dataset in SSRS
    If you are using SQL Server 2008 and above you can use a lookup function to get values from another dataset. You can find out more here: http://msdn.microsoft.com/en-us/library/ms170438.aspx * If this has answered your question, please mark it as answered
    Author: briankmcdonald briankmcdonald     Date: 11/10/2010     Section: Forum
  • Lookup in SSRS 2008 R2
    We use more than one dataset in many of the reports and we always think to join or merge datasets to provide a good solution in reports but we were not able to do it in 2005 or 2008, but now the time has come and microsoft has finally included some cool f
    Author: hardikabhavsar hardikabhavsar     Date: 3/8/2011     Section: Blog
  • HOW to Get values from stored procedure into a field in a Report
    No worries! I personally would just execute your sp 2 within your sp 1. The results of sp 1 would then be returned back to your report. However, if you are using SSRS 2008, you may be able to use one of the new Lookup Functions. But either way, you'll nee
    Author: briankmcdonald briankmcdonald     Date: 10/15/2010     Section: Forum
  • HOW to Get values from stored procedure into a field in a Report
    Thank you again, I am using SSRS 2008, where can I get list of the lookup functions? briankmcdonald said: I personally would just execute your sp 2 within your sp 1 do you mean sp1 within sp2? If I could not fix it this way, I will try using stored proced
    Author: rv7a99cv rv7a99cv     Date: 10/16/2010     Section: Forum
  • Dynamic Lookup and Fuzzy Lookup or alternative
    Hello I am working on a project where I need to take a client list (oledb client file) and match it against several different years of Reference Data (oledb 2000 to 2007) using the Lookup and Fuzzy Lookup functions of SSIS Sql 2005. From my reading there
    Author: negril negril     Date: 12/21/2009     Section: Forum
Page 1 of 1 (13 items)