Dear ALL, I have this problem during view report in Report Manager (I m using CTP Sept Cut for my SQL 2005 now). And, i can't find out what is this error about. w3wp!processing!1!10/26/2005-12:01:48:: a ASSERT: Assertion failed! Call stack Microsoft.ReportingServices.ReportProcessing.Rep...more >>

Using SRS 2000. When creating a matrix report, can you order the columns? By default, they are in alpha order. My columns are the months of the year. Using Order By in the query doesn't work. I want January, February..., not April, August......more >>

How can I add new elements to an RDL report definition and then render those elements? For example, I'd like to add a new type of report (i.e. not a table, matrix, list, or chart), and write the code to generate the rendering of that particular type of element. A further complication: th...more >>

Hi all, For some reason I am receiving an error when parsing this statement: =iif(sum(fields!Sales.value)=0,0,sum(fields!Price.value)/sum(fields!Sales.va lue)) So the % works however as some of the sales do equal 0 I receive errors on the report... Why won't the IIF statement place a 0 th...more >>

I have a dataset with multiple tables. The datatable I need is called InvoiceTemplate and has its tableadapter implemented to fetch data from the sql server backend with a stored proc, which accepts a single parameter: an integer determining the country. When the dataset is filled I get the fo...more >>

Hi, I'm playing with the Printerdelivery sample in 2005 and having problems. 1. When I use the EMF Image type the printout for the rendered report is larger then expected. The fonts seem larger and the lines of text are cut off. I tried modifying the Device Info and add the DpiX and DpiY t...more >>

Trying to learn reporting services and in particular how to cascade parameters. Using AdventureWorks200 db made up a report which works fine except when there are no db entries for the last cascaded parameter. Its doing category->subcategory->product->vendor there are vendors in the db for so...more >>

How can I use conditional number formatting if one of the formats contain a comma? The iif statement conditions are separated by commas. If one of the conditionals should have the number format: #,##0,;(#,##0,);0 While the other condition should format to percentage: #.0%;(#.0%);0.0...more >>

sql reporting services (sp2) windows 2003 server Sql 200 sp4 all on one server (iis & sql server) I have about 30 reports which I deploy from my local environment to our reporting server. If I deploy about 10 of the reports everything is fine, all reports deployed work. However, the more...more >>

Does anyone know when in the lifecycle of the execution of a report, a custom assembly get executed? I understand that datasources are loaded in the order they appear in the RDL file. is a custom assembly executed when it is also found in an RDL file? We are trying to get a custom assem...more >>

Hi again -- I am just trying to set up my first Report Model. We use Oracle to store all of our data that we want to report on (we use Reporting Services). Can I build a report model for Report Builder using an Oracle database as the data source? When I try to create the datasource, it look...more >>

Does anyone know how to do alternative color row dynamically on reports? I can do that in ASP.NET DataGrid.. but can't seem to find a property on reporting server.. ...more >>

Hi, I'm trying to look at the samples supplied with reporting services. Found a folder with a bunch of samples C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Reports which has a SampleReports.sln this opens fine in visual studio .net (help about says Microsoft Dev...more >>

Hello, 120-day trial, which version is that, enterprise, developer, ..? I am trying to download the developer version so that I can install it to a XP. Where can I find it? Thanks, ...more >>

I recently installed SQL Server 2005, Sept CTP. I have a solution that I developed for reporting services -- I can currently modify and pre-view all reports using the report designer. I can also deploy all reports (no errors or failures). But when I try to open any of the reports in the Rep...more >>

Report Builder displays the description text as a tooltip in the Explorer pane. -----Original Message----- From: RonVanZanten@discussions.microsoft.com Posted At: Tuesday, October 25, 2005 5:42 AM Posted To: microsoft.public.sqlserver.reportingsvcs Conversation: Report Builder Subject: Repo...more >>

hi, i dont find how to assign customize dataset to sql report datasource. plz give me reply ASAP...more >>

Is is possible to write SQL or call a strored procedure inside a text box to return a value for display purposes? I have a stroed procedure that holds a value but I can't figure out he syntax to allow the report to render. Thanks for the help! Anthony...more >>

I only can create reports based on three predefined templates. It is very restricted....more >>

Hi! I have a report in my application, accessed through a URL. This URL contains a user id, which is used to decide what data should be contained in the report. Is it possible to hide this URL from the user? Now the URL can be retrived by choosing "View Code" in the application, and the use...more >>

hi all, examine the following piece : with member [month_list].[jan-sept] AS 'sum([month_list].[All month_list].[January]:[Month_list].[All month_list].[September])' As you can see, i summate the months January to September, september being the current month. Now, is there a way to...more >>

I have a main report, which among other things contains two subreports enclosed within a rectange (for easy read layout). However, if none of the subreports returns any data, i would like the rectangle to invisible and not take any space on the sub report. So what I wish to do is something ...more >>

I installed the SharePoint Report Pack and successfully ran the reports against the sample database. I then tried to import my own log files into the live reporting database. Keep in mind that I am using UK date format for my database. The RPDataExtration.log file reports a few exceptions....more >>