▼
Showing posts with label SSRS reports. Show all posts
Showing posts with label SSRS reports. Show all posts
Sunday, August 22, 2021

How to add ranges in SSRS in design level

›
 Hi, In the Tablix property of the grid we add the filter in any rages. NOTE:  1. All the operator are common and except  < > . This ...
1 comment:
Wednesday, July 14, 2021

Alternative row colors with different scope in SSRS

›
 Hi, Alternative colors without any scope or condiction. =iif(RowNumber(Nothing) Mod 2, "#ffffff", "#f0f0f0")  Alternati...
Monday, December 2, 2013

The SQL server reporting Service service is running -SSRS 2012

›
Solution for this error:  The deployment was cancelled because of an error: On the reporting server, |Verify that The SQL server rep...
Tuesday, November 26, 2013

How to give null/ space if the values is zero in SSRS 2012

›
Hi,  Just enter the syntex as expression for SSRS =iif(Fields!FieldName.Value > 0,  Fields!FieldName.Value,  space(0)) Regards,
Monday, September 23, 2013

Job to save the SSRS in PDF at given location in Dynamic AX

›
Hi, static void SaveSSRSasPdfCode(Args _args) {      SrsReportRun srsReportRun;     srsReportRun = new SrsReportRun("ReportName.P...
Sunday, September 22, 2013

Job to run reports without knowing the used class names in Dynamic AX

›
static void PrintSSRSthroughCode(Args _args) {     SrsReportRun srsReportRun;     srsReportRun = new SrsReportRun ("ReportName.Prec...
Thursday, September 19, 2013

Validate the contract class or SSRS parameter from code level before printing

›
Just add below code in contract class so that mandatory  fields like date fields can be validated by throwing the warning. public boolea...

Tablix headers not repeating in SSRS

›
Hi, To repeat tablix header through out the ssrs (all pages) 1. In the grouping pane, make sure to turn on advanced mode (click on the sm...
Monday, September 16, 2013

what is the difference between Hidden and Internal in Parameter visibility ? in SSRS

›
Hi, let me say you Develop a Report which has a parameter as  User!userID.Value ( Named as EmployeeID in Reports )  to Filter your Data ...
Wednesday, August 28, 2013

Job to run the DP class in Dynamic AX

›
static void Job2runDP(Args _args) {     TenantBalanceDetailsTmpTbl TenantBalanceDetailsTmpTbl; //temp table name     Query q;     Tena...
2 comments:

Company image in SSRS 2012

›
1. Create a field as Companyimg in the temp table 2. In the properties of that field select the extended datatypes as "Bitmap". ...

Alternative color in SSRS 2012

›
Write in the expression in SSRS =iif(RowNumber(Nothing) Mod 2, "White", "WhiteSmoke") or use =IIF(RunningValue(Fie...
Tuesday, August 27, 2013

Complete company name as expression in SSRS 2012

›
Expression in SSRS =Microsoft.Dynamics.Framework.Reports.DataMethodUtility.PostDataMethodEvaluation(Microsoft.Dynamics.Framework.Reports....
1 comment:
Wednesday, August 7, 2013

Debug the report in AX 2012

›
Hi static void AlfasithDpDebug(Args _args) {     NQ_smmActivitiesDP    NQ_smmActivitiesDP;     NQ_smmActivitiesDP   dataprovider ...
Wednesday, July 24, 2013

How to add multiple parameter in to SSRS report as Query range in Dynamic AX

›
Hi, Adding the fields in the Contract directly reflect on the parameter fields in the report dialog. Adding the QueryBuildRange and its d...

Cross row manipulation of SSRS reports 2012

›
Hi, Cross summation or manipulation in SSRS reports. Consider the below image has credits and debit, The Balance is calculated by  ...
Tuesday, July 23, 2013

Change company in Dynamics AX 2009

›
Hi,  In Microsoft Dynamics AX Axapta, sometimes, we can to insert/update/delete records in different companies or insert/update/delete...
Wednesday, July 17, 2013

Save the SSRS report as pdf or print it through code in Dynamic AX

›
Ax 2012 Reports (SSRS) Print Utilities This article gives the examples, to print the reports of Dynamics Ax 2012 (SSRS Reports), in diffe...

UI Builder class in Dynamic AX

›
UI Builder class   Today i will share how to give a filter lookup using an UI Builder class.                                            ...
1 comment:

RDP Class in Dynamic AX

›
Style 1. [ SRSReportQueryAttribute (querystr(CustTableQry)), SRSReportParameterAttribute(classstr(CustContractClass)) ] class CustTa...