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...
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 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...
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...
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 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 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 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 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...
Hi Everyone,
A bit embarassed by this one, but what does <> mean? For i nstance:
IF(@somethingi <> 75)
I've seen <, >, <=, >=, but not sure about <>.
Thanks.
I've seen different variations to this question, but can't figure out the exact code for what I'm trying to do. I need someone to spell it out for me.
I have a 5 character ID. I want to s...
Are there any tools/ methods to convert Crystal Reports(.rpts) to jasper reports?
How to apply font color to report parameters in reporting services?
ok so i have a binary field
when i run my code in SQL server management studio, it gives me a decent result i can live with, something like 0x149C0C9E00E20010,
however when i use the sam...
I have a table that I would like to get a report by orders and order amounts. Plus I would like to get the previous orders order number and amount on the same line for that customer. Can someo...
I have a 5-level hierarchy, but I think the question can be asked thinking of just a two level hierarchy: Suppose we have Continent and Country, and I want to select North America and Europe. ...
