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!

  • Congratulations Mike Lewis 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. Nesy123456789

    DISTINCT MDX

    Check out the link: http://thavash.spaces.live.com/ it is in R2 2008.
  2. Nesy123456789

    DISTINCT MDX

    cheers I'll have a go. By the way - do you know how the 2008 sparkline handles this? Will it generate dupes?
  3. Nesy123456789

    Expression to loop rows

    You can add an additional field to be displayed by your stored procedure which does the calculation then add this field to the table as an ordinary column. The "over partition" function should help you here. e.g in proc: Select state, ((Sum(age)/(Sum(age)))* 100000) over (partition by state) as...
  4. Nesy123456789

    DISTINCT MDX

    I have a dataset in Reporting Services 2005 which has fields from two cube dimensions.The first dimension has summary data and is displayed in a table- e.g Company Number, total sales, etc. The second dimension has info across time periods - e.g. Company Number, weekly sales, weekNumber. I want...
  5. Nesy123456789

    Convert Date query

    Can you confirm the report parameters are datatype datetime, and the datatype of CR_HISTORY.DateStart column ?
  6. Nesy123456789

    extra blank rows in matrix

    I'm looking at the proc, but are there any other possibilities I can look into, such as editing the report xml / code-behind etc? Or some kind of cheat like placing additional textboxes with 'A','B' or 'C' and hiding/showing if =Fields!type.Value doesn't have 'A','B' or 'C', or using new...
  7. Nesy123456789

    extra blank rows in matrix

    in Reporting Services - Is it possible to add extra rows in a Matrix containing blank data? The row group is filled from a dataset (which is filled by stored proc). e.g the row group expression is: =Fields!type.Value My problem is the Type can be 'A','B' or 'C' in any combination eg. some rows...

Part and Inventory Search

Back
Top