SurendraThotaMSBIProfessional

Required : In one of our requirement we need to show the message column as the combination of 4 columns in a Source , But SSRS we need to  show as Single column with  line sepeated of each Source column data . Example Meassage :  in Source Database we have 4 Text Columns with different language 1, NL_Text  2,Fr_Text 3,De_text  4,EN_Text but In report They  need to show as Single column  called Message  like 1 message    : NL_text : blabalabala .......                       Fr_Text : Blablabla.......                       DE_text :Blabla....                       EN_text :Blabla........... Solution :   Concatenate  4 columns in Source by appending some charecter to identify where to have a new line in between the message  . 'vbCrLf  NL Text : ' ||dyn_messagetext.nl_text || ' vbCrLf   Fr Text :' || dyn_messagetext.FR_text || '  as Meassage from Table In SSRS  Put an expression   =Replace(Fields!MESSAGETEXT.Value, "vbCrLf" ,vbCrLf)

Actual Error   :   In one of our new requirement we need to pull data from Excel file and load it in to Sql server table . The Package worked fine when it ran on my machine but when we   deployed the package into development   server and try to run it failed with fallowing error Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". Root Cause   : On further analysis I discovered that one will get the above mentioned error when Microsoft Office 2007 is not installed on the machine where SQL Server 2008 Integration Services is installed. In order to import data from Microsoft Office Excel 2007 file formats such as .xls, .xlsx and .xlsb or from Microsoft Office Access 2007 file formats such as .mdb or .accdb files

Actual issue : when we rendered the SSRS report to WORD format and trying to print the report Then we will get an Error : The Margins of Section 1 are set outside the printable area of the page . Do you want to continue ? Root Cause   : Most printers cannot print all the way to the edge of the paper, because of physical limitations in the way that the printer handles paper. If you set your document margins or section margins closer to the edge of the paper than your printer is capable of printing, Microsoft Word returns an error message when you send your document to the printer. Reslution : The easiest way to avoid this issue is set the margin of your report a little big. I have tested it on my test environment. If I set the margin to 0.1in, then the issue appears, when I set the margin to 1in, the issue disappeared. Select Report in the Properties window, and set the margin to 1in.