Saturday, February 25, 2012

Reporting Services Data Extension - Passing Report Parameters

I have created a custom data extension.

I am using this custom data extension from BI Studio.

Que1: I want to create report parameters from BI studio and capture them in my Data Extension.

Que2: Every report parameter has so many properties, like hidden, internal, default value etc, how do capture that information in my data extension, the parameters only give me name and value.

Que3: I know I can capture command Text. So My command can be Select * From tablename where fieldname= @.myFieldname. Once I get this commandText in my data extension, How do extract parameters of the command?

Que4: If I have any custom attributes in my RDL file, Can I capture them in my Data Extension ?

Any help is appreciated...

Anybody, Any suggestions, please.....

No comments:

Post a Comment