Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Trybbe
  • Content: Threads
  • Order by date
  1. Trybbe

    Using Case in a where clause

    Hi May you please help with the query below I am at odds as to what the problem is, it fails on a case statement at the end of the query Declare @StartPeriod Numeric(18,0), @EndPeriod Numeric(18,0), @Consolidate Varchar(200), @TransferType Varchar(200), @EEOccupLevels Varchar(200) Set...
  2. Trybbe

    Dynamic Rows in Matrix SSRS 2005

    Hi Guys Is it possible to have the values of a matrix row change based on parameter values? Where your default value would be all regions but when a user select a particular region you display all areas under that region. I wrote something like this on the expression area of the matrix row...
  3. Trybbe

    Using InScope function

    Hi I need help please I would like to create a drill through on my matrix data region. Currently I have managed to drill through on any of the matrix cells but I'm not winning with totals. So I've been searching for solutions and many seem to suggest the use of InScope function. Now I have...
  4. Trybbe

    Calculation Percentage

    Hi! Guys Please Help I need to calculate percetages of my employee transfers Grouped by gender and race. I have a query that goes like so: SELECT Cast(COUNT(EarningRange)as Float) AS ER, Race, Gender, CASE WHEN TransferType = 'TransferIn' THEN 'Transfers' END AS HeadCount FROM...

Part and Inventory Search

Back
Top