I have a list on an rdlc that I want to break for every page. I set page break properties for end and start together and then seperately and none works.
It will break for the first page bu...
Hi everyone,
So I need to find out if a date entered is a Sunday. If it is, I gotta do something special with this data. I'm not sure if Datepart will help or how to use it effectively to e...
It is saying that: Select statements included within a function cannot return data to a client. , but I want to use the Case to determine if specific types of records qualify. Not all record...
Hi--
I have a report to print a range of invoices. Every invoice has four parts to it: the header information, the detail information, the total, and then a resummarization of the detail b...
I need to be able to route the output of a ReportingServices rdlc report created in Visual Studio 2005 and executed in a C# program (utilizing the Reporting.WebForms classes) directly to a se...
I'm trying to create an expression that determines the shading of the field based on three factors. I thought using Switch to test various conditions would be the cleanest way to do this. Th...
I am trying to setup a multivalue parameter in SQL Server 2005 Reporting Services. For the "Available Values" in the report itself, I want to specify non-queried values; however, for each non-...
I'm using Visual Studio 2005 to develop an SSRS report that utilizes 5 cascading parameters, as follows:
From Year: @FromYear - List of available years from reporting data source.
From ...
HI guys
I have the expression below which gives me a value of -0.030%. How do you convert the negative to a postive. From -0.030%. to 0.030%.
FormatPercent(Sum(Fields!Margin1.Value, "S...
In crystal and in excel, when you create a pie chart you have the options of showing both the catgory labels and the percent simply by clicking on some check boxes. I am using ssrs and i don'...
Hello,
I have a report that has a blank page at the end. I've checked my margins to be sure my 'theoretical' page size is less than my 'actual' page size (left margin + size + right margin ...
Hi,
Using report builder 2.0, I have just a detailed tablix, is it possible to add paging to it, just like you'd add paging to an asp.net datagrid ? At the moment I just have a scroll bar and...
The goal is to set up Reporting Services to work over the internet over SSL using Integrated Windows authentication. SSL is required for security; Windows authentication is required so that cr...
Hi you clever people,
Ok Ive now got myself clued up on SSRS and ive got to grips with HTML. Im trying to build an online MI platform and Im looking to have visible reports displayed within...
Hi all,
I'm trying to create a product sales report which will allow users to view the product references they are interested in.
The parameter should be a plain text box or multiple tex...
I am query some information with sql server reporting/business intelligence studio from an old act database (odbc).
there is a varchar column for 'last attempt' with a size of 8 that return...
Hello
I want to export a table of my database in a csv file.
But I want the program build csv file dynamically.
For example if I click on the "Export.aspx" without save any file, A csv f...
My question is I created a report using 2 Different data sources and it seems easy enough but when I add a new set under data set 2 called sum of all I get an error. Not sure what the error i...
HI,
Any one know how to insert page break in Reporting Service? I would like to insert a page break in my reporting for every 1000 data rows.
Thanks.
I have a SSAS cube and a report in SSRS , i have one fact table, and the same table is also Dimension , is a relationship type :Fact , by one field Id AutoNumber.
In a report, i use two fiel...
I am looking to filter for Current month. I know how to do last 30 days getdate() -30
But how do I do it from the beginning of the month to current day
it also has a time stamp so i want...
Hi All,
How do you calculate the average of three fields in reporting services using an expression for the text box.
For example I have three report items below
reportitems!textbox122...
I've copied over a Query I used for a Reporting Service Report to a Visual Studio Report, but it flags the error:
The OVER SQL construct or statement is not supported.
The query is below...
First, this is *not* a timeout issue. The session isn't timing out, the service appears to be using the wrong context when executing reports from the report menu.
I have already completely ...
I have recently pushed the following Killbits update KB973525 via WSUS to some of my clients.
Now they are getting the following message when they try to print via Server Reporting Service...
