Microsoft Dynamics AX (Archived)

How to to add dynamic columns in SSRS report

(0) Share

Report

Posted on by @rp@n

Dear All,

As per customer requirement I need to add dynamics columns in SSRS report.
Please give me more shed on this.

Thanks!

Arpan Sen

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

@rp@n 30 on at

Like (0)

Report

Thanks Crispin

I think this is not a proper way to do. Shall i do by Matrix?

Thanks!

Arpan Sen

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

Thank u np.

Was this reply helpful? Yes No
Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

If you need some help from us, you should first explain what you mean by "dynamic"? Assuming you want to add extra column based on some logic, what the logic would be?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Dear Arpan,

You better try with LayoutTemplate. it may work

Thanks,
Suresh

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

Thanks Suresh

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report

Matrix and tablix report are probably your best option with SSRS - but as Martin said it would help to explain what you are trying to do i.e. what does dynamic mean in your case - and maybe you should instead use Atlas, or Power Bi.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

Thanks Magic,

Here dynamic columns means for example :

If user put value 10 in dialog

then in report it should print 10 customer account based on value.

Please give me more shed on this.

Thanks!

Arpan Sen

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report

Then it sounds like you looking to filter the report data by a parameter.

You can use ranges or add a filter. A filter works on the client side and operates on the flattened data. Filters must be used cautiously and must not be considered as an alternative for a query range because .the system fetches the whole data from the datasource, after which it then applies the filter/

The data needs to be restricted only to a certain data region and not the entire dataset.

A new parameter can be added to a dataset through a query.

When a dataset is linked to a query, then the parameters are automatically created from the fields that are added to the Ranges node in the AOT query.

e.g. on the filters node of the CustTransTable you might create a new filter and nn the new filter node, set the fproperties e.g.:

Name CustGroup

Value =1

Expression =IIF((Parameters!CustGroup.

Value=Fields!CustGroup.Value),1,0)

The data region displays only the data for which the expression evaluates to 1.

,Select preview and activate the parameters tab. The parameters that were added are visible along with the standard parameters. Verify the parameters through the report preview.

The deployed report dialog will provide a parameter field for CustGroup for you to enter a value.

If this does not make sense to then you need to buy a manual, or speak with a consultant.

these links may help

msdax.wordpress.com/.../how-to-set-the-query-range-on-a-ssrs-report

community.dynamics.com/.../186009

blogs.msdn.microsoft.com/.../how-to-specify-range-values-on-a-query-in-a-ax-ssrs-report

technet.microsoft.com/.../aa337401(v=sql.105).aspx

It is possible to allow more parameters to be added by the user through the query framework. To enable this, set the Dynamic filters property to Yes on the datasource node

(You can also use a parameter that is not linked to the dataset but is needed for the purpose of reporting. Such parameters are referred as unbound parameters. These are parameters tare added manually and are typically used for the purpose of formatting or calculating methods.)

Was this reply helpful? Yes No