none
Report Builder 3.0 Dataset Parameter RRS feed

  • Pergunta

  • Hi,

    I need to pass a set of data as a parameter to my dataset, because all my filters are gathered outside the report.

    I wish to pass a parameter like this:

    {[CLIENTE].[SEGUIMENTOS].[SEGUIMENTO].&[DISTRIBUIDORES / ATACADOS]},{[VENDEDOR].[SUPERVISORES].[SUPERVISOR].&[GERENTE DE VENDAS]}

    So I could use in the Where() function in my MDX query.

    I tested the MDX with this parameter and it works.

    So I added a @Filtros parameter to my dataset query, but It throws an error saying that it was expecting a tuple set and instead recieved a number or a string.

    My Query:

     SELECT 
    	NON EMPTY { [Measures].[FAT] } ON COLUMNS, 
    	NON EMPTY { 
    		([PRODUTO].[CLASSES].[PRODUTO].ALLMEMBERS * [Time].[Time].[Quarter].ALLMEMBERS ) 
    	} 
    	DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS 
    FROM 
    	[SCA] 
    
    WHERE(@Filtros)
    
    CELL PROPERTIES 
    	VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

    Thank you.

    sábado, 3 de março de 2012 22:23