Recent update: 2008-3-21
In SQL Server Reporting Service SP2, Microsoft added a new feature to print reports directly in client side by adding an activex control. It is very nice! However, I encountered a problem that, this control can not print reports with my dotmatrix printer (Epson LQ1600K), it is always in double ...
Sorry im very new! I have been using RS2000 and VS 2003 to create an asp.net page in C# to display a report from Reporting services in another application. I have this working but had a few questions: Firstly how do i hide the tool bar showing only report content? Can i do the same to the ...
512 byte By
St3veM at 2008-3-5
Hi All, I have a report I've designed in Visual Studio (Business Intelligence Module) where I have a drop down that I have a couple of values in, but I want to be able to select various combinations of those values, but can only select one at a time.What I'm trying to achieve is a list with a ...
Hi folksI uploaded my report project ( http://....../reports/). Now (online) when I go into the folder and click on one of my reports to view it ... It fails. There is just the loading, blue line on the IE bottom but its NOT finishing loading (I have a blank/empty site).What can I do to view it ...
My main report has a detail section that contains a subreport. We are wanting to see all parts for a given customer with a good bit of detail for each part (hence the subreport instead of a list). I need to find a way to pass the part number from a dataset in the main report as a parameter to ...
Will a Report viewer control be available for WinFoms applications that are created in Visual Studio 2003? We have a large project that would like to utilize SQL Server 2005 and the WinForms Report Viewer control for local reports, but not want to have to recompile the project at this time to ...
Is there a way that you can save your report to PDF,HTML or any prictureformat. I have a windows verision and want to distrubute my report. /Anders
Will Microsoft be providing a tool with General Release of Reporting Services that will allow any conversion of existing Crystal RPT files into RDL's? Thanks, Jeff
If I Group on =MonthName(Month(Fields!CreatedDate.Value)) I group my Report on Month. How can I group it by Quater. /Anders
Rajeev please help, I think I have found a bug in .Net.If you look at my other recent post you will see the code I am using to bind a report to a datatable in ASP.Net via an ObjectDataSource, which works for the master report. Using exactly the same code to create the ObjectDataSource, but ...
Has anyone gotten images to work (external or embedded) in a locally hosted report in ASP .Net 2.0. I am using the report viewer control and locally defined report. I would prefer an external image, but I can't get either to work. No matter what I put for the value, the image path in the ...
HelloI need help with the reportviewer in ASP.net.I have a .rplc file and a DataSet. I try to do this in Form Load ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local; ReportViewer1.LocalReport.ReportPath = pathToRPLCFile;//in my window form i do this linesDataSet ...
Can i create a report project to store all of the embedded reports? I tried a library project, could not make it work. It says cannot find the report definition.
I am trying to bind a report to a datatable (or dataset) in asp.net. The only way I can see is via an ObjectDataSource (unlike windows where I can bind direct to the datatable). Is this the case, is it not possible to bind direct to the table or dataset?Assuming we have to go through an ...
453 byte By
sam at 2008-2-20
I am making report in Excel by retrieving the data from MS Accesss using VB.NET.I want the name should be displayed in the Title Bar.The code I have used there is not working.Dim table_name As String = _ dr_table("TASK INFO").ToString Me.Text = "MDBAnalyzer: Task Info" & table_na...
Hiya guys,This is probably going to sound like a stupid question, but I have got an access database that I created, with lots of reports already created.Im now using Visual Studio 2005 B2 (VB.NET) to re-create a front end to my dataset. ( Im a new user to VB.NET and its my first programming ...
1575 byte By
JG67 at 2008-2-20
I am trying to set up a Local report with a bindingsource that has been sorted and filtered in a specific way. However when the reportviewer renders, all rows in the data table are shown without any sort applied. Am I missing something? Here is roughly what I am doing...ReportDataSource ...
113 byte By
AlSoft at 2008-2-20
Is there any changes regarding Report Controls in the June Comunity preview comparing to Beta2? Should I try it?
530 byte By
Hozefa at 2008-2-19
Hi I have created a report using sql reporting services 2000 and have deployed it on the server. I have given rights to certain users to view my reports, now when that user tries to access my report he gets error like thisCannot create a connection to data source 'Dev_Local'. ...
how datareports can show the images stored in ms access in binary format how it is possible
I have a locally hosted report in an ASP .Net application. I am rendering this report to a text stream so that I can send it via email, but I think there is probably a better way to do this. What is the best way to programatically email a locally hosted report?
I haven't been able to figure this one out. I have an object that has hierarchical data, such as the following: public class ClientFile { public ClientFile() { _applications = new List<Application>(); } public ClientFile(string clientFileID) : this() { _clientFileID = clientFileID; } ...
Hi Rajeev,Outside of the LocalReport class are there any other classes/controls which process and render RDL locally? The LocalReport class does everything I want for it to do, except that the rendering formats are pared down somewhat. I am interested in being able to export in HTML format ...
I created a ReportViewer from the toolbox. I then proceeded to create a form that contains a single bar chart. At this point, I created a very simple class: class ChartData { public int Param1 { get { return 1; } }}I then added this as a data source by selecting "Object." From the Data Sources ...
I have seen similar information on some other posts, but not specifically this question. Sorry if this is a re-post. Is the report viewer control (and the LocalReport class) freely redistributable? If not, what is the licensing agreement? Thanks, Ken
I am planning to employ a LocalReport object in a .dll I'm writing which will be used to render reports. Is the LocalReport class going to support the same output formats that Reporting Services does? I do like the myriad of output formats (PDF, Excel, CSV, XML, Tif) that Reporting Services ...
I understand that Report Server supports role-based security such that users in the different Windows user groups have certain rights with reports. In addition to role-based security, I'm investigating Reporting Services 2005 to see if it suits our needs to providing user-based security in ...
My VB .Net Windows application using SQL Reporting runs fine on my development machine. But when I deploy it to a user's machine and try to run a report, I get the message:Could not load file or assembly Microsoft.ReportViewer.ProcessingObjectModel.dll This file is in the GAC on my machine, ...
Am moving crystal reports to reporting services in anger. Am discovering the following points as I go along that may be interesting to others doing the same. If anyone knows something I have said is wrong, or wants to add a useful tip please feel free to comment as I am hoping other new RS ...
353 byte By
albnig at 2008-2-14
Hi Rajeev,another little question... what about the wonderful reporting tool embedded with access? it seems to me amazing that microsoft has forgotten it for so many years.. no way to reproduce it in .net version, right? It was the best reporting tool I have seen in the planet, and this many ...
In Visual Studio .Net 2003, you could preview a report in design mode by clicking the Preview tab. There is no Preview tab in 2005 Beta 2 or no similar menu options. Is there a simple way to preview a report in design mode without having to run the application? I am working in a VB .Net Windows ...
As far as I can tell to add a parameter to a report in a VS project you should go to report menu / Report parameters. Here you can add the parameters. I am using the june ctp. When I go to the menu and select Report parameters i get an error 'Exception has been thrown by the target of an ...
466 byte By
albnig at 2008-2-12
Hi Rajeev,what I am trying to do is put into a database something like a html page (with no external file like images of course) and render it on a report. This works well with gridview thanks to the property "htmlencode" set to false in the right cell. But when I print the same field in local ...
370 byte By
jlo at 2008-2-12
Everytime I create a report, I have to go into each text box in the layout format and change the font, size, color, and alignment for each text box. I have tried going into Tools --> Options --> Fonts & Colors but it does not change. The defualt that is shown is not even the defualt that shows in th...
437 byte By
Anika at 2008-2-11
Hi,I can not able to add parameter value in my local report. I have setup in the report(Report->Report Parameter) then the error come like this "An attempt was made to set a report parameter 'variable name' that is not defined in this report".I also defined parameter variable in my code ...
Hi allI'm very new to Reporting Services in general. I have played with some samples and even successfully created my own custom Data Processing Extension. Though with some troubles, I managed to published some reports to the Report Server using this Data Processing Extension.However, I wonder ...
I have an ASP .Net 2.0 application that uses the report viewer control for local reports. This works perfectly on my development machine, but when deployed to an ISP, I initially get an error that the Microsoft.ReportViewer.Common assembly is not found.I can bypass this by deploying the ...
Hi!I'm facing what I think is a strange bug in ReportViewer control.I using a server report, it opens without problems on the ReportViewer in my WinForms app.But there are 2 strange things: the print button is disabled and the printpreview dialog does nothing.Does anybody know something about ...
464 byte By
albnig at 2008-2-8
Hi,I'm using VS 2005 beta2 and sqlserver express april CPT. When I open a new rdlc file, I can see the report designer working well but no panes. So I can't preview the data... any ideas? I'm working in webforms.. I wish to view the report with a hyperlink on an aspx page.. how can do that? ...
I definitly need an example of how I can allow ASP.NET client (Internet Explorer) to print a report. There were some references to EMF format, but I don't see any export option for that, and even if that was there - how can I use EMF to print local report without third-party controls?
I am trying to add a local report to my ASP.NET 2.0 app.When I create new datasource in VS report designer it always creates SQL Datasource (it doesn't even ask me about the name of the dataset).I am going to use my business objects as a source of data, so it would help to be able to use them ...
15745 byte By
respag at 2008-2-7
Hello I have created a simple web application that uses the new ReportViewer control with a local report. The application has a DropDownList and I want that when I select an item in the combo, the report changes according the value selected. The report use a DataSet with an select parametrized ...
I have a report on a server under a folder. In setting up the ReportViewer control, I set the report path to "[folder name]/[report name]". When I ran this, I got the following exceptionThe path must be less than 260 characters long and must not start with slashIt turned out that the path in ...
I have a report that takes in 4 dates, and everything is working great in the report manager. Viewing this report in a ReportViewer control, however, is a bit different. I understand that the date picker is not supported, and that's not a problem for me at all. However, when I run the report, ...
Hi,I have a problem to showing parameter values in my report for exampel (From Date and To Date).I define public property in my code but i am not able to show these values in my report. Public Class StatisticsFormPublic fromDate As DateTimePublic tilDate As DateTimePrivate Sub ...
Hi, I need to create a custom control (User Control) in Visual studio using "Chart", "Matrix" and "TextBox" controls of Reporting services. Which CTP version of Visual Studio supports for solving the above issue. Thanks
Can you point me in the direction of how to create and populate a SubReport? Why does the footer not display at the bottom of the page?
I'm trying to put the column name on a matrix in Reporting Service wiht sql server 2005, but i can't...The example behind: Jan Feb marCH jose 71789678 2608923 677122 343434 I needName ID Jan Feb Mqarchjose 71789678 2608923 677122 343434 If you know how..pliz help me...
Any idea on why my Visual Studio 2005 Beta 2 is not allowing me to create a Report Project?Please help!My version of VS 2005 Beta 2 is: 8.0.50215.44 (beta2.050215-4400)Please email me the version of VS 2005 Beta 2 that you have if you are able to create a Report Project under Business ...
I want to write a Windows Forms appl that can dynamically generate a report definition and then view/print the resulting report. What is the best way to programatically generate the equivelent of an .rdlc file that can then be "executed"? I see there is documentation on the .rdl format so I ...