When I go out to Reports I can see the reports but when you click on
them all yo get is the properties tab and they will not render. If I
go out the the Reportsserver they will run fine. Is there a reason
why they will not give me the option to render?Just two things, check for the access from the RM, and clear the cache and
then try deploy and run the report. I faced the same before.
Amarnath, MCTS.
"captkirkrules" wrote:
> When I go out to Reports I can see the reports but when you click on
> them all yo get is the properties tab and they will not render. If I
> go out the the Reportsserver they will run fine. Is there a reason
> why they will not give me the option to render?
>
Showing posts with label properties. Show all posts
Showing posts with label properties. Show all posts
Friday, March 30, 2012
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.
> >
> >
> >
Monday, March 26, 2012
Report DateTime Parameters in UK date format
I have a report that I've developed that accepts several datetime parameters.
In the Report properties, I've set the report Language to English (United
Kingdom).
I am calling my report via the Web Service from an ASP.Net application. The
ASP.Net application Culture and UICulture are set for en-GB.
What is happening is that when a date is passed to one of the report
parameters (gEndDate) as "14/12/2004" (December 14), I get the following
error:
The value provided for the report parameter 'gEndDate' is not valid for its
typeI should also point out that my Visual Studio .Net 2003 environment is in
en-US and my computer is in the United States English setting.
The development environment I am testing (where I got the error) is a
Virtual PC environment set up as English UK in the Control Panel.
"AdamB" wrote:
> I have a report that I've developed that accepts several datetime parameters.
> In the Report properties, I've set the report Language to English (United
> Kingdom).
> I am calling my report via the Web Service from an ASP.Net application. The
> ASP.Net application Culture and UICulture are set for en-GB.
> What is happening is that when a date is passed to one of the report
> parameters (gEndDate) as "14/12/2004" (December 14), I get the following
> error:
> The value provided for the report parameter 'gEndDate' is not valid for its
> type
>
In the Report properties, I've set the report Language to English (United
Kingdom).
I am calling my report via the Web Service from an ASP.Net application. The
ASP.Net application Culture and UICulture are set for en-GB.
What is happening is that when a date is passed to one of the report
parameters (gEndDate) as "14/12/2004" (December 14), I get the following
error:
The value provided for the report parameter 'gEndDate' is not valid for its
typeI should also point out that my Visual Studio .Net 2003 environment is in
en-US and my computer is in the United States English setting.
The development environment I am testing (where I got the error) is a
Virtual PC environment set up as English UK in the Control Panel.
"AdamB" wrote:
> I have a report that I've developed that accepts several datetime parameters.
> In the Report properties, I've set the report Language to English (United
> Kingdom).
> I am calling my report via the Web Service from an ASP.Net application. The
> ASP.Net application Culture and UICulture are set for en-GB.
> What is happening is that when a date is passed to one of the report
> parameters (gEndDate) as "14/12/2004" (December 14), I get the following
> error:
> The value provided for the report parameter 'gEndDate' is not valid for its
> type
>
Tuesday, February 21, 2012
Replication: EM-Could not retrieve the list of registered subscribers
When I try to open the subscribers tab in the publisher and distributor properties in SQL Enterprise Manager I get the following error:
SQL Enterprise Manager could not retrieve the list of registered subscribers.
Error 8152: String or binary data will be truncated
Anyone who has experienced similar problems or has a solution?
Best Regards
MFYou might have a problem in the distribution database. I would check the system table mssubscriptions first to see if there's anything wrong.
SQL Enterprise Manager could not retrieve the list of registered subscribers.
Error 8152: String or binary data will be truncated
Anyone who has experienced similar problems or has a solution?
Best Regards
MFYou might have a problem in the distribution database. I would check the system table mssubscriptions first to see if there's anything wrong.
Labels:
database,
distributor,
em-could,
enterprise,
errorsql,
following,
manager,
microsoft,
mysql,
oracle,
properties,
publisher,
registered,
replication,
retrieve,
server,
sql,
subscribers,
tab
Subscribe to:
Posts (Atom)