Hi,
I'm using Reporting Services for SQL2K. My report will need to dynamically
call a custom assembly for each row in a dataset, and then show the image
file that the custom assembly creates. I was thinking of using an Image
control in the report and then changing the path to the image file at
runtime. But I can not figure out how to access the image1.Value property.
Any tips on this or perhaps an alternative solution?
TIA
JonasI found the answer, and it was very easy ;-)
When the control is selected in the Report Designer, it it possible to edit
the properties as usual. The property for Value can also use an Expression,
and voila, this can point to a variable which contains a dynamically created
path.
Brgds
Jonas
"Jonas" <Jonas@.nospam.pl> wrote in message
news:%23z53z3cHGHA.240@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm using Reporting Services for SQL2K. My report will need to dynamically
> call a custom assembly for each row in a dataset, and then show the image
> file that the custom assembly creates. I was thinking of using an Image
> control in the report and then changing the path to the image file at
> runtime. But I can not figure out how to access the image1.Value property.
> Any tips on this or perhaps an alternative solution?
> TIA
> Jonas
>
>
Showing posts with label services. Show all posts
Showing posts with label services. Show all posts
Tuesday, March 27, 2012
Change Header of Report?
Hi all,
Thanks for your answer and I apologize for the big delay in answering.
I tried the ReportViewer control in VS 2005. I set the Report Server URL and the Report Path but I keep getting the error: "The request failed with HTTP status 401: Unauthorized."
As I said, I'm all new to this so I have no idea where to search for this error.
I'm pretty new to SQL Reporting Services so my question might be a little silly. 
I was wondering, if it was possible to change the toolbar of a report. The only thing I found to change there, is the sorting and filter dropdowns. But other than that, is there a way to add my own controls like a Commandbutton? If not, is it possible to remove certain things from the toolbar like the print icon?
Thanks for your answers in advance.
Nat
If you are using Report Manager, you cannot change the toolbar of the report viewer. If you are using the new ReportViewer controls (included in Visual Studio 2005) in your application, you can remove buttons from the toolbar. However, you cannot add things to the toolbar. You could have your own toolbar along with the report viewer.
|||Hi Brian,Thanks for your answer and I apologize for the big delay in answering.
I tried the ReportViewer control in VS 2005. I set the Report Server URL and the Report Path but I keep getting the error: "The request failed with HTTP status 401: Unauthorized."
As I said, I'm all new to this so I have no idea where to search for this error.
Thanks again for your answers in advance.
Nat
Change from Crystal Reports to SQL Server 2005 Reporting Services?
Hi all,
We have a web application that generates statistical reports in PDF format
based on customer data and we're thinking of migrating to SQL Server 2005
Reporting Services but I'd like to know if what we are doing is possible.
Basically, the customer logs onto the system via a regular browser, this
creates a folder on the backend based on their session info. Then they
select a couple of different reports, enter the required parameters and hit
print. The web app runs a VB program that loads the RPT file, modifies the
connections so it's getting the data from the correct customer database,
then exports the report as a PDF into the previously created folder. The
user is then redirected to that file so they can download it.
Whether the report is shown in a browser window or not is all dependent on
the customers settings for PDF documents. We don't need interactive
web-based reports, we don't need to drill-down, we don't need OLAP. It's a
simple "I want a report", "Here it is" scenario, but there is the definate
potential of having several hundred customers all requesting reports at the
same time, which is something our current solution can't handle.
Comments and suggestions are welcome.2005 has the ability to change the datasource at runtime. You do not need to
do any of this creating a folder in the background etc. Everything that you
want is really very simple.When your web app renders it can request it as
PDF. Also, you can send the report a parameter and based on that parameter
pick the appropriate database.
Implementing your security is the biggest issue (and what comes up the most
with an internet application). You will need to do forms based
authentication (which I have not done and do not know much about).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andrew Hayes" <AndrewHayes@.discussions.microsoft.com> wrote in message
news:OOzh8DapGHA.4408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> We have a web application that generates statistical reports in PDF format
> based on customer data and we're thinking of migrating to SQL Server 2005
> Reporting Services but I'd like to know if what we are doing is possible.
> Basically, the customer logs onto the system via a regular browser, this
> creates a folder on the backend based on their session info. Then they
> select a couple of different reports, enter the required parameters and
> hit print. The web app runs a VB program that loads the RPT file, modifies
> the connections so it's getting the data from the correct customer
> database, then exports the report as a PDF into the previously created
> folder. The user is then redirected to that file so they can download it.
> Whether the report is shown in a browser window or not is all dependent on
> the customers settings for PDF documents. We don't need interactive
> web-based reports, we don't need to drill-down, we don't need OLAP. It's a
> simple "I want a report", "Here it is" scenario, but there is the definate
> potential of having several hundred customers all requesting reports at
> the same time, which is something our current solution can't handle.
> Comments and suggestions are welcome.
>|||Thanks for the reply Bruce. Application security is already handled.
Maybe you can guide me through my understanding of how SSRS would handle
this?
a) User opens web-page.
b) User selects report from drop-down list, and the postback shows the
correct parameter options.
c) User enters the parameter values he needs.
d) User clicks on print.
e) Pop-up appears asking the user to wait while their report is prepared.
f) A few minutes later, the pop-up disappears to be replaced by the usual
File Download dialog.
g) User clicks Save and the PDF is saved to their PC.
We can do this in Crystal Reports without any fuss, but when more than 30
users are performing the same actions at the same time, the queue of report
requests ends up being pretty large as it takes quite some time to produce
each report. We're hoping that SSRS will let us "farm" out the report
generation to multiple servers.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OJlmwOcpGHA.3324@.TK2MSFTNGP05.phx.gbl...
> 2005 has the ability to change the datasource at runtime. You do not need
> to do any of this creating a folder in the background etc. Everything that
> you want is really very simple.When your web app renders it can request it
> as PDF. Also, you can send the report a parameter and based on that
> parameter pick the appropriate database.
> Implementing your security is the biggest issue (and what comes up the
> most with an internet application). You will need to do forms based
> authentication (which I have not done and do not know much about).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Andrew Hayes" <AndrewHayes@.discussions.microsoft.com> wrote in message
> news:OOzh8DapGHA.4408@.TK2MSFTNGP04.phx.gbl...
>> Hi all,
>> We have a web application that generates statistical reports in PDF
>> format based on customer data and we're thinking of migrating to SQL
>> Server 2005 Reporting Services but I'd like to know if what we are doing
>> is possible.
>> Basically, the customer logs onto the system via a regular browser, this
>> creates a folder on the backend based on their session info. Then they
>> select a couple of different reports, enter the required parameters and
>> hit print. The web app runs a VB program that loads the RPT file,
>> modifies the connections so it's getting the data from the correct
>> customer database, then exports the report as a PDF into the previously
>> created folder. The user is then redirected to that file so they can
>> download it.
>> Whether the report is shown in a browser window or not is all dependent
>> on the customers settings for PDF documents. We don't need interactive
>> web-based reports, we don't need to drill-down, we don't need OLAP. It's
>> a simple "I want a report", "Here it is" scenario, but there is the
>> definate potential of having several hundred customers all requesting
>> reports at the same time, which is something our current solution can't
>> handle.
>> Comments and suggestions are welcome.
>>
>|||Although implemented in a different way, the scenario described below is no
problem. RS has support for web farms. The Reporting Services app (which is
a 2.0 dotnet application) can run on a web farm. They all use the same
backend database for object/metadata caching. You do have to purchase a SQL
Server 2005 server license for each box running
PDF processing is more resource intensive than html or csv but RS 2005 has
improved this over RS 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andrew Hayes" <AndrewHayes@.discussions.microsoft.com> wrote in message
news:eqzqBohpGHA.1548@.TK2MSFTNGP04.phx.gbl...
> Thanks for the reply Bruce. Application security is already handled.
> Maybe you can guide me through my understanding of how SSRS would handle
> this?
> a) User opens web-page.
> b) User selects report from drop-down list, and the postback shows the
> correct parameter options.
> c) User enters the parameter values he needs.
> d) User clicks on print.
> e) Pop-up appears asking the user to wait while their report is prepared.
> f) A few minutes later, the pop-up disappears to be replaced by the usual
> File Download dialog.
> g) User clicks Save and the PDF is saved to their PC.
> We can do this in Crystal Reports without any fuss, but when more than 30
> users are performing the same actions at the same time, the queue of
> report requests ends up being pretty large as it takes quite some time to
> produce each report. We're hoping that SSRS will let us "farm" out the
> report generation to multiple servers.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OJlmwOcpGHA.3324@.TK2MSFTNGP05.phx.gbl...
>> 2005 has the ability to change the datasource at runtime. You do not need
>> to do any of this creating a folder in the background etc. Everything
>> that you want is really very simple.When your web app renders it can
>> request it as PDF. Also, you can send the report a parameter and based on
>> that parameter pick the appropriate database.
>> Implementing your security is the biggest issue (and what comes up the
>> most with an internet application). You will need to do forms based
>> authentication (which I have not done and do not know much about).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Andrew Hayes" <AndrewHayes@.discussions.microsoft.com> wrote in message
>> news:OOzh8DapGHA.4408@.TK2MSFTNGP04.phx.gbl...
>> Hi all,
>> We have a web application that generates statistical reports in PDF
>> format based on customer data and we're thinking of migrating to SQL
>> Server 2005 Reporting Services but I'd like to know if what we are doing
>> is possible.
>> Basically, the customer logs onto the system via a regular browser, this
>> creates a folder on the backend based on their session info. Then they
>> select a couple of different reports, enter the required parameters and
>> hit print. The web app runs a VB program that loads the RPT file,
>> modifies the connections so it's getting the data from the correct
>> customer database, then exports the report as a PDF into the previously
>> created folder. The user is then redirected to that file so they can
>> download it.
>> Whether the report is shown in a browser window or not is all dependent
>> on the customers settings for PDF documents. We don't need interactive
>> web-based reports, we don't need to drill-down, we don't need OLAP. It's
>> a simple "I want a report", "Here it is" scenario, but there is the
>> definate potential of having several hundred customers all requesting
>> reports at the same time, which is something our current solution can't
>> handle.
>> Comments and suggestions are welcome.
>>
>>
>
We have a web application that generates statistical reports in PDF format
based on customer data and we're thinking of migrating to SQL Server 2005
Reporting Services but I'd like to know if what we are doing is possible.
Basically, the customer logs onto the system via a regular browser, this
creates a folder on the backend based on their session info. Then they
select a couple of different reports, enter the required parameters and hit
print. The web app runs a VB program that loads the RPT file, modifies the
connections so it's getting the data from the correct customer database,
then exports the report as a PDF into the previously created folder. The
user is then redirected to that file so they can download it.
Whether the report is shown in a browser window or not is all dependent on
the customers settings for PDF documents. We don't need interactive
web-based reports, we don't need to drill-down, we don't need OLAP. It's a
simple "I want a report", "Here it is" scenario, but there is the definate
potential of having several hundred customers all requesting reports at the
same time, which is something our current solution can't handle.
Comments and suggestions are welcome.2005 has the ability to change the datasource at runtime. You do not need to
do any of this creating a folder in the background etc. Everything that you
want is really very simple.When your web app renders it can request it as
PDF. Also, you can send the report a parameter and based on that parameter
pick the appropriate database.
Implementing your security is the biggest issue (and what comes up the most
with an internet application). You will need to do forms based
authentication (which I have not done and do not know much about).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andrew Hayes" <AndrewHayes@.discussions.microsoft.com> wrote in message
news:OOzh8DapGHA.4408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> We have a web application that generates statistical reports in PDF format
> based on customer data and we're thinking of migrating to SQL Server 2005
> Reporting Services but I'd like to know if what we are doing is possible.
> Basically, the customer logs onto the system via a regular browser, this
> creates a folder on the backend based on their session info. Then they
> select a couple of different reports, enter the required parameters and
> hit print. The web app runs a VB program that loads the RPT file, modifies
> the connections so it's getting the data from the correct customer
> database, then exports the report as a PDF into the previously created
> folder. The user is then redirected to that file so they can download it.
> Whether the report is shown in a browser window or not is all dependent on
> the customers settings for PDF documents. We don't need interactive
> web-based reports, we don't need to drill-down, we don't need OLAP. It's a
> simple "I want a report", "Here it is" scenario, but there is the definate
> potential of having several hundred customers all requesting reports at
> the same time, which is something our current solution can't handle.
> Comments and suggestions are welcome.
>|||Thanks for the reply Bruce. Application security is already handled.
Maybe you can guide me through my understanding of how SSRS would handle
this?
a) User opens web-page.
b) User selects report from drop-down list, and the postback shows the
correct parameter options.
c) User enters the parameter values he needs.
d) User clicks on print.
e) Pop-up appears asking the user to wait while their report is prepared.
f) A few minutes later, the pop-up disappears to be replaced by the usual
File Download dialog.
g) User clicks Save and the PDF is saved to their PC.
We can do this in Crystal Reports without any fuss, but when more than 30
users are performing the same actions at the same time, the queue of report
requests ends up being pretty large as it takes quite some time to produce
each report. We're hoping that SSRS will let us "farm" out the report
generation to multiple servers.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OJlmwOcpGHA.3324@.TK2MSFTNGP05.phx.gbl...
> 2005 has the ability to change the datasource at runtime. You do not need
> to do any of this creating a folder in the background etc. Everything that
> you want is really very simple.When your web app renders it can request it
> as PDF. Also, you can send the report a parameter and based on that
> parameter pick the appropriate database.
> Implementing your security is the biggest issue (and what comes up the
> most with an internet application). You will need to do forms based
> authentication (which I have not done and do not know much about).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Andrew Hayes" <AndrewHayes@.discussions.microsoft.com> wrote in message
> news:OOzh8DapGHA.4408@.TK2MSFTNGP04.phx.gbl...
>> Hi all,
>> We have a web application that generates statistical reports in PDF
>> format based on customer data and we're thinking of migrating to SQL
>> Server 2005 Reporting Services but I'd like to know if what we are doing
>> is possible.
>> Basically, the customer logs onto the system via a regular browser, this
>> creates a folder on the backend based on their session info. Then they
>> select a couple of different reports, enter the required parameters and
>> hit print. The web app runs a VB program that loads the RPT file,
>> modifies the connections so it's getting the data from the correct
>> customer database, then exports the report as a PDF into the previously
>> created folder. The user is then redirected to that file so they can
>> download it.
>> Whether the report is shown in a browser window or not is all dependent
>> on the customers settings for PDF documents. We don't need interactive
>> web-based reports, we don't need to drill-down, we don't need OLAP. It's
>> a simple "I want a report", "Here it is" scenario, but there is the
>> definate potential of having several hundred customers all requesting
>> reports at the same time, which is something our current solution can't
>> handle.
>> Comments and suggestions are welcome.
>>
>|||Although implemented in a different way, the scenario described below is no
problem. RS has support for web farms. The Reporting Services app (which is
a 2.0 dotnet application) can run on a web farm. They all use the same
backend database for object/metadata caching. You do have to purchase a SQL
Server 2005 server license for each box running
PDF processing is more resource intensive than html or csv but RS 2005 has
improved this over RS 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andrew Hayes" <AndrewHayes@.discussions.microsoft.com> wrote in message
news:eqzqBohpGHA.1548@.TK2MSFTNGP04.phx.gbl...
> Thanks for the reply Bruce. Application security is already handled.
> Maybe you can guide me through my understanding of how SSRS would handle
> this?
> a) User opens web-page.
> b) User selects report from drop-down list, and the postback shows the
> correct parameter options.
> c) User enters the parameter values he needs.
> d) User clicks on print.
> e) Pop-up appears asking the user to wait while their report is prepared.
> f) A few minutes later, the pop-up disappears to be replaced by the usual
> File Download dialog.
> g) User clicks Save and the PDF is saved to their PC.
> We can do this in Crystal Reports without any fuss, but when more than 30
> users are performing the same actions at the same time, the queue of
> report requests ends up being pretty large as it takes quite some time to
> produce each report. We're hoping that SSRS will let us "farm" out the
> report generation to multiple servers.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OJlmwOcpGHA.3324@.TK2MSFTNGP05.phx.gbl...
>> 2005 has the ability to change the datasource at runtime. You do not need
>> to do any of this creating a folder in the background etc. Everything
>> that you want is really very simple.When your web app renders it can
>> request it as PDF. Also, you can send the report a parameter and based on
>> that parameter pick the appropriate database.
>> Implementing your security is the biggest issue (and what comes up the
>> most with an internet application). You will need to do forms based
>> authentication (which I have not done and do not know much about).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Andrew Hayes" <AndrewHayes@.discussions.microsoft.com> wrote in message
>> news:OOzh8DapGHA.4408@.TK2MSFTNGP04.phx.gbl...
>> Hi all,
>> We have a web application that generates statistical reports in PDF
>> format based on customer data and we're thinking of migrating to SQL
>> Server 2005 Reporting Services but I'd like to know if what we are doing
>> is possible.
>> Basically, the customer logs onto the system via a regular browser, this
>> creates a folder on the backend based on their session info. Then they
>> select a couple of different reports, enter the required parameters and
>> hit print. The web app runs a VB program that loads the RPT file,
>> modifies the connections so it's getting the data from the correct
>> customer database, then exports the report as a PDF into the previously
>> created folder. The user is then redirected to that file so they can
>> download it.
>> Whether the report is shown in a browser window or not is all dependent
>> on the customers settings for PDF documents. We don't need interactive
>> web-based reports, we don't need to drill-down, we don't need OLAP. It's
>> a simple "I want a report", "Here it is" scenario, but there is the
>> definate potential of having several hundred customers all requesting
>> reports at the same time, which is something our current solution can't
>> handle.
>> Comments and suggestions are welcome.
>>
>>
>
Sunday, March 25, 2012
change fonts existing reports
Is it possible to change the font, for example to font-family Arial, for all
the existing reports made in reporting services.
--
regards, pakamSorry, this is not supported.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"pakam" <pakam@.discussions.microsoft.com> wrote in message
news:A53D0F05-9BF1-4A6C-A42C-DBAB603B8392@.microsoft.com...
> Is it possible to change the font, for example to font-family Arial, for
> all
> the existing reports made in reporting services.
> --
> regards, pakam|||You could do it dynamically, by using getreportdefinition to get one of the
existing reports as xml, then use SelectNodeList to get all the <FontFamily>
nodes.
Then foreach node in the node list, change the InnerText to the new font &
republish the report
"Robert Bruckner [MSFT]" wrote:
> Sorry, this is not supported.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "pakam" <pakam@.discussions.microsoft.com> wrote in message
> news:A53D0F05-9BF1-4A6C-A42C-DBAB603B8392@.microsoft.com...
> > Is it possible to change the font, for example to font-family Arial, for
> > all
> > the existing reports made in reporting services.
> > --
> > regards, pakam
>
>|||Hi mark-s,
Thank you for your reaction. For your solution I have to write code ? I did
find the GetReportDefinition but not the SelectNodeList. Can you explain more
how to do this ? .
I did find out that it is possible to use Edit -> Find and Replace ->
Replace in Files. This is not perfect but it helps to avoid changing every
item. Then you can change all reports in the project to the font-family arial
for example.
Regards pakam
"mark-s" wrote:
> You could do it dynamically, by using getreportdefinition to get one of the
> existing reports as xml, then use SelectNodeList to get all the <FontFamily>
> nodes.
> Then foreach node in the node list, change the InnerText to the new font &
> republish the report
> "Robert Bruckner [MSFT]" wrote:
> > Sorry, this is not supported.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "pakam" <pakam@.discussions.microsoft.com> wrote in message
> > news:A53D0F05-9BF1-4A6C-A42C-DBAB603B8392@.microsoft.com...
> > > Is it possible to change the font, for example to font-family Arial, for
> > > all
> > > the existing reports made in reporting services.
> > > --
> > > regards, pakam
> >
> >
> >|||Hi pakam
Yes, you will have to write code. SelectNodeList is in the System.Xml.XPath
namespace.
However, if you only want to change the font once, then Find/Replace might
be easier. I was thinking that you may need to change the font regularly.
"pakam" wrote:
> Hi mark-s,
> Thank you for your reaction. For your solution I have to write code ? I did
> find the GetReportDefinition but not the SelectNodeList. Can you explain more
> how to do this ? .
> I did find out that it is possible to use Edit -> Find and Replace ->
> Replace in Files. This is not perfect but it helps to avoid changing every
> item. Then you can change all reports in the project to the font-family arial
> for example.
> Regards pakam
>
> "mark-s" wrote:
> > You could do it dynamically, by using getreportdefinition to get one of the
> > existing reports as xml, then use SelectNodeList to get all the <FontFamily>
> > nodes.
> > Then foreach node in the node list, change the InnerText to the new font &
> > republish the report
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > Sorry, this is not supported.
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > >
> > > "pakam" <pakam@.discussions.microsoft.com> wrote in message
> > > news:A53D0F05-9BF1-4A6C-A42C-DBAB603B8392@.microsoft.com...
> > > > Is it possible to change the font, for example to font-family Arial, for
> > > > all
> > > > the existing reports made in reporting services.
> > > > --
> > > > regards, pakam
> > >
> > >
> > >
the existing reports made in reporting services.
--
regards, pakamSorry, this is not supported.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"pakam" <pakam@.discussions.microsoft.com> wrote in message
news:A53D0F05-9BF1-4A6C-A42C-DBAB603B8392@.microsoft.com...
> Is it possible to change the font, for example to font-family Arial, for
> all
> the existing reports made in reporting services.
> --
> regards, pakam|||You could do it dynamically, by using getreportdefinition to get one of the
existing reports as xml, then use SelectNodeList to get all the <FontFamily>
nodes.
Then foreach node in the node list, change the InnerText to the new font &
republish the report
"Robert Bruckner [MSFT]" wrote:
> Sorry, this is not supported.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "pakam" <pakam@.discussions.microsoft.com> wrote in message
> news:A53D0F05-9BF1-4A6C-A42C-DBAB603B8392@.microsoft.com...
> > Is it possible to change the font, for example to font-family Arial, for
> > all
> > the existing reports made in reporting services.
> > --
> > regards, pakam
>
>|||Hi mark-s,
Thank you for your reaction. For your solution I have to write code ? I did
find the GetReportDefinition but not the SelectNodeList. Can you explain more
how to do this ? .
I did find out that it is possible to use Edit -> Find and Replace ->
Replace in Files. This is not perfect but it helps to avoid changing every
item. Then you can change all reports in the project to the font-family arial
for example.
Regards pakam
"mark-s" wrote:
> You could do it dynamically, by using getreportdefinition to get one of the
> existing reports as xml, then use SelectNodeList to get all the <FontFamily>
> nodes.
> Then foreach node in the node list, change the InnerText to the new font &
> republish the report
> "Robert Bruckner [MSFT]" wrote:
> > Sorry, this is not supported.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "pakam" <pakam@.discussions.microsoft.com> wrote in message
> > news:A53D0F05-9BF1-4A6C-A42C-DBAB603B8392@.microsoft.com...
> > > Is it possible to change the font, for example to font-family Arial, for
> > > all
> > > the existing reports made in reporting services.
> > > --
> > > regards, pakam
> >
> >
> >|||Hi pakam
Yes, you will have to write code. SelectNodeList is in the System.Xml.XPath
namespace.
However, if you only want to change the font once, then Find/Replace might
be easier. I was thinking that you may need to change the font regularly.
"pakam" wrote:
> Hi mark-s,
> Thank you for your reaction. For your solution I have to write code ? I did
> find the GetReportDefinition but not the SelectNodeList. Can you explain more
> how to do this ? .
> I did find out that it is possible to use Edit -> Find and Replace ->
> Replace in Files. This is not perfect but it helps to avoid changing every
> item. Then you can change all reports in the project to the font-family arial
> for example.
> Regards pakam
>
> "mark-s" wrote:
> > You could do it dynamically, by using getreportdefinition to get one of the
> > existing reports as xml, then use SelectNodeList to get all the <FontFamily>
> > nodes.
> > Then foreach node in the node list, change the InnerText to the new font &
> > republish the report
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > Sorry, this is not supported.
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > >
> > > "pakam" <pakam@.discussions.microsoft.com> wrote in message
> > > news:A53D0F05-9BF1-4A6C-A42C-DBAB603B8392@.microsoft.com...
> > > > Is it possible to change the font, for example to font-family Arial, for
> > > > all
> > > > the existing reports made in reporting services.
> > > > --
> > > > regards, pakam
> > >
> > >
> > >
Tuesday, March 20, 2012
Change Datasource connectionstring
Hey,
I have a SQL Server 2005, an Reporting Services is also installed.
Now I have a report 'Report1' and a datasource 'DS1', the report is build and deployed.
The report works fine when i see it in a browser.
Now I have made a vb.net application with a dataviewer, the dataviewer shows the report 'Report1'.
But I want to be able to change the datasource 'DS1' from my application code.
How can I do this?
thanks
Hi,
you could use a hidden parameter which will influence the beahaviour of a dynamic evaluated connectring string, though connection strings can be designed dynamically like ="Data Source" + IIF(Parameters!SomeParam.Value = 1, "SomeServer",SomeOtherServer") That is a thing which is most common, enabling you to do this also on the brwoser interface by just manipulating the URL of the Report.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
change Datasource at runtime
Hi
I've had the same problem. I found that it was not possible without re-rendering the SRS code(XML). It is not possible in SRS since you can't use an expression to change the dataset. Also the field names of datasets may differ.
Is it possible to change the datasource dynamically in reporting services.
For example if I have a dataset named DataSet1 whose datasource1 connects to server1, how can I change the same DataSet1 to use datasource2 to points to a different server. I would like to know if this datasource change is possible out side the dataset (dynamically).
Thanks
I've had the same problem. I found that it was not possible without re-rendering the SRS code(XML). It is not possible in SRS since you can't use an expression to change the dataset. Also the field names of datasets may differ.
Monday, March 19, 2012
Change Data Capture in Integration Services Packages
Hi,
Is available any tutorial or example which shows how to use Change Data Capture in Integration Services Packages?
I have found Using Change Data Capture in Integration Services Packages topic in BOL but there is an error and I can not open it. There is also Change Data Capture live meeting but "this meeting has already finished".
Thanks,
Rafal
Hi Rafal,You can still view the LiveMeeting. If you've registered for Katmai on Connect, go here to access the archived LiveMeetings.
-Chris
|||
Hi Rafal,
Change Data Capture is working fine in Katmai, I have already tested it.
Go to the below mentioned site. It clearly demonstrates the way to achieve it.
http://www.kodyaz.com/articles/change-data-capture.aspx
If still u find any problem doing so, do tell me where exactly you failing, might help you out
|||Rafal,
I can send the sample i used in the live meeting presentation, if you haven;t already got one, We plan to provide samples publicly very shortly, but this should help you out in the short term.
ThanksGopal
|||Hi Gopal, The SSIS sample will be of help to us. I would appreciate if you cand send the sample. Thanks.
Change Data Capture in Integration Services Packages
Hi,
Is available any tutorial or example which shows how to use Change Data Capture in Integration Services Packages?
I have found Using Change Data Capture in Integration Services Packages topic in BOL but there is an error and I can not open it. There is also Change Data Capture live meeting but "this meeting has already finished".
Thanks,
Rafal
Hi Rafal,You can view the archived LiveMeeting. If you've registered for Katmai on Connect, go here to select an archived LiveMeeting.
-Chris
Change Data Capture in Integration Services Packages
Hi,
Is available any tutorial or example which shows how to use Change Data Capture in Integration Services Packages?
I have found Using Change Data Capture in Integration Services Packages topic in BOL but there is an error and I can not open it. There is also Change Data Capture live meeting but "this meeting has already finished".
Thanks,
Rafal
Hi Rafal,You can still view the LiveMeeting. If you've registered for Katmai on Connect, go here to access the archived LiveMeetings.
-Chris
|||
Hi Rafal,
Change Data Capture is working fine in Katmai, I have already tested it.
Go to the below mentioned site. It clearly demonstrates the way to achieve it.
http://www.kodyaz.com/articles/change-data-capture.aspx
If still u find any problem doing so, do tell me where exactly you failing, might help you out|||Rafal,
I can send the sample i used in the live meeting presentation, if you haven;t already got one, We plan to provide samples publicly very shortly, but this should help you out in the short term.
ThanksGopal
|||Hi Gopal, The SSIS sample will be of help to us. I would appreciate if you cand send the sample. Thanks.
Sunday, March 11, 2012
Change CommandText
I have a report created on the reporting services and i
need to change the query that the report uses to retrieve
data dynamically based on a criteria page.
All I need is to change part of the RDL of the report
that includes the command text but i can't seem to find
how to do that. Can anyone please HELP!!!.
Thanks...
Omniams-help://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure_data_v1_41ir.htm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Omnia" <anonymous@.discussions.microsoft.com> wrote in message
news:725a01c494ba$37e1cf70$a601280a@.phx.gbl...
>I have a report created on the reporting services and i
> need to change the query that the report uses to retrieve
> data dynamically based on a criteria page.
> All I need is to change part of the RDL of the report
> that includes the command text but i can't seem to find
> how to do that. Can anyone please HELP!!!.
>
> Thanks...
> Omnia|||Thanks very much for the link...
But I still have the following issues:
- Primarily the walkthrough does not work as it insists
on generating errors being unable to parse the query and
I can't manage to make it work...
- The other issue is that this will provide either
an 'ALL' or single selection but not multiple selection
which is what I primarily wanted to achieve, nevertheless
I do appreciate if you can help me further with the
syntax to make the walkthrough work...
Thanks again !!!
Omnia
>--Original Message--
>ms-
help://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure
_data_v1_41ir.htm
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"Omnia" <anonymous@.discussions.microsoft.com> wrote in
message
>news:725a01c494ba$37e1cf70$a601280a@.phx.gbl...
>>I have a report created on the reporting services and i
>> need to change the query that the report uses to
retrieve
>> data dynamically based on a criteria page.
>> All I need is to change part of the RDL of the report
>> that includes the command text but i can't seem to find
>> how to do that. Can anyone please HELP!!!.
>>
>> Thanks...
>> Omnia
>
>.
>|||Could you post your query and exact error message?
Multiple selection feature is in our wishlist for future releases.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Omnia" <anonymous@.discussions.microsoft.com> wrote in message
news:80f101c495a4$c5efd1a0$a501280a@.phx.gbl...
> Thanks very much for the link...
> But I still have the following issues:
> - Primarily the walkthrough does not work as it insists
> on generating errors being unable to parse the query and
> I can't manage to make it work...
> - The other issue is that this will provide either
> an 'ALL' or single selection but not multiple selection
> which is what I primarily wanted to achieve, nevertheless
> I do appreciate if you can help me further with the
> syntax to make the walkthrough work...
>
> Thanks again !!!
> Omnia
>
>
>
>>--Original Message--
>>ms-
> help://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure
> _data_v1_41ir.htm
>>--
>>This posting is provided "AS IS" with no warranties, and
> confers no rights.
>>"Omnia" <anonymous@.discussions.microsoft.com> wrote in
> message
>>news:725a01c494ba$37e1cf70$a601280a@.phx.gbl...
>>I have a report created on the reporting services and i
>> need to change the query that the report uses to
> retrieve
>> data dynamically based on a criteria page.
>> All I need is to change part of the RDL of the report
>> that includes the command text but i can't seem to find
>> how to do that. Can anyone please HELP!!!.
>>
>> Thanks...
>> Omnia
>>
>>.|||Thank You very much for your assistance, the walkthrough
worked fine, and I will try to apply that around here...
>--Original Message--
>Could you post your query and exact error message?
>Multiple selection feature is in our wishlist for future
releases.
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>"Omnia" <anonymous@.discussions.microsoft.com> wrote in
message
>news:80f101c495a4$c5efd1a0$a501280a@.phx.gbl...
>> Thanks very much for the link...
>> But I still have the following issues:
>> - Primarily the walkthrough does not work as it insists
>> on generating errors being unable to parse the query
and
>> I can't manage to make it work...
>> - The other issue is that this will provide either
>> an 'ALL' or single selection but not multiple selection
>> which is what I primarily wanted to achieve,
nevertheless
>> I do appreciate if you can help me further with the
>> syntax to make the walkthrough work...
>>
>> Thanks again !!!
>> Omnia
>>
>>
>>
>>--Original Message--
>>ms-
help://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure
>> _data_v1_41ir.htm
>>--
>>This posting is provided "AS IS" with no warranties,
and
>> confers no rights.
>>"Omnia" <anonymous@.discussions.microsoft.com> wrote in
>> message
>>news:725a01c494ba$37e1cf70$a601280a@.phx.gbl...
>>I have a report created on the reporting services and
i
>> need to change the query that the report uses to
>> retrieve
>> data dynamically based on a criteria page.
>> All I need is to change part of the RDL of the report
>> that includes the command text but i can't seem to
find
>> how to do that. Can anyone please HELP!!!.
>>
>> Thanks...
>> Omnia
>>
>>.
>
>.
>|||What is ms-help://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure_data_v1_41ir.htm
Is that a URL ? Or is it
http://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure_data_v1_41ir.htm
I can access neither.
Please help !|||ms-help: link should work if you have books online installed.
MSDN page is here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_structure_data_v1_41ir.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"mangaraju venuturupalli" <mangaraju@.yahoo.com> wrote in message
news:784bfe81.0409141309.18bae5e6@.posting.google.com...
> What is
> ms-help://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure_data_v1_41ir.htm
> Is that a URL ? Or is it
> http://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure_data_v1_41ir.htm
> I can access neither.
> Please help !
need to change the query that the report uses to retrieve
data dynamically based on a criteria page.
All I need is to change part of the RDL of the report
that includes the command text but i can't seem to find
how to do that. Can anyone please HELP!!!.
Thanks...
Omniams-help://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure_data_v1_41ir.htm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Omnia" <anonymous@.discussions.microsoft.com> wrote in message
news:725a01c494ba$37e1cf70$a601280a@.phx.gbl...
>I have a report created on the reporting services and i
> need to change the query that the report uses to retrieve
> data dynamically based on a criteria page.
> All I need is to change part of the RDL of the report
> that includes the command text but i can't seem to find
> how to do that. Can anyone please HELP!!!.
>
> Thanks...
> Omnia|||Thanks very much for the link...
But I still have the following issues:
- Primarily the walkthrough does not work as it insists
on generating errors being unable to parse the query and
I can't manage to make it work...
- The other issue is that this will provide either
an 'ALL' or single selection but not multiple selection
which is what I primarily wanted to achieve, nevertheless
I do appreciate if you can help me further with the
syntax to make the walkthrough work...
Thanks again !!!
Omnia
>--Original Message--
>ms-
help://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure
_data_v1_41ir.htm
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"Omnia" <anonymous@.discussions.microsoft.com> wrote in
message
>news:725a01c494ba$37e1cf70$a601280a@.phx.gbl...
>>I have a report created on the reporting services and i
>> need to change the query that the report uses to
retrieve
>> data dynamically based on a criteria page.
>> All I need is to change part of the RDL of the report
>> that includes the command text but i can't seem to find
>> how to do that. Can anyone please HELP!!!.
>>
>> Thanks...
>> Omnia
>
>.
>|||Could you post your query and exact error message?
Multiple selection feature is in our wishlist for future releases.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Omnia" <anonymous@.discussions.microsoft.com> wrote in message
news:80f101c495a4$c5efd1a0$a501280a@.phx.gbl...
> Thanks very much for the link...
> But I still have the following issues:
> - Primarily the walkthrough does not work as it insists
> on generating errors being unable to parse the query and
> I can't manage to make it work...
> - The other issue is that this will provide either
> an 'ALL' or single selection but not multiple selection
> which is what I primarily wanted to achieve, nevertheless
> I do appreciate if you can help me further with the
> syntax to make the walkthrough work...
>
> Thanks again !!!
> Omnia
>
>
>
>>--Original Message--
>>ms-
> help://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure
> _data_v1_41ir.htm
>>--
>>This posting is provided "AS IS" with no warranties, and
> confers no rights.
>>"Omnia" <anonymous@.discussions.microsoft.com> wrote in
> message
>>news:725a01c494ba$37e1cf70$a601280a@.phx.gbl...
>>I have a report created on the reporting services and i
>> need to change the query that the report uses to
> retrieve
>> data dynamically based on a criteria page.
>> All I need is to change part of the RDL of the report
>> that includes the command text but i can't seem to find
>> how to do that. Can anyone please HELP!!!.
>>
>> Thanks...
>> Omnia
>>
>>.|||Thank You very much for your assistance, the walkthrough
worked fine, and I will try to apply that around here...
>--Original Message--
>Could you post your query and exact error message?
>Multiple selection feature is in our wishlist for future
releases.
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>"Omnia" <anonymous@.discussions.microsoft.com> wrote in
message
>news:80f101c495a4$c5efd1a0$a501280a@.phx.gbl...
>> Thanks very much for the link...
>> But I still have the following issues:
>> - Primarily the walkthrough does not work as it insists
>> on generating errors being unable to parse the query
and
>> I can't manage to make it work...
>> - The other issue is that this will provide either
>> an 'ALL' or single selection but not multiple selection
>> which is what I primarily wanted to achieve,
nevertheless
>> I do appreciate if you can help me further with the
>> syntax to make the walkthrough work...
>>
>> Thanks again !!!
>> Omnia
>>
>>
>>
>>--Original Message--
>>ms-
help://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure
>> _data_v1_41ir.htm
>>--
>>This posting is provided "AS IS" with no warranties,
and
>> confers no rights.
>>"Omnia" <anonymous@.discussions.microsoft.com> wrote in
>> message
>>news:725a01c494ba$37e1cf70$a601280a@.phx.gbl...
>>I have a report created on the reporting services and
i
>> need to change the query that the report uses to
>> retrieve
>> data dynamically based on a criteria page.
>> All I need is to change part of the RDL of the report
>> that includes the command text but i can't seem to
find
>> how to do that. Can anyone please HELP!!!.
>>
>> Thanks...
>> Omnia
>>
>>.
>
>.
>|||What is ms-help://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure_data_v1_41ir.htm
Is that a URL ? Or is it
http://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure_data_v1_41ir.htm
I can access neither.
Please help !|||ms-help: link should work if you have books online installed.
MSDN page is here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_structure_data_v1_41ir.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"mangaraju venuturupalli" <mangaraju@.yahoo.com> wrote in message
news:784bfe81.0409141309.18bae5e6@.posting.google.com...
> What is
> ms-help://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure_data_v1_41ir.htm
> Is that a URL ? Or is it
> http://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_structure_data_v1_41ir.htm
> I can access neither.
> Please help !
Change color in a chart
Does anyone know how to change a chart color in reporting services?
I need a different color from colors available in the palette.
Thanks in advance,
ELEN.type into the related property box the color rather than use the pallet
eg Beside BackgroudColor there might be a [] Transparent
just type in #12ff21
ELEN wrote:
> Does anyone know how to change a chart color in reporting services?
> I need a different color from colors available in the palette.
> Thanks in advance,
> ELEN.|||You also need to make sure you have SP2 installed
I need a different color from colors available in the palette.
Thanks in advance,
ELEN.type into the related property box the color rather than use the pallet
eg Beside BackgroudColor there might be a [] Transparent
just type in #12ff21
ELEN wrote:
> Does anyone know how to change a chart color in reporting services?
> I need a different color from colors available in the palette.
> Thanks in advance,
> ELEN.|||You also need to make sure you have SP2 installed
Thursday, March 8, 2012
change acceptable filesize of files to be placed in the portal
Nice thing of the reporting services portal is the option to upload
different type of files like xls and pdf.
I was trying to upload a pdf of 5 megs but the portal didn't accept it.
Is it possible to change the maximum acceptable filesize?Do you realize that RS anything deployed into a database. Nothing is stored
as a file. RS is not really designed to be used as a document storage
system. Although as you discovered you can do this (I have done it for some
word documents).
I am not aware of any parameter to change in this regard (changing the max
file size).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"nickismyname" <j.koopmans@.novio.nl> wrote in message
news:1166110729.330622.237020@.16g2000cwy.googlegroups.com...
> Nice thing of the reporting services portal is the option to upload
> different type of files like xls and pdf.
> I was trying to upload a pdf of 5 megs but the portal didn't accept it.
> Is it possible to change the maximum acceptable filesize?
>
different type of files like xls and pdf.
I was trying to upload a pdf of 5 megs but the portal didn't accept it.
Is it possible to change the maximum acceptable filesize?Do you realize that RS anything deployed into a database. Nothing is stored
as a file. RS is not really designed to be used as a document storage
system. Although as you discovered you can do this (I have done it for some
word documents).
I am not aware of any parameter to change in this regard (changing the max
file size).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"nickismyname" <j.koopmans@.novio.nl> wrote in message
news:1166110729.330622.237020@.16g2000cwy.googlegroups.com...
> Nice thing of the reporting services portal is the option to upload
> different type of files like xls and pdf.
> I was trying to upload a pdf of 5 megs but the portal didn't accept it.
> Is it possible to change the maximum acceptable filesize?
>
Change "Report is being generated"
Hello,
I develop some application using SQL Server Reporting Services 2005 to Russian customers. They usually don't know English well. That's why I really want to change phrase "Report is being generated" to Russian words.
How can I do it? I tried to fing this phrase in configuration files or registry but there wasn't success.
Thank you,Hi,
If I change the language of the browser, the language of the "Report is being generated" changes. Not sure if you have already tried this. If you have, then I'm guessing the Server doesn't have Russian language capabilities. I tried in Russian and it didn't work.
Tommy|||Well, I use Russian version of Internet Explorer and English version of SQL Server. There is no Russian SQL Server yet.
So, maybe there is any "low-level" feature to change this phrase?|||
If you are using the ReportViewer control, you can customize the message by implementing IReportViewerMessages. The specific property that will help you is ProgressText.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportviewermessages.aspx
|||Well, I tried to do this. I full copied sample but all the time I receive "The type MySample.CReportViewerCustomMessages does not implementIReportViewerMessages or could not be found".
When I try to use this class in other keys at web.config, everything is OK...|||Most likely the problem is that the class could not be found. Are you using the fully qualified name of the class, including the assembly and public key if necessary?|||Well, I tried... Is there any example of using this feature? It'll be very useful!|||There are some sample implementations on MSDN, though it sounds like your issue is with deployment, not implementation. Will you post the exact line you are adding to the web.config file? You should be able to take the config file value and pass it to Type.GetType() without errors. Your assembly should also be in the same location as the rest of your binaries or in the GAC.|||
how can i create assembly for web config,
my class name inherited from IReportMessages name is "newMessages" and its in app_code. my project has not namespace.
my project name is reportWeb.(reportWeb/app_code/newMessages class path)
|||You can set the value of the web.config entry to:
value="Namespace.Classname, APP_CODE"
If you have no namespace, then:
value="Classname, APP_CODE"
|||I solved, it was my fault.When I looked assamblies I have created two version, I was giving wrong version of assambly.I deleted that then I give the valid one to referance web.config It is worked.Thanks.
|||I'm getting the same error over and over, I try a lot of stuff but nothing takes me to the solution!
Can anyone give a complete walkthrought since the creation of a classe to the final web.config edit? Please!
Thanks!
|||first you should create class library project.
I create strong key with "sn -k <project path>".
my project name is prometus, and my class name msg which is inherited from IReportViewerMessages
"namespace Prometus
{
public class msg:IReportViewerMessages
{".
Then implement the Interface.
then in AssemblyInfo.cs give your strong named key path.(if your .snk file is not in your project path use full path sample: "c:\a.snk")
[assembly: AssemblyKeyFile("..\\..\\a.snk")]
then build your project.
you should load assembly to gac.
in command prompt use gacutil -i "your dllname".
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
then add the appsettings key like this
<!--<add key="ReportViewerMessages" value="Prometus.Msg, Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
|||
Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
|||PedroMarques wrote:
Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
I forgot to tell one thing, I'm trying to translate the Report Manager of the Report Server Browser! I'm not creating a project that uses the report view component...
This quote was just to clarify this point...
Thanks again for your time!
Wednesday, March 7, 2012
Change "Report is being generated"
Hello,
When I try to use this class in other keys at web.config, everything is OK...|||Most likely the problem is that the class could not be found. Are you using the fully qualified name of the class, including the assembly and public key if necessary?|||Well, I tried... Is there any example of using this feature? It'll be very useful!|||There are some sample implementations on MSDN, though it sounds like your issue is with deployment, not implementation. Will you post the exact line you are adding to the web.config file? You should be able to take the config file value and pass it to Type.GetType() without errors. Your assembly should also be in the same location as the rest of your binaries or in the GAC.|||
I develop some application using SQL Server Reporting Services 2005 to Russian customers. They usually don't know English well. That's why I really want to change phrase "Report is being generated" to Russian words.
How can I do it? I tried to fing this phrase in configuration files or registry but there wasn't success.
Thank you,Hi,
If I change the language of the browser, the language of the "Report is being generated" changes. Not sure if you have already tried this. If you have, then I'm guessing the Server doesn't have Russian language capabilities. I tried in Russian and it didn't work.
Tommy
|||Well, I use Russian version of Internet Explorer and English version of SQL Server. There is no Russian SQL Server yet.
So, maybe there is any "low-level" feature to change this phrase?|||
If you are using the ReportViewer control, you can customize the message by implementing IReportViewerMessages. The specific property that will help you is ProgressText.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportviewermessages.aspx
|||Well, I tried to do this. I full copied sample but all the time I receive "The type MySample.CReportViewerCustomMessages does not implement IReportViewerMessages or could not be found".When I try to use this class in other keys at web.config, everything is OK...|||Most likely the problem is that the class could not be found. Are you using the fully qualified name of the class, including the assembly and public key if necessary?|||Well, I tried... Is there any example of using this feature? It'll be very useful!|||There are some sample implementations on MSDN, though it sounds like your issue is with deployment, not implementation. Will you post the exact line you are adding to the web.config file? You should be able to take the config file value and pass it to Type.GetType() without errors. Your assembly should also be in the same location as the rest of your binaries or in the GAC.|||
how can i create assembly for web config,
my class name inherited from IReportMessages name is "newMessages" and its in app_code. my project has not namespace.
my project name is reportWeb.(reportWeb/app_code/newMessages class path)
|||You can set the value of the web.config entry to:
value="Namespace.Classname, APP_CODE"
If you have no namespace, then:
value="Classname, APP_CODE"
|||I solved, it was my fault.When I looked assamblies I have created two version, I was giving wrong version of assambly.I deleted that then I give the valid one to referance web.config It is worked.Thanks.
|||I'm getting the same error over and over, I try a lot of stuff but nothing takes me to the solution!
Can anyone give a complete walkthrought since the creation of a classe to the final web.config edit? Please!
Thanks!
|||first you should create class library project.
I create strong key with "sn -k <project path>".
my project name is prometus, and my class name msg which is inherited from IReportViewerMessages
"namespace Prometus
{
public class msg:IReportViewerMessages
{".
Then implement the Interface.
then in AssemblyInfo.cs give your strong named key path.(if your .snk file is not in your project path use full path sample: "c:\a.snk")
[assembly: AssemblyKeyFile("..\\..\\a.snk")]
then build your project.
you should load assembly to gac.
in command prompt use gacutil -i "your dllname".
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
then add the appsettings key like this
<!--<add key="ReportViewerMessages" value="Prometus.Msg, Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
|||
Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
|||PedroMarques wrote:
Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
I forgot to tell one thing, I'm trying to translate the Report Manager of the Report Server Browser! I'm not creating a project that uses the report view component...
This quote was just to clarify this point...
Thanks again for your time!
Change "Report is being generated"
Hello,
I develop some application using SQL Server Reporting Services 2005 to Russian customers. They usually don't know English well. That's why I really want to change phrase "Report is being generated" to Russian words.
How can I do it? I tried to fing this phrase in configuration files or registry but there wasn't success.
Thank you,Hi,
If I change the language of the browser, the language of the "Report is being generated" changes. Not sure if you have already tried this. If you have, then I'm guessing the Server doesn't have Russian language capabilities. I tried in Russian and it didn't work.
Tommy|||Well, I use Russian version of Internet Explorer and English version of SQL Server. There is no Russian SQL Server yet.
So, maybe there is any "low-level" feature to change this phrase?|||
If you are using the ReportViewer control, you can customize the message by implementing IReportViewerMessages. The specific property that will help you is ProgressText.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportviewermessages.aspx
|||Well, I tried to do this. I full copied sample but all the time I receive "The type MySample.CReportViewerCustomMessages does not implementIReportViewerMessages or could not be found".
When I try to use this class in other keys at web.config, everything is OK...|||Most likely the problem is that the class could not be found. Are you using the fully qualified name of the class, including the assembly and public key if necessary?|||Well, I tried... Is there any example of using this feature? It'll be very useful!|||There are some sample implementations on MSDN, though it sounds like your issue is with deployment, not implementation. Will you post the exact line you are adding to the web.config file? You should be able to take the config file value and pass it to Type.GetType() without errors. Your assembly should also be in the same location as the rest of your binaries or in the GAC.|||
how can i create assembly for web config,
my class name inherited from IReportMessages name is "newMessages" and its in app_code. my project has not namespace.
my project name is reportWeb.(reportWeb/app_code/newMessages class path)
|||You can set the value of the web.config entry to:
value="Namespace.Classname, APP_CODE"
If you have no namespace, then:
value="Classname, APP_CODE"
|||I solved, it was my fault.When I looked assamblies I have created two version, I was giving wrong version of assambly.I deleted that then I give the valid one to referance web.config It is worked.Thanks.
|||I'm getting the same error over and over, I try a lot of stuff but nothing takes me to the solution!
Can anyone give a complete walkthrought since the creation of a classe to the final web.config edit? Please!
Thanks!
|||first you should create class library project.
I create strong key with "sn -k <project path>".
my project name is prometus, and my class name msg which is inherited from IReportViewerMessages
"namespace Prometus
{
public class msg:IReportViewerMessages
{".
Then implement the Interface.
then in AssemblyInfo.cs give your strong named key path.(if your .snk file is not in your project path use full path sample: "c:\a.snk")
[assembly: AssemblyKeyFile("..\\..\\a.snk")]
then build your project.
you should load assembly to gac.
in command prompt use gacutil -i "your dllname".
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
then add the appsettings key like this
<!--<add key="ReportViewerMessages" value="Prometus.Msg, Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
|||
Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
|||Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
I forgot to tell one thing, I'm trying to translate the Report Manager of the Report Server Browser! I'm not creating a project that uses the report view component...
This quote was just to clarify this point...
Thanks again for your time!
Change "Report is being generated"
Hello,
When I try to use this class in other keys at web.config, everything is OK...|||Most likely the problem is that the class could not be found. Are you using the fully qualified name of the class, including the assembly and public key if necessary?|||Well, I tried... Is there any example of using this feature? It'll be very useful!|||There are some sample implementations on MSDN, though it sounds like your issue is with deployment, not implementation. Will you post the exact line you are adding to the web.config file? You should be able to take the config file value and pass it to Type.GetType() without errors. Your assembly should also be in the same location as the rest of your binaries or in the GAC.|||
I develop some application using SQL Server Reporting Services 2005 to Russian customers. They usually don't know English well. That's why I really want to change phrase "Report is being generated" to Russian words.
How can I do it? I tried to fing this phrase in configuration files or registry but there wasn't success.
Thank you,Hi,
If I change the language of the browser, the language of the "Report is being generated" changes. Not sure if you have already tried this. If you have, then I'm guessing the Server doesn't have Russian language capabilities. I tried in Russian and it didn't work.
Tommy
|||Well, I use Russian version of Internet Explorer and English version of SQL Server. There is no Russian SQL Server yet.
So, maybe there is any "low-level" feature to change this phrase?|||
If you are using the ReportViewer control, you can customize the message by implementing IReportViewerMessages. The specific property that will help you is ProgressText.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportviewermessages.aspx
|||Well, I tried to do this. I full copied sample but all the time I receive "The type MySample.CReportViewerCustomMessages does not implement IReportViewerMessages or could not be found".When I try to use this class in other keys at web.config, everything is OK...|||Most likely the problem is that the class could not be found. Are you using the fully qualified name of the class, including the assembly and public key if necessary?|||Well, I tried... Is there any example of using this feature? It'll be very useful!|||There are some sample implementations on MSDN, though it sounds like your issue is with deployment, not implementation. Will you post the exact line you are adding to the web.config file? You should be able to take the config file value and pass it to Type.GetType() without errors. Your assembly should also be in the same location as the rest of your binaries or in the GAC.|||
how can i create assembly for web config,
my class name inherited from IReportMessages name is "newMessages" and its in app_code. my project has not namespace.
my project name is reportWeb.(reportWeb/app_code/newMessages class path)
|||You can set the value of the web.config entry to:
value="Namespace.Classname, APP_CODE"
If you have no namespace, then:
value="Classname, APP_CODE"
|||I solved, it was my fault.When I looked assamblies I have created two version, I was giving wrong version of assambly.I deleted that then I give the valid one to referance web.config It is worked.Thanks.
|||I'm getting the same error over and over, I try a lot of stuff but nothing takes me to the solution!
Can anyone give a complete walkthrought since the creation of a classe to the final web.config edit? Please!
Thanks!
|||first you should create class library project.
I create strong key with "sn -k <project path>".
my project name is prometus, and my class name msg which is inherited from IReportViewerMessages
"namespace Prometus
{
public class msg:IReportViewerMessages
{".
Then implement the Interface.
then in AssemblyInfo.cs give your strong named key path.(if your .snk file is not in your project path use full path sample: "c:\a.snk")
[assembly: AssemblyKeyFile("..\\..\\a.snk")]
then build your project.
you should load assembly to gac.
in command prompt use gacutil -i "your dllname".
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
then add the appsettings key like this
<!--<add key="ReportViewerMessages" value="Prometus.Msg, Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
|||
Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
|||Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
I forgot to tell one thing, I'm trying to translate the Report Manager of the Report Server Browser! I'm not creating a project that uses the report view component...
This quote was just to clarify this point...
Thanks again for your time!
Friday, February 24, 2012
Centralized reports logging
We are using sql server 2000 reporting services. Management needs to know the
list of reports actually used, their frequency, and all the statistics along
with each one of them such as who, when, where, how long etc.
One way to that is to create a table in sql server and log all the facts
related to these attributes when the report(s) are launched at the front end
(asp.net) side. I am thinking out loud that SSRS must be logging this
information some where.
Is there any way to get to it? If yes, then how. I will google and look at
BOL to see if this could be done. In the mean time, any hints, pointers are
greatly appreciated.
Thank you in advance...RS has a series of reports that include packages you schedule (from SQL
Server). I haven't done this yet (I am doing it for RS 2005 but it uses
Integration Services instead of DTS).
RS 2000 steps
1.Reports you can download
2. Create table
3. Create DTS and schedule. This loads the table with info on usage
4. Run or schedule to run the management reports
You definitely do not need to roll you own with this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sqlster" <nospam@.nospam.com> wrote in message
news:9A9FF399-FF68-45D7-B60D-C1A1BF21242F@.microsoft.com...
> We are using sql server 2000 reporting services. Management needs to know
> the
> list of reports actually used, their frequency, and all the statistics
> along
> with each one of them such as who, when, where, how long etc.
> One way to that is to create a table in sql server and log all the facts
> related to these attributes when the report(s) are launched at the front
> end
> (asp.net) side. I am thinking out loud that SSRS must be logging this
> information some where.
> Is there any way to get to it? If yes, then how. I will google and look at
> BOL to see if this could be done. In the mean time, any hints, pointers
> are
> greatly appreciated.
> Thank you in advance...
list of reports actually used, their frequency, and all the statistics along
with each one of them such as who, when, where, how long etc.
One way to that is to create a table in sql server and log all the facts
related to these attributes when the report(s) are launched at the front end
(asp.net) side. I am thinking out loud that SSRS must be logging this
information some where.
Is there any way to get to it? If yes, then how. I will google and look at
BOL to see if this could be done. In the mean time, any hints, pointers are
greatly appreciated.
Thank you in advance...RS has a series of reports that include packages you schedule (from SQL
Server). I haven't done this yet (I am doing it for RS 2005 but it uses
Integration Services instead of DTS).
RS 2000 steps
1.Reports you can download
2. Create table
3. Create DTS and schedule. This loads the table with info on usage
4. Run or schedule to run the management reports
You definitely do not need to roll you own with this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sqlster" <nospam@.nospam.com> wrote in message
news:9A9FF399-FF68-45D7-B60D-C1A1BF21242F@.microsoft.com...
> We are using sql server 2000 reporting services. Management needs to know
> the
> list of reports actually used, their frequency, and all the statistics
> along
> with each one of them such as who, when, where, how long etc.
> One way to that is to create a table in sql server and log all the facts
> related to these attributes when the report(s) are launched at the front
> end
> (asp.net) side. I am thinking out loud that SSRS must be logging this
> information some where.
> Is there any way to get to it? If yes, then how. I will google and look at
> BOL to see if this could be done. In the mean time, any hints, pointers
> are
> greatly appreciated.
> Thank you in advance...
Cell Drillthrough in Reporting Services 2005
Hi,
I’ve build a report in reporting services 2005, based on a MOLAP cube (Analysis Services 2005). In the cube I’ve enabled drillthrough.
I know that we can define drillthrough in the report by clicking on one of the members of the dimension hierarchy, but that’s not what I want. I want to be able to drillthrough on a cell. Is there any way how to do that in Reporting Services 2005?
Thanks,
AbdelSSAS actions are not carried to SSRS reports. One workaround is to create a drillthrough report which gets the context from the master report and executes the DRILLTHROUGH MDX query.|||Hi Abdel ,
You have written U know how to define a drillthrough in the report by clicking on one of the members of the dimension hierarchy . can you please tell me how we will do that ?
I am trying to make a drillthrough report ,can you please give me a step by step process for enabling drill through in the reports .
I want to jump to a child report & pass the parameters of the parent report to the child report , I am able to get the parameters value in the child report ,but not able to use those values in the dataset query of the child report .
can you please tell me if this is possible or not ? & if yes how ?
Thanks
Rashmi
|||Please note the the original question was asking about a drillthrough action in the cube. If you just want the user to drilll through to another report, you can use the SSRS navigation feature. To do so, right-click on the textbox which will be use for drillthrough and choose Properties. Then go to the Navigation tab and use the Jump to Report feature. Note that that if the second report will retrieve data from the cube as well, you need to pass the parameters in the required format, e.g.; [Date].[Date].&[20070523]Cell Drillthrough in Reporting Services 2005
Hi,
I’ve build a report in reporting services 2005, based on a MOLAP cube (Analysis Services 2005). In the cube I’ve enabled drillthrough.
I know that we can define drillthrough in the report by clicking on one of the members of the dimension hierarchy, but that’s not what I want. I want to be able to drillthrough on a cell. Is there any way how to do that in Reporting Services 2005?
Thanks,
AbdelSSAS actions are not carried to SSRS reports. One workaround is to create a drillthrough report which gets the context from the master report and executes the DRILLTHROUGH MDX query.|||Hi Abdel ,
You have written U know how to define a drillthrough in the report by clicking on one of the members of the dimension hierarchy . can you please tell me how we will do that ?
I am trying to make a drillthrough report ,can you please give me a step by step process for enabling drill through in the reports .
I want to jump to a child report & pass the parameters of the parent report to the child report , I am able to get the parameters value in the child report ,but not able to use those values in the dataset query of the child report .
can you please tell me if this is possible or not ? & if yes how ?
Thanks
Rashmi
|||Please note the the original question was asking about a drillthrough action in the cube. If you just want the user to drilll through to another report, you can use the SSRS navigation feature. To do so, right-click on the textbox which will be use for drillthrough and choose Properties. Then go to the Navigation tab and use the Jump to Report feature. Note that that if the second report will retrieve data from the cube as well, you need to pass the parameters in the required format, e.g.; [Date].[Date].&[20070523]Sunday, February 19, 2012
CD-Key?
Have one Small Business Server Premium with 5 clients and im trying to install Reporting Services but it keep asking for the key, but there was no key with the program.
Im i supposed to use the key for SQL Server, or SBS?
Thanks in advance
Reporting Services is part of the SQL Server license. You should use a SQL Server product key.
Subscribe to:
Posts (Atom)