all groups > sql server reporting services > september 2006 > threads for wednesday september 20
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
Default Value for Paramters
Posted by SQLKen at 9/20/2006 4:51:16 PM
HI,
I set the default value for the report, but it doesn't show at runtime.
what is the problem? any work around trick?
Thanks
Ken
... more >>
AM PM format
Posted by Mark Goldin at 9/20/2006 4:25:06 PM
How can I show time portion of a date in "hh:mm:ss" AM?PM format?
Thanks
... more >>
401 Unauthorized When Access Application Remotely
Posted by Cyke at 9/20/2006 1:38:03 PM
Hello,
I have developed a web application which has a ReportViewer control
embedded in the page and connects to a remote Reporting Services
server. Everything works fine locally in my development environment.
However, when I deploy to the test server, the ReportViewer control
throws a Report... more >>
Re-installed RS2000 and "Setup could not initialize the report server"
Posted by VancouverGuy at 9/20/2006 11:14:04 AM
Hi folks,
I'm trying to reinstall Reporting Services 2000 on a Win2k3 box with
4 procs.
The install completes successfully, but at the last screen I recieve a
message saying
"Setup could not initialize the report server"
I have checked the following kb articles, but I still see the same... more >>
In a subscription, if the email fails, will I get notified?
Posted by DragonVic at 9/20/2006 11:09:02 AM
I have subscriotions that fail because someoen's email is no longer valid,
where is this information stored so I can fix the problem? I have a large
list and it is hard to do manually.... more >>
Need help with editing body columns and contents
Posted by David at 9/20/2006 10:54:02 AM
Hello,
I am new to MS RS and need help with clarification about body columns.
How can I accomplish a one-page report with 2 columns in the body section?
How do I edit the contents in the columns when I am in VS design mode?
I have a report that was previously built with only one column in th... more >>
problem with dates in parameter
Posted by Brian L at 9/20/2006 9:16:01 AM
Report query uses @startDate and @endDate for current date and tomorrow.
For currentdate I use =Today and that seems ok but if the report is run at
3PM the time shows 3PM rather than 00:00:00.
EndDate is more problematic. I've tried many different suggestions from
within this forum for obtai... more >>
Use RS2005 to run reports from a sql2000 db
Posted by Damon Johnson at 9/20/2006 9:15:01 AM
We have sql2000 EE installed on a dedicated WS2003 machine. RS2000 is not
installed.
I have just installed sql2005 SE and RS2005 on a seperate workstation
running WS2003.
Can I use RS2005 on the workstation to run reports from the sql2000 database
on the dedicated server?
I tried sear... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
A text file data source
Posted by Kerrie at 9/20/2006 8:53:47 AM
Hi all,
I have to write a report that uses a .txt file as a data-source and I
am not sure how to do that.
Anyone know where I can find out how to set this up? ODBC Connection?
The .txt file format is like this....(top 5 rows)
20040881 2004/12/22 01:30:12 NONIMPACT
20040883 2004/12/22 15:02... more >>
Passing UnNamed Parameters
Posted by BillB at 9/20/2006 8:07:02 AM
I have a Un-Named Parameter. User specifies any number from 1-24.
for this example 12 (meaning I want to find the Fiscal_Year,Fiscal_Period
12 months back from Today)
DataSetAA Source is (Reporting Services)
Select Fiscal_Year,Fiscal_Period, Start_Date
from Table A1
I'm looking for... more >>
HTTP status 400: Bad Request
Posted by cathedr NO[at]SPAM wa.state.gov at 9/20/2006 7:22:02 AM
I have SQL Server 2005 setup on an existing server. I just added SQL
Reporting Services to a Windows 2003 server. The initial install of
Reporting Services went flawlessly. After installation, I added the Service
Pack to Reporting Services so it would match the SQL Server I want to point
... more >>
|