I'm running SQL Server 2005 and using Visual Studio 2005 to create SQL Server Reporting Services reports.
Is there anyway to create a report footer (ala Crystal) - that is a section that wo...
Hi all
I was wondering whether anyone might be able to help me with this.
My configuration is below:
Ø I have configured reporting services to use SharePoint Integrated reporting.
...
I am working with SQL Reporting Services within a Windows Forms .NET application. Is there a way that I can print a report without displaying it first and without displaying a print dialog fir...
How can I create a rolling average vlaue for the last 3 month's and show the data in a line chart in Report Studio.
I have an application that is using Microsofts reporting tools in VS 2005. I am trying to create a header for the report which has data provided by a dataset. Fields can't be used in the hea...
Hi all,
I have a SQL Reporting Services server(the Reporting db's are on a different server). Basically these are to be decomissioned and I'm trying to find out how to migrate the web and db'...
Hi,
I am new to Cognos. I need to install Cognos 8. I installed the software, typically i failed at Configuration of Cognos to SQL Server 2000. Please anybody help me in this or a su...
I want to be able to use data returned in a stored procedure output parameter
in a report. For example, I have a stored procedure that might look like this:
CREATE PROCEDURE Example
@...
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")
...
trying to add page numbers to my report (.rdlc), any idea why this does not work, sits in the footer template
="Page " & Globals!PageNumber
all i get on each page is "Page"
I have a report that I want to be customized according to the User that is logged in. For instance, I have a report that already grabs and reports data for a group of users. However, I want ...
I have a report with six parameters and if the user enters those parameters in, it will take you to a detailed page
where i have applied interactive sort on each of the columns. Now, my pro...
i use SharpDevelop with mysql. what is the best reporting tools for SharpDevelop??
HI , I want to create drill down options in my SSRS 2005 matrix report. My field is =Fields!Class.Value .
Can any body help me how to create it ?
We have several reports setup in SSRS 2005 that are running very slow.
Through looking at the SSRS logs in the ReportServer database, we've deduced it is primarily the TimeRendering that is...
I have created many reports in SSRS with user parameters, and they work just fine. But I am trying to create an internal parameter (select a group based on conditions) to apply to the report ...
Hi,
I am working in Reporting services SSRS and using tool-tip on certain fields
=IIf(IsNothing(Fields!ValueDate1.Value), "0.00", "$" & Format(CDbl(Fields!ValueDate1.Value), "N0"))
but ...
Is there are way in Reporting Services to setup Parameters that control other parameters? I wish to setup the following:
Parameter1 (Interger) - "Select Report Type"
- <Label> = <Value>
...
Hi Guys,
Does anybody know how to change a filter in Reporting Services to OR rather the AND. I have tried without success, the field is grayed out and always defaults to AND yet the help c...
We are trying to add a couple of new tables to an existing database to help us track sales commission related data. The database already has three pre-existing tables, PJEMPLOY, PJPROJEM, and ...
CR XI Release 2, SP2
Windows MCE, SP2
i've been dealing with a very frustrating problem that seems to have stemmed from uninstalling and reinstalling .NET Framework
prior to today, I wa...
Hi,
I have a table that displays the following data:
1. 100
2. 200
3. 300
3. 0
4. 0
5. 400
How can I make an expression so that if I get a 0, i don't display anything (return a nul...
I'm in the process of planning my Windows 2003 Active Directory domain. Should I setup Windows 2003 DNS before I run dcpromo or should I let dcpromo take care of it.
Hello
I have a MS SQL reporting Services Report with many datasets and textboxes. Each textbox is the result of a dataset that will either return 1 record or 0 records.
If the result is 0...
Hi Experts,
How can i ouput the date to include the "st", "nd", "rd", "th" as in 1st, 2nd, 3rd, 4th
Don't know what that part of the date format is called ??
Thanks
