Hi: I have a Report Service running as a web service. I call the web service to get the RDL back as a byte(), then I call XmlSerializer to cast it to a "Report" type autogenerated by the report service The following code works just fine for SQL2005, but it would throw and exception for SQL2008, when tries to deserialize so if the report...
An error has occurred during local report processing. An error has occured during report processing. Query execution failed for dataset 'DataSet_XXXXX' Server: The operation has been cancelled. What the William H Gates is going on here? I am trying to preview a report, that uses datasets which connect to ssas cubes, in the report de...
Our application allows administrators to add “User Properties” in order for them to be able to tailor the system to match their own HR systems. For example, if your company has departments, you can define “Departments” in the Properties table and then add values that correspond to “Departments” such as “Jewelry”, “Electronics” etc… You...
I have an SSRS 2008 report that uses a list area and several subreports. I need to have a few data items (company name, invoice number) repeat on each page that relates to that company. The report will print pages for multiple companies, with multiple pages for each company. I know how to get repeat headers to work. I also know how...
I'm trying to translate this Crystal Reports IF Statement for use in a WHERE clause - {@receipt_datetime_daylight} in {?DateRange} and (if {?Call Sign} = "All Call Signs" Then {cacs_incident_task.resource_or_class_id} = {cacs_incident_task.resource_or_class_id} Else If {?Call Sign} = "All Sierra Call Signs" Then {cacs_incident_t...
Parser: The query contains the XXXXXName parameter, which is not declared. (msmgdsrv) I have no idea why I keep getting this error. It occurs when I change the MDX in the query designer and trying OKing out of the query designer. The strange thing is that the parameter DOES exist, I can see it in the parameters section of the dataset d...
Assume i have a custom Windows application written in C#. This application has only the following functionalists, add, edit, delete and view. For example, a user can add a sale, change sales record, delete a sale record or view the whole sales record. I need to add some reporting functionalists e.g. i want a user to print the sales of a...
While runing MS SQL report I get an error "Error: Subreport could not be shown.". Is there any way to get more information regarding an error? ...
I have a date as shown in expression: = Fields!last_sales_date.Value will show: 04/16/2010 Applying standard date properties allows only a few ways to display this date. I don't want to use the system dates supplied. What is the correct way to customize the display format to the following: Want to show: 4/16/10 Using VS 2003 ...
Hi, I'm writing a report that will show data based on the User!UserID built into the SSRS infrastructure. The data is sensitive to the user's department. In addition to these department users, there will be admins that should be able to run for all departments, or have a report parameter to run for a specific department. Ideally, I'd...
I email out daily sales reports via SQL Server Reporting Services. However, a few users receive on iPhones and the reports don't reload when a new one comes in. It thinks it is the same file as the previous day's report. Is there a way to clear the cache or force a reload? ...
Hi all, for a data warehouse project I need to know about some best practices regarding custom report viewer filters/parameters. Usually I use the standard parameter feature for reports, like multiple select boxes, check boxes, text boxes etc.. But for the current project some reports require more complex report parameters. E.g. a user...
Hello, I'm using SSRS 2005, with custom forms authentication module. That works great. But the report builder prompts for credentials, is there a way to get around this? Is this a configurability thing? Thanks. ...
Hi, We render SSRS reports through the Web Services API. For some reason when I get the HTML back any toggle functionality is missing. I see that ReportingExecutionService has an option called ToggleItem however I don't see any way of getting the item's ID. How can I discover toggle items and enable an action to be called on one? ...
I was wondering whether what should be a better approach. I am having an application, which is working on WAMP (WINDOWS, APACHE, MYSQL, PHP) stack. Now there are increasing amounts of reports being generated and discussed. What approach should I be going for. There are two I can think of. Put the all reporting on the same production ...
Hi, I know how to group chart slices / bars below a certain threshold together into one bar. But if the data displayed in the chart contains lots of small slices, collecting slices below 5% or so results in a huge "other" slice / bar. On the other hand, if I collect only slices below a very small treshold, the chart could contain too m...
Hi everyone, I have a question about report modeling in Visual Studio 2008. When I preview the report, I get something like this: http://i39.tinypic.com/2nlu49z.jpg Though, that is not exactly what I need. I don't need rows 1,2,3 to be repeated two times. I would like "x, y" to be together in one row, and only one instance of rows wit...
Hi all, in the data warehouse there's a default language for the measures, and I added a translation for German captions. In a Visual Studio Report Server project, when creating a query with my German OS, the cube and its measures are displayed in German language. When dragging measures to the mdx query windows, the default measure name...
My SSRS report loads logo images for each customer from a customer number specific folder on the report server. I write an expression, to form my URL to the image based on th customer number. ..."http://localhost/images/" + iCustomerNumber.ToString() + "/logo.gif" I am able to get this working, but the problem I face is, when a parti...
Issue: the user is getting an error “The requested list could not be retrieved because the query is not valid or a connection could not be made to the data source.” while trying to filter a reporting using Report Builder 2.0. When you expand the details the message is “Input string was not in a correct format” I verified that when the...