Forum Replies Created

Viewing 15 posts - 16 through 30 (of 85 total)

  • RE: Calculate the Running Total for the last five Transactions

    stephenejones1960 (4/19/2014)


    Thanks for the code. I just have a general question: Does someone know how to change the code so that the five items can be multiplied, instead of added?...

  • RE: How to select this

    surindersinghthakur (5/20/2013)


    Below are sample tables and sample date, please help

    --create table c (c_id integer, p_id varchar(10))

    --create table f (c_id integer,f_id integer,e_dt date,amt_gross integer,amt_matched integer)

    --create table bf(bf_id integer,actual_dt date,c_id integer,p_id varchar(10))

    --create...

  • RE: The Cascading (CROSS) APPLY

    ChrisM@Work (4/22/2013)


    Divya Agrawal (4/19/2013)


    DECLARE @T TABLE (auditlogid int, userid int , auditlog varchar(max))

    INSERT into @T

    select 1,1,'ProgramCompletionStatus - ProgramNotCompleted, '

    union all

    select 1,1,'InputValidationStatus - Success, IsValidUserID - Yes, IsValidProgramID...

  • RE: The Cascading (CROSS) APPLY

    DECLARE @T TABLE (auditlogid int, userid int , auditlog varchar(max))

    INSERT into @T

    select 1,1,'ProgramCompletionStatus - ProgramNotCompleted, '

    union all

    select 1,1,'InputValidationStatus - Success, IsValidUserID - Yes, IsValidProgramID - Yes, ...

  • RE: The Cascading (CROSS) APPLY

    If there is a csv column having different number of comma's in it, how would CCA help in it. In the examples provided by you we can split a csv...

  • RE: The Cascading (CROSS) APPLY

    Great post!! thanks for sharing..it is really very useful

  • RE: SSRS 2005 Multi-Value Filter.

    10e5x (1/14/2013)


    Hi all,

    I met with a very tricky problem. I have a muti-value filter in my name whereby user are able to select the names to view the report. The...

  • RE: Need to add % sign for only few rows

    vandana_j79 (1/18/2013)


    Hi

    I have SSRS (2008) Report which

    line ...

  • RE: Date Range filter in Performancepoint 2010

    prabhakarannsn (9/18/2012)


    Hi Divya,

    I tried with the 'time intelligence post formula filer' as per the above link.

    The date filters are exist in the dashboard, but the data are not reflected in...

  • RE: Date Range filter in Performancepoint 2010

    prabhakarannsn (9/17/2012)


    is there any method to implement date range filter( fromdate and todate) in performancepoint 2010?

    I can implement the same in SSRS reports but can't in performancepoint 2010.

    As compared to...

  • RE: Subtotal for cloumn group only showing first value

    AnyHelpAppreciated (9/14/2012)


    Thanks for your reply.

    I think you are using VS2008, as my screen doesn't look like yours - I'm using VS2005. I don't have all those options in the...

  • RE: Subtotal for cloumn group only showing first value

    AnyHelpAppreciated (9/14/2012)


    I can't access the greyed-out cell underneath 'Total' to put an expression in it, it's automatically generated when I click on 'Subtotal'. Yes, I'm using a matrix to display...

  • RE: Subtotal for cloumn group only showing first value

    AnyHelpAppreciated (9/13/2012)


    Anyone who can help?? I just need a simple SUM of the values in each row. I thought that the built-in subtotal function would be fine.

    Here's what my matrix...

  • RE: Hide multiple Columns based on Parameter value in SSRS 2004

    yudy.varma (9/14/2012)


    Thnks divya..its working

    I am glad it helped you 🙂

  • RE: Hide multiple Columns based on Parameter value in SSRS 2004

    Divya Agrawal (9/13/2012)


    yudy.varma (9/1/2012)


    Can anybody tell me how to hide/show multiple columns based on multivalued parameter.

    ex :i have two parameters

    1)item

    2)option(multivalued - ven,itm,qty) and values are (venr,itm,qty).

    i have...

Viewing 15 posts - 16 through 30 (of 85 total)