I'm using the reportviewer control with Visual Studio 2008 in a asp.net 3.5 webforms application. I've created many reports that that render using the reportviewer control rather than running on the server with reporting services. This works great, but my problem is when I export to a pdf there may be a lot of white space that needs remo...
I've never used SSRS before and I want to have a play around with it on my local machine to see if it's a good fit for a project. I have the full (advanced services) version of SQL Server 2008 Express installed, according to the web installer. However, when I fire up Reporting Services Configuration Manager and try to connect to my loc...
I have a query that takes roughly 2 minutes to run. It's not terribly complex in terms of parameters or anything, and the report itself doesn't do any truly extensive processing. Basically just spits the data straight out in a nice format. (Actually one of the reports doesn't format the data at all, just returns a flat table meant to ...
Hi Everybody, I have a SQL Server 2008 database which is located on a distant server (I have full access to this server however). On my computer I have Visual Studio 2008 installed, and I need to load a solution which contains projects that have been created using plugins from SQL Server. Those plugins are : - SQL Server Analysis Servic...
Hello, I am using SSRS 2008 with VS 2008 using Windows XP Pro w/SP3. I have the reporting server setup and want to use Forms Authentication. I followed the steps outlined on the following MSDN page and have reporting server running with Forms Authentication. msdn.microsoft.com/en-us/library/aa902691%28SQL.80%29.aspx However, when I tr...
Hi, I have a report to which I have execute-only access - I don't have the access to the RDL file. This report exposes several parameters which I would like to set from URL. I've successfully changed some parameters using the standard param=data form (as explained here: http://msdn.microsoft.com/en-us/library/ms153586.aspx). However, s...
See this Image below http://i46.tinypic.com/2pt6jkn.jpg This is report in SSRS as shown when it is uploaded in the server. On my developement machine, the format is ok as shown in the pic below. http://i48.tinypic.com/be9dmh.jpg Why is the format getting messed up? ...
Hello I'm working in a SSRS report. I have a table in the report. How do i set the row height of the rows in the table? Thank you. Regards NLV ...
here's the job description: Experience with data mapping/extracts tools such as Monarch and VorteXML. Familiarity with XML documents and schemas. Minimum 1-3 years of data analysis in SQL Server environment. Working knowledge of TSQL and SQL Server 2000 tools such as Enterprise Manager, SQL Query Analyzer, Profiler, DTS and BCP. Working...
Hi, I'm having a problem with the Visual Studio 2010 RC Webforms ReportViewer. It shows the report ok when I am loading the page, but when clicking on "Next Page" or entering a page number, it just loads and displays the first page all over again. I have verified using Firebug that the request initiated by the paging button is actuall...
Over the next few months, we need to consider the best technology/technique for periodically uploading SQL Server 2008 Express data that is held on a local network up to a Web based SQL Server 2008 server. The idea is to allow us to consolidate the data in 20 distributed (local) SQL Server Express 2008 apps in use throughout the country...
Hi there, For some time, PDF files generated with SSRS 2008 do not open in most versions of Acrobat Reader (it used to work with almost all versions of Acrobat Reader) Acrobat Reader 5, 8.1.3, 9.1.3, 9.2, Foxit Reader : works fine Acrobat 8.x (other than 8.1.3), 9.1.0, 9.3 : does not work, Acrobat Reader freezes. Sometimes it eventually...
I want to subscribe report on specific schedule in reporting services 2008. i.e report will dilever to user automatically on schedule. I am using visual studio 2008. I have done the configuration setting (rsreportserver.config, app.config after adding refrences of asmx files) by refrence msdn. The code is running fine (no exception occur...
i have sql server 2008. i would like to learn the reporting services. where can i start? can you show me a tutorial that helps me make a simple report. ...
I have a report that via a text box property action triggers a drill-through report (and gives it two parameters (start date, end date)). That all works fine in the report designer, however after deploying the report on the server the pane in the drill-through reports is hidden. Is there a way I can change this behavior. Our users want t...
does BI studio come bundled with another software? i am trying to create a report server for SSRS but am not able to find BI on my computer and cannot find a place where to download. thank you! ...
Hi, We are using Reporting Service(SSRS 2008) webservice(ReportingService2005.asmx, ReportingExecutionService2005.asmx) to export/Render the report into PDF format from Windows application. When exporting the huge amount of data contain report(Upto 10MB), then we are getting exception as "The underlying connection was closed: An unexpec...
The company I work for is looking for a reporting solution with the following requirements: Must be able to generate a set of reports nightly. Must give the client the ability to create reports dynamically. Must have robust export features. Must have a viewer that can be displayed within a web application. The company is looking at u...
We are reviewing our need for Crystal Enterprise - Business Objects. Our requirements are to have a way for users to login and choose from an selection of reports dependant on what they have access to. These reports are all designed in Crystal Reports and link to various databases. Are there any enterprise type solutions for hosting r...
We have a Lotus Notes web service that generates an XML response. In our development environment on Visual Studio we can access the data source and run the report without issue. When we run the report from SQL Server we get the following error: An error has occurred during report processing. Query execution failed for data set ...