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 gkittelson 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: *

  1. Trybbe

    Using Case in a where clause

    Hi Borrisov Thank you for the answer it worked well, I achieved the desired results
  2. 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...
  3. Trybbe

    Dynamic Rows in Matrix SSRS 2005

    Sorry for not being specific, that's for SQL Server Reporting Services 2005
  4. 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...
  5. 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...
  6. Trybbe

    Calculation Percentage

    Hi! Thanks for the reply The problem is that Earningranges is a text field which states the pay range of the employee hence I first need to count then use the results. Witha that in mind I have decided to create a table from this query then use the resultant table to do my calculations...
  7. 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