all groups > sql server reporting services > june 2006 > threads for thursday june 22
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Problem with Parameterized reports - changing default values
Posted by Graham Smith at 6/22/2006 11:46:02 PM
Hi I have two issues: I have recently migrated SSRS2000 to SSRS2005.
1. When I run CRM3 parameterized reports using the RS Report Manager
interface i get error messages like " The 'CRM_Locale' parameter is missing
a value " or "The 'CRM_Locale' parameter is missing a value", however when
... more >>
What Datatype Is RS Using for String Parameter
Posted by Mike Harbinger at 6/22/2006 7:33:41 PM
Is it VARCHAR(8000) ?
Thanks
... more >>
One server, many databases and stored procedures
Posted by ddaniels via SQLMonster.com at 6/22/2006 7:08:35 PM
Hi -
I have a single database structure that will be implemented several times in
SQL Server 2000 to support multiple clients. I would like to have a single
instance of a report to use against all of these databases. I envision using
the connection string to control which database the report... more >>
TextBox Expression Problem
Posted by Joe Delphi at 6/22/2006 5:15:27 PM
Hi,
I am attempting to avoid a divide by zero error in a text box. The value for
the text box is:
=IIF((ReportItems!textbox2.Value+ReportItems!textbox3.Value+ReportItems!textbox4.Value)
<> 0 ,
ReportItems!textbox3.Value/(ReportItems!textbox2.Value+ReportItems!textbox3.Value+Repo... more >>
how to stagger reporting services scheduled deliveries?
Posted by ===Steve L.=== at 6/22/2006 3:46:59 PM
i'm new to sql2k5 and reporting services 2k5.
is there a way to automatically stagger various scheduled deliveries?
or to check certain things, for example, a temp table needed to be
populated before the report is generated, or stop the rest of
deliveries if one of them failed and so on. somethi... more >>
publishing a ssrs2005 reprot on a 2000 system
Posted by Amedeo Feroce at 6/22/2006 3:41:47 PM
Hello everyone!
Does anyone know if you can depoly a report created in SSRS2005 environment
on a SQL Server 2000 report server???
Thanks!
Amedeo
... more >>
Page footers in Sub report not visible in main report.
Posted by Manuraj VS at 6/22/2006 2:07:20 PM
Hi ,
I have a sub report which has a page footer.This page footer has page
number & a text box which dispalys something based upon the parameter send
from the main report. Iam calling this sub report 5 times from the main
report by passing a parameter , say @D ( @D =1 ,@D =2 , @D ... more >>
My own report parameters
Posted by Ravi Manda at 6/22/2006 1:45:02 PM
Hi there,
Can I add my own report parameters on report parameter area of a sql server
report 2005.
I have a label, textbox followed by a button. Open a aspx search page
onclicking the button.
Thanks,
Ravi... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Using "ALL" in Parameters
Posted by Benw at 6/22/2006 1:13:02 PM
I am trying to use 'ALL" in my parameters but it doesnt seem to work. My
parameter dataset query looks like this:
SELECT Empid AS EMPLOYEE
FROM smServFault
WHERE (TaskStatus <> 'C')
UNION
SELECT 'ALL' AS EMPLOYEE
ORDER BY EMPLOYEE
and my main query looks like this:
... more >>
File System Access With Custom Assembly Method
Posted by jeffjones176 NO[at]SPAM gmail.com at 6/22/2006 1:01:45 PM
Hello All,
I am building a dashboard report that will read through the file system
for a record's document folder on our server and report to the user if
there are any files missing in the directory. I am using a custom
assembly to house the method. When using the assembly in the dev
enviro... more >>
Reporting Services Question
Posted by KC at 6/22/2006 11:52:02 AM
I have an associate who needs Reporting Services 2005 installed. They do not
have a Visual Studio 2005 license of any kind. Does this normally go on a
desktop and if so, what is the minimum license required to remain compliant?
THANK YOU in advance!... more >>
Reports Not Updating
Posted by dotNetDave at 6/22/2006 10:53:01 AM
I'm running Reporting Services on SQL 2000. I have some reports that
automatically run when you bring them up because the don't require
parameters. If I run the report (in IE) and then get out of the report. Then
change the underlying data in the database. Go back to Reporting Services and
r... more >>
How would i build a development environment for reportingservices
Posted by AG at 6/22/2006 10:39:03 AM
I have configured a development server with sql standard edition 2005
and have to give developer acees to this machine.I cannot install the
client tools of standard edition on windows xp systems and i get the
error "TYhe installation package is not supported by this processor
type".
How shoul... more >>
Report Designer: Refreshing Fields VERY Slow
Posted by Chance at 6/22/2006 9:35:02 AM
I have a query that uses temp tables, and the query seems to execute and
refresh fields fine, but as soon as I put in a parameter for a DateTime field
the query will run but the Refresh Fields button takes forever...like 2
hours! I think it is running my rather lengthy query without the parame... more >>
Custom data extension has trust issues
Posted by Ryan at 6/22/2006 8:55:46 AM
I wrote a custom data processing extension for reporting services in
SQL Server 2005. The extension works in preview mode, but when viewing
it from the report server I get the error:
----
An error has occurred during report processing. (rsProcessingAborted)
Cannot create command for data source... more >>
Change background color on toggle
Posted by GopherGold at 6/22/2006 7:27:03 AM
I have a report with a table, four columns. I added a second row to the
table and inserted a subreport. The subreport's ToggleItem is the first
column in the first detail row of the table. When I toggle a row to display
the subreport, I'd like to change the background color of the row. I c... more >>
Hardware considerations for Report Server?
Posted by Marc at 6/22/2006 6:59:02 AM
Hi all,
we use SSRS based on SSAS Cubes.
We thought about installing SSAS on one server, the relational data on an
other SQL Server and put the Report Server with the IIS 6.0 on a third
machine.
As we haven't any experiences with load and performance for BI-Applications
I'm wondering ... more >>
Parameter All Values and Values
Posted by Benw at 6/22/2006 6:32:02 AM
I am new at this parameter thing. I have a paramater that uses a drop down
list and can select multiple values. How can I let the user choose all of
the values without having to click on all the values individually. And also
How can I get the parameter to import the values into the dropdown... more >>
Matrix - Total in non column group
Posted by Maran at 6/22/2006 6:05:02 AM
Is it possible to create a "total" for a non "column group" ?
Usually you add a "SubTotal" to get values in column groups summarized. Is
it possible to do something similar to a "row group column"?
Like:
DataTable
"Q1", Id1, "NonGroup", 1, "Group1", 5
"Q1", Id1, "NonGroup", 1, "Group2", ... more >>
|