No announcements
Found 3191219 threads
-
0 Votes
Group by Lookup function result
Hi EXR88, Per my understanding that you have add some row group in the report to group the result which include the JobTitle from the table1 and also group by the field which result ...Answered | 1 Replies | 851 Views | Created by EZR88 - Wednesday, March 11, 2015 4:56 PM | Last reply by Vicky_Liu - Thursday, March 12, 2015 8:07 AM -
1 Votes
lookup function with aggregations in expressions
Hi Hmai, The Lookup() function is a new Reporting Services features in SQL Server 2008 R2 and returns the first matching value for the specified name form a ...Answered | 2 Replies | 1943 Views | Created by hmai - Thursday, October 11, 2012 1:16 AM | Last reply by Fanny Liu - Friday, October 12, 2012 5:06 AM -
0 Votes
Lookup function failing in SSRS
Hi Sarayu, I have tested in my local environment and the lookup function works fine.Answered | 2 Replies | 1948 Views | Created by Sarayu_CM - Thursday, February 5, 2015 2:31 AM | Last reply by Visakh16 - Friday, February 6, 2015 5:40 AM -
1 Votes
Lookup Function issue
Hi, Make sure your both the dataset should be in Same folder in report manager Just try with field Name not with report Items see this Look ...Answered | 1 Replies | 2496 Views | Created by Mr. Alejo - Friday, October 5, 2012 4:51 PM | Last reply by Sanjeewan Kumar - Saturday, October 6, 2012 8:30 PM -
0 Votes
lookup function in SQL 2008
Thanks for the help, it works perfect.Answered | 2 Replies | 7280 Views | Created by Arne Olsson - Thursday, November 4, 2010 2:14 PM | Last reply by Arne Olsson - Wednesday, November 10, 2010 8:41 AM -
2 Votes
Sum Function with INNER Join
It works now.Answered | 8 Replies | 20366 Views | Created by Raptor_45 - Thursday, July 11, 2013 2:47 PM | Last reply by Raptor_45 - Thursday, July 11, 2013 3:44 PM -
0 Votes
Sum Lookup Function does not work as needed
Also this time, were all the expression 2 working as you wanted, right?Proposed | 5 Replies | 1916 Views | Created by Riaon - Tuesday, November 19, 2019 9:53 AM | Last reply by Lukas DreiKlein - Friday, November 29, 2019 9:03 AM -
1 Votes
Lookup Function - Composite Keys
Can this be done as Lookup( "Key B" , (Field B, Field C), "DatasetName") I have a similar ...Answered | 2 Replies | 5449 Views | Created by DataAnalyst - Wednesday, October 5, 2011 10:16 PM | Last reply by Fab_83 - Friday, November 25, 2011 4:51 PM -
0 Votes
lookup function malfunctioning!
Hi sea_lene, According to your description, when Impact_ID in Risk_RemediationPlan matching a Impact_ID from a different Dataset, you want to return all the Reponse_IDs, so you used ...Answered | 1 Replies | 707 Views | Created by sea_lene - Tuesday, August 12, 2014 7:45 AM | Last reply by Wendy Fu - Friday, August 15, 2014 8:48 AM -
0 Votes
function to create 3 variables from1: count, sum, and count/sum
Hello John, A scalar function can only return one result; a scalar value.Answered | 1 Replies | 4926 Views | Created by JohnLawlor - Friday, June 11, 2010 9:11 PM | Last reply by Olaf Helper - Saturday, June 12, 2010 4:48 AM -
0 Votes
problem with sum function in query
Another method to solve this would be to base the join on the two columns and to use CASE expressions to sum only when there is a match: SELECT S.slotid, ...Answered | 2 Replies | 5834 Views | Created by SqlNewbie12 - Monday, November 2, 2009 4:21 PM | Last reply by Plamen Ratchev - Wednesday, November 4, 2009 7:26 PM -
0 Votes
Cascading Lookup - Multi-select functionality
JP, try Bamboo Nation Lookup selector allow to select multiple itemsAnswered | 1 Replies | 5816 Views | Created by Jayaprakash Lingamaneni - Monday, August 10, 2009 12:33 PM | Last reply by G Vijai Kumar - Monday, August 10, 2009 12:39 PM -
0 Votes
Need Help with MDX SUM
[SUMError] AS sum([Measures].Answered | 2 Replies | 1120 Views | Created by PMunshi - Tuesday, November 5, 2013 10:26 PM | Last reply by Elvis Long - Tuesday, November 12, 2013 9:07 AM -
0 Votes
Sum Function for non contiguous selection
For instance a list and than use the Linq Sum expression.Answered | 2 Replies | 648 Views | Created by Gradient127 - Monday, April 13, 2015 4:00 PM | Last reply by ryguy72 - Wednesday, April 15, 2015 9:16 PM -
2 Votes
a report grouping and SUM challenge
After I initially posted the problem I was diverted but am back to this ... working through it again.Answered | 7 Replies | 4820 Views | Created by TRNS - Tuesday, February 19, 2013 2:48 PM | Last reply by TRNS - Wednesday, March 6, 2013 6:11 AM -
0 Votes
SSRS LookUp Function
Hi Harshac, According to your description, you want to return one dataset values which match nothing in another dataset by using lookup function.Answered | 2 Replies | 870 Views | Created by Harshac - Monday, June 6, 2016 8:35 PM | Last reply by Harshac - Thursday, June 16, 2016 9:09 PM -
0 Votes
Lookup Function returning an error
I didn't end up using lookup funtion.Answered | 5 Replies | 2003 Views | Created by SJ_PPM - Sunday, July 14, 2013 8:30 PM | Last reply by SJ_PPM - Thursday, July 18, 2013 12:59 AM -
0 Votes
IIF function together with Parameter and LOOKUP
RC.Value.equals("1"),LOOKUP(Fields!Answered | 1 Replies | 1096 Views | Created by HCMJ - Friday, February 7, 2014 12:33 PM | Last reply by AndrewBorgCardona - Friday, February 7, 2014 1:09 PM -
1 Votes
How to use case when function with SUM function ?
CONVERT(VARCHAR(8),DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0),112) then LEAVE.SUM_DAYS else 0 END) AS TOTALDAYS Vinay Valeti| If you think my ...Answered | 1 Replies | 1021 Views | Created by Caulson - Tuesday, October 22, 2013 2:33 AM | Last reply by Vinay Valeti - Tuesday, October 22, 2013 2:39 AM -
0 Votes
Need help with SUM function on specific position on the CTE table
CASE WHEN pos between 4 and 11 then pos else 0 END and do a SUM for that DECLARE @T AS TABLE ( Pos INT ,Val INT ) INSERT INTO @T SELECT 1, 20 UNION ...Answered | 1 Replies | 790 Views | Created by GarinTiger - Tuesday, December 22, 2015 4:45 PM | Last reply by Harsha Lella - Tuesday, December 22, 2015 5:12 PM
No announcements