Report Formatting: run

Showing posts with label run. Show all posts

Friday, March 30, 2012

Report parameters

Hi everybody.
I have one dataset with parameter 'UserID' and second Dataset which fill
UserID parameter. When i run my report i can choose value from second
Dataset, but i wont that in my Parameter will be present value as 'All' which
mean all records from query. It is possible? if yes how? any sample?
P.S.
I know how add this value but i don't know how to write my query.
Thank you.Hello Dmitri,
Here is how to write the query to have 'All' included in your list of
users:
SELECT UserNo, UserName FROM Users
UNION
SELECT -1, 'All'
Take care,
Michelle|||Hi,
SELECT col1,col2,...
FROM table1
where col1 = CASE WHEN @.Param = 'All' THEN col1
ELSE @.Param
END
Eric|||oops, I forgot the second half - to check for the 'All' in your second
query:
SELECT something1, something2
FROM someTable
WHERE (User = @.User OR @.User = 'All')
or
SELECT something1, something2
FROM someTable
WHERE (UserNo = @.UserNo OR @.UserNo = -1)
Michelle|||Hi,
select col1,col2,col3
from table1
where col1 = case when @.param = 'all' then col1
else @.param
end
hth,
Eric|||Thank you all.
"Aiwa" wrote:
> Hi,
> select col1,col2,col3
> from table1
> where col1 = case when @.param = 'all' then col1
> else @.param
> end
> hth,
> Eric
>

Report parameter 'x' was not found.

I created a simple report to display the default value of a report parameter.
But when I run in VS it works, but when I run it under the "Custom Report"
in SQL Server Managment Studio the report parameter is not found. Below is
the code what am I doing wrong. Thanks in advance for your help.
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataSource1">
<DataSourceReference>DataSource1</DataSourceReference>
<rd:DataSourceID>b64e9e97-e752-4d30-8e40-ad77c2582190</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>1in</BottomMargin>
<RightMargin>1in</RightMargin>
<ReportParameters>
<ReportParameter Name="x">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>5</Value>
</Values>
</DefaultValue>
<Prompt>x</Prompt>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<Textbox Name="textbox1">
<Left>2in</Left>
<Top>0.375in</Top>
<rd:DefaultName>textbox1</rd:DefaultName>
<Width>1.125in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.375in</Height>
<Value>=First(Fields!x.Value, "DataSet1")</Value>
</Textbox>
</ReportItems>
<Height>2in</Height>
</Body>
<rd:ReportID>397ab84d-5c20-454f-9ec1-a1548611ba69</rd:ReportID>
<LeftMargin>1in</LeftMargin>
<DataSets>
<DataSet Name="DataSet1">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>select @.x x</CommandText>
<QueryParameters>
<QueryParameter Name="@.x">
<Value>=Parameters!x.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataSource1</DataSourceName>
</Query>
<Fields>
<Field Name="x">
<rd:TypeName>System.Object</rd:TypeName>
<DataField>x</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>6.5in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>1in</TopMargin>
</Report>Did you find a solution to this?
--
-sam
"Greg Larsen" wrote:
> I created a simple report to display the default value of a report parameter.
> But when I run in VS it works, but when I run it under the "Custom Report"
> in SQL Server Managment Studio the report parameter is not found. Below is
> the code what am I doing wrong. Thanks in advance for your help.
> <?xml version="1.0" encoding="utf-8"?>
> <Report
> xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <DataSources>
> <DataSource Name="DataSource1">
> <DataSourceReference>DataSource1</DataSourceReference>
> <rd:DataSourceID>b64e9e97-e752-4d30-8e40-ad77c2582190</rd:DataSourceID>
> </DataSource>
> </DataSources>
> <BottomMargin>1in</BottomMargin>
> <RightMargin>1in</RightMargin>
> <ReportParameters>
> <ReportParameter Name="x">
> <DataType>String</DataType>
> <DefaultValue>
> <Values>
> <Value>5</Value>
> </Values>
> </DefaultValue>
> <Prompt>x</Prompt>
> </ReportParameter>
> </ReportParameters>
> <rd:DrawGrid>true</rd:DrawGrid>
> <InteractiveWidth>8.5in</InteractiveWidth>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <Body>
> <ReportItems>
> <Textbox Name="textbox1">
> <Left>2in</Left>
> <Top>0.375in</Top>
> <rd:DefaultName>textbox1</rd:DefaultName>
> <Width>1.125in</Width>
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <CanGrow>true</CanGrow>
> <Height>0.375in</Height>
> <Value>=First(Fields!x.Value, "DataSet1")</Value>
> </Textbox>
> </ReportItems>
> <Height>2in</Height>
> </Body>
> <rd:ReportID>397ab84d-5c20-454f-9ec1-a1548611ba69</rd:ReportID>
> <LeftMargin>1in</LeftMargin>
> <DataSets>
> <DataSet Name="DataSet1">
> <Query>
> <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
> <CommandText>select @.x x</CommandText>
> <QueryParameters>
> <QueryParameter Name="@.x">
> <Value>=Parameters!x.Value</Value>
> </QueryParameter>
> </QueryParameters>
> <DataSourceName>DataSource1</DataSourceName>
> </Query>
> <Fields>
> <Field Name="x">
> <rd:TypeName>System.Object</rd:TypeName>
> <DataField>x</DataField>
> </Field>
> </Fields>
> </DataSet>
> </DataSets>
> <Width>6.5in</Width>
> <InteractiveHeight>11in</InteractiveHeight>
> <Language>en-US</Language>
> <TopMargin>1in</TopMargin>
> </Report>

Report parameter with datetime

Hi,

Anyone can help me?

I created a store proc with @.startdate and @.enddate

in query analyser - I run it as Exec SP_Admission '2006/01/01','2006/01/25' and it is ok.

Then I created a report in VS2005 and set the parameter as datetime in report parameter.

if I manually force to fill startdate and enddate with ‘yyyy/mm/dd’ format in preview, it works.

However if I choose the date from the given calendar(Date Time Picker), it doesn’t work

it is said that "The value provided the report parameter 'enddate' is not valid for its type.

Of course it not valid because it always comes with ‘dd/mm/yyyy’ format

I didn't setup the date time picker, it will automatically when I choose datetime as datatype.

any idea what should I do?

thanks,

Susan

Hi Susan,

not exactly brilliant, but

Exec SP_Admission convert(datetime,'12/10/2006',103),convert(datetime,'12/11/2006',103)
should work in your case, so put your parameter instead of '12/10/2006'
|||

Thanks...

someone suggested that in my SP -

I declare as varchar then in where statement I convert it as you mention.

however in report para - I can't set it as datetime but set to string.

it works ok but I can't use the date time picker .

well at least works that way...

Thanks so much

Report Parameter in Report Builder

How do you create report parameter in Report Builder? I want to create a new field and add to the report. When I run the report, it'll prompt for entering the value.

Thanks in advance!!

Brian wrote a blog article about this: http://blogs.msdn.com/bwelcker/archive/2006/07/29/682444.aspx

-- Robert

Wednesday, March 28, 2012

Report Parameter Default Value from Column

DataSet2:
select MyCol1 from MySecondTable
In the Report Parameters dialog box, I add MyCol1 as a multi-value
parameter. When I run the report, I can select one or more values from the
MyCol1 drop-down. This works great.
The problem is I want the first value in MyCol1 to be the default value in
the drop-down. In the Default Values box, I select Non-queried, and use the
expression =Parameters!MyCol1.Value(0) This seems exactly right to me.
With the default value set as above, the report fails to run with the
following error: Error during processing of 'MyCol1' report parameter.
Any suggestions on how to fix this?
Thanks,
--
RandyYou can create a hidden parameter but not multi-valued. Set its default
value as coming from a query and select MyCol1 in DataSet2, it should pull
the first value from the dataset. Then you can set the default value of the
multi-valued parameter to the value of the hidden parameter.
"randy1200" wrote:
> DataSet2:
> select MyCol1 from MySecondTable
> In the Report Parameters dialog box, I add MyCol1 as a multi-value
> parameter. When I run the report, I can select one or more values from the
> MyCol1 drop-down. This works great.
> The problem is I want the first value in MyCol1 to be the default value in
> the drop-down. In the Default Values box, I select Non-queried, and use the
> expression =Parameters!MyCol1.Value(0) This seems exactly right to me.
> With the default value set as above, the report fails to run with the
> following error: Error during processing of 'MyCol1' report parameter.
> Any suggestions on how to fix this?
> Thanks,
> --
> Randy|||I have done this by creating another dataset called someting like
MyCol1Default defined as:
SELECT TOP1 MyCol1 FROM MySecondTable
or
SELECT MIN(MyCol1) FROM MySecondTable
Then in the report parameter definition specify that the default comes from
dataset MyCol1Default and that the value is MyCol1.
HTH,
Magendo_man
"randy1200" wrote:
> DataSet2:
> select MyCol1 from MySecondTable
> In the Report Parameters dialog box, I add MyCol1 as a multi-value
> parameter. When I run the report, I can select one or more values from the
> MyCol1 drop-down. This works great.
> The problem is I want the first value in MyCol1 to be the default value in
> the drop-down. In the Default Values box, I select Non-queried, and use the
> expression =Parameters!MyCol1.Value(0) This seems exactly right to me.
> With the default value set as above, the report fails to run with the
> following error: Error during processing of 'MyCol1' report parameter.
> Any suggestions on how to fix this?
> Thanks,
> --
> Randy

Report Parameter Dataset Running Twice?

Hi,
I have a DDL Report Parameter tied to a Dataset.
When I go to view the Report in RS the Dataset is run to populate the
Parameter, but it also seems to run the Dataset when I hit the View Report
button.
I don't have the Dataset tied to anything except the Report Parameter.
Is there a way to stop the 2nd run?
thank you
tOn May 22, 11:59 am, DigHazuse <DigHaz...@.discussions.microsoft.com>
wrote:
> Hi,
> I have a DDL Report Parameter tied to a Dataset.
> When I go to view the Report in RS the Dataset is run to populate the
> Parameter, but it also seems to run the Dataset when I hit the View Report
> button.
> I don't have the Dataset tied to anything except the Report Parameter.
> Is there a way to stop the 2nd run?
> thank you
> t
It should only be running to populate the report parameter. It sounds
like you possibly have the autorefresh set for the report (go to the:
Report drop-down tab -> Report Properties... -> General tab ->
autorefresh and see if it is selected). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thank you for responding Enrique ... unfortunately that box is not checked.
Any other ideas?
thank you
t
"EMartinez" wrote:
> On May 22, 11:59 am, DigHazuse <DigHaz...@.discussions.microsoft.com>
> wrote:
> > Hi,
> > I have a DDL Report Parameter tied to a Dataset.
> >
> > When I go to view the Report in RS the Dataset is run to populate the
> > Parameter, but it also seems to run the Dataset when I hit the View Report
> > button.
> >
> > I don't have the Dataset tied to anything except the Report Parameter.
> >
> > Is there a way to stop the 2nd run?
> >
> > thank you
> > t
>
> It should only be running to populate the report parameter. It sounds
> like you possibly have the autorefresh set for the report (go to the:
> Report drop-down tab -> Report Properties... -> General tab ->
> autorefresh and see if it is selected). Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>sql

Report Pack for IIS

Hi,
I am wondering if I can run the "Microsoft SQL Server Report Pack for
Internet Information Services (IIS)" on a SQL 2005 64 bit.
2nd question, where can I find the script as well as some DTS or jobs to
populate the IISlog DB.
ThanksHello,
Based on my research, Microsoft SQL Server Report Pack for Internet
Information Services (IIS) only support SQL Server 2000.
To confirm that, I tried to tested on my side and I could not install it on
the SQL 2005 server.
As for the second question, I am not sure what you want to do with the
IISLog DB. Would you please try to make it more clear?
Please NOTE: Microsoft SQL Server Report Pack for Internet Information
Services (IIS) is licensed "as-is" It is not supported, and you bear the
risk of using it. Microsoft gives no express warranties, guarantees or
conditions.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi, I found the package for sql 2005 at
"http://www.microsoft.com/downloads/details.aspx?FamilyId=D81722CE-408C-4FB6-A429-2A7ECD62F674&displaylang=en
I managed to make it work, For the second question, I need to know if there
is any process has been devloped to import data from log files to the Database
Thansk
"Wei Lu [MSFT]" wrote:
> Hello,
> Based on my research, Microsoft SQL Server Report Pack for Internet
> Information Services (IIS) only support SQL Server 2000.
> To confirm that, I tried to tested on my side and I could not install it on
> the SQL 2005 server.
> As for the second question, I am not sure what you want to do with the
> IISLog DB. Would you please try to make it more clear?
> Please NOTE: Microsoft SQL Server Report Pack for Internet Information
> Services (IIS) is licensed "as-is" It is not supported, and you bear the
> risk of using it. Microsoft gives no express warranties, guarantees or
> conditions.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>|||Hello
Based on my test, you could the Log Parser which included with the IIS 6.0
Resource Kit to populated with your own IIS Log to your SQL Server.
Internet Information Services (IIS) 6.0 Resource Kit Tools
http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=56fc
92ee-a71a-4c73-b628-ade629c89499
The following example exports data from W3C Extended log files and writes
it to a SQL table:
logparser "Select TO_TIMESTAMP(date, time) as Timestamp,
cs-uri-stem as UriStem, cs-uri-query as UriQuery FROM ex000123.log TO
TestTable"
¨Ci:W3C -o:SQL -server:SERVERSQL
-driver:"SQL Server" -database:LogDB -username:user
-password:xxx
-createtable:ON
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.sql

Report ownership

I have 2 reports that run against a Oracle database. They run fine on my
development PC. Had huge problems getting them to run on the Reports Manager
scheduled. We finally got one working, after days of beating on it, it was
uploaded by the senior DBA (so owned by his userid also), the connection file
was also uploaded by the senior DBA, this report runs fine. The other,
report gets an error saying:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'cdbprod'.
(rsErrorOpeningConnection) Get Online Help
Error while trying to retrieve text for error ORA-12154
--
www.duanelawrence.comThe ReportServer Windows service is responsible for executing scheduled
reports. It will be doing this under the specified service user account
(which is typically a low-privileged user account). You may run into file
permission issues related to tnsnames.ora or other Oracle client dlls.
Please verify based on KB 870668 that the service account has sufficient
permissions:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B870668
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"duanelawrence.com" <duanelawrencecom@.discussions.microsoft.com> wrote in
message news:9DA7837D-D8D8-4300-A32E-8AEA0127ACA7@.microsoft.com...
> I have 2 reports that run against a Oracle database. They run fine on my
> development PC. Had huge problems getting them to run on the Reports
Manager
> scheduled. We finally got one working, after days of beating on it, it
was
> uploaded by the senior DBA (so owned by his userid also), the connection
file
> was also uploaded by the senior DBA, this report runs fine. The other,
> report gets an error saying:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'cdbprod'.
> (rsErrorOpeningConnection) Get Online Help
> Error while trying to retrieve text for error ORA-12154
> --
> www.duanelawrence.com
>|||Thanks Robert
I wish to add some information that I did not say in the first post. We are
using a
"shared data source" with "Credentials stored securely in the report server
" set to on. You see, we are scheduling the reports to run in the Reports
Manager (you can not create a schedule until you use "Credentials stored
securely in the report server " option). When you look at the Reports
Manager in a web browser and click on "Show Details", you will see a
"Modified By" column. The user id in the modified by column has to have read
and execute privileges to the 2 named directories in the article.
I have read many articles saying exactly what you say below, but I have
proof that it is not true. I added my user id to the 2 directories named in
the article you listed and the reports work fine. The user id in the "shared
data source" under "Credentials stored securely in the report server " only
has the privileges created by the Oracle DBA, no network privaleges at all.
Duane
"Robert Bruckner [MSFT]" wrote:
> The ReportServer Windows service is responsible for executing scheduled
> reports. It will be doing this under the specified service user account
> (which is typically a low-privileged user account). You may run into file
> permission issues related to tnsnames.ora or other Oracle client dlls.
> Please verify based on KB 870668 that the service account has sufficient
> permissions:
> http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B870668
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "duanelawrence.com" <duanelawrencecom@.discussions.microsoft.com> wrote in
> message news:9DA7837D-D8D8-4300-A32E-8AEA0127ACA7@.microsoft.com...
> > I have 2 reports that run against a Oracle database. They run fine on my
> > development PC. Had huge problems getting them to run on the Reports
> Manager
> > scheduled. We finally got one working, after days of beating on it, it
> was
> > uploaded by the senior DBA (so owned by his userid also), the connection
> file
> > was also uploaded by the senior DBA, this report runs fine. The other,
> > report gets an error saying:
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot create a connection to data source 'cdbprod'.
> > (rsErrorOpeningConnection) Get Online Help
> > Error while trying to retrieve text for error ORA-12154
> >
> > --
> >
> > www.duanelawrence.com
> >
> >
>
>|||More supporting evidence
http://www.sqlmonster.com/Uwe/ForumPost.aspx?article=sql-server-reporting:6675:77E633A0-1B40-4766-936D-73B640F3DBF8%40microsoft.com
I consider this closed.
Duane
"duanelawrence.com" wrote:
> Thanks Robert
> I wish to add some information that I did not say in the first post. We are
> using a
> "shared data source" with "Credentials stored securely in the report server
> " set to on. You see, we are scheduling the reports to run in the Reports
> Manager (you can not create a schedule until you use "Credentials stored
> securely in the report server " option). When you look at the Reports
> Manager in a web browser and click on "Show Details", you will see a
> "Modified By" column. The user id in the modified by column has to have read
> and execute privileges to the 2 named directories in the article.
> I have read many articles saying exactly what you say below, but I have
> proof that it is not true. I added my user id to the 2 directories named in
> the article you listed and the reports work fine. The user id in the "shared
> data source" under "Credentials stored securely in the report server " only
> has the privileges created by the Oracle DBA, no network privaleges at all.
> Duane
>
>
> "Robert Bruckner [MSFT]" wrote:
> > The ReportServer Windows service is responsible for executing scheduled
> > reports. It will be doing this under the specified service user account
> > (which is typically a low-privileged user account). You may run into file
> > permission issues related to tnsnames.ora or other Oracle client dlls.
> > Please verify based on KB 870668 that the service account has sufficient
> > permissions:
> > http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B870668
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "duanelawrence.com" <duanelawrencecom@.discussions.microsoft.com> wrote in
> > message news:9DA7837D-D8D8-4300-A32E-8AEA0127ACA7@.microsoft.com...
> > > I have 2 reports that run against a Oracle database. They run fine on my
> > > development PC. Had huge problems getting them to run on the Reports
> > Manager
> > > scheduled. We finally got one working, after days of beating on it, it
> > was
> > > uploaded by the senior DBA (so owned by his userid also), the connection
> > file
> > > was also uploaded by the senior DBA, this report runs fine. The other,
> > > report gets an error saying:
> > >
> > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > Online Help
> > > Cannot create a connection to data source 'cdbprod'.
> > > (rsErrorOpeningConnection) Get Online Help
> > > Error while trying to retrieve text for error ORA-12154
> > >
> > > --
> > >
> > > www.duanelawrence.com
> > >
> > >
> >
> >
> >|||I'm not sure I understand your last posting. Does it work now for the shared
data source in your case?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"duanelawrence.com" <duanelawrencecom@.discussions.microsoft.com> wrote in
message news:5AEAE806-5968-4D04-A55C-8F5C55C432E5@.microsoft.com...
> More supporting evidence
>
http://www.sqlmonster.com/Uwe/ForumPost.aspx?article=sql-server-reporting:6675:77E633A0-1B40-4766-936D-73B640F3DBF8%40microsoft.com
> I consider this closed.
> Duane
>
>
> "duanelawrence.com" wrote:
> > Thanks Robert
> >
> > I wish to add some information that I did not say in the first post. We
are
> > using a
> > "shared data source" with "Credentials stored securely in the report
server
> > " set to on. You see, we are scheduling the reports to run in the
Reports
> > Manager (you can not create a schedule until you use "Credentials stored
> > securely in the report server " option). When you look at the Reports
> > Manager in a web browser and click on "Show Details", you will see a
> > "Modified By" column. The user id in the modified by column has to have
read
> > and execute privileges to the 2 named directories in the article.
> >
> > I have read many articles saying exactly what you say below, but I have
> > proof that it is not true. I added my user id to the 2 directories
named in
> > the article you listed and the reports work fine. The user id in the
"shared
> > data source" under "Credentials stored securely in the report server "
only
> > has the privileges created by the Oracle DBA, no network privaleges at
all.
> >
> > Duane
> >
> >
> >
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > The ReportServer Windows service is responsible for executing
scheduled
> > > reports. It will be doing this under the specified service user
account
> > > (which is typically a low-privileged user account). You may run into
file
> > > permission issues related to tnsnames.ora or other Oracle client dlls.
> > > Please verify based on KB 870668 that the service account has
sufficient
> > > permissions:
> > > http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B870668
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > >
> > >
> > > "duanelawrence.com" <duanelawrencecom@.discussions.microsoft.com> wrote
in
> > > message news:9DA7837D-D8D8-4300-A32E-8AEA0127ACA7@.microsoft.com...
> > > > I have 2 reports that run against a Oracle database. They run fine
on my
> > > > development PC. Had huge problems getting them to run on the
Reports
> > > Manager
> > > > scheduled. We finally got one working, after days of beating on it,
it
> > > was
> > > > uploaded by the senior DBA (so owned by his userid also), the
connection
> > > file
> > > > was also uploaded by the senior DBA, this report runs fine. The
other,
> > > > report gets an error saying:
> > > >
> > > > An error has occurred during report processing.
(rsProcessingAborted) Get
> > > > Online Help
> > > > Cannot create a connection to data source 'cdbprod'.
> > > > (rsErrorOpeningConnection) Get Online Help
> > > > Error while trying to retrieve text for error ORA-12154
> > > >
> > > > --
> > > >
> > > > www.duanelawrence.com
> > > >
> > > >
> > >
> > >
> > >

Monday, March 26, 2012

Report OK in local development, won't run on server

I am attempting to migrate a report I developed locally in my development
environment to the Reporting Services server in preparation for deployment.
The report gets its data from a stored procedure that requires no
parameters; it simply runs and returns data.
I am able to upload the RDL file to the server without incident and the
report is shown properly in the report listing on the reporting server web
page.
However when I try to render the report on the reporting server I receive
the following errors:
An error has occurred during report processing. (rsProcessingAborted)
Cannot set the command type for data set 'DataSet1'.
(rsErrorSettingCommandType)
Stored Procedure command type is not supported.
The report itself is very simple, only one matrix control exists on the page.
I did not install the server environment myself however I have been able to
determine that Reporting Services SP2 has been installed - as it has been in
my development environment.
Any help you could give would be appreciated, thanks.
-ChuckAlthough I haven't see this exact error I have seen an issue with the stored
procedure security rights not allowing the credentials your report is
running under to execute it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ExNooYorka" <ExNooYorka@.discussions.microsoft.com> wrote in message
news:3447A77A-5DB5-4D1B-A067-3E576605F484@.microsoft.com...
>I am attempting to migrate a report I developed locally in my development
> environment to the Reporting Services server in preparation for
> deployment.
> The report gets its data from a stored procedure that requires no
> parameters; it simply runs and returns data.
> I am able to upload the RDL file to the server without incident and the
> report is shown properly in the report listing on the reporting server web
> page.
> However when I try to render the report on the reporting server I receive
> the following errors:
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot set the command type for data set 'DataSet1'.
> (rsErrorSettingCommandType)
> Stored Procedure command type is not supported.
> The report itself is very simple, only one matrix control exists on the
> page.
> I did not install the server environment myself however I have been able
> to
> determine that Reporting Services SP2 has been installed - as it has been
> in
> my development environment.
> Any help you could give would be appreciated, thanks.
> -Chuck|||Bruce:
Thanks for the reply.
When I read your reply I thought you hit the nail right on the head
because on the remote SQL Server I had indeed not granted credentials
to anyone - only admins could run my stored procedure.
However even granting rights to the PUBLIC group did not resolve the
problem described below.
I have, however, resolved it.
The data source present on the reporting server was pointed to a custom
data provider that did not support the Stored Procedure command type.
I believe it was the custom data provider (or the layer that interacts
with the custom data provider) that was throwing the error described
below.
I created a new data source on the report server that points to the
native SQL Server data provider and that resolved the issue.
Thanks again for your help - a fresh pair of eyes is always most
helpful.
-Chuck
Bruce L-C [MVP] wrote:
> Although I haven't see this exact error I have seen an issue with the stored
> procedure security rights not allowing the credentials your report is
> running under to execute it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ExNooYorka" <ExNooYorka@.discussions.microsoft.com> wrote in message
> news:3447A77A-5DB5-4D1B-A067-3E576605F484@.microsoft.com...
> >I am attempting to migrate a report I developed locally in my development
> > environment to the Reporting Services server in preparation for
> > deployment.
> >
> > The report gets its data from a stored procedure that requires no
> > parameters; it simply runs and returns data.
> >
> > I am able to upload the RDL file to the server without incident and the
> > report is shown properly in the report listing on the reporting server web
> > page.
> >
> > However when I try to render the report on the reporting server I receive
> > the following errors:
> >
> > An error has occurred during report processing. (rsProcessingAborted)
> > Cannot set the command type for data set 'DataSet1'.
> > (rsErrorSettingCommandType)
> > Stored Procedure command type is not supported.
> >
> > The report itself is very simple, only one matrix control exists on the
> > page.
> >
> > I did not install the server environment myself however I have been able
> > to
> > determine that Reporting Services SP2 has been installed - as it has been
> > in
> > my development environment.
> >
> > Any help you could give would be appreciated, thanks.
> >
> > -Chuck

Report of Job Activities

I need a report of all job monitoring activities. How can you run a report
out of SQL 2005 which list the reports by day, date and time
--
WPJLYou may want to be more specific on exactly what you'd like to accomplish.
Perhaps, an example would help.
Linchi
"WPJL" wrote:
> I need a report of all job monitoring activities. How can you run a report
> out of SQL 2005 which list the reports by day, date and time
> --
> WPJL|||WPJL
As Linchi said , to help you we need an exmaple
http://dimantdatabasesolutions.blogspot.com/2008/03/sql-server-agent-jobs-duration-report.html
"WPJL" <WPJL@.discussions.microsoft.com> wrote in message
news:CFA4269C-267E-4CE4-A53A-085FC22621B6@.microsoft.com...
>I need a report of all job monitoring activities. How can you run a report
> out of SQL 2005 which list the reports by day, date and time
> --
> WPJL|||I asked to create an analysis report of all jobs which run via SQL Service
Job Activity. The data that is needed is the day, date and time intervals
which each job runs. The requestors want a side by side analysis to view
specific jobs that run on the same day and time. We currently have
approximately 72 jobs which run via SQL server. To get the information into
a spread sheet, I had to open the job history and properties and manually
enter this information in an excel spreadsheet. This is very time consuming.
Examples of jobs â' Job A run everyday M-F at 6:00 a.m., Job B run M-F at
6:00 a.m., Job C may run everyday starting 12:00 a.m, until 12:00 midnight.
However, the job runs M_F, at time intervals of every 10 minutes. It starts
at 12:00, 12:10, 12:20 and so on.
I wanted to know if there was a way to query the Job Activity data out of
SQL query where I could create an analysis report which would show a
comparison of the days, dates and interval times that each report runs.
Thanks.
--
WPJL
"Linchi Shea" wrote:
> You may want to be more specific on exactly what you'd like to accomplish.
> Perhaps, an example would help.
> Linchi
> "WPJL" wrote:
> > I need a report of all job monitoring activities. How can you run a report
> > out of SQL 2005 which list the reports by day, date and time
> > --
> > WPJL

Report not right in VB

I've got a report that works great in Crystal, but when I run the report in VB, I get a nearly blank report. (see attachments)
There are 3 sub reports in the main report.

Here is the code that I use for the report. I've used similar code before and it's worked before.

Dim CRXReport As CRAXDDRT.Report
Dim CRXDb As CRAXDDRT.Database
Dim CRXTbl As CRAXDDRT.DatabaseTable

Dim con As ADODB.Connection
Dim rs As ADODB.Recordset

Dim init As Integer
Dim rptNum As Integer
Dim rptBranch As String
Dim rptDate As String

Set CRXReport = Report
Set CRXDb = CRXReport.Database
Set Report = app.OpenReport("D:\mgmntReport\mgmntReportLandscape.rpt")

Set con = New ADODB.Connection
Set rs = New ADODB.Recordset

con.Open "Driver={SQL Server};Server=TSGDEV07;Database=SEDONADW;Uid=sa;Pwd=psswrd;"
rs.Open "SELECT DISTINCT cono, officeno FROM management_YTD_Payroll", con

rptDate = Trim(Str(Month(Date))) & Trim(Str(Day(Date))) & Trim(Str(Year(Date)))
'MkDir "c:\MgmntReports\" & rptDate & "\"

rptNum = 1
Do While Not (rs.EOF Or rs.BOF)
Report.DiscardSavedData
frmMain.Show

'Debug.Print Report.Database.Tables.Count
Report.Database.Tables.Item(1).SetLogOnInfo "TSGDEV07", "sedonaDW", "sa", "psswrd"
Report.Database.Tables.Item(2).SetLogOnInfo "TSGDEV07", "sedonaDW", "sa", "psswrd"
Report.Database.Tables.Item(3).SetLogOnInfo "TSGDEV07", "sedonaDW", "sa", "psswrd"
Report.Database.Tables.Item(4).SetLogOnInfo "TSGDEV07", "sedonaDW", "sa", "psswrd"

Report.ParameterFields(1).AddCurrentValue Str(rs.Fields("cono"))
Report.ParameterFields(2).AddCurrentValue Str(rs.Fields("officeno"))

Report.ExportOptions.DestinationType = crEDTDiskFile
Report.ExportOptions.FormatType = crEFTPortableDocFormat
Report.ExportOptions.PDFExportAllPages = True
Report.ExportOptions.DiskFileName = "D:\mgmntReport\Reports\" & rs.Fields("cono") & rs.Fields("officeno") & ".pdf"
Report.Export False
rs.MoveNext
Loop
rs.Close
con.Close

Set rs = Nothing
Set con = Nothing
Set CRXReport = Nothing

Anyone have any suggestions?I think the problem may be with the sub-reports.
The 'Report.Database.Tables.Item(1).SetLogOnInfo ...' lines are only setting the logOnInfo for the tables in the main report. I need to login to about 6 other tables for the sub reports. I have no idea about how to do that though.|||I have an idea how to get to the sub report.

Report.OpenSubreport("billings.rpt").Database.Tables.Item(1).SetLogOnInfo..."

also

report.OpenSubreport("billings.rpt").ParameterFields(1).addCurrentValue..."|||Here is what i got to work. (adapted from http://support.businessobjects.com/communitycs/filesandupdates/scr8_vb_rdc_subreports.exe.asp)

Option Explicit
'this application illustrates how to set properties of a subreport at runtime
'although it specifically sets the database location and the value for a text object
'the logic is the same for formatting fields, passing log on information, setting parameter values, etc.
Dim app As New CRAXDDRT.Application
Dim Report As New CRAXDDRT.Report

'Dim CRReport As New CrystalReport1

Private Sub Form_Load()
Dim CRXReport As CRAXDDRT.Report
Dim CRXDb As CRAXDDRT.Database
Dim CRXTbl As CRAXDDRT.DatabaseTable

Dim con As ADODB.Connection
Dim rs As ADODB.Recordset
Dim i As Integer
Dim j As Integer
Dim x As Integer

Set con = New ADODB.Connection
Set rs = New ADODB.Recordset

con.Open "Driver={SQL Server};Server=TSGDEV07;Database=SEDONADW;Uid=sa;Pwd=psswrd;"
rs.Open "SELECT DISTINCT cono, officeno FROM management_YTD_Payroll", con

Set CRXReport = Report
Set CRXDb = CRXReport.Database
Set Report = app.OpenReport(rptPath & "mgmntReportLandscape.rpt")

'this code works through the RDC object model to identify a subreport object
'in the main report
Dim crSecs As CRAXDRT.Sections
Dim crSec As CRAXDRT.Section
Dim crRepObjs As CRAXDRT.ReportObjects
Dim crSubRepObj As CRAXDRT.SubreportObject
Dim crSubReport As CRAXDRT.Report

Set crSecs = Report.Sections
For i = 1 To crSecs.Count
Set crSec = crSecs.Item(i)
Set crRepObjs = crSec.ReportObjects
For x = 1 To crRepObjs.Count
If crRepObjs.Item(x).Kind = crSubreportObject Then

Set crSubReport = Report.OpenSubreport(crRepObjs.Item(x).SubreportName)

'the following code sets the subreport table to a different database
For j = 1 To crSubReport.Database.Tables.Count
crSubReport.Database.Tables.Item(j).SetLogOnInfo "TSGDEV07", "sedonaDW", "sa", "psswrd"
Next j
'within this loop you can set other properties of the subreport and
'the field objects and sections in it.
End If
Next
Next
Do While Not (rs.EOF Or rs.BOF)
Report.DiscardSavedData
Report.ParameterFields(1).AddCurrentValue CStr(rs.Fields("cono"))
Report.ParameterFields(2).AddCurrentValue CStr(rs.Fields("officeno"))
Report.ExportOptions.DestinationType = crEDTDiskFile
Report.ExportOptions.FormatType = crEFTPortableDocFormat
Report.ExportOptions.PDFExportAllPages = True
Report.ExportOptions.DiskFileName = "D:\mgmntReport\Reports\" & rs.Fields("cono") & rs.Fields("officeno") & ".pdf"
Report.Export False
rs.MoveNext
Loop

rs.Close
con.Close
Set rs = Nothing
Set con = Nothing
End
End Sub

Private Sub Form_Resize()
CRViewer1.Left = 0
CRViewer1.Height = ScaleHeight
CRViewer1.Width = ScaleWidth
frmMain.WindowState = vbMaximized
End Sub

Tuesday, March 20, 2012

Report Manager Port Question

Is it possible to run Report Manager from a different port. I know that local host is set to port 80 by default. My default Web Site is set to Port 81 and I can not get Report Manager to run. An example is http://localhost:81/Reports.You need to set the ReportServerUrl property in RSWebApplication.config to point to the port where the report server is installed.
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks for the reply Brian. I tried that and it did not work. I have not rebooted the computer since the change so I will try a reboot this evening.

Gerry

Monday, March 12, 2012

report manager parameter BUG

here is an example of this bug at work.. (i am using RS SP1)
1) upload this report into report manager
2) - RUN THE Report, and notice that the 2nd parameter called
'defaultparam' gets set to the date, and it works.. (all the report
does is show this parameter)
3) - go to the parameter editing section of hte report in report
manager
4) - change something UNRELELATED to defaultparam - for instance the
PROMPT of the firstparameter - dummyparam, and then APPLY
5) - go back to the report - and "defaultparam" nolonger calculates the
date (the default parameter expression in the report)
conclusion, report manager not only updates the parameters you change,
(as it should to give the administrator ability to), it erroneously
updates all the parameters..
also i notice that query based default (foir single value, rather than
name,value) don't show up in report manager as "query based" (and thus also
sucumb to this bug")
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini..."xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<Top>0.125in</Top>
<rd:DefaultName>textbox1</rd:DefaultName>
<Height>0.25in</Height>
<Width>1in</Width>
<CanGrow>true</CanGrow>
<Value>=Parameters!defaultparam.Value</Value>
<Left>0.25in</Left>
</Textbox>
</ReportItems>
<Style />
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<Width>6.5in</Width>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>ed8d8d8c-443f-4598-82a1-db50fd8cbc9a</rd:ReportÂID>
<BottomMargin>1in</BottomMargin>
<ReportParameters>
<ReportParameter Name="dummyparam">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>dummyparameter</Prompt>
</ReportParameter>
<ReportParameter Name="defaultparam">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>=Format(DateTime.Now,"d")</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>defaultparam</Prompt>
</ReportParameter>
<ReportParameter Name="nextparam">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>Report_Parameter_2</Prompt>
</ReportParameter>
</ReportParameters>
<Language>en-US</Language>
</Report>please excuse the double posts, i thought i was putting it on a private
newsgroup at msdn subscribers|||This is a known limitation of the report manager report parameter page.
This issue should be fixed in Yukon.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Karl Prosser" <laborready.com@.kprosser(backwards)> wrote in message
news:2D74DC06-9039-4576-86DB-01055F1A98A6@.microsoft.com...
> please excuse the double posts, i thought i was putting it on a private
> newsgroup at msdn subscribers|||is there a way to make a 'hidden writeable (not read only) parameter' other
than changing in in report manager (which messes up the other default ones?)
because in report designer you can't make it this way, you can omit the
prompt , but then its hidden but gives you READONLY parameter errors if
trying to set it in the URL..
maybe there is a script that uses the webservice or something?
"Daniel Reib [MSFT]" wrote:
> This is a known limitation of the report manager report parameter page.
> This issue should be fixed in Yukon.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Karl Prosser" <laborready.com@.kprosser(backwards)> wrote in message
> news:2D74DC06-9039-4576-86DB-01055F1A98A6@.microsoft.com...
> > please excuse the double posts, i thought i was putting it on a private
> > newsgroup at msdn subscribers
>
>|||There is actually a way to achieve a hidden parameter in SP1 and in the
upcoming SP2 through report designer: specify just at least one blank as
report parameter prompt and publish to the report server.
Note: the parameter will still be prompted in designer preview, but it will
not be prompted in the viewer of report manager.
The next version (RS2005) will have a better solution for managing hidden
parameters (also through the SOAP API and report manager).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Karl Prosser" <laborready.com@.kprosser(backwards)> wrote in message
news:1BCA549E-DD3D-4754-A1D1-6077EA3D3243@.microsoft.com...
> is there a way to make a 'hidden writeable (not read only) parameter'
> other
> than changing in in report manager (which messes up the other default
> ones?)
> because in report designer you can't make it this way, you can omit the
> prompt , but then its hidden but gives you READONLY parameter errors if
> trying to set it in the URL..
> maybe there is a script that uses the webservice or something?
>
> "Daniel Reib [MSFT]" wrote:
>> This is a known limitation of the report manager report parameter page.
>> This issue should be fixed in Yukon.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Karl Prosser" <laborready.com@.kprosser(backwards)> wrote in message
>> news:2D74DC06-9039-4576-86DB-01055F1A98A6@.microsoft.com...
>> > please excuse the double posts, i thought i was putting it on a private
>> > newsgroup at msdn subscribers
>>|||nice.. just a space instead of a blank.. well at least i can control it
completely from the RDL, its a big releif, i think i need to start a site
with Questions and Answers for these bizarre things in RS
"Robert Bruckner [MSFT]" wrote:
> There is actually a way to achieve a hidden parameter in SP1 and in the
> upcoming SP2 through report designer: specify just at least one blank as
> report parameter prompt and publish to the report server.
> Note: the parameter will still be prompted in designer preview, but it will
> not be prompted in the viewer of report manager.
>|||Daniel,
Would there happen to be a published list of 'known limitations' for RS SP1,
or do we just have to figure these things out as we come upon them?
--
Adrian M.
MCP
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:ul5cMEUFFHA.2176@.TK2MSFTNGP15.phx.gbl...
> This is a known limitation of the report manager report parameter page.
> This issue should be fixed in Yukon.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Karl Prosser" <laborready.com@.kprosser(backwards)> wrote in message
> news:2D74DC06-9039-4576-86DB-01055F1A98A6@.microsoft.com...
>> please excuse the double posts, i thought i was putting it on a private
>> newsgroup at msdn subscribers
>|||Unfortunately, such a site does not exist. We are so busy fixing them (and
adding new ones <g>) that we haven't had time to create something like this.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
news:eGTLpKcFFHA.1292@.TK2MSFTNGP10.phx.gbl...
> Daniel,
> Would there happen to be a published list of 'known limitations' for RS
> SP1, or do we just have to figure these things out as we come upon them?
> --
> Adrian M.
> MCP
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:ul5cMEUFFHA.2176@.TK2MSFTNGP15.phx.gbl...
>> This is a known limitation of the report manager report parameter page.
>> This issue should be fixed in Yukon.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Karl Prosser" <laborready.com@.kprosser(backwards)> wrote in message
>> news:2D74DC06-9039-4576-86DB-01055F1A98A6@.microsoft.com...
>> please excuse the double posts, i thought i was putting it on a private
>> newsgroup at msdn subscribers
>>
>

Report Manager not responding

Hi,

I'm hoping to get some help here. I've spend countless hours trying to get Reporting Services running without success.

When I run the Report Manager it does not respond. Coming up with Opening page http://localhost/reports/Pages/Folder.aspx. . . The progress bar ticks along but the page never actually loads. The Configuration tool shows green icons everywhere. No errors in the Event viewer.

I am running Windows XP Professional with SP2. I have uninstalled and re-installed IIS, ASP.NET and SQL2005 numerous times. Varying the order, all without success. What else is involved ?

I have loaded Service Pack 1 and the latest hotfixes. What else can I try ?

Thanks in advance,
Claude

Hi,

are you running IE7 Beta 3 ? Then have a look here: http://www.sqlserver2005.de/sqlserver2005/MyBlog/tabid/56/EntryID/10/Default.aspx

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks Jens. I'm using IE 6.

|||Are you able to browse the report server directly (http://servername/reportserver)?|||

Thanks Brain, gives the same non-response.

|||

Some further clues . . .

When I tried connecting to the Report Server with the Management Studio, the following messages appear:

The underlying connection was closed: An unexpected error occurred on a send. (System.Web.Services)

Authentication failed because the remote party has closed the transport stream. (System)

Any ideas ?

|||

Hi,

there should be a more detailed log in the directory of Reporting Services, perhaps you could try to investigate that and send the relevant portion to the forum, thanks.

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I have a similar problem as Claude. I have two instances of SQL Server (2000 and 2005) installed locally. I am using the Developer version of 2005 running under XP Pro. I dont have administrator rights on my machine.

For some reason I just cannot connect to Report Manager, directly from the browser or from Management Studio. It just hangs and eventually tells you that 'cannot find server'. I tried evrything that Claude has done but no luck.

Any ideas please ?

Thanks

|||Are the services started ? What are the logs telling you ? (event log and log in the log directory)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks Jens.

This is the content of the ReportServerWebApp Logfile:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>New Zealand Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServerWebApp__08_18_2006_18_32_46.log</Path>
<SystemName>ACKCSABATIER01</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
aspnet_wp!ui!1!18/08/2006-18:33:20:: e ERROR: The underlying connection was closed: An unexpected error occurred on a send.
aspnet_wp!ui!1!18/08/2006-18:33:21:: e ERROR: HTTP status code --> 500
-Details--
System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send. > System.IO.IOException: Authentication failed because the remote party has closed the transport stream.

at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)

at System.Net.TlsStream.CallProcessAuthentication(Object state)

at System.Threading.ExecutionContext.runTryCode(Object userData)

at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)

at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)

at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

at System.Net.TlsStream.ProcessAuthentication(LazyAsyncResult result)

at System.Net.TlsStream.Write(Byte[] buffer, Int32 offset, Int32 size)

at System.Net.PooledStream.Write(Byte[] buffer, Int32 offset, Int32 size)

at System.Net.ConnectStream.WriteHeaders(Boolean async)

End of inner exception stack trace

at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)

at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetWebResponse(WebRequest request)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
aspnet_wp!ui!1!18/08/2006-18:33:22:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

|||

Did you get any resolution on this? I can deploy reports from Visual Studio, but I cant manage them. I am having a terrible time trying to get the Server Mangement Studio to connect to Reporting Services. I get the same errors in my logs:System.Net.WebException:

The underlying connection was closed: An unexpected error occurred on a send. > System.IO.IOException: Authentication failed because the remote party has closed the transport stream.