Today I have to record very small tip. During development of on SSRS report for Dynamics Ax 2012 R3, End user wants a row at the report footer for analysis. he wants some kind of percentage calculation with '%'. A For this I have to use CStr ssrs expression function like Ctr(((sum(DataSet!field.Value) / … [Read more...] about float value conversion in string SSRS expression and decimal points SSRS dynamics ax 2012 R3.
Sql server reporting services
Hi, all very small tip today, Recently I have to add water mark in one of custom report. In SSRS for Dynamics Ax 2012, we can achieve water mark by adding background image in report body. Water mark image should be small in size and used as background Image. If you use high in size image, Report will threw errors on deployed at server. This water mark can hide and show … [Read more...] about water mark in SSRS report Dynamics Ax 2012.
I was configuring Dynamics AX 2012 R3 reporting extension on one of Virtual machine. Here is my notes with step by step screen shot. First step to run step up and then add or modify component option. Click on next button and select reporting extension form Click on next and from next window click on Validate it, if any component is missing then … [Read more...] about Step by Step guide to install Reporting extensions (SSRS) for Dynamics Ax 2012 R3
During SSRS report for Dynamics Ax 2012, I found that when report goes on multiple pages, column header did not appear all page except the first one. I fix this problem by setting some properties to true. Select the tablix and below right side of columns group header and click there on small arrow head and select the advance Mode. This will open … [Read more...] about Repeat the column header row on every page Tablix SSRS dynamics Ax 2012
Recently I update my dynamics Ax development Environment by restoring Database from Production Dynamics AX Db. After the restoring the database, when I run any SSRS report form Dynamics Ax, it starts to give error "Only integrated security is supported for AX queries." The reporting Services are working perfectly other than Dynamics Ax reports. One way to apply the … [Read more...] about Dynamics Ax 2012 : “Only integrated security is supported for AX queries.”
Too the point, opens your Reporting Services project in BIDS and add report menu. The database is used in report can be download from here http://tsql.solidq.com/books/tsqlfund2008/ Select new report like as After creating new report you have to add new dataset form data source panel. In Dataset Properties window you have to use dataset from … [Read more...] about Drill Down Report SSRS with the Visibility Property