BUILTIN\Administrators not recognized - rsUnknownUserName

Hello all,

We recently moved our Team Foundation Server from one server to another, of course the reporting services was also included in that move.

On the new server, we are not able to change Reporting Services security parameters anymore, we get this error :
User or group ? BUILTIN\Administrators not recognized. (rsUnknownUserName)

The old server was an english windows 2003, the new one a french version, i guess the problem is related. The BUILTIN\Administrators group name on the new server is "BUILTIN\Administrateurs".

Is there a way to change security params without getting this error ? How can we remove from Reporting Services this reference to BUILDTIN\Administrators ? I've tried to modify the table Users directly in ReportServer DB without any success..

Please help !
Alexandre

Ok I was finally able to solve the problem ! I connected to my Reporting Services server using SQL Server Management Studio and not Reporting Services administration website. In the root folder permissions, I removed the reference to BUILTIN\Administrators and added the one to BUILTIN\Administrateurs, and it worked !

Alexandre

Built in report tool returns dollar symbol not pound symbol.

I can't be the only one to of noticed this but my local setting are all set to United Kingdom, but when using the in built reporting tool I always get dollar symbols.
The command I used to format the text box was the formatcurrency() express which states it will format the text in accordance with the settings in control panel. The only thing I can think of is that it is either using a system default setting (were on a domain with roaming profiles) or it uses the language as set on the SQL server (which I haven't checked yet).

Anyone else noticed this odd behavior or know where you type the expression pattern to make a custom currency format for UK?

I use a custom format entered in the Format code: box

￡#,##0.00

|||Yeah thats, the method I used in the end. Shame the formatcurrency() function doesn't do what it should out of the box.
Thank you. |||

Yep, I'd be interested to know why we can't default to local currency settings as with say Office programs...

Let me know if you find out :)

|||Yes, would be useful. I might google once I have some spare time. Just hope one of the developers of that section who might know passes over this.|||

You may want to read this: http://msdn2.microsoft.com/en-us/library/ms156493.aspx

The Report has a Language property which could be set to a static value, such as en-UK. Or you could set it to the current user's language by using an expression: =User!Language. Note: you can also override the report's language on individual textboxes by explicitly setting the textbox.Language property.

-- Robert

|||I can confirm that setting the language of the report does in fact fix the local symbol's. I never noticed this property as it is tucked away. To get to it you have to select it from the drop down menu in properties ( http://www.devstuff.eu/images/stories/msdn/ReportSelecter.JPG ). Then you can set report wide settings.

Interesting points about this :
Text boxes local settings does not override form default.|||Thanks guys.

Building reports ?

The databases I have in the SQL Server 2000 and i need to use
reporting services in the SQL Server 2005. If i am in SQL Server 2005 and i
want to just have connection to my databases in 2000 without restoring
the db's in the 2005. Can i build the reports using SSRS 2005? If yes
then what steps do i need to know to start building RS reports besides
connecting to SR2000 db?
Thanks.On Jun 20, 12:55 pm, GGill <G...@.discussions.microsoft.com> wrote:
> The databases I have in the SQL Server 2000 and i need to use
> reporting services in the SQL Server 2005. If i am in SQL Server 2005 and i
> want to just have connection to my databases in 2000 without restoring
> the db's in the 2005. Can i build the reports using SSRS 2005? If yes
> then what steps do i need to know to start building RS reports besides
> connecting to SR2000 db?
> Thanks.
When you make the reports, link them to the SQL Server 2000 server.
I've never had any problem pulling data from the older servers. You
would add the connection string the same way you would with the 2005
version. You can even make shared datasources. I just tested it, yep
it works. Just make a shared datasource and use that for all your
reports. It will link to the specified server/database as needed.
Hope that helps.|||Thank you.
"Ayman" wrote:
> On Jun 20, 12:55 pm, GGill <G...@.discussions.microsoft.com> wrote:
> > The databases I have in the SQL Server 2000 and i need to use
> > reporting services in the SQL Server 2005. If i am in SQL Server 2005 and i
> > want to just have connection to my databases in 2000 without restoring
> > the db's in the 2005. Can i build the reports using SSRS 2005? If yes
> > then what steps do i need to know to start building RS reports besides
> > connecting to SR2000 db?
> >
> > Thanks.
> When you make the reports, link them to the SQL Server 2000 server.
> I've never had any problem pulling data from the older servers. You
> would add the connection string the same way you would with the 2005
> version. You can even make shared datasources. I just tested it, yep
> it works. Just make a shared datasource and use that for all your
> reports. It will link to the specified server/database as needed.
> Hope that helps.
>|||When i linked from SSRS2005 to SS2000 .
Should i go first to the Reporting Services Configuration? If yes then
when i go to Reporting Services Configuration it is asking me to select from
drop-down box instance name but my instance name is disabled. How can i
enable that?
If i do not need to do that then after conecting to server should i just
start creating project and designing the new reports from Visual Studio 2005?
"GGill" wrote:
> Thank you.
> "Ayman" wrote:
> > On Jun 20, 12:55 pm, GGill <G...@.discussions.microsoft.com> wrote:
> > > The databases I have in the SQL Server 2000 and i need to use
> > > reporting services in the SQL Server 2005. If i am in SQL Server 2005 and i
> > > want to just have connection to my databases in 2000 without restoring
> > > the db's in the 2005. Can i build the reports using SSRS 2005? If yes
> > > then what steps do i need to know to start building RS reports besides
> > > connecting to SR2000 db?
> > >
> > > Thanks.
> >
> > When you make the reports, link them to the SQL Server 2000 server.
> > I've never had any problem pulling data from the older servers. You
> > would add the connection string the same way you would with the 2005
> > version. You can even make shared datasources. I just tested it, yep
> > it works. Just make a shared datasource and use that for all your
> > reports. It will link to the specified server/database as needed.
> > Hope that helps.
> >
> >

Building my own Query Designer

I have created a Custom Data Extention to query SharePoint List data directly
from within Reporting Services. I would like to replace the Generic Query
designer with my own code to make selecting columns or adding selection
critera an easier and more friendly process and can see that Microsoft have
built query designers for SAP etc.. so it would appear possible'
I have been unable to find any documentation on developing Query designers
but I am hoping that someone can help me?
Thanks
JasonHello Jason,
You need to create a Visual Studio 2005 Add-on to add your own Query
designer.
There are some sample projects in the Vistual Studio 2005 SDK.
http://www.microsoft.com/downloads/details.aspx?familyid=51a5c65b-c020-4e08-
8ac0-3eb9c06996f4&displaylang=en
And you may refer this web site:
http://msdn2.microsoft.com/en-us/vstudio/aa700819.aspx
Also, this article may be helpful for you to understand the Visual Studio
Add-in
http://www.codeproject.com/csharp/LineCounterAddin.asp
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hmmm..I didn't know it was a VS2005 Addin... I've built a few addins for
VS2005 before...I'll take a look.. :)
Thanks!!! :)
"Wei Lu [MSFT]" wrote:
> Hello Jason,
> You need to create a Visual Studio 2005 Add-on to add your own Query
> designer.
> There are some sample projects in the Vistual Studio 2005 SDK.
> http://www.microsoft.com/downloads/details.aspx?familyid=51a5c65b-c020-4e08-
> 8ac0-3eb9c06996f4&displaylang=en
> And you may refer this web site:
> http://msdn2.microsoft.com/en-us/vstudio/aa700819.aspx
> Also, this article may be helpful for you to understand the Visual Studio
> Add-in
> http://www.codeproject.com/csharp/LineCounterAddin.asp
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Wei Lu,
I'm actually at the .Net Roadshow in Boston this week so I have not had a
chance to get into the code.
While I know how to build VS2005 addins, is there a defined interface for
building Query designers? I se how to launch the designer in the
RSReportDesigner.config but I'm wondering if there is any documentation on
the interface I would need to implement just like I had to when building the
Sharepoint Data Extension.
I can see designers like:
Microsoft.ReportingServices.QueryDesigners
Microsoft.ReportingServices.QueryDesigners.Essbase
Microsoft.ReportingServices.QueryDesigners.SapBw
Now I'd like to "implement" my own...Any help on the interface I need to
build to make it work would be gratefully appreciated..
Thanks
Jason
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Jason,
Well, that will be some difficult if you want the Visual Studio load your
custom designer and embedded it into the project.
My suggestion is that you only use the addin to make you could generate the
query to query the datasource and add it to the querytext in the xml.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||If you got this working I would like to test it for you...
"Jason" wrote:
> Wei Lu,
> I'm actually at the .Net Roadshow in Boston this week so I have not had a
> chance to get into the code.
> While I know how to build VS2005 addins, is there a defined interface for
> building Query designers? I se how to launch the designer in the
> RSReportDesigner.config but I'm wondering if there is any documentation on
> the interface I would need to implement just like I had to when building the
> Sharepoint Data Extension.
> I can see designers like:
> Microsoft.ReportingServices.QueryDesigners
> Microsoft.ReportingServices.QueryDesigners.Essbase
> Microsoft.ReportingServices.QueryDesigners.SapBw
> Now I'd like to "implement" my own...Any help on the interface I need to
> build to make it work would be gratefully appreciated..
> Thanks
> Jason
>
> "Wei Lu [MSFT]" wrote:
> > Hi ,
> >
> > How is everything going? Please feel free to let me know if you need any
> > assistance.
> >
> > Sincerely,
> >
> > Wei Lu
> > Microsoft Online Community Support
> >
> > ==================================================> >
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> >
> > ==================================================> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >

Building custom Reporting Services Toolbar

We have an ASP.Net web app that uses RS for reporting. We can't use the RS
toolbar since we will be generating reports using the SOAP API. Does
anybody have any ideas/suggestions/examples on building a custom toolbar for
RS? Any input will be greatly appreciated. TIA.You just need to create a user control that calls the RS SOAP API for the
functionality you need, e.g. Parameters, etc. The AwReporterWeb project
included in my book source code
(http://www.manning-sandbox.com/thread.jspa?threadID=10394&tstart=45)
demonstrates how you can get a list of reports and parameters. More involved
scenarios are implemented in the AwReporterWin WinForm demo (e.g. obtaining
the parameters values, multi-value parameters, etc.).
As a side note, you may find my AwReportViewer control useful
(http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=45) to
handle images, dataset binding (using my custom dataset extension) and more
:-)
Finally, please note that by going SOAP you are losing not only the report
toolbar but also report interactive features (at least in version 1.0 of
RS), as well as simplicity.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"TechnoSpyke" <technospyke@.yahoo.com> wrote in message
news:OX8WEX0yEHA.2600@.TK2MSFTNGP09.phx.gbl...
> We have an ASP.Net web app that uses RS for reporting. We can't use the
RS
> toolbar since we will be generating reports using the SOAP API. Does
> anybody have any ideas/suggestions/examples on building a custom toolbar
for
> RS? Any input will be greatly appreciated. TIA.
>
>|||One more thing... you can save yourself quite a bit of development time if
you could postpone the toolbar implementation until the RS 2005 controls are
out. They will include a custom toolbar, events, and will support both
connected and disconnected mode. The first public drop of the controls will
be in Yukon Beta 3 which is just a few months away.
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
news:OJs1PZ4yEHA.2196@.TK2MSFTNGP14.phx.gbl...
> You just need to create a user control that calls the RS SOAP API for the
> functionality you need, e.g. Parameters, etc. The AwReporterWeb project
> included in my book source code
> (http://www.manning-sandbox.com/thread.jspa?threadID=10394&tstart=45)
> demonstrates how you can get a list of reports and parameters. More
involved
> scenarios are implemented in the AwReporterWin WinForm demo (e.g.
obtaining
> the parameters values, multi-value parameters, etc.).
> As a side note, you may find my AwReportViewer control useful
> (http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=45) to
> handle images, dataset binding (using my custom dataset extension) and
more
> :-)
> Finally, please note that by going SOAP you are losing not only the report
> toolbar but also report interactive features (at least in version 1.0 of
> RS), as well as simplicity.
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "TechnoSpyke" <technospyke@.yahoo.com> wrote in message
> news:OX8WEX0yEHA.2600@.TK2MSFTNGP09.phx.gbl...
> > We have an ASP.Net web app that uses RS for reporting. We can't use the
> RS
> > toolbar since we will be generating reports using the SOAP API. Does
> > anybody have any ideas/suggestions/examples on building a custom toolbar
> for
> > RS? Any input will be greatly appreciated. TIA.
> >
> >
> >
>|||Thanks Leo. I've been planning on getting your book for some time now, but
haven't gotten around to it... yet. Now I will have to :-)
I would have prefered to use URL access, and custom authentication, but we
need to upgrade to Enterprise Edition to do that, and the cost is a bit too
much. I understand that the reports will lose some of its interactive
features if I use SOAP API.
"Teo Lachev" <teo@.prologika.com> wrote in message
news:uSDp6g4yEHA.1196@.TK2MSFTNGP15.phx.gbl...
> One more thing... you can save yourself quite a bit of development time if
> you could postpone the toolbar implementation until the RS 2005 controls
> are
> out. They will include a custom toolbar, events, and will support both
> connected and disconnected mode. The first public drop of the controls
> will
> be in Yukon Beta 3 which is just a few months away.
> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
> news:OJs1PZ4yEHA.2196@.TK2MSFTNGP14.phx.gbl...
>> You just need to create a user control that calls the RS SOAP API for the
>> functionality you need, e.g. Parameters, etc. The AwReporterWeb project
>> included in my book source code
>> (http://www.manning-sandbox.com/thread.jspa?threadID=10394&tstart=45)
>> demonstrates how you can get a list of reports and parameters. More
> involved
>> scenarios are implemented in the AwReporterWin WinForm demo (e.g.
> obtaining
>> the parameters values, multi-value parameters, etc.).
>> As a side note, you may find my AwReportViewer control useful
>> (http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=45) to
>> handle images, dataset binding (using my custom dataset extension) and
> more
>> :-)
>> Finally, please note that by going SOAP you are losing not only the
>> report
>> toolbar but also report interactive features (at least in version 1.0 of
>> RS), as well as simplicity.
>> --
>> Hope this helps.
>> ---
>> Teo Lachev, MVP [SQL Server], MCSD, MCT
>> Author: "Microsoft Reporting Services in Action"
>> Publisher website: http://www.manning.com/lachev
>> Buy it from Amazon.com: http://shrinkster.com/eq
>> Home page and blog: http://www.prologika.com/
>> ---
>> "TechnoSpyke" <technospyke@.yahoo.com> wrote in message
>> news:OX8WEX0yEHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > We have an ASP.Net web app that uses RS for reporting. We can't use
>> > the
>> RS
>> > toolbar since we will be generating reports using the SOAP API. Does
>> > anybody have any ideas/suggestions/examples on building a custom
>> > toolbar
>> for
>> > RS? Any input will be greatly appreciated. TIA.
>> >
>> >
>> >
>>
>|||You don't have to :-)
I guess at the end you would you need to determine if the money you will
save by using Standard justifies the development effort getting around SOAP
addressability limitations. On the upside, it looks like the 2005 controls
will support drilldown with SOAP.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"TechnoSpyke" <technospyke@.yahoo.com> wrote in message
news:ej40s59yEHA.3548@.TK2MSFTNGP09.phx.gbl...
> Thanks Leo. I've been planning on getting your book for some time now,
but
> haven't gotten around to it... yet. Now I will have to :-)
> I would have prefered to use URL access, and custom authentication, but we
> need to upgrade to Enterprise Edition to do that, and the cost is a bit
too
> much. I understand that the reports will lose some of its interactive
> features if I use SOAP API.
> "Teo Lachev" <teo@.prologika.com> wrote in message
> news:uSDp6g4yEHA.1196@.TK2MSFTNGP15.phx.gbl...
> > One more thing... you can save yourself quite a bit of development time
if
> > you could postpone the toolbar implementation until the RS 2005 controls
> > are
> > out. They will include a custom toolbar, events, and will support both
> > connected and disconnected mode. The first public drop of the controls
> > will
> > be in Yukon Beta 3 which is just a few months away.
> >
> > "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
> > news:OJs1PZ4yEHA.2196@.TK2MSFTNGP14.phx.gbl...
> >> You just need to create a user control that calls the RS SOAP API for
the
> >> functionality you need, e.g. Parameters, etc. The AwReporterWeb project
> >> included in my book source code
> >> (http://www.manning-sandbox.com/thread.jspa?threadID=10394&tstart=45)
> >> demonstrates how you can get a list of reports and parameters. More
> > involved
> >> scenarios are implemented in the AwReporterWin WinForm demo (e.g.
> > obtaining
> >> the parameters values, multi-value parameters, etc.).
> >>
> >> As a side note, you may find my AwReportViewer control useful
> >> (http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=45)
to
> >> handle images, dataset binding (using my custom dataset extension) and
> > more
> >> :-)
> >>
> >> Finally, please note that by going SOAP you are losing not only the
> >> report
> >> toolbar but also report interactive features (at least in version 1.0
of
> >> RS), as well as simplicity.
> >>
> >> --
> >> Hope this helps.
> >>
> >> ---
> >> Teo Lachev, MVP [SQL Server], MCSD, MCT
> >> Author: "Microsoft Reporting Services in Action"
> >> Publisher website: http://www.manning.com/lachev
> >> Buy it from Amazon.com: http://shrinkster.com/eq
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >>
> >> "TechnoSpyke" <technospyke@.yahoo.com> wrote in message
> >> news:OX8WEX0yEHA.2600@.TK2MSFTNGP09.phx.gbl...
> >> > We have an ASP.Net web app that uses RS for reporting. We can't use
> >> > the
> >> RS
> >> > toolbar since we will be generating reports using the SOAP API. Does
> >> > anybody have any ideas/suggestions/examples on building a custom
> >> > toolbar
> >> for
> >> > RS? Any input will be greatly appreciated. TIA.
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>

Building a report

I have been "Thrown to the wolves" and need to learn Visual Studio and Reporting Services thru the scholl of hard knocks. I have had about 5 years a self teaching on Microsoft Access and 2 months of SQL Server. Not by any means a pro but I'm learning.

I put my SQL in the Data tab. I go to layout. I have made a couple of reports using the table and subreport in the toolbox. However when I try to drag and drop the fields into the body without a table all that previews is the first field.

When I drop the field in the body it comes out=First(Fields!fldname.Value) or=Sum(Fields!fldname2.Value)

I'd like to get this a continuous report(form). I hope I'm explaining this well enough. I'm going top Barnes and Noble today to get a book but in the meantime does anyone understand what I'm looking for?

I tried finding it on BOL but it didn't help me that much.

Hi

you can also use List to place labels inside. List is similar to Table(Grid) as you can place fields inside, but list does not force you to have table layout.

-yuriy

|||

Hi, I am not sure what you are trying to ask, if you are bugged that when you drag/drop a field it comes like =First(Fields!fldname.Value) instead of

=Fields!fldname.Value, then you can edit this directly or right click in textbox ot table cell and go to Expressions and there you can create an expression using different functions,variables, parameters and fields.

I apologise if I am tootally off the track.

|||

No apologise necessary. I can't explain what I'm looking for well.

I grab a field from my fieldlist and drop it in the body. I go to preview and all that comes up is the first record in my result set. How do I make it a continous report so I have the first record, the last record and everything in between.

I'm able to do this if I create a table in the body and drop the fields in the details portion of that table. However that is too structured for some of the reports I'm looking for.

|||

Drag LIST control to your report first. Configure it to repeat records from your source. Then drag fields into the LIST control.

|||

Yes,

That works. Well I haven't tried the configure part yet but I create a list, drag the field in the list and BAM there it is. Great answer thank you.

|||

You can only use the data regions available to build reports, and they are sufficient to build most of the reports, go through the report design basics(http://msdn2.microsoft.com/en-us/library/ms159253.aspx) and Data regions available in reporting services and you should be able to design more complicated reports with a combination of these data regions(http://msdn2.microsoft.com/en-us/library/ms157134.aspx) .

Still if you have some problem designing the report you can post your specific requirement and we will try to help.

Build-In Functions

Hi,
We are migrating from MS Access to Reporting Services.
When building a query in MS Access we have the possibility to create
functions with the expression builder.
The builder contains a lot of standard functions (Built-In Functions).
Question 1:
Is there such a system when building queries for Reporting Services.
Question 2:
It is possible to create user_defined functions in SQL-server.
Are there libraries outhere of user_defined functions Microsoft or the
community has build ?
Thanks for you reply.....
Regards,
Frank1. Yes there is a query builder built in to the development environment (
pretty much the same thing as in Access.)
2. Yes you can create UDFs in SQL... Many people share their UDFs on the
web, you just have to search or ask onthe newsgroups. Additionally RS allows
the use of Excel, and VB functions automatically...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Frank van de Ven" <qualicon_fvdven@.hotmail.com.(donotspam)> wrote in
message news:8E6884FF-ADB0-4BCB-AEEB-BE0C372E9A35@.microsoft.com...
> Hi,
> We are migrating from MS Access to Reporting Services.
> When building a query in MS Access we have the possibility to create
> functions with the expression builder.
> The builder contains a lot of standard functions (Built-In Functions).
> Question 1:
> Is there such a system when building queries for Reporting Services.
> Question 2:
> It is possible to create user_defined functions in SQL-server.
> Are there libraries outhere of user_defined functions Microsoft or the
> community has build ?
> Thanks for you reply.....
> Regards,
> Frank
>

Build error after installing SQLRS2005

Since installing the latest version of Reporting Services side-by-side with
the 2000 version I can't build any of my extensions with the following
error:
fatal error CS0009: Metadata file 'c:\Program Files\Microsoft SQL
Server\90\SDK\Assemblies\Microsoft.ReportingServices.Interfaces.dll' could
not be opened -- 'Version 2.0 is not a compatible version.'
This is not the assembly I have referenced in the project so where is the
redirect happening?Hi James,
Thanks for your post.
From your descriptions, I understood you scenario as below
1. You have installed SQL Server 2000 Reporting Services before, it's OK to
build your extensions.
2. You have upgraded your SQL Server 2000 RS to SQL Server 2005 Reporting
Services, the assembly you refered was redirect to another one and report
the error message
If I have misunderstood your concern, please feel free to point it out.
1. Is it possible for you to complie the assembliy with VS.NET 2005 first?
2. Would you please clarify what is "side-by-side" in your words? Is it
possible for you to let me know the detailed steps?
3. Any more related logs in SQL/Reporting Error Logs?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
> From your descriptions, I understood you scenario as below
> 1. You have installed SQL Server 2000 Reporting Services before, it's OK
> to
> build your extensions.
Yes.
> 2. You have upgraded your SQL Server 2000 RS to SQL Server 2005 Reporting
I have installed the Yukon RTM as a new instance called "Yukon" in addition
to the existing RS2000.
> Services, the assembly you refered was redirect to another one and report
> the error message
Yup, I was referring to the interfaces assembly in the RS2000 folder but it
was redirected to the one in the RS2005 SDK folder.
> If I have misunderstood your concern, please feel free to point it out.
> 1. Is it possible for you to complie the assembliy with VS.NET 2005 first?
After upgrading the project it does build in VS2005. However I need it to
build in 2003 because I need a .NET 1.1 assembly...
> 2. Would you please clarify what is "side-by-side" in your words? Is it
> possible for you to let me know the detailed steps?
Side-by-side really means I've installed a new instance of SQL2005 so I can
continue to develop on SQL2000.
> 3. Any more related logs in SQL/Reporting Error Logs?
Nope, this is a build problem not a runtime problem. The error message is
occuring because VS2003 is attempting to load a .NET 2.0 assembly.|||Sorry if this is double posted - the original didn't appear after an hour or
so...
Hi Michael,
> From your descriptions, I understood you scenario as below
> 1. You have installed SQL Server 2000 Reporting Services before, it's OK
> to
> build your extensions.
Yes.
> 2. You have upgraded your SQL Server 2000 RS to SQL Server 2005 Reporting
I have installed the Yukon RTM as a new instance called "Yukon" in addition
to the existing RS2000.
> Services, the assembly you refered was redirect to another one and report
> the error message
Yup, I was referring to the interfaces assembly in the RS2000 folder but it
was redirected to the one in the RS2005 SDK folder.
> If I have misunderstood your concern, please feel free to point it out.
> 1. Is it possible for you to complie the assembliy with VS.NET 2005 first?
After upgrading the project it does build in VS2005. However I need it to
build in 2003 because I need a .NET 1.1 assembly...
> 2. Would you please clarify what is "side-by-side" in your words? Is it
> possible for you to let me know the detailed steps?
Side-by-side really means I've installed a new instance of SQL2005 so I can
continue to develop on SQL2000.
> 3. Any more related logs in SQL/Reporting Error Logs?
Nope, this is a build problem not a runtime problem. The error message is
occuring because VS2003 is attempting to load a .NET 2.0 assembly.
Regards,
James Snape|||Hi James,
Please build the assembly in another machine that has VS.NET 2003 and .NET
1.1 only and then deploy the assembly in your SQL Server 2005 directly.
Make sure the machine has .NET 1.1 installed.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
It's not my goal to build the assembly and install on SQL2005. I just have
to develop for both RS2000 and RS2005 which is why that are both installed
on my machine. The project in question is a VS2003 project, the output of
which will be installed in a RS2000 server. The VS2003 project will not
build in this configuration and I can't use 2.0 assemblies inside RS2000.
Regards,
James Snape
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:djwX7pS4FHA.3936@.TK2MSFTNGXA01.phx.gbl...
> Hi James,
> Please build the assembly in another machine that has VS.NET 2003 and .NET
> 1.1 only and then deploy the assembly in your SQL Server 2005 directly.
> Make sure the machine has .NET 1.1 installed.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi James,
Yes, you cannot use .net 2.0 runtime assembies inside VS.NET 2003/RS2000;
You can only build .net 2.0 runtime with VS.NET 2005. If you want to build
the report with .net 1.1 runtime, you will have to use VS.NET 2003
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
I completely agree, but the problem here is that since installing RS2005 my
old references to the RS2000 (1.1) assembly have been redirected to the new
RS2005 (2.0) assembly even though the project hint path points to the
correct (old) location. I just really want to know how to stop the redirect
and make it use the v1.1 assembly.
Regards,
James Snape
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:O8PIC824FHA.1144@.TK2MSFTNGXA01.phx.gbl...
> Hi James,
> Yes, you cannot use .net 2.0 runtime assembies inside VS.NET 2003/RS2000;
> You can only build .net 2.0 runtime with VS.NET 2005. If you want to build
> the report with .net 1.1 runtime, you will have to use VS.NET 2003
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
> If you are outside the United States, please visit our International
> Support page: http://support.microsoft.com/common/international.aspx
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi James,
As for which verion of runtime library the .net framework application will
load, if differs according to how the .net managed code is hosted in the
application.
1. If the the application is a pure .net managed application, the CLR host
is the application process it self, then the application will prefer the
class library version which it built with. If that version not available on
target machine, it try loading the latest compatible one.
2. If the .net code is hosted as "Add-in" model, in other word, the
application it self is not a pure .net application, but it load the CLR as
part of its process to run some managed code. In such scenario, the process
by default will load the latest runtime and class library verison. This is
because in such scenario, the host could load multiple such assemblies
which may be built under different versions (so which version should the
application chose?). So for consistency consideration, the application will
load the latest framework no matter the which version the add-in assemblies
were built with.
Based on my understanding, the SQLserver reporting service is rely on the
"ReportingServicesService.exe" process which is a managed application. So
this application's built version also determine all the sequential
assemblies it will load into.
In addition, before your deploying the Reports, please make sure you have
deployed it to the right TargetServer:
Right Click the solution name;
Select Properties;
Make sure you are using SQL Server 2000 RS or SQL Server 2005 RS
Hope helps. Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "James Snape" <jim_snape.at.hotmail.com@.online.nospam>
| References: <uEaHQ043FHA.476@.TK2MSFTNGP15.phx.gbl>
<rjcK#jD4FHA.3220@.TK2MSFTNGXA01.phx.gbl>
<O6QboiG4FHA.1416@.TK2MSFTNGP09.phx.gbl>
<djwX7pS4FHA.3936@.TK2MSFTNGXA01.phx.gbl>
<un6ygiT4FHA.3588@.TK2MSFTNGP15.phx.gbl>
<O8PIC824FHA.1144@.TK2MSFTNGXA01.phx.gbl>
| Subject: Re: Build error after installing SQLRS2005
| Date: Mon, 7 Nov 2005 17:22:31 -0000
| Lines: 51
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| Message-ID: <e7V2r$74FHA.3136@.TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: ip-213-92-131-1.aramiska-arc.aramiska.net 213.92.131.1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:55896
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi Michael,
|
| I completely agree, but the problem here is that since installing RS2005
my
| old references to the RS2000 (1.1) assembly have been redirected to the
new
| RS2005 (2.0) assembly even though the project hint path points to the
| correct (old) location. I just really want to know how to stop the
redirect
| and make it use the v1.1 assembly.
|
| Regards,
| James Snape
|
|
| "Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
| news:O8PIC824FHA.1144@.TK2MSFTNGXA01.phx.gbl...
| > Hi James,
| >
| > Yes, you cannot use .net 2.0 runtime assembies inside VS.NET
2003/RS2000;
| > You can only build .net 2.0 runtime with VS.NET 2005. If you want to
build
| > the report with .net 1.1 runtime, you will have to use VS.NET 2003
| >
| > Thank you for your patience and cooperation. If you have any questions
or
| > concerns, don't hesitate to let me know. We are always here to be of
| > assistance!
| >
| >
| > Sincerely yours,
| >
| > Michael Cheng
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader so
| > that others may learn and benefit from your issue.
| > =====================================================| > Business-Critical Phone Support (BCPS) provides you with technical phone
| > support at no charge during critical LAN outages or "business down"
| > situations. This benefit is available 24 hours a day, 7 days a week to
all
| > Microsoft technology partners in the United States and Canada.
| >
| > This and other support options are available here:
| > BCPS:
| >
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
| > Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/
| >
| > If you are outside the United States, please visit our International
| > Support page: http://support.microsoft.com/common/international.aspx
| > =====================================================| > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| >
|
|
||||Sorry guys, but you don't seem to get the problem I was trying to describe I
guess I haven't been explicit enough. As it turns out I have solved the
problem by not referencing the assembly in the ReportServer/bin folder but
instead copying it to my .csproj folder and referencing it there. The
redirect doesn't happen and I can now build successfully.
Many thanks
James Snape
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:HLY6XHE5FHA.3904@.TK2MSFTNGXA01.phx.gbl...
> Hi James,
> As for which verion of runtime library the .net framework application
> will
> load, if differs according to how the .net managed code is hosted in the
> application.
> 1. If the the application is a pure .net managed application, the CLR host
> is the application process it self, then the application will prefer the
> class library version which it built with. If that version not available
> on
> target machine, it try loading the latest compatible one.
> 2. If the .net code is hosted as "Add-in" model, in other word, the
> application it self is not a pure .net application, but it load the CLR as
> part of its process to run some managed code. In such scenario, the
> process
> by default will load the latest runtime and class library verison. This
> is
> because in such scenario, the host could load multiple such assemblies
> which may be built under different versions (so which version should the
> application chose?). So for consistency consideration, the application
> will
> load the latest framework no matter the which version the add-in
> assemblies
> were built with.
> Based on my understanding, the SQLserver reporting service is rely on the
> "ReportingServicesService.exe" process which is a managed application. So
> this application's built version also determine all the sequential
> assemblies it will load into.
>
> In addition, before your deploying the Reports, please make sure you have
> deployed it to the right TargetServer:
> Right Click the solution name;
> Select Properties;
> Make sure you are using SQL Server 2000 RS or SQL Server 2005 RS
> Hope helps. Thanks,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
> --
> | From: "James Snape" <jim_snape.at.hotmail.com@.online.nospam>
> | References: <uEaHQ043FHA.476@.TK2MSFTNGP15.phx.gbl>
> <rjcK#jD4FHA.3220@.TK2MSFTNGXA01.phx.gbl>
> <O6QboiG4FHA.1416@.TK2MSFTNGP09.phx.gbl>
> <djwX7pS4FHA.3936@.TK2MSFTNGXA01.phx.gbl>
> <un6ygiT4FHA.3588@.TK2MSFTNGP15.phx.gbl>
> <O8PIC824FHA.1144@.TK2MSFTNGXA01.phx.gbl>
> | Subject: Re: Build error after installing SQLRS2005
> | Date: Mon, 7 Nov 2005 17:22:31 -0000
> | Lines: 51
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <e7V2r$74FHA.3136@.TK2MSFTNGP09.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: ip-213-92-131-1.aramiska-arc.aramiska.net
> 213.92.131.1
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:55896
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Hi Michael,
> |
> | I completely agree, but the problem here is that since installing RS2005
> my
> | old references to the RS2000 (1.1) assembly have been redirected to the
> new
> | RS2005 (2.0) assembly even though the project hint path points to the
> | correct (old) location. I just really want to know how to stop the
> redirect
> | and make it use the v1.1 assembly.
> |
> | Regards,
> | James Snape
> |
> |
> | "Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
> | news:O8PIC824FHA.1144@.TK2MSFTNGXA01.phx.gbl...
> | > Hi James,
> | >
> | > Yes, you cannot use .net 2.0 runtime assembies inside VS.NET
> 2003/RS2000;
> | > You can only build .net 2.0 runtime with VS.NET 2005. If you want to
> build
> | > the report with .net 1.1 runtime, you will have to use VS.NET 2003
> | >
> | > Thank you for your patience and cooperation. If you have any questions
> or
> | > concerns, don't hesitate to let me know. We are always here to be of
> | > assistance!
> | >
> | >
> | > Sincerely yours,
> | >
> | > Michael Cheng
> | > Microsoft Online Partner Support
> | >
> | > When responding to posts, please "Reply to Group" via your newsreader
> so
> | > that others may learn and benefit from your issue.
> | > =====================================================> | > Business-Critical Phone Support (BCPS) provides you with technical
> phone
> | > support at no charge during critical LAN outages or "business down"
> | > situations. This benefit is available 24 hours a day, 7 days a week to
> all
> | > Microsoft technology partners in the United States and Canada.
> | >
> | > This and other support options are available here:
> | > BCPS:
> | >
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> | > Others:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/
> | >
> | > If you are outside the United States, please visit our International
> | > Support page: http://support.microsoft.com/common/international.aspx
> | > =====================================================> | > This posting is provided "AS IS" with no warranties, and confers no
> | > rights.
> | >
> |
> |
> |
>|||Hi James,
Sorry for the misunderstanding and it's great to hear you have resolved it
by copying the assembly to your project folder.
Anyway, thanks so much for sharing this with us.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.