The SQL database has issued an error. SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]String or binary data would be truncated.

Make sure to update the following EDT properties of Name and Txt fields on the table.
Name —> DirPartyName

Txt — > ItemFreeTxt

Advertisements

Page Total and Running Total in SSRS AX 2012

In SSRS Reports, you can easily make use of running totals on every page of your report. SQL Server Reporting Service does not have a standard functionality for this.  Here I will explain how you can implement running totals in your report.

  1. Add a tablix to your report and add a dataset to it. In my example I have 3 columns:
    Debtor code, Account Name and Outstanding amount.
  2. Add a 4th column to the tablix. Set the visibility of this column to Hide.
  3. Select in the 4th column the detail row. Select Text Box Properties and change the name of the textbox to ‘RunningTotal’.
  4. Select Value and press the expression button. In this expression we will define the running total of the column. In my example, I have a columns Outstanding from the dataset ‘CreditLimitDetails’

    =RunningValue(Fields!Outstanding.Value,SUM,”CreditLimitDetails”)
    Now we have a running value of the outstanding amount in the 4th column.

  5. To display the running value on every page, we will use the page footer.
  6. Add a page footer to your report. In BIDS you can select, Report, Add Page footer.
  7. In this example I will add a page total and a running total to the report.
  8. Insert a 2 text boxes to the page footer.
  9. Open the expression definition of the first text box. In this text box we will define the totaal outstanding amount of the current page.
    =”Page Total: ” + cstr(Sum(ReportItems!Outstanding.Value))
  10. Open the expression definition of the second text box. In this text box we will define the Running total of the outstanding column of the current page and all previous pages.
    =”Running Total: ” +cstr(Last(ReportItems!RunningTotal.Value))

Now your report will print running totals at the bottom of every page.

SSRS White Space due to Hidden Column ?

I have few SSRS Reports that is show/hide columns based on the parameter. Some time you may get White Space due to hidden column. The reason behind the white space is, The design which you made you are changing the HIDDEN property to Header and Data Row. It means you made hidden only Header and Data row. But you can see the Tablix row at the top of your Header and Data row which is in Grey Color. So right click the particular Tablix Row and Custom Invisible Property Set True or False.

Drillthrough Report in SSRS

Hi Guys, Have a Good Day!. Hope you are doing Good.

Today I’m going to share you how to developDrillthrough report in SSRS.

Confused ?

Don’t worry. Let me explain in short manner. Drillthrough report is a report that user can opens by clicking a link within another report. For example, We are listing All the Vendors and want to iterate vendors to all of his Purchase Orders and to their Purchase Order Details.

CONCEPT1

For more Details DrillThrough Reports in SSRS

We are going to illustrates the following tasks:
• Creating a Report Model project. 
• Creating reports 
• Vendor list 
• Purchase order list 
• Purchase order details 
• Providing drill-through action under designs 
• Saving the report to AOT and deploying it to the Report Server.
 Continue reading 

Developing a Simple SSRS Report in Visual Studio

Hi Guys , I hope you are doing Good..  🙂

Today i am gonna show  SQL Server Reporting Services (SSRS ) development for Dynamics AX. Here i’m going to demonstrate how to develop a simple SSRS report.

Before going to SSRS development , I would like to explain the importance and usage of SSRS in short manner.

SSRS provides a full set of tools to develop various kinds of reports, manage them, and deploy them to multiple environments. It also provides an independent user interface where users can see all the reports and run them, or administrators can control security permissions for other users.

Microsoft SQL Server reporting services are used now for Microsoft Dynamics AX 2012 reporting requirements. All reports available in AX 2012 are based out of SSRS, and use a rich variety of capabilities available in standard SSRS.

Continue reading