|
|
|
June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
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 Parameterized query that will work for both Oracle and SQL Server Posted by John A at 6/2/2006 5:49:01 PM Hi, I have a dataset that I am using the following SQL DML to gather the data
select * from hermes.vwsurveyprepostresults where ssn = ? and surveydate = ?
This works fine when the Shared Data Source is Oracle. However when I am
using a SQL Server Shared Data Source I need to change it to the ...more >>
Reporting Services - Add a trendline with forecast to a chart Posted by EmmaNikki at 6/2/2006 4:47:11 PM I know how to add a trendline with forecast in Excel. How is it done in SRS?
Thank you,
Emma...more >>
RS service won't start Posted by Joe S. at 6/2/2006 3:01:02 PM I have RS 2005 on a Win 2003 SP1 x64 with SQL2005 & SQL 2000 installed. RS
was installed and running fine with several reports until one of my DC died.
I have a 2nd DC which I then had to install DHCP service, but other than that
everything else seems to running. Now the RS service wont start ...more >>
Getting a .rdl from a ReportBuilder save Posted by bill at 6/2/2006 2:48:32 PM I have created and deployed a report model.
I can go to http://localhost/reports not problem
I can create reports no problem using the Report Builder.
My question is: Is there a way of grabbing some sort of .rdl file or
something of that report so I can publish it to another server? After
I sa...more >>
Multi Value Parameters and Default Values Posted by retkow at 6/2/2006 2:16:02 PM How can I set a default value for a multi value parameter. Right now I have
a multi value parameter for states. In addition the value of ALL is also in
the param list. I would like the parameter to default to ALL so the user
isn't required to select a state.
ALL
AK
AL
AR
AZ
CA
CO...more >>
formatting with expressions trouble Posted by Benw at 6/2/2006 12:32:02 PM I am trying to make a whole row "bolder" if a field in that row return true.
iif(field = true,"bolder","normal")
Isnt that the way it is written inside the format weight in the properties....more >>
Triggering events in SQL Server Reporting Services 2005... Posted by SP at 6/2/2006 12:29:09 PM Hello there,
I have developed a Report using Reporting Services, Once the report is
displayed correctly with all the data, I would like the report to be
emailed to a set of users.
To achieve this functionality I have created a class in C# which send
emails to a set of users.
I reference ...more >>
Duplicate Information with Different IDs Posted by JDArsenault at 6/2/2006 12:00:02 PM I am trying to sum monthly hours for weekly timecards which have multiple
line items as tasks, but I am retrieving duplicate entries.
This is because a timecard can have a timecard_type of "r" (regular), or a
timecard_type of "c" (corrected).
If the timecard is corrected, the original with the...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Ignores date parameters Posted by Benw at 6/2/2006 11:15:02 AM I have a report with a beginning date and ending date. I want all the data
between those dates. It is set to datetime in the parameters and runs just
fine except it totally ignores my dates. It gives me just about everything.
Any suggestions?...more >>
SQL 2000 Database and SQL Server 2005 Database in same report Posted by AAA at 6/2/2006 9:51:02 AM Is anyone aware of whether you are able to use data from a SQL Server 2000
database and SQL 2005 database in the same report using SQL 2005 report
writing tools? If so, is there a recommended way to accomplish this. Any
tips would be much appreciated.
...more >>
Can't extract key with rskeymgmt Posted by sfp at 6/2/2006 7:32:32 AM I'm trying to move my RS from one machine to another. Following the MS
instructions found on
http://support.microsoft.com/?kbid=842425, it says to extract the
encryption key. When I try that, i get
C:>rskeymgmt.exe -e -f c:\rskey.txt -p thepassword
Are you sure you want to extract the key f...more >>
Adding Table Columns Posted by WvanWyk at 6/2/2006 3:37:02 AM Any help with this will be appreciated:
I have a simple table control in a report that has values in cells, some of
the cells contain values based on values of fields in the dataset i.e.
IIF(Field1 < Field2, Field1, Field2). How would I go about adding together
the actual results of cells i...more >>
Cascading parameters problem : First parameter is textbox Posted by sachin laddha at 6/2/2006 3:00:26 AM Hi,
I am using cascading parameters in my report. The first paramter is a
servername which user types in a TextBox. The second parameter is
populated based on the first parameter.
The problem is secord paramter drop down list doesn't get populated
unless I press "View Report" button in the ...more >>
Page break and subreport Posted by Jerome FAURE at 6/2/2006 2:04:45 AM Hello,
Using SSRS 2005, SP1.
I've got a report which contains a subreport.
This subreport is based on a list and can display one or more records.
When i put the subreport in its parent report, i give it an height
which is equal to the height necessary for displaying one record.
When i ...more >>
What is the new file type in SSRS 2005 for? Posted by jameslastowski via SQLMonster.com at 6/2/2006 12:00:00 AM Since upgrading to SSRS 2005 from SSRS 2000 we notice that there is a new
file created for each report once it runs. Whereas the report is named
Pipeline.rdl we have an addtional file named Pipeline.rdl.data and the listed
(file) Type is "Partition data". What can, should, or should not do with...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |