Tags » SSRS

SSRS Report UI Builder Class sample code

UI Builder class will be very useful class for the ssrs reports based on selection of parameter selection values will differ from field to field. 792 more words

Ax2012

SSRS DP class with Contract and Query

DP Class 
Class Declaration :


class FOFS_PendingPORDP extends SRSReportDataProviderBase
{
FOFS_PendingPOTmp tmp_FOFSPendingPO;
FOFS_PendingPOAgeingTmp tmpPendingPOAgeing;
}

Get Report table buffer :


public FOFS_PendingPOAgeingTmp getAgeingData()
{
select * from tmpPendingPOAgeing; 909 more words

Ax2012

SSRS report Contract and DP sample

Here i am giving some more additional Contract class methods and DP class sample codes

Contract class 

Class declaration method

/// <summary>
/// Data Contract class for FOFS_POCostFactorInvoice SSRS report… 469 more words

Ax2012

SSRS Report by using Controller class sample code

Contract Class : Here I am passing an Account number as a parameter

Class Declaration :


class FOFS_POTermsAndConditionsContract
{
AccountNum account;
int64 tablenumber;
SalesId salesid; 501 more words

Ax2012

Adding message body text to email destination for reports

I had a request from a customer and did a little investigation into it. They wanted to be able to send an ah-doc report to a customer via email. 205 more words

Infrastructure

Modify Controller Class for Query Based Report SSRS

public void prePromptModifyContract()
{
    //add a range in the report query  
      SrsReportHelper::addParameterValueRangeToQuery(this.getFirstQuery(),tableNum(SSRSReportDemo),fieldNum(SSRSReportDemo, RecId),SysQuery::value(this.parmArgs().record().RecId));
}

source : https://community.dynamics.com/ax/b/dynamics101trainingcenterax/archive/2014/01/30/using-controller-class-in-developing-ssrs-reports-in-microsoft-dynamics-ax-2012.aspx

AX 2012

SQL Server : SSRS Error

Sometimes when you open SSRS reports in internet explorer for the first time it may throw the error message below:

This page might not function correctly because either your browser does not support scripts or active scripting is disabled… 70 more words

Reporting Services