Is there a way for displaying the page in table in report body.
Please let me know. thanks in advance
Hi Experts,
I'm writing an application that populates a SQL Server table every hour or so. I will also develop a SQL Server Reporting Services report that will display information from thi...
Dear All,
Please help how to set report layout to landscape rather potrait to rdlc report.
I have tried by setting width and height to report properties . But it doesn't work.
Hi,
Does anyone know of a way of restoring the reporting services configuraion in SQL 2005.
I am having major issues trying to get reports to run and wanted to try and sor this out ASAP.
Th...
Hi all,
I need Custom Report Builders,How to download it and
Any body give me some reference Urls.We want to purchase that software
So that user will select his required fields from tables ...
I am using Visual Studio 2008 Reports (not Crystal Reports) to report the data from an SQL database. This works but I would like to show column totals. The Report Wizard does not allow for t...
I am trying to write a report which shows a different currency symbol dependent on the results of the SQL query. For example in the table I have:
Name, Currency
United Kingdom, 1
United...
Couple of issues here. I have two reports, one is the summary of the data in the other. I need to subscribe users to the reports via e-mail, but need to have one (summary) render in web arch...
We run Reporting Services in Sharepoint integrated mode. We have a farm, with the report server on one server and Sharepoint (MOSS 2007) on another server. When we connect a report to a dataso...
I have an expression in my page footer
="Total Carried Forward " + FormatCurrency(Sum(ReportItems("DonorTotal").Value).ToString())
However this just totals the DonorTotal for the page, I...
HI All ,
Please let me know How to Change The Color Using RowNumber Function In SSRS Matrix
for Table i am using following fuction:
=iif(rownumber("tablename") mod 2 , "Blue","Red")
...
Hi
We're using a Report Viewer webpart to deliver reporting from our SQL RS server via a Sharepoint site. For certain reports we are getting a SQL error (as below) - these we believe are re...
We have MS SQL 2000. We have a table of Items where we store Parent Items and Child Items. The Parent Items are the way we purchase (in Cases) and the Child Item is the way we sell (in Each)...
Hi I'm new to SSRS and I'm having problems with grouping some totals.
My data is very similar to the table below, what I'm trying to do is sum the gp and the total weeks left. The problem ...
I have a report that uses a DAO connection to a Text file. It is very, very slow to connect - once it does it runs normal. I have the same report and text file in Crystal 8.5 - the connectio...
Hi Everyone,
Got a lot of help earlier, but I'm still working on this. I'll be posting two code pieces. One will be the original stored proc., the second will be mine, trying to improve o...
I have a sql query and I am able to create a table in sql reporting services like below
dtype ddate ID name role
cc 12/2/2005 1 john consultant
bb 12/2/2005 1 john consultant
aa...
Hi ,
I am using SSRS 2008. i want to know id i can custom sort the category values. In the category group properties i can only sort alphabetically. But my category values are not all char....
I currently have a cross tab that is currently running onto 3 pages.
Is there a way I can wrap this so that I can get all the data on one page?
I am trying to update records in one table (wk_curtrcrevenue) by selecting the amount divided by the rate of another (paydetail). The amount could be pieces or dollars. p.pyd_number is the num...
I have created a report in Reporting services that allows the toggle of detail items to be selected before the report is viewed. The display/non display of the detail items works fine.
...
I have a report and will be printing in a pre printed form. How can i have the header section print on the next pages or leave an empty spaces so the line details will be on the ocrrect are in...
Is it possible to have a normal user setup a shared schedule and be able to change it when need be, or does it always have to be an administrator do it.
Hi all,
I am trying to write a 'if' statement for my report in Visual Studio 2008 to see if a value is equaled to something else and if it is, return that value. Here is what I came up wit...
I'm creating a report that is pulling in info from our MS CRM 4 and another backoffice system. I'm looking to add a jump to URL hyperlink to access the Contact record within CRM that any recor...
