I want to put my first date on co-ordinate 0 of X-axis on chart how can I do that sql server 2008 reporting service
I want to put my first date on co-ordinate 0 of X-axis on chart how can I do that sql server 2008 reporting service ...
ssrs-2008
What all are the possible reporting deployment options ?
I have a small application where there are some reports i have done. What i do each time when i have to deploy the reports is as follows, take the solution of the reporting to the sql machine where reporting server is installed open the solution change the data source property and sql reporting server url then say deploy. Is there o...
'Go to Report' (drillthrough) action not working in SSRS and ASP.NET
Hello experts! I've recently started working with SSRS 2008 and ASP.Net. I must develop a report with 3 different levels of detail. So, I decided the best solution was to develop 3 different reports and provide some drill-through mechanism in order to allow navigation. For that, I set the 'Action' property of one of the textboxes to 'Go...
How do I execute a stored procedure every time a report is run?
I have a stored proc that basically is used for logging reports that were executed with their parameters. I'd like to run this stored proc on every execution of the report? Do I do this through the report code window? ...
silverlight 4 automatic printing ssrs reports
hi i wrote a small app in WPF based on the link below , that contacts the SSRS server, sends a report name & parameters and gets a report printed automatically on the client default printer. My clients are very keen on this one click printing idea. http://blogs.msdn.com/b/bryanke/archive/2004/02/11/71491.aspx now here is my problem: I...
Using 2008, how do I add the rich textbox?
Using 2008, how do I add the rich textbox to my toolbox? ...
SSRS 2008 Error Message. What does it mean?
Anyone have a clue what this error message means? An unexpected error occurred while compiling expressions. native compiler return value ‘128’ ...
How to pass a parameter to SSRS report from SSIS package?
Hello, I'm writing my first SSIS pkg and I'm stuck. Any insight would be greatly appreciated. I'm running a sql agent job that kicks off a SSRS report. (The job was generated via a scheduled subscription.) This report relies on 2 stored procs which require the parameter 'When' (date type) and it dumps a PDF of the report to a file sh...
I want to Repeat Page Header on each Page for reports.Repeat on NewPage is not appearing in properties of Tablix member in SSRS 2008.
How to Repeat Page Header on each Page. Repeat on NewPage Property is not appearing in ssrs 2008 tablix memeber property ...
Displaying Multi-Value Parameters.
Is this really the best way to handle this? I have a multivalued parameter which has about 25 elements in it. If the user selects "Select All" and I use the standard (at least as far as I know) method of displaying the parameter at the top of the report: =join(Parameters!ProductClass.Value, ",") Rather than the the word "All" or some...
SSRS report parameters
In my SSRS report there are 2 parameters called DataSourceIDList and ReporterIDlist. DataSourceIDList : is a drop down list and this will populate based on SQL query. ReporterIDlist : is a drop down list and this will populate reporters based on selected Datasourceid from DataSourceIDList and this is also a SQL query. both parameters ...
How to change the SSRS input parameters position in report
My SSRS report contains 7 input parameters and while running my report the size of the parameter(i.e. length) is increasing. One of my input parameter(drop down list) may contain 100 characters so the size is not constant but i want to place all parameters in 2 lines or 3 lines(in a row). Now it is coming 2 parameters per a row Please...
How to call print from asp.net on a reportviewer control?
Hello, I'm using ssrs with an asp.net reportviewer control to display server reports. We want to do away with the toolbar because it doesn't fit with our look and feel but we want to maintain some of the functionality, the one bit I'm struggling with is the print. Is there any way to bring up the same print dialog as the print button on...
SSRS web services fire a data subscriptions
Is there any way to fire off a data subscription from using the SSRS web services? ...
opening a file in the browser instead of downloading it
Im using ssrs through a reports server to generate a resultStream byte array using ReportExecutionService.Render() which I am currently serving to the user with the following code. Is there a way I can use this same byte array to automatically open the report in a new browser window instead of going to the save/open dialog? public vo...
SSRS Pre Loading Dropdownlist from Web Service Not Working
I have a Report that needs to populate a list of customers before the user has the option to view the report. I have 2 datasets 1 is for the customer list and the other is for the main view. When i run the report if i specify a default value for the parameter for the dataset that gets customers it works fine but if i do not specify a def...
Date Format incorrect in Reporting Services
I have a Date Time field in a report with format set to 31/01/2000 13:30. It says on the dialog that Formats that begin with an asterisk () will reflect the regional settings of the report. It also confirms below that my current regional settings are: English (UK) I then deploy to my local report server and run the report and it displ...
Go To Report action in SSRS 2008, Sharepoint Integrated mode doesn't do anything
I've created two reports in the same project, and the first report has an Action "Go To Report" in a tablix cell, to take it to this subreport I'll call SecondRpt.rdl. When I run it in BIDS, the action works fine. I deploy the reports to Sharepoint, and when I click on the cell, nothing happens, no err message or anything. I've read t...
Charts are printing grainy artifacts from the viewer, but not on screen or PDF
SSRS 2008 R2 Pie Chart with CustomAttribute PieDrawingStyle = Concave Everything looks great on screen, PDF looks great, printing PDF is fine, printing from the viewer looks like the printer is running out of ink, or its trying to print it in 8-bit, it just looks bad. The concave looks awesome and our clients love it, but they do a lo...
SSRS 2008 Report Rendering Question
Good Day, I created a simple grouping report using BIDS 2008 and have set the following properties of a textbox to hide a row in the Table (or Tablix) control. CanGrow = false CanShrink = true Hidden = true The report displays fine in Preview mode, however, when I deploy the reports to the server and view it, it doesn't render the sam...