Help in Chosing the Software for Reporting Services

Hi All,

I have downloaded SQL Server 2005 Express Edition with Advanced Services SP2 from the following link

http://msdn.microsoft.com/vstudio/express/sql/download/

This I did after hearing Advanced Services provide Reporting Services tool with basic functionalities. After installion I am not able to find the SQL Server Business Intelligence Development Studio. Also there is no provision for installing the Reporting Services.

I already have Visual Studio Express installed.

Could someone tell me what else to download? Also it is asking for another software to be downloaded along with the existing one.

Regards

Karthik

In Visual Studio, when you try and create new projects, do you see a folder called "business intelligence"?|||

I am using Visual Web Developer 2005 Express Edition not Visual Studio. I don't have that option.

I was browsing through many other but couldn't understand clearly what is going wrong. Could you tell me the pre-requisites required for the installation?

|||http://www.microsoft.com/technet/prodtechnol/sql/2005/usingssrswithsqlexpress.mspx|||

Thanks for the link...

After lot of searching I figured out the option to install Reporting Services would not appear till IIS is installed. After doing this it is working fine now.

Could you please let me know if installation of SQL Server 2005 Express Edition with Advanced Services SP2 is possible in Vista Home Basic. Nowhere it is clearly explained if it can be done or not.

Help abt reporting services

Hi,
I have VS 2005 and SQL Server 2005 installed.How do i create reports
using Reporting Services '
I can't find any tab like " Reporting Services" under File | new |
project .
What should I do 'R wrote:
> Hi,
>
> I have VS 2005 and SQL Server 2005 installed.How do i create reports
> using Reporting Services '
> I can't find any tab like " Reporting Services" under File | new |
> project .
> What should I do '
In VS2005, Create an empty solution, then in this solution add a new
project.
Under project types you should see "Business Intelligence Projects"
under project types.
Select this, then you can select "Report Server Project"
You can then create your reports and data sources as required, and
deploy to your report server.|||Have you installed the client tools? If you installed SQL 2005 on your
computer that does not install the client tools. You have to run setup
separately for that.
If you installed the client tools prior to VS 2005 then you need to install
them again.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"R" <rashmi.bhandarkar@.gmail.com> wrote in message
news:1166503957.547110.245550@.73g2000cwn.googlegroups.com...
> Hi,
>
> I have VS 2005 and SQL Server 2005 installed.How do i create reports
> using Reporting Services '
> I can't find any tab like " Reporting Services" under File | new |
> project .
> What should I do '
>

Help : I Can't Re-installed RS !

I uninstalled Reporting Services SP1 from the development environment.
My Database is on a distant Server.
I want to re-install Reporting Service and I have this message when I select
my Report Server Database (the same as before the uninstal) : "The Report
Server Database is a different version and cannot be used for this
installation."
Can you help me ?First you need to install RS and point to an new DB. After the install
upgrade RS to SP1. Once this is done you will need to run RSConfig to point
to the old DB. If you saved off your Symmetric key you will want to reapply
it using rskeymgmt.exe. If you did not you will need to run
rskeymgmt.exe -d. Doing this will delete all the encrypted content, meaning
you will have to reenter all of your report credentials.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Karine" <Karine@.discussions.microsoft.com> wrote in message
news:074B3037-396E-45D3-B245-1E6798FA1ED1@.microsoft.com...
> I uninstalled Reporting Services SP1 from the development environment.
> My Database is on a distant Server.
> I want to re-install Reporting Service and I have this message when I
select
> my Report Server Database (the same as before the uninstal) : "The Report
> Server Database is a different version and cannot be used for this
> installation."
> Can you help me ?
>
>|||Karine,
I have a step-by-step document that you may find useful:
http://prologika.com/blog/archive/2004/08/20/161.aspx
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com : http://tinyurl.com/3l49j
Home page and blog: http://www.prologika.com/
----
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23ymuy74iEHA.1040@.TK2MSFTNGP09.phx.gbl...
> First you need to install RS and point to an new DB. After the install
> upgrade RS to SP1. Once this is done you will need to run RSConfig to
point
> to the old DB. If you saved off your Symmetric key you will want to
reapply
> it using rskeymgmt.exe. If you did not you will need to run
> rskeymgmt.exe -d. Doing this will delete all the encrypted content,
meaning
> you will have to reenter all of your report credentials.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Karine" <Karine@.discussions.microsoft.com> wrote in message
> news:074B3037-396E-45D3-B245-1E6798FA1ED1@.microsoft.com...
> > I uninstalled Reporting Services SP1 from the development environment.
> > My Database is on a distant Server.
> > I want to re-install Reporting Service and I have this message when I
> select
> > my Report Server Database (the same as before the uninstal) : "The
Report
> > Server Database is a different version and cannot be used for this
> > installation."
> >
> > Can you help me ?
> >
> >
> >
>|||Thanks.
I don't use your method because RS has allready uninstalled and so I can't
save my key.
I delete from my SQL Server the DataBase Report and the database
ReportserverTempDB. I run RS install, I select my SQL Server and I can
continu running the install.
I can deploy my reports so now ... all is good ...
"Teo Lachev" wrote:
> Karine,
> I have a step-by-step document that you may find useful:
> http://prologika.com/blog/archive/2004/08/20/161.aspx
> --
> Hope this helps.
> ----
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com : http://tinyurl.com/3l49j
> Home page and blog: http://www.prologika.com/
> ----
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:%23ymuy74iEHA.1040@.TK2MSFTNGP09.phx.gbl...
> > First you need to install RS and point to an new DB. After the install
> > upgrade RS to SP1. Once this is done you will need to run RSConfig to
> point
> > to the old DB. If you saved off your Symmetric key you will want to
> reapply
> > it using rskeymgmt.exe. If you did not you will need to run
> > rskeymgmt.exe -d. Doing this will delete all the encrypted content,
> meaning
> > you will have to reenter all of your report credentials.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Karine" <Karine@.discussions.microsoft.com> wrote in message
> > news:074B3037-396E-45D3-B245-1E6798FA1ED1@.microsoft.com...
> > > I uninstalled Reporting Services SP1 from the development environment.
> > > My Database is on a distant Server.
> > > I want to re-install Reporting Service and I have this message when I
> > select
> > > my Report Server Database (the same as before the uninstal) : "The
> Report
> > > Server Database is a different version and cannot be used for this
> > > installation."
> > >
> > > Can you help me ?
> > >
> > >
> > >
> >
> >
>
>

HELP !!!!

Hey,

I've installed the reporting services with the SQL EXPRESS 2005.

I've succeed to make some reports, and now i want to deploy them.

When i'm trying to run the reporting services configuration manger, i get the message "bad namespace". ican't connect in the instalation window to any machine that i'm trying to connect.

iI've tried to connect my computer, other computers with SQLEXPRESS and with SQL 2000, but i didn't succed.

How i should configure the report server ?

please, help !

Please HELP S.O.S !!!!

HELP ! How to Print Through Network Printer

Hello All,
I have Sample printer deliver extension provided with Reporting
Services. This code works well when i use Local printer, but i want to
use network printer, for that i changed config file as -
<Printer>\\199.63.103.253\NB1OACHP5100</Printer>
but Reporting Services shows error - The printer
\\199.63.103.253\NB1OACHP5100 is not currently installed on the server.
Can anybody help me how to solve this? Also can i print the report on
an trigger like in my application i use a button to print, and on click
this report get printed.
Please help me if you solved such problem or you know how to solve
this.
Thank You
Regards
RajAll printers you use from the server Must be defined to the server... This is
simply the control panel add printer stuff.
This is doc'd in books on line...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Raj" wrote:
> Hello All,
> I have Sample printer deliver extension provided with Reporting
> Services. This code works well when i use Local printer, but i want to
> use network printer, for that i changed config file as -
> <Printer>\\199.63.103.253\NB1OACHP5100</Printer>
> but Reporting Services shows error - The printer
> \\199.63.103.253\NB1OACHP5100 is not currently installed on the server.
>
> Can anybody help me how to solve this? Also can i print the report on
> an trigger like in my application i use a button to print, and on click
> this report get printed.
> Please help me if you solved such problem or you know how to solve
> this.
> Thank You
> Regards
> Raj
>|||Thanks for reply Wayne, but i already defined the printer to the
server. It is installed on my machine where server is installed. And
also do anybody know how to print report without preview on click
event?
Thanks & Regards
Raj|||We've been trying to auto-print without the preview or dialog box that pops
up, the only thing we have found is by doing a subscription...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Raj" wrote:
> Thanks for reply Wayne, but i already defined the printer to the
> server. It is installed on my machine where server is installed. And
> also do anybody know how to print report without preview on click
> event?
> Thanks & Regards
> Raj
>|||The printer delivery sample indicates that the server name/address must be
included in the configuration for a Networked printer. This does not appear
to be true. All that is necessary here is that the name be exactly the
same (exact case also) as what is defined in the Control Panel for the
computer
on which the Report Server is running.
"Raj" wrote:
> Hello All,
> I have Sample printer deliver extension provided with Reporting
> Services. This code works well when i use Local printer, but i want to
> use network printer, for that i changed config file as -
> <Printer>\\199.63.103.253\NB1OACHP5100</Printer>
> but Reporting Services shows error - The printer
> \\199.63.103.253\NB1OACHP5100 is not currently installed on the server.
>
> Can anybody help me how to solve this? Also can i print the report on
> an trigger like in my application i use a button to print, and on click
> this report get printed.
> Please help me if you solved such problem or you know how to solve
> this.
> Thank You
> Regards
> Raj
>

Help ! Error after (windows update) of .NET Framework

Hi all,
today i updated my .NET framework to 1.1 SP 1 (via windows update).
After than, my reporting services failed with the error key
"rsReportServerDisabled".
I have just a german full error message, but it is something with
"...decode symetric key ...". I use Win XP Professional as operating system.
Please apologize my english.
Thank your help in advance.
ThomasMost likely the ASP.NET account got reset. If you have the encryption key
saved, you can restore it using rskeymgmt. If not, you will need to reset
the encryption via rskeymgmt -d.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Thomas" <Thomas@.discussions.microsoft.com> wrote in message
news:D5EEE105-6F19-411C-A820-FBCE3940E699@.microsoft.com...
> Hi all,
> today i updated my .NET framework to 1.1 SP 1 (via windows update).
> After than, my reporting services failed with the error key
> "rsReportServerDisabled".
> I have just a german full error message, but it is something with
> "...decode symetric key ...". I use Win XP Professional as operating
> system.
> Please apologize my english.
> Thank your help in advance.
> Thomas
>
>|||I just tried it and you will probably also need to reconfigure the
connection string via rsconfig before you restore the encryption key.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:uCvrjDElEHA.3428@.TK2MSFTNGP14.phx.gbl...
> Most likely the ASP.NET account got reset. If you have the encryption key
> saved, you can restore it using rskeymgmt. If not, you will need to reset
> the encryption via rskeymgmt -d.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Thomas" <Thomas@.discussions.microsoft.com> wrote in message
> news:D5EEE105-6F19-411C-A820-FBCE3940E699@.microsoft.com...
>> Hi all,
>> today i updated my .NET framework to 1.1 SP 1 (via windows update).
>> After than, my reporting services failed with the error key
>> "rsReportServerDisabled".
>> I have just a german full error message, but it is something with
>> "...decode symetric key ...". I use Win XP Professional as operating
>> system.
>> Please apologize my english.
>> Thank your help in advance.
>> Thomas
>>
>>
>|||OK, one more correction. :) I was told by the developers that you won't need
to restore the encryption key. After resetting the connection string, you
just need to do an rsactivate -r -c and things will start working again.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:ePMQzNFlEHA.3452@.TK2MSFTNGP15.phx.gbl...
>I just tried it and you will probably also need to reconfigure the
>connection string via rsconfig before you restore the encryption key.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:uCvrjDElEHA.3428@.TK2MSFTNGP14.phx.gbl...
>> Most likely the ASP.NET account got reset. If you have the encryption key
>> saved, you can restore it using rskeymgmt. If not, you will need to reset
>> the encryption via rskeymgmt -d.
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Thomas" <Thomas@.discussions.microsoft.com> wrote in message
>> news:D5EEE105-6F19-411C-A820-FBCE3940E699@.microsoft.com...
>> Hi all,
>> today i updated my .NET framework to 1.1 SP 1 (via windows update).
>> After than, my reporting services failed with the error key
>> "rsReportServerDisabled".
>> I have just a german full error message, but it is something with
>> "...decode symetric key ...". I use Win XP Professional as operating
>> system.
>> Please apologize my english.
>> Thank your help in advance.
>> Thomas
>>
>>
>>
>|||Thank you Brian !
I will try it at once...
Best regards from Germany
Thomas
"Brian Welcker [MSFT]" wrote:
> OK, one more correction. :) I was told by the developers that you won't need
> to restore the encryption key. After resetting the connection string, you
> just need to do an rsactivate -r -c and things will start working again.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:ePMQzNFlEHA.3452@.TK2MSFTNGP15.phx.gbl...
> >I just tried it and you will probably also need to reconfigure the
> >connection string via rsconfig before you restore the encryption key.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:uCvrjDElEHA.3428@.TK2MSFTNGP14.phx.gbl...
> >> Most likely the ASP.NET account got reset. If you have the encryption key
> >> saved, you can restore it using rskeymgmt. If not, you will need to reset
> >> the encryption via rskeymgmt -d.
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "Thomas" <Thomas@.discussions.microsoft.com> wrote in message
> >> news:D5EEE105-6F19-411C-A820-FBCE3940E699@.microsoft.com...
> >> Hi all,
> >> today i updated my .NET framework to 1.1 SP 1 (via windows update).
> >> After than, my reporting services failed with the error key
> >> "rsReportServerDisabled".
> >> I have just a german full error message, but it is something with
> >> "...decode symetric key ...". I use Win XP Professional as operating
> >> system.
> >> Please apologize my english.
> >>
> >> Thank your help in advance.
> >> Thomas
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
>
>

Help - Schema provided by Microsoft NOT ONLINE anymore

Hi
we are currently using a schema referring to
http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservice
for System.Web.Services.Protocol.SoapDocumentMethodAtrribute an
referring to
http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/creat
for Subscription.RequestNamespace from Reference.cs whil
programmatically creating a subscription
However, when we check for either of these URLs, they are no
available on Microsoft's site anymore. Can anyone possibly provid
some information on how to get to these schema files? :?
Many thanks in advance
MichaeWe have the same problem for these references:
System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/Cancel"& _
"Job",
RequestNamespace:="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices",
ResponseNamespace:="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices",
Use:=System.Web.Services.Description.SoapBindingUse.Literal,
ParameterStyle:=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)> _
This is from the system provided:
Public Function CancelJob(ByVal JobID As String) As Boolean
We are having the same problem with the Web References for function
ListJobs()
Have you had any luck with this?
"mhamach" wrote:
> Hi,
> we are currently using a schema referring to
> http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices
> for System.Web.Services.Protocol.SoapDocumentMethodAtrribute and
> referring to
> http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/create
>
> for Subscription.RequestNamespace from Reference.cs while
> programmatically creating a subscription.
> However, when we check for either of these URLs, they are not
> available on Microsoft's site anymore. Can anyone possibly provide
> some information on how to get to these schema files? :?
> Many thanks in advance!
> Michael
>|||I'm also experiencing the same problem.
Has anybody found a sollution to this?
"mhamach" wrote:
> Hi,
> we are currently using a schema referring to
> http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices
> for System.Web.Services.Protocol.SoapDocumentMethodAtrribute and
> referring to
> http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/create
>
> for Subscription.RequestNamespace from Reference.cs while
> programmatically creating a subscription.
> However, when we check for either of these URLs, they are not
> available on Microsoft's site anymore. Can anyone possibly provide
> some information on how to get to these schema files? :?
> Many thanks in advance!
> Michael
>|||Is there anything at http://schemas.microsoft.com/sqlserver/ that helps
you?|||I could'nt find anything at http://schemas.microsoft.com/sqlserver/.
Is there any other way of rendering reports, other than using Reporting
Service.vb
"timseal" wrote:
> Is there anything at http://schemas.microsoft.com/sqlserver/ that helps
> you?
>

Help - not a valid MIMEType

I am trying to use an image with a "Web" source, the url points to an
aspx page on the same machine as the reporting server, this page
returns a jpeg image (a chart) created by some C# code. On the
"Layout" tab of VS.NET the image is displayed but when I switch to the
"Preview" tab I just get the dreaded Red X.
The following warnings are written to the Output window.
Images with external URL references will not display if the report is
published to a report server without an UnattendedExecutionAccount or
the target image(s) are not enabled for anonymous access.
The value of the MIMEType property for the image ?image1' is
"image/jpeg; charset=utf-8", which is not a valid MIMEType.
I have configured the UnattendedExecuionAccount (rsconfig -e...) and
the page which returns the image allows anonymous access but it
doesn't seem to make any difference. What I don't understand is the
message about the invalid MIMEType, the code which returns the image
sets the ContentType="image/jpeg".
Any help much appreciated.Make sure you are using RS SP1
"Mark" <mark.huston@.invensys.com> wrote in message
news:24909f78.0410130833.6ffb3518@.posting.google.com...
> I am trying to use an image with a "Web" source, the url points to an
> aspx page on the same machine as the reporting server, this page
> returns a jpeg image (a chart) created by some C# code. On the
> "Layout" tab of VS.NET the image is displayed but when I switch to the
> "Preview" tab I just get the dreaded Red X.
> The following warnings are written to the Output window.
> Images with external URL references will not display if the report is
> published to a report server without an UnattendedExecutionAccount or
> the target image(s) are not enabled for anonymous access.
> The value of the MIMEType property for the image 'image1' is
> "image/jpeg; charset=utf-8", which is not a valid MIMEType.
> I have configured the UnattendedExecuionAccount (rsconfig -e...) and
> the page which returns the image allows anonymous access but it
> doesn't seem to make any difference. What I don't understand is the
> message about the invalid MIMEType, the code which returns the image
> sets the ContentType="image/jpeg".
> Any help much appreciated.|||Jeff,
I have SP1 installed (did it again to make sure!). The problem does
not occur when displaying external images that come from a file, but
only when they are returned from code (in an aspx.cs module). I am
beginning to think it could be some kind of security/permission
problem, but I don't know where to look for more info on this. for
example the following url will work
http://10.34.3.76/Trending/myImage.jpg
but this one doesn't
http://10.34.3.76/Trending/getImage.aspx
Any ideas ?
"Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message news:<#z26bNUsEHA.2780@.TK2MSFTNGP09.phx.gbl>...
> Make sure you are using RS SP1
> "Mark" <mark.huston@.invensys.com> wrote in message
> news:24909f78.0410130833.6ffb3518@.posting.google.com...
> > I am trying to use an image with a "Web" source, the url points to an
> > aspx page on the same machine as the reporting server, this page
> > returns a jpeg image (a chart) created by some C# code. On the
> > "Layout" tab of VS.NET the image is displayed but when I switch to the
> > "Preview" tab I just get the dreaded Red X.
> > The following warnings are written to the Output window.
> >
> > Images with external URL references will not display if the report is
> > published to a report server without an UnattendedExecutionAccount or
> > the target image(s) are not enabled for anonymous access.
> > The value of the MIMEType property for the image 'image1' is
> > "image/jpeg; charset=utf-8", which is not a valid MIMEType.
> >
> > I have configured the UnattendedExecuionAccount (rsconfig -e...) and
> > the page which returns the image allows anonymous access but it
> > doesn't seem to make any difference. What I don't understand is the
> > message about the invalid MIMEType, the code which returns the image
> > sets the ContentType="image/jpeg".
> >
> > Any help much appreciated.|||Always as a quick test, add the ASPNET account to the admin group (perhaps
IUSR and IWAM too).
Jeff
"Mark" <mark.huston@.invensys.com> wrote in message
news:24909f78.0410132301.5b201e32@.posting.google.com...
> Jeff,
> I have SP1 installed (did it again to make sure!). The problem does
> not occur when displaying external images that come from a file, but
> only when they are returned from code (in an aspx.cs module). I am
> beginning to think it could be some kind of security/permission
> problem, but I don't know where to look for more info on this. for
> example the following url will work
> http://10.34.3.76/Trending/myImage.jpg
> but this one doesn't
> http://10.34.3.76/Trending/getImage.aspx
> Any ideas ?
> "Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
news:<#z26bNUsEHA.2780@.TK2MSFTNGP09.phx.gbl>...
> > Make sure you are using RS SP1
> >
> > "Mark" <mark.huston@.invensys.com> wrote in message
> > news:24909f78.0410130833.6ffb3518@.posting.google.com...
> > > I am trying to use an image with a "Web" source, the url points to an
> > > aspx page on the same machine as the reporting server, this page
> > > returns a jpeg image (a chart) created by some C# code. On the
> > > "Layout" tab of VS.NET the image is displayed but when I switch to the
> > > "Preview" tab I just get the dreaded Red X.
> > > The following warnings are written to the Output window.
> > >
> > > Images with external URL references will not display if the report is
> > > published to a report server without an UnattendedExecutionAccount or
> > > the target image(s) are not enabled for anonymous access.
> > > The value of the MIMEType property for the image 'image1' is
> > > "image/jpeg; charset=utf-8", which is not a valid MIMEType.
> > >
> > > I have configured the UnattendedExecuionAccount (rsconfig -e...) and
> > > the page which returns the image allows anonymous access but it
> > > doesn't seem to make any difference. What I don't understand is the
> > > message about the invalid MIMEType, the code which returns the image
> > > sets the ContentType="image/jpeg".
> > >
> > > Any help much appreciated.|||I am having the same problem. I am trying to display a dynamically generated
chart via an aspx web page to perform advanced charting that RS charting can
not do. If I can not get this to work, I do not know how I will be able to
generate the charts that I need within the report. Just as Mark gets, I get
the MIME type error in the preview, a red X when viewed through RS, but the
designer show the image. I have setup Unattended Execution and that made a
slight difference in that the image dimensions were set, but no image.
Please help, I am at wits end.
"Mark" wrote:
> I am trying to use an image with a "Web" source, the url points to an
> aspx page on the same machine as the reporting server, this page
> returns a jpeg image (a chart) created by some C# code. On the
> "Layout" tab of VS.NET the image is displayed but when I switch to the
> "Preview" tab I just get the dreaded Red X.
> The following warnings are written to the Output window.
> Images with external URL references will not display if the report is
> published to a report server without an UnattendedExecutionAccount or
> the target image(s) are not enabled for anonymous access.
> The value of the MIMEType property for the image â'image1' is
> "image/jpeg; charset=utf-8", which is not a valid MIMEType.
> I have configured the UnattendedExecuionAccount (rsconfig -e...) and
> the page which returns the image allows anonymous access but it
> doesn't seem to make any difference. What I don't understand is the
> message about the invalid MIMEType, the code which returns the image
> sets the ContentType="image/jpeg".
> Any help much appreciated.
>|||I began to get this error right after I installed "Office 2003 Pro".
Do you use MS Office 2003?
"Mark" wrote:
> I am trying to use an image with a "Web" source, the url points to an
> aspx page on the same machine as the reporting server, this page
> returns a jpeg image (a chart) created by some C# code. On the
> "Layout" tab of VS.NET the image is displayed but when I switch to the
> "Preview" tab I just get the dreaded Red X.
> The following warnings are written to the Output window.
> Images with external URL references will not display if the report is
> published to a report server without an UnattendedExecutionAccount or
> the target image(s) are not enabled for anonymous access.
> The value of the MIMEType property for the image â'image1' is
> "image/jpeg; charset=utf-8", which is not a valid MIMEType.
> I have configured the UnattendedExecuionAccount (rsconfig -e...) and
> the page which returns the image allows anonymous access but it
> doesn't seem to make any difference. What I don't understand is the
> message about the invalid MIMEType, the code which returns the image
> sets the ContentType="image/jpeg".
> Any help much appreciated.
>|||We had the exact same problem, images rendered from an aspx file would
show up in the designer but not the preview or the full report (with
SP1)
I noticed the error said the invalid mime type was "image/jpeg;
charset=utf-8" or similar
So on the aspx file that returned the jpeg, right below
response.contenttype="image/jpeg"
I added:
response.charset=""
and now the images appear on the report! Looks like reporting services
isn't parsing the HTTP headers correctly...
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message news:<57AC3785-F8DF-4094-A90A-85E6E0917CD6@.microsoft.com>...
> I began to get this error right after I installed "Office 2003 Pro".
> Do you use MS Office 2003?
> "Mark" wrote:
> > I am trying to use an image with a "Web" source, the url points to an
> > aspx page on the same machine as the reporting server, this page
> > returns a jpeg image (a chart) created by some C# code. On the
> > "Layout" tab of VS.NET the image is displayed but when I switch to the
> > "Preview" tab I just get the dreaded Red X.
> > The following warnings are written to the Output window.
> >
> > Images with external URL references will not display if the report is
> > published to a report server without an UnattendedExecutionAccount or
> > the target image(s) are not enabled for anonymous access.
> > The value of the MIMEType property for the image �image1' is
> > "image/jpeg; charset=utf-8", which is not a valid MIMEType.
> >
> > I have configured the UnattendedExecuionAccount (rsconfig -e...) and
> > the page which returns the image allows anonymous access but it
> > doesn't seem to make any difference. What I don't understand is the
> > message about the invalid MIMEType, the code which returns the image
> > sets the ContentType="image/jpeg".
> >
> > Any help much appreciated.
> >

HELP - Designing a Subscripion System for a Group of Reports

We're developing an ASP.NET 2.0 (C#) application that will act as a
front-end to SQL Server 2005 Reporting Services. We have an interesting
requirement that [we believe] can't be solved using RS out-of-the-box. So,
I'm writing today to get some ideas on possible solutions.
The requirement is that the app. needs to support, what we're calling, a
report group. A report group is simply a group of similar reports that can
be executed as a single unit (instead of having to execute each report
individually). This was not too bad to solve. We simply created our own
database tables that track which report group contains which reports.
The tricky part is that we now have to figure out a way to create a
subscription that executes the report group (thereby executing each
individual report in the report group automatically). Creating a
subscription for a single report is fairly straightforward, but it appears
this concept of a report group is not a part of RS.
Does anyone out there have any good ideas/suggestions on how we can
implement such functionality?
The best thought we have so far is to write another application that manages
the execution of each report in a report group. So, the SQL Server 2005 job
would call this additional little application, this additional app. would
lookup which reports are in the report group, and then it would loop through
all the reports and execute them one-by-one. But, this has some issues-like
how do we handle the output type (PDF, Excel, etc.) and how do we handle the
destination (e-mail, printer, etc.) of each report. Plus, it seems like we
would be somewhat reinventing the wheel as far as subscriptions go.
Thanks.Why aren't you using one master report with all the other reports as
sub-reports?
Tom Bizannes
oiduts wrote:
> We're developing an ASP.NET 2.0 (C#) application that will act as a
> front-end to SQL Server 2005 Reporting Services. We have an interesting
> requirement that [we believe] can't be solved using RS out-of-the-box. So,
> I'm writing today to get some ideas on possible solutions.
> The requirement is that the app. needs to support, what we're calling, a
> report group. A report group is simply a group of similar reports that can
> be executed as a single unit (instead of having to execute each report
> individually). This was not too bad to solve. We simply created our own
> database tables that track which report group contains which reports.
> The tricky part is that we now have to figure out a way to create a
> subscription that executes the report group (thereby executing each
> individual report in the report group automatically). Creating a
> subscription for a single report is fairly straightforward, but it appears
> this concept of a report group is not a part of RS.
> Does anyone out there have any good ideas/suggestions on how we can
> implement such functionality?
> The best thought we have so far is to write another application that manages
> the execution of each report in a report group. So, the SQL Server 2005 job
> would call this additional little application, this additional app. would
> lookup which reports are in the report group, and then it would loop through
> all the reports and execute them one-by-one. But, this has some issues-like
> how do we handle the output type (PDF, Excel, etc.) and how do we handle the
> destination (e-mail, printer, etc.) of each report. Plus, it seems like we
> would be somewhat reinventing the wheel as far as subscriptions go.
> Thanks.|||You could try setting up a shared schedule. It would still require
individual subscriptions for each report but they would all start
firing at the same scheduled time.

Help - Complex Currency Conversion - MDX

Dear all,

I have implemented Conversion conversion in my SSAS cube (One - Many) and is working fine. (Reporting Currency dimension that has currencies to which data can be converted, Fx rates measure group that has FX rates for those currencies from base currency (GBP) and calculation to convert it) The calculation I use is as below

Code Snippet

Scope ( {Measures.[YTD Value Reporting CCY], Measures.[LTD Value Reporting CCY]});

Scope (Leaves ([Calendar]), Except([Reporting Currency].[Reporting Currency].[Reporting Currency].Members , [Reporting Currency].[Reporting Currency].&[GBP]));

Scope ( {Measures.[YTD Value Reporting CCY], Measures.[LTD Value Reporting CCY]});

This = [Reporting Currency].[Reporting Currency].[GBP] *

( Measures.[Rate],

[Reporting Currency].[Reporting Currency].CurrentMember

);

End Scope;

End Scope;

End Scope;

Now I have a situation in which the FX rates can be different for each record in the fact table. So I have introducted the FX Rate Set ID dimension (degenerate dimension for the rate measure group) and also have it as a measure (non-additive, visible=false) for the Balance measure group that contain the data to be converted. Now, how do I acheive the actual conversion by modifying the above MDX?

Something similar to the below is what I'm trying to acheive but no idea how to get it right in MDX. Please help in the correct approach and the right MDX.

Code Snippet

This = [Reporting Currency].[Reporting Currency].[GBP] *

( Measures.[Rate],

[Reporting Currency].[Reporting Currency].CurrentMember,

[FX Rate Set].[Set ID].[<<'Value of Measures.[Rate Set ID]'>>]

);

Thanks in advance.

Cheers,

Arun

Pl can anyone help me on this?

|||Could you explain this statement with an example: "I have a situation in which the FX rates can be different for each record in the fact table"? Are you referring to the Balance or the FX Rate fact table - and does this mean that FX rates may vary on the same day?|||

Below is the sample data

Fx Rates : (the pivot currency is GBP)

Date RateSet ToCurrency Rate

03 May 2007 1 AUD 2.54

03 May 2007 2 AUD 2.51

03 May 2007 1 GBP 1

03 May 2007 2 GBP 1

03 May 2007 1 EUR 1.51

03 May 2007 2 EUR 1.6

Fact Table:

ID Date <<Other dimension keys>>> Currency Balance BalanceInGBP FXRateSet

101 03 May 2007 USD 100 195 1

102 03 May 2007 USD 100 194 2

Measure Group:

Balance MG:

Balance (FactTable.Balance)

BalanceReportingCurrency (FactTable.BalanceInGBP)

Rates:

Rate ([Fx Rates].Rate)

Calculation :

In my first post... (the column names may be bit different.)

In the above scenario, the for the same date, I may have to use different "Fx rate Set" whose ID is present in both Fact table and Fx rates table. I have a dimension called Currency that joins with the Currency column in fact table. I also have another dimension called [Reporting Hierarchy] that will hold the ToCurrency in Fx Rates and based on which the conversion will be done dynamically using calculations (The BalanceReportingCurrency measure will be calcualted dynamically using corresponding rates).

|||Forgot to mention - I have the FXRateSetID from the fact table as a measure in the balance MG as it may help in doing the calculation|||One idea is to slightly change the original solution by creating a new dimension like DailyRateSet, whose key attribute is a collection of the 2 fields: Date, RateSetID. This dimension would be used as the intermediate dimension, instead of Calendar. Another approach would be with a separate RateSet dimension, but I haven't been able to work that out yet.|||

Finally got it working. I'm having the Rate Set as another dimension referred by both fact table and the Fx rates table, then whilst doing the calculation, I perform the calc at leaf levels of both Fx rate set and Time - and using the fx rate set dimension for getting the correct rate.

At present, I convert all values to GBP when laoding to my cube. To make the data independent of rate change problems, now I'm trying to work out many-to many currency conversion.

Help - Complex Currency Conversion - MDX

Dear all,

I have implemented Conversion conversion in my SSAS cube (One - Many) and is working fine. (Reporting Currency dimension that has currencies to which data can be converted, Fx rates measure group that has FX rates for those currencies from base currency (GBP) and calculation to convert it) The calculation I use is as below

Code Snippet

Scope ( {Measures.[YTD Value Reporting CCY], Measures.[LTD Value Reporting CCY]});

Scope (Leaves ([Calendar]), Except([Reporting Currency].[Reporting Currency].[Reporting Currency].Members , [Reporting Currency].[Reporting Currency].&[GBP]));

Scope ( {Measures.[YTD Value Reporting CCY], Measures.[LTD Value Reporting CCY]});

This = [Reporting Currency].[Reporting Currency].[GBP] *

( Measures.[Rate],

[Reporting Currency].[Reporting Currency].CurrentMember

);

End Scope;

End Scope;

End Scope;

Now I have a situation in which the FX rates can be different for each record in the fact table. So I have introducted the FX Rate Set ID dimension (degenerate dimension for the rate measure group) and also have it as a measure (non-additive, visible=false) for the Balance measure group that contain the data to be converted. Now, how do I acheive the actual conversion by modifying the above MDX?

Something similar to the below is what I'm trying to acheive but no idea how to get it right in MDX. Please help in the correct approach and the right MDX.

Code Snippet

This = [Reporting Currency].[Reporting Currency].[GBP] *

( Measures.[Rate],

[Reporting Currency].[Reporting Currency].CurrentMember,

[FX Rate Set].[Set ID].[<<'Value of Measures.[Rate Set ID]'>>]

);

Thanks in advance.

Cheers,

Arun

Pl can anyone help me on this?

|||Could you explain this statement with an example: "I have a situation in which the FX rates can be different for each record in the fact table"? Are you referring to the Balance or the FX Rate fact table - and does this mean that FX rates may vary on the same day?|||

Below is the sample data

Fx Rates : (the pivot currency is GBP)

Date RateSet ToCurrency Rate

03 May 2007 1 AUD 2.54

03 May 2007 2 AUD 2.51

03 May 2007 1 GBP 1

03 May 2007 2 GBP 1

03 May 2007 1 EUR 1.51

03 May 2007 2 EUR 1.6

Fact Table:

ID Date <<Other dimension keys>>> Currency Balance BalanceInGBP FXRateSet

101 03 May 2007 USD 100 195 1

102 03 May 2007 USD 100 194 2

Measure Group:

Balance MG:

Balance (FactTable.Balance)

BalanceReportingCurrency (FactTable.BalanceInGBP)

Rates:

Rate ([Fx Rates].Rate)

Calculation :

In my first post... (the column names may be bit different.)

In the above scenario, the for the same date, I may have to use different "Fx rate Set" whose ID is present in both Fact table and Fx rates table. I have a dimension called Currency that joins with the Currency column in fact table. I also have another dimension called [Reporting Hierarchy] that will hold the ToCurrency in Fx Rates and based on which the conversion will be done dynamically using calculations (The BalanceReportingCurrency measure will be calcualted dynamically using corresponding rates).

|||Forgot to mention - I have the FXRateSetID from the fact table as a measure in the balance MG as it may help in doing the calculation|||One idea is to slightly change the original solution by creating a new dimension like DailyRateSet, whose key attribute is a collection of the 2 fields: Date, RateSetID. This dimension would be used as the intermediate dimension, instead of Calendar. Another approach would be with a separate RateSet dimension, but I haven't been able to work that out yet.|||

Finally got it working. I'm having the Rate Set as another dimension referred by both fact table and the Fx rates table, then whilst doing the calculation, I perform the calc at leaf levels of both Fx rate set and Time - and using the fx rate set dimension for getting the correct rate.

At present, I convert all values to GBP when laoding to my cube. To make the data independent of rate change problems, now I'm trying to work out many-to many currency conversion.