Hi
I have beening trying to build a report with 2 parameters. When I run it
under VS.net, it all went well, but after I deploy it to the server, I got
the message as following: Reporting Services Error--The path of the item ''
is not valid. The full path must be less than 260 characters long, must start
with slash; other restrictions apply. Check the documentation for complete
set of restrictions. (rsInvalidItemPath) Get Online Help
what went wrong, please help. TIAYou sure have to post your URL to help you.
Jens Suessmeyer.
"wd1153" <wd1153@.discussions.microsoft.com> schrieb im Newsbeitrag
news:5138A906-7AA9-4D7A-A1B5-E3C9756BE7E1@.microsoft.com...
> Hi
> I have beening trying to build a report with 2 parameters. When I run it
> under VS.net, it all went well, but after I deploy it to the server, I got
> the message as following: Reporting Services Error--The path of the item
> ''
> is not valid. The full path must be less than 260 characters long, must
> start
> with slash; other restrictions apply. Check the documentation for complete
> set of restrictions. (rsInvalidItemPath) Get Online Help
> what went wrong, please help. TIA
>
>|||Sorry, the URL as following:
http://localhost/reportserver?%2fRev_Stats%2fRev_Stats&rs:Command=Render
"Jens Sü�meyer" wrote:
> You sure have to post your URL to help you.
> Jens Suessmeyer.
>
> "wd1153" <wd1153@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:5138A906-7AA9-4D7A-A1B5-E3C9756BE7E1@.microsoft.com...
> > Hi
> >
> > I have beening trying to build a report with 2 parameters. When I run it
> > under VS.net, it all went well, but after I deploy it to the server, I got
> > the message as following: Reporting Services Error--The path of the item
> > ''
> > is not valid. The full path must be less than 260 characters long, must
> > start
> > with slash; other restrictions apply. Check the documentation for complete
> > set of restrictions. (rsInvalidItemPath) Get Online Help
> > what went wrong, please help. TIA
> >
> >
> >
>
>
Showing posts with label deploy. Show all posts
Showing posts with label deploy. Show all posts
Friday, March 30, 2012
Report doesn't work when deployed
I have a report that works perfectly in the development enviroment but when I
deploy it and run it in the report server I get this message:
"An error has occurred during report processing. (rsProcessingAborted)
Obtener ayuda en lÃnea
Query execution failed for data set 'All_TTs'. (rsErrorExecutingCommand)
Obtener ayuda en lÃnea
Object reference not set to an instance of an object. "
I tried recreating the data set bu it was worthless.
--
Pato Connonensure your datasource is pointing to the correct location, and that the
report uses the correct datasource. also ensure your datasource has the
correct connection information
"Pato Connon" wrote:
> I have a report that works perfectly in the development enviroment but when I
> deploy it and run it in the report server I get this message:
> "An error has occurred during report processing. (rsProcessingAborted)
> Obtener ayuda en lÃnea
> Query execution failed for data set 'All_TTs'. (rsErrorExecutingCommand)
> Obtener ayuda en lÃnea
> Object reference not set to an instance of an object. "
> I tried recreating the data set bu it was worthless.
> --
> Pato Connon|||If you are using an ODBC datasource, you might have to create the
datasource on the SSRS server as well. When you run the report in the
designer, it is looking for the ODBC connection on your computer, but
when it runs on the server, it is looking on the server.
-Josh
Pato Connon wrote:
> I have a report that works perfectly in the development enviroment but wh=en I
> deploy it and run it in the report server I get this message:
> "An error has occurred during report processing. (rsProcessingAborted)
> Obtener ayuda en l=EDnea
> Query execution failed for data set 'All_TTs'. (rsErrorExecutingCommand)
> Obtener ayuda en l=EDnea
> Object reference not set to an instance of an object. "
> I tried recreating the data set bu it was worthless.
> -- > Pato Connon
deploy it and run it in the report server I get this message:
"An error has occurred during report processing. (rsProcessingAborted)
Obtener ayuda en lÃnea
Query execution failed for data set 'All_TTs'. (rsErrorExecutingCommand)
Obtener ayuda en lÃnea
Object reference not set to an instance of an object. "
I tried recreating the data set bu it was worthless.
--
Pato Connonensure your datasource is pointing to the correct location, and that the
report uses the correct datasource. also ensure your datasource has the
correct connection information
"Pato Connon" wrote:
> I have a report that works perfectly in the development enviroment but when I
> deploy it and run it in the report server I get this message:
> "An error has occurred during report processing. (rsProcessingAborted)
> Obtener ayuda en lÃnea
> Query execution failed for data set 'All_TTs'. (rsErrorExecutingCommand)
> Obtener ayuda en lÃnea
> Object reference not set to an instance of an object. "
> I tried recreating the data set bu it was worthless.
> --
> Pato Connon|||If you are using an ODBC datasource, you might have to create the
datasource on the SSRS server as well. When you run the report in the
designer, it is looking for the ODBC connection on your computer, but
when it runs on the server, it is looking on the server.
-Josh
Pato Connon wrote:
> I have a report that works perfectly in the development enviroment but wh=en I
> deploy it and run it in the report server I get this message:
> "An error has occurred during report processing. (rsProcessingAborted)
> Obtener ayuda en l=EDnea
> Query execution failed for data set 'All_TTs'. (rsErrorExecutingCommand)
> Obtener ayuda en l=EDnea
> Object reference not set to an instance of an object. "
> I tried recreating the data set bu it was worthless.
> -- > Pato Connon
Report does not display the same as in the Preview window in Visual Studio
After formatting the report and making it look like I want too in the
Preview window of Visual Studio. I deploy the report to the web server
and when I open it - the web rendering (formatting) does not duplicate
what I see in the Preview window. It looks like it's adding extra rows
between the objects and is not following the vertical alignment that
was used in Visual Studio.
Does anyone have ideas on what could be causing this?
Thanks..I do. Verify if there are textboxes overlaping each other. In preview
windows this issue do not cause problem, but at render time, it does.
[]s
Renato
"Manuel" <mxgamez@.kelsey-seybold.com> escreveu na mensagem
news:ce53542a.0408260535.724891fd@.posting.google.com...
> After formatting the report and making it look like I want too in the
> Preview window of Visual Studio. I deploy the report to the web server
> and when I open it - the web rendering (formatting) does not duplicate
> what I see in the Preview window. It looks like it's adding extra rows
> between the objects and is not following the vertical alignment that
> was used in Visual Studio.
> Does anyone have ideas on what could be causing this?
> Thanks..|||Thanks... That worked.
"Renato Aloi" <aloi@.jew.com.br> wrote in message news:<OS$E9e3iEHA.2760@.TK2MSFTNGP15.phx.gbl>...
> I do. Verify if there are textboxes overlaping each other. In preview
> windows this issue do not cause problem, but at render time, it does.
> []s
> Renato
> "Manuel" <mxgamez@.kelsey-seybold.com> escreveu na mensagem
> news:ce53542a.0408260535.724891fd@.posting.google.com...
> > After formatting the report and making it look like I want too in the
> > Preview window of Visual Studio. I deploy the report to the web server
> > and when I open it - the web rendering (formatting) does not duplicate
> > what I see in the Preview window. It looks like it's adding extra rows
> > between the objects and is not following the vertical alignment that
> > was used in Visual Studio.
> >
> > Does anyone have ideas on what could be causing this?
> >
> > Thanks..
Preview window of Visual Studio. I deploy the report to the web server
and when I open it - the web rendering (formatting) does not duplicate
what I see in the Preview window. It looks like it's adding extra rows
between the objects and is not following the vertical alignment that
was used in Visual Studio.
Does anyone have ideas on what could be causing this?
Thanks..I do. Verify if there are textboxes overlaping each other. In preview
windows this issue do not cause problem, but at render time, it does.
[]s
Renato
"Manuel" <mxgamez@.kelsey-seybold.com> escreveu na mensagem
news:ce53542a.0408260535.724891fd@.posting.google.com...
> After formatting the report and making it look like I want too in the
> Preview window of Visual Studio. I deploy the report to the web server
> and when I open it - the web rendering (formatting) does not duplicate
> what I see in the Preview window. It looks like it's adding extra rows
> between the objects and is not following the vertical alignment that
> was used in Visual Studio.
> Does anyone have ideas on what could be causing this?
> Thanks..|||Thanks... That worked.
"Renato Aloi" <aloi@.jew.com.br> wrote in message news:<OS$E9e3iEHA.2760@.TK2MSFTNGP15.phx.gbl>...
> I do. Verify if there are textboxes overlaping each other. In preview
> windows this issue do not cause problem, but at render time, it does.
> []s
> Renato
> "Manuel" <mxgamez@.kelsey-seybold.com> escreveu na mensagem
> news:ce53542a.0408260535.724891fd@.posting.google.com...
> > After formatting the report and making it look like I want too in the
> > Preview window of Visual Studio. I deploy the report to the web server
> > and when I open it - the web rendering (formatting) does not duplicate
> > what I see in the Preview window. It looks like it's adding extra rows
> > between the objects and is not following the vertical alignment that
> > was used in Visual Studio.
> >
> > Does anyone have ideas on what could be causing this?
> >
> > Thanks..
Wednesday, March 28, 2012
Report Description Overwrite Issue
When I deploy a report from MSDE, the description from within the report
properties is displayed under the report name/link within the Report Manager.
When I modify the report description in MSDE and then re-deploy the report
it doesn't update the one I see in Report Manager? I can delete the report
in Report Manager and then redeploying creates the modified description; but
I don't really want to have to delete reports everytime I modify the
description.
Is this is a bug?MSDE is not a supported platform for Report Server. You must use either the
Standard edition or the Enterprise edition. You can also use the Developer
edition, but it is licensed for developing or testing only.
Charles Kangai, MCT, MCDBA
"Simon" wrote:
> When I deploy a report from MSDE, the description from within the report
> properties is displayed under the report name/link within the Report Manager.
>
> When I modify the report description in MSDE and then re-deploy the report
> it doesn't update the one I see in Report Manager? I can delete the report
> in Report Manager and then redeploying creates the modified description; but
> I don't really want to have to delete reports everytime I modify the
> description.
> Is this is a bug?
properties is displayed under the report name/link within the Report Manager.
When I modify the report description in MSDE and then re-deploy the report
it doesn't update the one I see in Report Manager? I can delete the report
in Report Manager and then redeploying creates the modified description; but
I don't really want to have to delete reports everytime I modify the
description.
Is this is a bug?MSDE is not a supported platform for Report Server. You must use either the
Standard edition or the Enterprise edition. You can also use the Developer
edition, but it is licensed for developing or testing only.
Charles Kangai, MCT, MCDBA
"Simon" wrote:
> When I deploy a report from MSDE, the description from within the report
> properties is displayed under the report name/link within the Report Manager.
>
> When I modify the report description in MSDE and then re-deploy the report
> it doesn't update the one I see in Report Manager? I can delete the report
> in Report Manager and then redeploying creates the modified description; but
> I don't really want to have to delete reports everytime I modify the
> description.
> Is this is a bug?
Report Description
Can someone please let me know what the use of the Report > Report Properties
> Author & Description Fields are?
When I deploy my reports to the server these values are not visible in the
report properties of the report manager nor are they exposed to be used in a
report. Both of which I want to do.I have just tested what you said below, and I found that although the Author
property I entered was overwritten by my NT login, the description came
through alright on the server after deploying. Go to the Properties tab of
the report in Report Manager and click on the General link; you should see
the description at least.
The description is very useful when searching [there is a Search for text
box at the top right of the screen].
Charles Kangai, MCT, MCDBA
"SAcanuck" wrote:
> Can someone please let me know what the use of the Report > Report Properties
> > Author & Description Fields are?
> When I deploy my reports to the server these values are not visible in the
> report properties of the report manager nor are they exposed to be used in a
> report. Both of which I want to do.|||Hi Charles:
I deployed my rdl using visual studio and the description was not displayed
on the general link of the report properties in the report manager. I also
tried this by uploading the rdl file onto the server...no description either.
Is there a setting that coud be preventing this from occuring?
"Charles Kangai" wrote:
> I have just tested what you said below, and I found that although the Author
> property I entered was overwritten by my NT login, the description came
> through alright on the server after deploying. Go to the Properties tab of
> the report in Report Manager and click on the General link; you should see
> the description at least.
> The description is very useful when searching [there is a Search for text
> box at the top right of the screen].
> Charles Kangai, MCT, MCDBA
> "SAcanuck" wrote:
> > Can someone please let me know what the use of the Report > Report Properties
> > > Author & Description Fields are?
> >
> > When I deploy my reports to the server these values are not visible in the
> > report properties of the report manager nor are they exposed to be used in a
> > report. Both of which I want to do.|||Hi checked the code in the rdl file and my description is referenced in
it...so I really dont know what the issue could be.
"Charles Kangai" wrote:
> I have just tested what you said below, and I found that although the Author
> property I entered was overwritten by my NT login, the description came
> through alright on the server after deploying. Go to the Properties tab of
> the report in Report Manager and click on the General link; you should see
> the description at least.
> The description is very useful when searching [there is a Search for text
> box at the top right of the screen].
> Charles Kangai, MCT, MCDBA
> "SAcanuck" wrote:
> > Can someone please let me know what the use of the Report > Report Properties
> > > Author & Description Fields are?
> >
> > When I deploy my reports to the server these values are not visible in the
> > report properties of the report manager nor are they exposed to be used in a
> > report. Both of which I want to do.|||Another thing we have two report server this description does appear on one
fo them, but not on the other. Why?
"Charles Kangai" wrote:
> I have just tested what you said below, and I found that although the Author
> property I entered was overwritten by my NT login, the description came
> through alright on the server after deploying. Go to the Properties tab of
> the report in Report Manager and click on the General link; you should see
> the description at least.
> The description is very useful when searching [there is a Search for text
> box at the top right of the screen].
> Charles Kangai, MCT, MCDBA
> "SAcanuck" wrote:
> > Can someone please let me know what the use of the Report > Report Properties
> > > Author & Description Fields are?
> >
> > When I deploy my reports to the server these values are not visible in the
> > report properties of the report manager nor are they exposed to be used in a
> > report. Both of which I want to do.|||If you have deployed the report before the description does not go over. It
only goes over it it is the first time you have deployed. Delete the report
on the server and redeploy and the description will come over.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
news:B37830C2-DE50-4695-B8D2-085B6976AC55@.microsoft.com...
> Hi Charles:
> I deployed my rdl using visual studio and the description was not
displayed
> on the general link of the report properties in the report manager. I also
> tried this by uploading the rdl file onto the server...no description
either.
> Is there a setting that coud be preventing this from occuring?
>
> "Charles Kangai" wrote:
> > I have just tested what you said below, and I found that although the
Author
> > property I entered was overwritten by my NT login, the description came
> > through alright on the server after deploying. Go to the Properties tab
of
> > the report in Report Manager and click on the General link; you should
see
> > the description at least.
> >
> > The description is very useful when searching [there is a Search for
text
> > box at the top right of the screen].
> >
> > Charles Kangai, MCT, MCDBA
> >
> > "SAcanuck" wrote:
> >
> > > Can someone please let me know what the use of the Report > Report
Properties
> > > > Author & Description Fields are?
> > >
> > > When I deploy my reports to the server these values are not visible in
the
> > > report properties of the report manager nor are they exposed to be
used in a
> > > report. Both of which I want to do.|||Bruce:
thanks it works now. Is there away to prevent the NT login name from
overwriting the Author name?
"Bruce L-C [MVP]" wrote:
> If you have deployed the report before the description does not go over. It
> only goes over it it is the first time you have deployed. Delete the report
> on the server and redeploy and the description will come over.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
> news:B37830C2-DE50-4695-B8D2-085B6976AC55@.microsoft.com...
> > Hi Charles:
> >
> > I deployed my rdl using visual studio and the description was not
> displayed
> > on the general link of the report properties in the report manager. I also
> > tried this by uploading the rdl file onto the server...no description
> either.
> >
> > Is there a setting that coud be preventing this from occuring?
> >
> >
> >
> > "Charles Kangai" wrote:
> >
> > > I have just tested what you said below, and I found that although the
> Author
> > > property I entered was overwritten by my NT login, the description came
> > > through alright on the server after deploying. Go to the Properties tab
> of
> > > the report in Report Manager and click on the General link; you should
> see
> > > the description at least.
> > >
> > > The description is very useful when searching [there is a Search for
> text
> > > box at the top right of the screen].
> > >
> > > Charles Kangai, MCT, MCDBA
> > >
> > > "SAcanuck" wrote:
> > >
> > > > Can someone please let me know what the use of the Report > Report
> Properties
> > > > > Author & Description Fields are?
> > > >
> > > > When I deploy my reports to the server these values are not visible in
> the
> > > > report properties of the report manager nor are they exposed to be
> used in a
> > > > report. Both of which I want to do.
>
>|||I don't know anything about that, sorry.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
news:6B8F8E52-2909-4FE6-B15A-E25ABE45CB64@.microsoft.com...
> Bruce:
> thanks it works now. Is there away to prevent the NT login name from
> overwriting the Author name?
> "Bruce L-C [MVP]" wrote:
> > If you have deployed the report before the description does not go over.
It
> > only goes over it it is the first time you have deployed. Delete the
report
> > on the server and redeploy and the description will come over.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
> > news:B37830C2-DE50-4695-B8D2-085B6976AC55@.microsoft.com...
> > > Hi Charles:
> > >
> > > I deployed my rdl using visual studio and the description was not
> > displayed
> > > on the general link of the report properties in the report manager. I
also
> > > tried this by uploading the rdl file onto the server...no description
> > either.
> > >
> > > Is there a setting that coud be preventing this from occuring?
> > >
> > >
> > >
> > > "Charles Kangai" wrote:
> > >
> > > > I have just tested what you said below, and I found that although
the
> > Author
> > > > property I entered was overwritten by my NT login, the description
came
> > > > through alright on the server after deploying. Go to the Properties
tab
> > of
> > > > the report in Report Manager and click on the General link; you
should
> > see
> > > > the description at least.
> > > >
> > > > The description is very useful when searching [there is a Search for
> > text
> > > > box at the top right of the screen].
> > > >
> > > > Charles Kangai, MCT, MCDBA
> > > >
> > > > "SAcanuck" wrote:
> > > >
> > > > > Can someone please let me know what the use of the Report > Report
> > Properties
> > > > > > Author & Description Fields are?
> > > > >
> > > > > When I deploy my reports to the server these values are not
visible in
> > the
> > > > > report properties of the report manager nor are they exposed to be
> > used in a
> > > > > report. Both of which I want to do.
> >
> >
> >
> Author & Description Fields are?
When I deploy my reports to the server these values are not visible in the
report properties of the report manager nor are they exposed to be used in a
report. Both of which I want to do.I have just tested what you said below, and I found that although the Author
property I entered was overwritten by my NT login, the description came
through alright on the server after deploying. Go to the Properties tab of
the report in Report Manager and click on the General link; you should see
the description at least.
The description is very useful when searching [there is a Search for text
box at the top right of the screen].
Charles Kangai, MCT, MCDBA
"SAcanuck" wrote:
> Can someone please let me know what the use of the Report > Report Properties
> > Author & Description Fields are?
> When I deploy my reports to the server these values are not visible in the
> report properties of the report manager nor are they exposed to be used in a
> report. Both of which I want to do.|||Hi Charles:
I deployed my rdl using visual studio and the description was not displayed
on the general link of the report properties in the report manager. I also
tried this by uploading the rdl file onto the server...no description either.
Is there a setting that coud be preventing this from occuring?
"Charles Kangai" wrote:
> I have just tested what you said below, and I found that although the Author
> property I entered was overwritten by my NT login, the description came
> through alright on the server after deploying. Go to the Properties tab of
> the report in Report Manager and click on the General link; you should see
> the description at least.
> The description is very useful when searching [there is a Search for text
> box at the top right of the screen].
> Charles Kangai, MCT, MCDBA
> "SAcanuck" wrote:
> > Can someone please let me know what the use of the Report > Report Properties
> > > Author & Description Fields are?
> >
> > When I deploy my reports to the server these values are not visible in the
> > report properties of the report manager nor are they exposed to be used in a
> > report. Both of which I want to do.|||Hi checked the code in the rdl file and my description is referenced in
it...so I really dont know what the issue could be.
"Charles Kangai" wrote:
> I have just tested what you said below, and I found that although the Author
> property I entered was overwritten by my NT login, the description came
> through alright on the server after deploying. Go to the Properties tab of
> the report in Report Manager and click on the General link; you should see
> the description at least.
> The description is very useful when searching [there is a Search for text
> box at the top right of the screen].
> Charles Kangai, MCT, MCDBA
> "SAcanuck" wrote:
> > Can someone please let me know what the use of the Report > Report Properties
> > > Author & Description Fields are?
> >
> > When I deploy my reports to the server these values are not visible in the
> > report properties of the report manager nor are they exposed to be used in a
> > report. Both of which I want to do.|||Another thing we have two report server this description does appear on one
fo them, but not on the other. Why?
"Charles Kangai" wrote:
> I have just tested what you said below, and I found that although the Author
> property I entered was overwritten by my NT login, the description came
> through alright on the server after deploying. Go to the Properties tab of
> the report in Report Manager and click on the General link; you should see
> the description at least.
> The description is very useful when searching [there is a Search for text
> box at the top right of the screen].
> Charles Kangai, MCT, MCDBA
> "SAcanuck" wrote:
> > Can someone please let me know what the use of the Report > Report Properties
> > > Author & Description Fields are?
> >
> > When I deploy my reports to the server these values are not visible in the
> > report properties of the report manager nor are they exposed to be used in a
> > report. Both of which I want to do.|||If you have deployed the report before the description does not go over. It
only goes over it it is the first time you have deployed. Delete the report
on the server and redeploy and the description will come over.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
news:B37830C2-DE50-4695-B8D2-085B6976AC55@.microsoft.com...
> Hi Charles:
> I deployed my rdl using visual studio and the description was not
displayed
> on the general link of the report properties in the report manager. I also
> tried this by uploading the rdl file onto the server...no description
either.
> Is there a setting that coud be preventing this from occuring?
>
> "Charles Kangai" wrote:
> > I have just tested what you said below, and I found that although the
Author
> > property I entered was overwritten by my NT login, the description came
> > through alright on the server after deploying. Go to the Properties tab
of
> > the report in Report Manager and click on the General link; you should
see
> > the description at least.
> >
> > The description is very useful when searching [there is a Search for
text
> > box at the top right of the screen].
> >
> > Charles Kangai, MCT, MCDBA
> >
> > "SAcanuck" wrote:
> >
> > > Can someone please let me know what the use of the Report > Report
Properties
> > > > Author & Description Fields are?
> > >
> > > When I deploy my reports to the server these values are not visible in
the
> > > report properties of the report manager nor are they exposed to be
used in a
> > > report. Both of which I want to do.|||Bruce:
thanks it works now. Is there away to prevent the NT login name from
overwriting the Author name?
"Bruce L-C [MVP]" wrote:
> If you have deployed the report before the description does not go over. It
> only goes over it it is the first time you have deployed. Delete the report
> on the server and redeploy and the description will come over.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
> news:B37830C2-DE50-4695-B8D2-085B6976AC55@.microsoft.com...
> > Hi Charles:
> >
> > I deployed my rdl using visual studio and the description was not
> displayed
> > on the general link of the report properties in the report manager. I also
> > tried this by uploading the rdl file onto the server...no description
> either.
> >
> > Is there a setting that coud be preventing this from occuring?
> >
> >
> >
> > "Charles Kangai" wrote:
> >
> > > I have just tested what you said below, and I found that although the
> Author
> > > property I entered was overwritten by my NT login, the description came
> > > through alright on the server after deploying. Go to the Properties tab
> of
> > > the report in Report Manager and click on the General link; you should
> see
> > > the description at least.
> > >
> > > The description is very useful when searching [there is a Search for
> text
> > > box at the top right of the screen].
> > >
> > > Charles Kangai, MCT, MCDBA
> > >
> > > "SAcanuck" wrote:
> > >
> > > > Can someone please let me know what the use of the Report > Report
> Properties
> > > > > Author & Description Fields are?
> > > >
> > > > When I deploy my reports to the server these values are not visible in
> the
> > > > report properties of the report manager nor are they exposed to be
> used in a
> > > > report. Both of which I want to do.
>
>|||I don't know anything about that, sorry.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
news:6B8F8E52-2909-4FE6-B15A-E25ABE45CB64@.microsoft.com...
> Bruce:
> thanks it works now. Is there away to prevent the NT login name from
> overwriting the Author name?
> "Bruce L-C [MVP]" wrote:
> > If you have deployed the report before the description does not go over.
It
> > only goes over it it is the first time you have deployed. Delete the
report
> > on the server and redeploy and the description will come over.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
> > news:B37830C2-DE50-4695-B8D2-085B6976AC55@.microsoft.com...
> > > Hi Charles:
> > >
> > > I deployed my rdl using visual studio and the description was not
> > displayed
> > > on the general link of the report properties in the report manager. I
also
> > > tried this by uploading the rdl file onto the server...no description
> > either.
> > >
> > > Is there a setting that coud be preventing this from occuring?
> > >
> > >
> > >
> > > "Charles Kangai" wrote:
> > >
> > > > I have just tested what you said below, and I found that although
the
> > Author
> > > > property I entered was overwritten by my NT login, the description
came
> > > > through alright on the server after deploying. Go to the Properties
tab
> > of
> > > > the report in Report Manager and click on the General link; you
should
> > see
> > > > the description at least.
> > > >
> > > > The description is very useful when searching [there is a Search for
> > text
> > > > box at the top right of the screen].
> > > >
> > > > Charles Kangai, MCT, MCDBA
> > > >
> > > > "SAcanuck" wrote:
> > > >
> > > > > Can someone please let me know what the use of the Report > Report
> > Properties
> > > > > > Author & Description Fields are?
> > > > >
> > > > > When I deploy my reports to the server these values are not
visible in
> > the
> > > > > report properties of the report manager nor are they exposed to be
> > used in a
> > > > > report. Both of which I want to do.
> >
> >
> >
Report Deployment Problem on SQL 2005
Hi everyone,
I'm trying to deploy my Report Project on SQL 2005 on my machine from Visual Studio itself, but I keep getting this error:
"The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file."
Although I specified the WebServiceAccount in the rsreportserver.config file, using an administrative account, but still facing the same problem :s.
Any idea what so ever?
ThanksI was hoping someone would reply to you on this problem. I am having a very similar problem of not being able to deploy reports to the Report Server, using the June SQL Server CTP.
I'm trying to deploy my Report Project on SQL 2005 on my machine from Visual Studio itself, but I keep getting this error:
"The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file."
Although I specified the WebServiceAccount in the rsreportserver.config file, using an administrative account, but still facing the same problem :s.
Any idea what so ever?
ThanksI was hoping someone would reply to you on this problem. I am having a very similar problem of not being able to deploy reports to the Report Server, using the June SQL Server CTP.
When trying to deploy Company Sales.rdl or any of the other sample reports to the Report Server, from Visual Studio 2005, this error message appears (see below). Where should I start to troubleshoot the problem? Thank you.
A connection could not be made to the report server http://localhost/reportserver. (Microsoft Report Designer)
===================================
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
===================================
The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)
I managed to solve the problem at my side, this post was very helpfull:
http://forums.microsoft.com
For my case, the easiest way was to reinstall SQL 2005 CTP again in one shot, as installing it in multiple phases caused the problem that I faced.
In addition, I had to give write authority to the (Network Services) to the ASP.NET Temporary files directory.
Hope this will be helpfull.|||I also had the same problem and it was resolved by reinstalling all components of SQL 2005 CTP in one go.|||
Solution to this problem is
1) Open Configure Report Server Tool
2) Update 'Web Service Identity' tab to reflect Asp .Net account on the machine.
For Eg. machineName\ASPNET
3) Click Apply Button, This will update WebServiceAccount tag in your report server configuration file 'rsreportserver.config'.
Hope this helps.
Thanks,
Report Deployment Problem on SQL 2005
Hi everyone,
I'm trying to deploy my Report Project on SQL 2005 on my machine from Visual Studio itself, but I keep getting this error:
"The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file."
Although I specified the WebServiceAccount in the rsreportserver.config file, using an administrative account, but still facing the same problem :s.
Any idea what so ever?
ThanksI was hoping someone would reply to you on this problem. I am having a very similar problem of not being able to deploy reports to the Report Server, using the June SQL Server CTP.
I'm trying to deploy my Report Project on SQL 2005 on my machine from Visual Studio itself, but I keep getting this error:
"The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file."
Although I specified the WebServiceAccount in the rsreportserver.config file, using an administrative account, but still facing the same problem :s.
Any idea what so ever?
ThanksI was hoping someone would reply to you on this problem. I am having a very similar problem of not being able to deploy reports to the Report Server, using the June SQL Server CTP.
When trying to deploy Company Sales.rdl or any of the other sample reports to the Report Server, from Visual Studio 2005, this error message appears (see below). Where should I start to troubleshoot the problem? Thank you.
A connection could not be made to the report server http://localhost/reportserver. (Microsoft Report Designer)
===================================
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
===================================
The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)
I managed to solve the problem at my side, this post was very helpfull:
http://forums.microsoft.com
For my case, the easiest way was to reinstall SQL 2005 CTP again in one shot, as installing it in multiple phases caused the problem that I faced.
In addition, I had to give write authority to the (Network Services) to the ASP.NET Temporary files directory.
Hope this will be helpfull.|||I also had the same problem and it was resolved by reinstalling all components of SQL 2005 CTP in one go.|||
Solution to this problem is
1) Open Configure Report Server Tool
2) Update 'Web Service Identity' tab to reflect Asp .Net account on the machine.
For Eg. machineName\ASPNET
3) Click Apply Button, This will update WebServiceAccount tag in your report server configuration file 'rsreportserver.config'.
Hope this helps.
Thanks,
Monday, March 26, 2012
Report Deployment Error on --http://localhost/reportserver
I am getting the following ERROR!! below when I try to DEPLOY my report. The output generated from - Debug --> Start
-- Deploy started: Project: Report Project1, Configuration: DebugLocal --
Deploying to http://localhost/reportserver/?%2fReport+Project1
Error rsReportServerDatabaseUnavailable : The report server cannot opena connection to the report server database. A connection to thedatabase is required for all requests and processing.
Deploy complete -- 1 errors, 0 warnings
=====================================================
-- Deploy started: Project: Report Project1, Configuration: DebugLocal --
Deploying to http://localhost/reportserver/?%2fReport+Project1
Error rsReportServerDatabaseUnavailable : The report server cannot opena connection to the report server database. A connection to thedatabase is required for all requests and processing.
Deploy complete -- 1 errors, 0 warnings
=====================================================
When I try to go tohttp://<server>/reportserver a PROMT window pop up "Enter username and password for "" at http://localhost. Atthis point I'm pretty desperate to get it to work., I have been tryingfor couple of days. I reinstalled reporting services couple of timeswith no success. Any help would be greatly appreciated. Thanks!
-lalon
Report deployment error in SharePoint Integration mode
Hi,
I get the following error when I am trying to deploy Report from Visual Studio Report Designer.
SRSS is configured in SharePoint integration mode. Configuration is mentioned below.
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://rbddspsdev2:44887/.
ADDITIONAL INFORMATION:
Server was unable to process request. > The request failed with HTTP status 401: Unauthorized. (System.Web.Services)
BUTTONS:
OK
Configuration is as follows.
Web front end server.
MOSS 2007 Standard edition 64 bit.
SQL Reporting Service Add in 64 bit.
SQL Server
MS SQL server 2005 32 bit with sp2.
Reporting Services configured.
WSS 3.0 32 bit required for configuration, of SRSS in integrated mode.
Windows service and web service are both running under a domain account. The account is a SharePoint Admininstrator. The account is also in Administrators, Reporting Server user and Web service group and also has a dbo rights on database.
Hi
To publish a report to a SharePoint site configured for SharePoint integration, you must verify that the report project properties in Report Designer point to the SharePoint site. All references to servers, reports, shared data sources, and resources must be fully qualified URLs. The TargetServerURL property must be a URL to a SharePoint site. The TargetDataSourceFolder and TargetReportFolder properties must be URLs to a SharePoint library or library folder. You must have Member or Owner permission on the SharePoint site to set the properties on the project.
To publish a report to a SharePoint site
1. In SQL Server Development Studio, open an existing or new Report Server project.
2. From the Project menu, click Properties. The <project> Property Pages dialog box opens.
3. Choose the Configuration you use to publish to a SharePoint site. For example, Active(Debug) or Production.
4. In the Deployment section, for the optional TargetDataSourceFolder, type a URL to a library or library folder. For example, http://TestServer/TestSite/Documents/DataSources.
5. For TargetReportFolder, type a fully qualified URL to a library or library folder. For example, http://TestServer/TestSite/Documents.
6. For TargetServerURL, type a URL to a SharePoint top-level site or sub-site. If you do not specify a site, the default top-level site is used. For example, http://servername, http://servername/site or http://servername/site/subsite..
7. Click OK.
8. In Solution Explorer, right-click on the report you want to publish, and click Deploy. The report is published to the location specified in TargetReportFolder.
|||Please post back if you have resolved this issue, as I have the same issue.
I have SQL 2005 sp2 as a seperate server from my sharepoint server. I was running reports in native mode and converted to integrated. I am using domain accounts for windows and web services. I have all green checks in reports configuration. If I browse to http://sqlserver/reportserver/ I get the following error:
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Get Online Help
I don't see anything in the log - but would be happy to post entries if someone can spot my error in them.
From VS 2005 when I attempt to upload a report, I get "a connection could not be made to the report server Get Online Help
I don't see anything in the log - but would be happy to post entries if someone can spot my error in them.
From VS 2005 when I attempt to upload a report, I get "a connection could not be made to the report server https://sharepointserver/
In Sharepoint configuration, when I attempt to set server defaults I get: "
Troubleshoot issues with Windows SharePoint Services. "
I would really love to get this working.
Please check rs_log# file in ...:\Documents and Settings\[USER]\Local Settings\Temp
It should contain more details about your problem.
Are you using "Windows Integrated" or "Trusted Accounts" Authentication Mode?
|||Hi all,
My issue i guess was because of the double hop between my Reporting Server and SharePoint server. Anyways now i have Reporting Server and MOSS both on same machine and the problem seem to go away on its own.
Hope this helps other too.
Thanks,
|||Anyone an answer to this? I've seen many blogs w/ this issue but no answers.Report Deployment
We have a "Change Management" Dept that MUST deploy all reports into
Production. I have the same ability from my machine and I can deploy the
solution (or each individual project) without problems (but they don't like
it since I am just a developer).
When CM deploys (they take my solution file and hit "Deploy") the
credentials to all of the data sources is removed so that we have to go into
Report Viewer and add back in the credentials.
So basically, why do I NOT have any problems deploying the solution and data
sources (credentials = a service account), yet CM takes a copy of my solution
and they cannot deploy the data sources with credentials?
Any thoughs appreciated.It is how it is configured in VS. They have it to overwrite data sources and
you do not. They should not be configured this way and they can change it.
Right mouse click on each project, properties, set the overwritedatasources
property to false (if you look for yours it is set to false). That is the
default so they must have changed it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:42674178-04C7-444B-B010-DFB59FD59373@.microsoft.com...
> We have a "Change Management" Dept that MUST deploy all reports into
> Production. I have the same ability from my machine and I can deploy the
> solution (or each individual project) without problems (but they don't
> like
> it since I am just a developer).
> When CM deploys (they take my solution file and hit "Deploy") the
> credentials to all of the data sources is removed so that we have to go
> into
> Report Viewer and add back in the credentials.
> So basically, why do I NOT have any problems deploying the solution and
> data
> sources (credentials = a service account), yet CM takes a copy of my
> solution
> and they cannot deploy the data sources with credentials?
> Any thoughs appreciated.
Production. I have the same ability from my machine and I can deploy the
solution (or each individual project) without problems (but they don't like
it since I am just a developer).
When CM deploys (they take my solution file and hit "Deploy") the
credentials to all of the data sources is removed so that we have to go into
Report Viewer and add back in the credentials.
So basically, why do I NOT have any problems deploying the solution and data
sources (credentials = a service account), yet CM takes a copy of my solution
and they cannot deploy the data sources with credentials?
Any thoughs appreciated.It is how it is configured in VS. They have it to overwrite data sources and
you do not. They should not be configured this way and they can change it.
Right mouse click on each project, properties, set the overwritedatasources
property to false (if you look for yours it is set to false). That is the
default so they must have changed it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:42674178-04C7-444B-B010-DFB59FD59373@.microsoft.com...
> We have a "Change Management" Dept that MUST deploy all reports into
> Production. I have the same ability from my machine and I can deploy the
> solution (or each individual project) without problems (but they don't
> like
> it since I am just a developer).
> When CM deploys (they take my solution file and hit "Deploy") the
> credentials to all of the data sources is removed so that we have to go
> into
> Report Viewer and add back in the credentials.
> So basically, why do I NOT have any problems deploying the solution and
> data
> sources (credentials = a service account), yet CM takes a copy of my
> solution
> and they cannot deploy the data sources with credentials?
> Any thoughs appreciated.
Report deploment to multiple servers SQL Reporting 2005
Hi
Another issue I would like your help:
We are writing reports for different clients. We need to deploy the same reports to different clients (thus also different DataSources). What is the best way to handle this? The folder names would probably be the same.
Andre
Sounds like you need a custom installer that will accept the required input (database name, credentials, folder path) and deploy the reports by calling down to the Report Server APIs. Or, you can script the objects and use the rs.exe utility to deploy. You may also find the RSScripter utility useful.sqlReport definitions - changes not apparent after upload/deploy.
We have SQL 2000 Reporting Services. There are a couple of reports that have been changed several times in the past, with no problems.
Now when we change these same reports, the new report definitions get successfully uploaded (as evidenced by the time stamp), but the old report definitions still show up.
We have tried the following.
1) Deleting the report from Reporting Services.
2) Recreating the report from scratch, then uploading the new report (w/ same name)
3) Uploading the desired report with a different name, then changing it to the desired name. (We have links and legacy applications that point to these reports). When we do this, the old version reappears.
This appears to be a caching problem. I have verified the caching option in the Properties > Data Execution [tab] is not selected. I have tried bouncing the SQL database, IIS services, and Reporting Services (let me know if there is a prescribed order).
Whatever we try, the old definitions remains persistently there.
Help!
Thanks in advance .
gmctech
Could this be client caching or proxy caching?
Wednesday, March 7, 2012
Report Builder - Can't Deploy
I am having a problem deploying a report. My target server url is
http://localhost/vbreports. I can get to this site with no problem. When I
deploy my report I get the error "A connection could not be made to the
report server http://localhost/vbreports".
Any help would be appreciated.
RobOn Mar 18, 6:31 am, Rob <R...@.discussions.microsoft.com> wrote:
> I am having a problem deploying a report. My target server url ishttp://localhost/vbreports. I can get to this site with no problem. When I
> deploy my report I get the error "A connection could not be made to the
> report serverhttp://localhost/vbreports".
> Any help would be appreciated.
> Rob
That is the url to access report manager application.
Reports are deployed to the reportserver application, typically
http://localhost/reportserver, or in your case, maybe http://localhost/vbreportserver
Rowen McDermott|||Thank you. Now I can deploy but the IE screen for the reportserver shows a
wierd screen. It shows a directory view and when I click on my models and
click on the model that I deployed I see the xml code instead of it running
the report builder. Any suggestions?
Thanks,
Rob
"Rowen" wrote:
> On Mar 18, 6:31 am, Rob <R...@.discussions.microsoft.com> wrote:
> > I am having a problem deploying a report. My target server url ishttp://localhost/vbreports. I can get to this site with no problem. When I
> > deploy my report I get the error "A connection could not be made to the
> > report serverhttp://localhost/vbreports".
> >
> > Any help would be appreciated.
> >
> > Rob
> That is the url to access report manager application.
> Reports are deployed to the reportserver application, typically
> http://localhost/reportserver, or in your case, maybe http://localhost/vbreportserver
> Rowen McDermott
>|||On Mar 21, 11:24 am, Rob <R...@.discussions.microsoft.com> wrote:
> Thank you. Now I can deploy but the IE screen for the reportserver shows a
> wierd screen. It shows a directory view and when I click on my models and
> click on the model that I deployed I see the xml code instead of it running
> the report builder. Any suggestions?
> Thanks,
> Rob
>
It sounds like you are getting confused between the report server
application and the report manager application. Both are installed
with reporting services.
The report server application 'http://localhost/reportserver' is the
primary application and includes a web service interface which can be
used to view reports. Reports are deployed to this application via the
web service.
The Report Manager application 'http://softwareserver/Reports/' is an
interface to the above web service that allows report viewing in a
more friendly manner. It is from here that you run report builder.
Rowen|||Thanks Rowen. I discovered my error last night. I can now deploy my model.
But when I open the report builder and choose my model I get the error: The
selected data source does not have any content available. I have checked the
table in the SQL database and there are records.
"Rowen" wrote:
> On Mar 21, 11:24 am, Rob <R...@.discussions.microsoft.com> wrote:
> > Thank you. Now I can deploy but the IE screen for the reportserver shows a
> > wierd screen. It shows a directory view and when I click on my models and
> > click on the model that I deployed I see the xml code instead of it running
> > the report builder. Any suggestions?
> >
> > Thanks,
> >
> > Rob
> >
> It sounds like you are getting confused between the report server
> application and the report manager application. Both are installed
> with reporting services.
> The report server application 'http://localhost/reportserver' is the
> primary application and includes a web service interface which can be
> used to view reports. Reports are deployed to this application via the
> web service.
> The Report Manager application 'http://softwareserver/Reports/' is an
> interface to the above web service that allows report viewing in a
> more friendly manner. It is from here that you run report builder.
> Rowen
>
http://localhost/vbreports. I can get to this site with no problem. When I
deploy my report I get the error "A connection could not be made to the
report server http://localhost/vbreports".
Any help would be appreciated.
RobOn Mar 18, 6:31 am, Rob <R...@.discussions.microsoft.com> wrote:
> I am having a problem deploying a report. My target server url ishttp://localhost/vbreports. I can get to this site with no problem. When I
> deploy my report I get the error "A connection could not be made to the
> report serverhttp://localhost/vbreports".
> Any help would be appreciated.
> Rob
That is the url to access report manager application.
Reports are deployed to the reportserver application, typically
http://localhost/reportserver, or in your case, maybe http://localhost/vbreportserver
Rowen McDermott|||Thank you. Now I can deploy but the IE screen for the reportserver shows a
wierd screen. It shows a directory view and when I click on my models and
click on the model that I deployed I see the xml code instead of it running
the report builder. Any suggestions?
Thanks,
Rob
"Rowen" wrote:
> On Mar 18, 6:31 am, Rob <R...@.discussions.microsoft.com> wrote:
> > I am having a problem deploying a report. My target server url ishttp://localhost/vbreports. I can get to this site with no problem. When I
> > deploy my report I get the error "A connection could not be made to the
> > report serverhttp://localhost/vbreports".
> >
> > Any help would be appreciated.
> >
> > Rob
> That is the url to access report manager application.
> Reports are deployed to the reportserver application, typically
> http://localhost/reportserver, or in your case, maybe http://localhost/vbreportserver
> Rowen McDermott
>|||On Mar 21, 11:24 am, Rob <R...@.discussions.microsoft.com> wrote:
> Thank you. Now I can deploy but the IE screen for the reportserver shows a
> wierd screen. It shows a directory view and when I click on my models and
> click on the model that I deployed I see the xml code instead of it running
> the report builder. Any suggestions?
> Thanks,
> Rob
>
It sounds like you are getting confused between the report server
application and the report manager application. Both are installed
with reporting services.
The report server application 'http://localhost/reportserver' is the
primary application and includes a web service interface which can be
used to view reports. Reports are deployed to this application via the
web service.
The Report Manager application 'http://softwareserver/Reports/' is an
interface to the above web service that allows report viewing in a
more friendly manner. It is from here that you run report builder.
Rowen|||Thanks Rowen. I discovered my error last night. I can now deploy my model.
But when I open the report builder and choose my model I get the error: The
selected data source does not have any content available. I have checked the
table in the SQL database and there are records.
"Rowen" wrote:
> On Mar 21, 11:24 am, Rob <R...@.discussions.microsoft.com> wrote:
> > Thank you. Now I can deploy but the IE screen for the reportserver shows a
> > wierd screen. It shows a directory view and when I click on my models and
> > click on the model that I deployed I see the xml code instead of it running
> > the report builder. Any suggestions?
> >
> > Thanks,
> >
> > Rob
> >
> It sounds like you are getting confused between the report server
> application and the report manager application. Both are installed
> with reporting services.
> The report server application 'http://localhost/reportserver' is the
> primary application and includes a web service interface which can be
> used to view reports. Reports are deployed to this application via the
> web service.
> The Report Manager application 'http://softwareserver/Reports/' is an
> interface to the above web service that allows report viewing in a
> more friendly manner. It is from here that you run report builder.
> Rowen
>
Saturday, February 25, 2012
Report appearance issues
I have 2 issues wih the appearance of my report both in the preview tab and when I deploy.
1. My report contains a subreport and the subreport appears indented from the left edge of the main report. How can I stop this? I won't the subreport to be aligned with the main report.
2. The last column of my report is stretched to the edge of the page even though I have all my cells set to CanGrow = false. How can I stop this?
Any help is appreciated.
I solved this one myself. The subreport's body was wider than the main report's body and as I have the table centred on both reports the subreport appeared indented. As soon as I made both report's body width the same the subreport aligned with the main report correctly. I also set every cell in the table in both reports to CanGrow = false and that stopped the last column stretching to the edge of the page.
Report and other controls not rendered
After resolving all the installation and configuration related issues, I was able to deploy a couple of projects on my report server. I can see alll folders and reports listed inside the folders from http://<servername>/reports . All works fine except when I run a report, the http://<servername>/Reports/Pages/Report.aspx page does not render report.
This page displays View, Properties, History Subscriptions etc, menu items on the top section of the page. It also displays Home, My Subscriptions, Site Settings, Help etc. links on top right corner of the page. I can also see the bar that has "New subscription" button. But the problem starts from the section below that. It does NOT display the Report navigation bottons (like First page button, Next Page button, previous page button, Last page button, print button etc.) Appears that the icons images for these bottons are missing. And above all, the page does not render report.
IE browser status indicate the following error:
error:'HoevrImagectl161_ctl01_ctl01_ctl06_ctl01' is null or not an object.
The report renders fine via http://<servername>/ReportServer/Pages/ReportViewer.aspx
I may not have explained the problem well here however, if you are interested, I can email you the screenshot of Report.aspx to help you understand the problem.
Any help is appreciated!!!
It seems you are using MOSS. Are you you have installed Sharepoint addon for Reporting Services found at http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=enIf you have. Have tou configured the reporting services in central admin - Application Settings?
If you have make sure in VS2005 you have deployed to the correct MOSS site collection and correct MOSS library and that is where you view your reports.
In MOSS the reports should render using RSViewerPage.aspx
Thanks
|||
Thanks for reply.
No. I am not running MOSS on this machine. Any other thought?
|||I just uploaded the screenprint at :
http://i205.photobucket.com/albums/bb8/spnet/ReportSerrverProblem.jpg
P.s. : I have deliberately masked out the server name and parameter value.
|||Pls help!! Any ideas?
|||
Woohhaaa!!!!!!!!! Figured that out.
It was a javascript error - "RSController.
Make sure your Reports website has the following seeting:
Right click "Reports" website on IIS manager
Go to Properties
Click on Virtual Directory tab
Click on Configuration button
In "wildcard Application Maps.." section, you should have the latest version of aspnet_isapi.dll file listed. If not listed, insert the file. Usually, the file is located at C:\Windows\Microsft.NET\Framework\<your version folder>\aspnet_isapi.dll
Now, click on "Edit" button. Make sure "Verify that File exixts" checkbox is UNCHECKED.
Click "ok" and exit out of Report properties dialogue box. Your reports should work now without IIS throwing any RSController or PramasCtl, imagehower etc. related errors.
Also visit:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=327473&SiteID=1
thank you all!!
Report and other controls not rendered
After resolving all the installation and configuration related issues, I was able to deploy a couple of projects on my report server. I can see alll folders and reports listed inside the folders from http://<servername>/reports . All works fine except when I run a report, the http://<servername>/Reports/Pages/Report.aspx page does not render report.
This page displays View, Properties, History Subscriptions etc, menu items on the top section of the page. It also displays Home, My Subscriptions, Site Settings, Help etc. links on top right corner of the page. I can also see the bar that has "New subscription" button. But the problem starts from the section below that. It does NOT display the Report navigation bottons (like First page button, Next Page button, previous page button, Last page button, print button etc.) Appears that the icons images for these bottons are missing. And above all, the page does not render report.
IE browser status indicate the following error:
error:'HoevrImagectl161_ctl01_ctl01_ctl06_ctl01' is null or not an object.
The report renders fine via http://<servername>/ReportServer/Pages/ReportViewer.aspx
I may not have explained the problem well here however, if you are interested, I can email you the screenshot of Report.aspx to help you understand the problem.
Any help is appreciated!!!
It seems you are using MOSS. Are you you have installed Sharepoint addon for Reporting Services found at http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=enIf you have. Have tou configured the reporting services in central admin - Application Settings?
If you have make sure in VS2005 you have deployed to the correct MOSS site collection and correct MOSS library and that is where you view your reports.
In MOSS the reports should render using RSViewerPage.aspx
Thanks
|||
Thanks for reply.
No. I am not running MOSS on this machine. Any other thought?
|||I just uploaded the screenprint at :
http://i205.photobucket.com/albums/bb8/spnet/ReportSerrverProblem.jpg
P.s. : I have deliberately masked out the server name and parameter value.
|||Pls help!! Any ideas?
|||
Woohhaaa!!!!!!!!! Figured that out.
It was a javascript error - "RSController.
Make sure your Reports website has the following seeting:
Right click "Reports" website on IIS manager
Go to Properties
Click on Virtual Directory tab
Click on Configuration button
In "wildcard Application Maps.." section, you should have the latest version of aspnet_isapi.dll file listed. If not listed, insert the file. Usually, the file is located at C:\Windows\Microsft.NET\Framework\<your version folder>\aspnet_isapi.dll
Now, click on "Edit" button. Make sure "Verify that File exixts" checkbox is UNCHECKED.
Click "ok" and exit out of Report properties dialogue box. Your reports should work now without IIS throwing any RSController or PramasCtl, imagehower etc. related errors.
Also visit:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=327473&SiteID=1
thank you all!!
Reporing Service and deploy permission
Dear all,
I use Window Vista+ Sql server 2005 with SP 2
When I deploy the report in Report designer, the following error message display
The permissions granted to user 'winVista\admin' are insufficient for performing this operation.
The user "admin" is a admininstor and I assign the following group to it
(1) administors
(2)WINVISTA\SQLServer2005ReportingServicesWebServiceUser$WINVISTA$MSSQLSERVER
(3)WINVISTA\SQLServer2005ReportServerUser$WINVISTA$MSSQLSERVER
Which and Where I must assign the permissions to this account?
thanks you
If you connect to Reporting Services in Sql Server Management Studio, right click on the servername and select the properties of the server. Then select the permissions page. What's in there?
Reporing Service and deploy permission
Dear all,
I use Window Vista+ Sql server 2005 with SP 2
When I deploy the report in Report designer, the following error message display
The permissions granted to user 'winVista\admin' are insufficient for performing this operation.
The user "admin" is a admininstor and I assign the following group to it
(1) administors
(2)WINVISTA\SQLServer2005ReportingServicesWebServiceUser$WINVISTA$MSSQLSERVER
(3)WINVISTA\SQLServer2005ReportServerUser$WINVISTA$MSSQLSERVER
Which and Where I must assign the permissions to this account?
thanks you
If you connect to Reporting Services in Sql Server Management Studio, right click on the servername and select the properties of the server. Then select the permissions page. What's in there?
Subscribe to:
Posts (Atom)