reporting-services

Reports are blank in Safari and Chrome

by

Ultimate solution (works in SSRS 2012 too!) Append the following script to the following file (on the SSRS Server) C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\js\ReportingServices.js function pageLoad() { var element = document.getElementById(“ctl31_ctl10”); if (element) { element.style.overflow = “visible”; } } Note: As azzlak noted, the div’s name isn’t always ctl31_ctl10. For SQL 2012 tryctl32_ctl09 and for … Read more

Creating Reports in ASP.Net with Entity Framework

by

Below is a quick sample of how i set the report datasource in one of my .NET winForms applications. public void getMyReportData() { using (myEntityDataModel v = new myEntityDataModel()) { var reportQuery = (from r in v.myTable select new { l.ID, l.LeaveApplicationDate, l.EmployeeNumber, l.EmployeeName, l.StartDate, l.EndDate, l.Supervisor, l.Department, l.Col1, l.Col2, ……., ……., l.Address }).ToList(); reportViewer1.LocalReport.DataSources.Clear(); … Read more

Open Source .Net Reporting Tool [closed]

by

fyireporting (released under Apache License) is worth a try. The fyiReporting RDL Project is a powerful report and charting system based on Report Definition Language (RDL). Tabular, free form, matrix, charts are fully supported. Report output may be displayed as HTML, PDF, XML, .Net Control, Web Archive, and to a printer. Libraries exist for use … Read more

Listing all Data Sources and their Dependencies (reports, items, etc) in SQL Server 2008 R2

by

The following (which was modified from what beargle posted earlier) does what I was looking for. This will list all the data sources by their actual name, and all their dependent items: SELECT C2.Name AS Data_Source_Name, C.Name AS Dependent_Item_Name, C.Path AS Dependent_Item_Path FROM ReportServer.dbo.DataSource AS DS INNER JOIN ReportServer.dbo.Catalog AS C ON DS.ItemID = C.ItemID … Read more

SSRS – Changing tab name when exporting to excel

by

You need to set the PageName of the Tablix Member (group), NOT the PageName of the Tablix itselfs. If you got the right object, if will say “Tablix Member” (Tablix-Element in German) in the title box of the properties grid. If it’s the wrong object, it will say only “table/tablix” (without member). Also, be advised … Read more

ReportViewer Control – Height issue

by

This is the way I fixed, take a look <div style=”Width:auto;”> <form id=”form1″ runat=”server” style=”width:100%; height:100%;”> <asp:ScriptManager ID=”ScriptManager1″ runat=”server”> </asp:ScriptManager> <rsweb:ReportViewer ID=”rptViewer” runat=”server” Width=”100%” Height=”100%” AsyncRendering=”False” SizeToReportContent=”True”> </rsweb:ReportViewer> </form></div> The thing doing the magic is AsyncRendering=”False” SizeToReportContent=”True” the rest is basic HTML. The report will be displayed as it was designed. There might be some … Read more

Easy way for Crystal Reports to MS SQL Server Reporting Services conversion [closed]

by

I have searched previously for this, with no luck. There does not seem to be any tools available for this conversion, the manual method thereby becomes the only method. And yes, there are consulting firms who will do the manual work for you, but they still do it manually. Crystal Reports and Reporting Services have … Read more

Copy and paste a table (tablix) in SSRS

by

You are likely getting the error message Report Builder was unable to paste successfully because somewhere in the grid there is a cell that uses Custom Code From the Report i.e. you cannot copy a textbox with this custom code: “Code.MyCustomeCode()” – Report Builder was unable to paste successfully This has been a reported bug … Read more

tech