formula in sql server

hi,
my users can make posts in my web application, i mean they fill a form and the information they filled will be saved in sql server 2000 and can be shown in web application,now i want to give each post an Id and save it in the database, how can i do that? does sql server have the abilities or i should do sth in my c# application

thanx

This is something that is best to let the database handle for you.

Set your ID column as an Identity column in your sql table.

Sql server will then set its value to a unique auto incrementing value automatically every time a new row is inserted.

Forms Authentication-Authorization ticket not received by LogonUse

Hello,
I've had my web application up and running and integrated with
ReportingServices using Forms Authentication for quite a while now. I
followed the examples provided and everything was running smoothly in the
testing environment.
We were accessing the Report Server using the domain/machine name and it was
working a treat. This afternoon, we recieved our fully qualified domain name
and went about updating references to this new url. Unfortunately, after
doing this we no longer seem to be able to access the report server. We
receive the following exception :
Authorization ticket not received by LogonUser
We are performing cookie management as described by the examples.
This has everyone here quite stumped and I was hoping someone may be able to
help out.OK, It seemed to have been due to a configuration setting in
RSReportServer.config.
I updated the node: <Configuration><Service><UrlRoot> to match the new url.
Just to be sure I also updated the node:
<Configuration><UI><ReportServerUrl> in RSWebApplication.config.
"Danny" wrote:
> Hello,
> I've had my web application up and running and integrated with
> ReportingServices using Forms Authentication for quite a while now. I
> followed the examples provided and everything was running smoothly in the
> testing environment.
> We were accessing the Report Server using the domain/machine name and it was
> working a treat. This afternoon, we recieved our fully qualified domain name
> and went about updating references to this new url. Unfortunately, after
> doing this we no longer seem to be able to access the report server. We
> receive the following exception :
> Authorization ticket not received by LogonUser
> We are performing cookie management as described by the examples.
> This has everyone here quite stumped and I was hoping someone may be able to
> help out.

Forms Authentication without Report Manager

I am intergrating Reporting Services into my own web application and want to use Forms Authentication. Do I need to do anything different than the Security Extension Sample on MSDN books online? Specifically, since I no longer need to go through Report Manager, how would I login the user and manage the cookie?http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp?ferame=true will help you in this. Actualyl I am researching this myself. I am looking to add/delete user roles programmatically. So far, I am having little luck but, I think I'll pull it together!

Forms Authentication for reporting

Hello
I have a web application that uses forms authentication.
Ideally I would like to be able to make some reports from my Reporting Services server available BUT I would also like to be able to pass authentication data through as I would like the reports available to be dictated by who the user is and the roles that they have within the application.
So for example if I have user A and user B then there are some reports that only user A will want to be able to see and some that only user B will want to see

There are also some reports that will vary the data according to who the user is e.g. user A will want to see their data only and User B will want to see their data only but on the same report
Is this possible? If anyone has any suggestions on where I can look to find out how to do this I would be grateful
thanks
steveI'd suggest doing the authentication before ever getting over to the reporting services server. Let the application control which reports each person can see based on their authorization in the application. Hopefully you will already have this information available, and if not it should not be hard to add.
And... even though it is more work now I'd also consider streaming the reporting services data back from the reporting services server to your application. Your server builds all of the correct parms including user specific required information, passes the request to the reporting services server, it processes the report data and comes back with a report, the report is streamed back to your application which displays it in a web browser or makes it available for download.|||

Thanks Patrick

The authorization information is available as you suggest.
I'm not sure I'm absolutely clear on what you mean bystreaming the reporting services data back. Do you mean some sort of HTTP handler or web service call? Ideally I would like something fairly simple that maintained much of the functionality of Reporting Services - particularly the ability to subscribe and to have different output formats

steve

|||What I am talking about is sending the data to the reporting server torun the report and getting the data back, but not actually using thereporting server to display the report. You'd lose some of thefunctionality of RS, but gain as much flexibility as you can code in.
I know reporting services can restrict report view by userids anddomains,but that is all configured on the reporting services side atthe report and the report folder level. The way that comes to mindfirst doing what you are talking about (passing credentials at reportrun time) is to have the report at a high level look at what is beingpassed and conditionally hide the page.
One thing I don't understand - how will somebody ever haveauthorization to see a report is even available if they are notauthorized to view it? Shouldn't you not even make the option availableto them? Display a report list for the current user, but that list is asubset of ALL of the reports available. They only see what they cantruly get to. I don't have your original post in front of me so I don'tknow if you have some restriction that prevents that. But that routeseems to be the best long term solution for anyone that is planning onusing reporting services and wants authentication.
FYI... in VS2005 there is a control you can put in your applicationthat looks/feels just like the reporting services website. So it willbe easier to stream reports back while keeping alot of thefunctionality.
|||Thanks patrick

steve|||My pleasure. I can't believe I was actually able to help somebody.
Report back with what you finally do and how it worked. I am interestedin seeing your solution and the code that goes along with it.
|||OK, no problems but don't hold your breath it may take a while
steve

Forms Authentication : Object moved

Server Error in '/' Application.
----
The request failed with the error message: -- <html><head><title>Object
moved</title></head><body> <h2>Object moved to <a
href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx'>here</a>.</h2>
</body></html> --.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Net.WebException: The request failed with the
error message: -- <html><head><title>Object moved</title></head><body>
<h2>Object moved to <a
href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx'>here</a>.</h2>
</body></html> --.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Stack Trace:
[WebException: The request failed with the error message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a
href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx'>here</a>.</h2>
</body></html>
--.]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream) +1136
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) +216
BusinessFacade.ReportingServiceWeb.ReportingService.CreateBatch() in
h:\my documents\visual studio
projects\reportingservices\businessfacade\web
references\reportingserviceweb\reference.cs:72
BusinessFacade.Scheduling.CreateRsSchedule(SavedReport R, Schedule
S, Guid EBCUserId) in h:\my documents\visual studio
projects\reportingservices\businessfacade\scheduling.cs:249
BusinessFacade.Scheduling.Add(SavedReport R, Schedule S, Guid
EBCUserId, String ReportPath) in h:\my documents\visual studio
projects\reportingservices\businessfacade\scheduling.cs:157
EBCReportInterface.Schedule.Scheduler_Click(Object sender, EventArgs
e) in c:\ebusiness
centre\portfolio.net\ebcreportinterface_2\saveandschedule.aspx.cs:458
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
+33
System.Web.UI.Page.ProcessRequestMain() +1263
----
Version Information: Microsoft .NET Framework Version:1.0.3705.288;
ASP.NET Version:1.0.3705.288Are you manually handling the authentication cookies used? This is detailed
in the forms authentication extension docs.
"Phil Winstanley [Microsoft MVP ASP.NET]" wrote:
> Server Error in '/' Application.
> ----
> The request failed with the error message: -- <html><head><title>Object
> moved</title></head><body> <h2>Object moved to <a
> href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx'>here</a>.</h2>
> </body></html> --.
> Description: An unhandled exception occurred during the execution of
> the current web request. Please review the stack trace for more
> information about the error and where it originated in the code.
> Exception Details: System.Net.WebException: The request failed with the
> error message: -- <html><head><title>Object moved</title></head><body>
> <h2>Object moved to <a
> href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx'>here</a>.</h2>
> </body></html> --.
> Source Error:
> An unhandled exception was generated during the execution of the
> current web request. Information regarding the origin and location of
> the exception can be identified using the exception stack trace below.
>
> Stack Trace:
>
> [WebException: The request failed with the error message:
> --
> <html><head><title>Object moved</title></head><body>
> <h2>Object moved to <a
> href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx'>here</a>.</h2>
> </body></html>
> --.]
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream) +1136
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) +216
> BusinessFacade.ReportingServiceWeb.ReportingService.CreateBatch() in
> h:\my documents\visual studio
> projects\reportingservices\businessfacade\web
> references\reportingserviceweb\reference.cs:72
> BusinessFacade.Scheduling.CreateRsSchedule(SavedReport R, Schedule
> S, Guid EBCUserId) in h:\my documents\visual studio
> projects\reportingservices\businessfacade\scheduling.cs:249
> BusinessFacade.Scheduling.Add(SavedReport R, Schedule S, Guid
> EBCUserId, String ReportPath) in h:\my documents\visual studio
> projects\reportingservices\businessfacade\scheduling.cs:157
> EBCReportInterface.Schedule.Scheduler_Click(Object sender, EventArgs
> e) in c:\ebusiness
> centre\portfolio.net\ebcreportinterface_2\saveandschedule.aspx.cs:458
> System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
> System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
> eventArgument) +57
> System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument) +18
> System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
> +33
> System.Web.UI.Page.ProcessRequestMain() +1263
>
>
> ----
> Version Information: Microsoft .NET Framework Version:1.0.3705.288;
> ASP.NET Version:1.0.3705.288
>sql

formatting textbox output

I have a report whcih displays information about a servers hardware
configuration. Unfortunatley the vendors application whcih collects and
stores this information, add spcaing between vaules in the form of [-] and
[+].
I'd like to remove this in the final rendering of the report for display
purposes.
see sample output:
ComputerSystem Name[-]ADM-EX01[+]SystemType[-]X86-based
PC[+]Manufacturer[-]Compaq[+]Model[-]ProLiant ML350
G3[+]Domain[-]MARBLEHEAD[+]DomainRole[-]Member
Server[+]NumberOfProcessors[-]2[+]TotalPhysicalMemory[-]2,146,979,840
Anyone have any ideas?
Much appreciated,
RCITGUYUse expression and Replace function. Remember, you can use VB in expressions.
Victor
"RCITGuy" wrote:
> I have a report whcih displays information about a servers hardware
> configuration. Unfortunatley the vendors application whcih collects and
> stores this information, add spcaing between vaules in the form of [-] and
> [+].
> I'd like to remove this in the final rendering of the report for display
> purposes.
> see sample output:
> ComputerSystem Name[-]ADM-EX01[+]SystemType[-]X86-based
> PC[+]Manufacturer[-]Compaq[+]Model[-]ProLiant ML350
> G3[+]Domain[-]MARBLEHEAD[+]DomainRole[-]Member
> Server[+]NumberOfProcessors[-]2[+]TotalPhysicalMemory[-]2,146,979,840
> Anyone have any ideas?
> Much appreciated,
> RCITGUY

Format of tables

Hello,

I have the following problem; In my application I have certain items that
have properties.

Item Property
--- --------
ToyBear Hairy, Soft, Brown
ToyCar Brown, Plastic, Wheels
ToyBall Round, Soft, Brown, Plastic

As you might expect I want to do queries on the properties; so property
Brown should yield all items listed above and Plastic should yield only
ToyCar and ToyBall.
The amount of properties is limitless, so making a separate field per
property seems to be madness. My question is how can I make a (or more)
tables that will enable me to search for items by applying one or more
properties?? What structure do I need to accomplish this?

Kind regards, Darius Blaszijk"Darius Blaszijk" <dhkblaszyjk@.zeelandnet.nl> wrote in message
news:41060ef3$0$13577$fb624cd1@.morenews.zeelandnet .nl...
> Hello,
> I have the following problem; In my application I have certain items that
> have properties.
> Item Property
> --- --------
> ToyBear Hairy, Soft, Brown
> ToyCar Brown, Plastic, Wheels
> ToyBall Round, Soft, Brown, Plastic
> As you might expect I want to do queries on the properties; so property
> Brown should yield all items listed above and Plastic should yield only
> ToyCar and ToyBall.
> The amount of properties is limitless, so making a separate field per
> property seems to be madness. My question is how can I make a (or more)
> tables that will enable me to search for items by applying one or more
> properties?? What structure do I need to accomplish this?
> Kind regards, Darius Blaszijk

The obvious thing would be to have two tables - TB_Item and TB_Property.
TB_Property has a foriegn key referencing into TB_Item.

Therefore, you're definition would look something like this:

CREATE DATABASE TB_Item (
name VARCHAR (30),

CONSTRAINT PK_TB_Item
PRIMARY KEY (name)
)

CREATE DATABASE TB_Property (
itemName VARCHAR (30)
propName VARCHAR (30)

CONSTRAINT FK_TB_Item_name
FOREIGN KEY (itemName)
REFERENCES TB_Approver_Type (name)
)

Then, to populate the database for the example of ToyBear given above, do:
INSERT INTO TB_Item (name) VALUES ('ToyBear')
GO
INSERT INTO TB_Property (itemName, propName) VALUES ('ToyBear', 'Hairy')
INSERT INTO TB_Property (itemName, propName) VALUES ('ToyBear', 'Soft')
INSERT INTO TB_Property (itemName, propName) VALUES ('ToyBear', 'Brown')

Hope that is clear, and answers your question,

Rowland.|||"Rowland Banks" <banksr0@.hotmail.com> wrote in message
news:ce544k$6mp$1@.sparta.btinternet.com...
> "Darius Blaszijk" <dhkblaszyjk@.zeelandnet.nl> wrote in message
> news:41060ef3$0$13577$fb624cd1@.morenews.zeelandnet .nl...
> > Hello,
> > I have the following problem; In my application I have certain items
that
> > have properties.
> > Item Property
> > --- --------
> > ToyBear Hairy, Soft, Brown
> > ToyCar Brown, Plastic, Wheels
> > ToyBall Round, Soft, Brown, Plastic
> > As you might expect I want to do queries on the properties; so property
> > Brown should yield all items listed above and Plastic should yield only
> > ToyCar and ToyBall.
> > The amount of properties is limitless, so making a separate field per
> > property seems to be madness. My question is how can I make a (or more)
> > tables that will enable me to search for items by applying one or more
> > properties?? What structure do I need to accomplish this?
> > Kind regards, Darius Blaszijk
> The obvious thing would be to have two tables - TB_Item and TB_Property.
> TB_Property has a foriegn key referencing into TB_Item.
> Therefore, you're definition would look something like this:
> CREATE DATABASE TB_Item (
> name VARCHAR (30),
> CONSTRAINT PK_TB_Item
> PRIMARY KEY (name)
> )
> CREATE DATABASE TB_Property (
> itemName VARCHAR (30)
> propName VARCHAR (30)
> CONSTRAINT FK_TB_Item_name
> FOREIGN KEY (itemName)
> REFERENCES TB_Approver_Type (name)
> )
> Then, to populate the database for the example of ToyBear given above, do:
> INSERT INTO TB_Item (name) VALUES ('ToyBear')
> GO
> INSERT INTO TB_Property (itemName, propName) VALUES ('ToyBear', 'Hairy')
> INSERT INTO TB_Property (itemName, propName) VALUES ('ToyBear', 'Soft')
> INSERT INTO TB_Property (itemName, propName) VALUES ('ToyBear', 'Brown')
> Hope that is clear, and answers your question,
> Rowland.
ADDENDUM:
I just read through your post again and I missed a bit. To extract the
information, use somethign similar to:

SELECT i.name
FROM TB_Item AS i, TB_Property AS p
WHERE i.name = p.itemName
AND p.itemName = 'Hairy'

hope that helps,

Rowland

Format HTMLOWC

I have a .net application already that does quite a bit
of reporting and I'd like to incorporate RS into it.
Currently, I have a DetailReport.aspx page that displays
results using Office Web Components. I'd like to replace
this page with reports from RS. When I try to view
reports using the Format=HTMLOWC directly in the HTML
Viewer, the results look just like regular HTML (not like
the Excel in OWC). I thought I could just display the
report using the ReportViewer.dll included with RS, but
it doesn't seem like that will work.
So, my question is what is the best way to incorporate RS
into my existing application? I want the user to be able
to experience the report in OWC through my current web
app.
Thanks in advance!
Jim
.What is is issue you have with ReportViewer control, because we are using
ReportViewer to display the report in the web interface and it works fine.
Let me know the issue and see how I can help you
Balaji
--
Message posted via http://www.sqlmonster.com|||Thanks for your response, but I'm not sure I understand. I changed the
webapp to use the reportviewer.dll control for RS and used the
Format="HTMLOWC" property, but the report is still rendered on the webform as
HTML and not HTML with OWC. Any ideas? Both the client and the IIS server
have OWC installd, but the RS Server may not.
JE
"BALAJI via SQLMonster.com" wrote:
> What is is issue you have with ReportViewer control, because we are using
> ReportViewer to display the report in the web interface and it works fine.
> Let me know the issue and see how I can help you
> Balaji
> --
> Message posted via http://www.sqlmonster.com
>|||Actually, I'm finding that I cannot even download the report using the Export
functionality in the HTML Viewer. It just shows up as regular HTML. I have
OWC installed on the client and it used to download the same report fine.
I've installed RS SP2 - could that have broken this?
JE
"Jim Emlet" wrote:
> Thanks for your response, but I'm not sure I understand. I changed the
> webapp to use the reportviewer.dll control for RS and used the
> Format="HTMLOWC" property, but the report is still rendered on the webform as
> HTML and not HTML with OWC. Any ideas? Both the client and the IIS server
> have OWC installd, but the RS Server may not.
> JE
> "BALAJI via SQLMonster.com" wrote:
> > What is is issue you have with ReportViewer control, because we are using
> > ReportViewer to display the report in the web interface and it works fine.
> >
> > Let me know the issue and see how I can help you
> >
> > Balaji
> >
> > --
> > Message posted via http://www.sqlmonster.com
> >|||The OWC rendering has lots of limitations that are described in the
documentation. If we run into one of these restrictions, it will come out as
straight HTML.
The best way to embed reports into your applications is actually the new
ReportViewer controls in VS 2005.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim Emlet" <JimEmlet@.discussions.microsoft.com> wrote in message
news:132259F7-7CAF-404C-9F04-8D8910BCC60A@.microsoft.com...
> Actually, I'm finding that I cannot even download the report using the
> Export
> functionality in the HTML Viewer. It just shows up as regular HTML. I
> have
> OWC installed on the client and it used to download the same report fine.
> I've installed RS SP2 - could that have broken this?
> JE
> "Jim Emlet" wrote:
>> Thanks for your response, but I'm not sure I understand. I changed the
>> webapp to use the reportviewer.dll control for RS and used the
>> Format="HTMLOWC" property, but the report is still rendered on the
>> webform as
>> HTML and not HTML with OWC. Any ideas? Both the client and the IIS
>> server
>> have OWC installd, but the RS Server may not.
>> JE
>> "BALAJI via SQLMonster.com" wrote:
>> > What is is issue you have with ReportViewer control, because we are
>> > using
>> > ReportViewer to display the report in the web interface and it works
>> > fine.
>> >
>> > Let me know the issue and see how I can help you
>> >
>> > Balaji
>> >
>> > --
>> > Message posted via http://www.sqlmonster.com
>> >