Some of the reports might take a long time to generate. Just to be on the safe side, I want to set a time out option for the reports so that they dont hog up the resource for a long time.
H...
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...
i am using crystal reports 9 and coldfusion 6.1 and the database is sybase, now theres a data imported from another database that has a chinese characters, when i run my report all i can see...
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 Guys,
I am stuck with a Page break problem in grouping(SSRS 2005). Here is my problem:
Here is the sample data.....I am grouping on location(NJ,NY,TX)....The problem is when I am viewin...
I have installed SQL 2005 w/Reporting Services and I am unable to get to the URL http://localhost/Reports; if I use anonymous, I get just the home, subscription and help tabs; nothing else. I...
I am having some difficulty getting SQL output into properly formatted XML. The closest I have come to getting what I want is with the SQL query below. When using text output the results run...
Hi Guys,
Why are my getting this error when I try and retrieve some results from a database?
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Line 1: Incorrect synta...
Need to convert a date to quarters. for instance, i retrieve a date field from a database using SQL and it is currently in this format: "10/25/2007 8:00:00 AM". I need to have the value of t...
I was using a sub-report in a main report, but could not get it to export in Excel. So I read where I could use a table in a list and pass it a parameter.
How do I pass parameters from one ...
I am working in Reporting Services SSRS 2005. Now my question is how can i move parameter text boxes in data-panel(see image). I know there is way to achieve this through CSS. But i am not get...
I have recently installed sql server 2005 express edition with all sample DBs, reporting services and analysis services etc, i installed the adventureworks sample DB also. I then went about t...
I have changed the datasource so the connection string uses a parameter, Database.Value. This allows me to specify which database to connect to when I run the report :
="data source=myserve...
Hi I have created a stored procedure (sqlserver) please see attached.
I am trying to call the procedure from cognos as I would like to use the vaules within a report but
I am getting the...
I haven't been able to find any information about this, but excuse me if someone else has already asked a similar question.
Using one report and one data driven subscription, I would like to ...
Hi,
Can someone tell me where can I get Cognos SDK and documentation? I need to create report using Cognos for my java (websphere) application. I searched over the internet, but cou...
I have set up the sample Printer Delivery Extension as per the MSDN.
The Delivery code works but the page is printing in Letter size 8.5/11.5 inches
I wish the default size to be A4 21.0x29....
I am getting this error when I try to access the reports through "Report Manager".
The error is " The underlying connection is closed, the remote name could not be resolved"
I have inst...
HI ,
i have a Problem with report parameters in SSRS 2005. below is my code which has one parameter @brokerno (without multivalues option),which is fine. I also need to add two extra...
I have a large set of SQL Reporting Services reports that I need to publish to a Reporting Services server. I could use the Report Manager to upload each individual file, but I would prefer to...
I created a parameter in Crystal Reports (ver. 10) called Description Search. it's a string parameter and the selection formula for the parameter is:
{INVENTRY.Description1}LIKE [{?Descript...
Hi
Can anyone tell me if Cognos can use excel as a datasource and if so can anyone tell me how to connect. i am trying (for the first time10 to create a report in cognos. The data i need is...
I have a Windows Forms application that is displaying SQL Server 2005 Reporting Services reports using a ReportViewer control. I have a report that has 3parameters. The first 2 parameters are ...
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.
...
