Forms Authentication Sample

I'm using the forms auth sample:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
I've followed the steps in the sample for configuring forms auth on the
/Reports and /ReportServer webs.
Forms Auth now works fine on the /ReportServer web. However, on the Report
Manager app (/Reports web), even though I authenticate correctly (I debugged
and stepped through the code), it's not redirecting to the ReturnURL. It
simply returns to the logon screen.
Here's what I've done to the Report Manager web (according to the sample
instructions):
1 - Copy Microsoft.Samples.ReportingServices.CustomSecurity.dll and
Microsoft.Samples.ReportingServices.CustomSecurity.pdb to the
<install>\ReportManager\bin directory
2- In RSWebApplication.config file I've updated the UI element:
<UI>
<CustomAuthenticationUI>
<loginUrl>/Pages/UILogon.aspx</loginUrl>
<UseSSL>False</UseSSL>
</CustomAuthenticationUI>
<ReportServerUrl>http://<server>/ReportServer</ReportServerUrl>
</UI>
*** I set UseSSL to false because this is a development environment ***
3 - In rsmgrpolicy.config I changed the PermissionSetName attribute from
Execution to FullTrust as follows:
<CodeGroup
class="FirstMatchCodeGroup"
version="1"
PermissionSetName="FullTrust"
Description="This code group grants MyComputer code Execution
permission. ">
<IMembershipCondition
class="ZoneMembershipCondition"
version="1"
Zone="MyComputer" />
4 - In the Report manager web config file:
Disabled impersonation by locating the section <identity impersonate= "true"
/> and changing it to the following: <identity impersonate="false" />.
5 - Set the Report virtual directory to Anonymous authentication
6 - In the RSReportServer.config file. Locate the <Security> element and add
the previously registered user name as follows:
<Security>
<Extension Name="Forms"
Type="Microsoft.Samples.ReportingServices.CustomSecurity.Authorization,
Microsoft.Samples.ReportingServices.CustomSecurity" >
<Configuration>
<AdminConfiguration>
<UserName>username</UserName>
</AdminConfiguration>
</Configuration>
</Extension>
</Security>
***username was changed to the user I set up and should validate. ***
Note: I've made all the changes in the article with regards to the
/ReportServer web as well. And again, that web appears to be working OK.
Any idea why Forms Auth isn't working correctly on the Reports Manager web
app' Is there something else I need to do to the web.config file?Be sure to navigate to http://SERVERNAME/reports and not
http://localhost/reports. That's what got me for a while!|||Thank You !!!!
"s" <sjd0103@.comcast.net> wrote in message
news:Xns95D6A2E839377sjd0103aolcom@.207.46.248.16...
> Be sure to navigate to http://SERVERNAME/reports and not
> http://localhost/reports. That's what got me for a while!

Forms Authentication - Error about 'text/html; charset=utf-8'

I saw post on the same issue but it is not answered.
I use win2k server and reporting service standard edition. The register
function works fine. But When I try to log on to http://servername/reports, I
get the following error:
Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'. The request failed with the error message: --
Reporting Services Erro
----
This operation is not supported in this edition of Reporting Services
(rsOperationNotSupported) Get Online Help
----
Microsoft Reporting Services --.
********************************************
Is this because of the Standard edition of reporting service?
Any help will be appreciated.
MichaelStandard edition doesn't support custom security extensions (which is what
the forms auth extension is).
http://www.microsoft.com/sql/reporting/productinfo/features.asp
--
Adrian M.
MCP
"bsanders" <missisummer@.community.nospam> wrote in message
news:F24683E8-1410-4C27-B478-6D2F7407FD42@.microsoft.com...
>I saw post on the same issue but it is not answered.
> I use win2k server and reporting service standard edition. The register
> function works fine. But When I try to log on to
> http://servername/reports, I
> get the following error:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'. The request failed with the error message: --
> Reporting Services Error
> ----
> This operation is not supported in this edition of Reporting Services
> (rsOperationNotSupported) Get Online Help
> ----
> Microsoft Reporting Services --.
> ********************************************
> Is this because of the Standard edition of reporting service?
> Any help will be appreciated.
> Michael|||Hello Michael,
By default, Reporting Services uses a Windows-based authentication
extension, which uses Windows account protocols to verify the identities of
users who claim to have accounts on the system. Reporting Services uses a
role-based security system to authorize users. The Reporting Services
role-based security model is similar to the role-based security models of
other technologies.
Because security extensions are based on an open and extensible API, you
can create new authentication and authorization extensions in Reporting
Services. However, Security extension API is not supported in Reporting
Services Standard Edition.
For more detailed information, you can also refer to the following article:
Using Forms Authentication in Reporting Services
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/ufairs.asp?frame=true
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================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.

Formatting within a Textbox possible?

Hi all.
Have been coming accross this same issue more and more. I am needed to take
in some HTML and print it in a TextBox so that we can render a PDF with
custom formatting.
Up until now, I've written some custom code that replaces known HTML tags
with ascii characters or line breaks, etc. But now I am required to recognize
the BOLD and ITALICS properties of fonts. As far as I know, its imposible to
set the format of text within a textbox (in line), without setting the entire
object's format. Is that correct?
The only thing I've come up with is the idea to create X amount of textboxes
that are split up and used to dynamically change formats of text. This sounds
like a huge thing to try and achieve, and I'm not sure it would even work.
Anyone have ideas, or work arounds? There is no ASCII within a fontset that
represtents the bold version that I could use?
Any idea if RS 2005 will support inline formatting like this?
Thanks,
AndreThe Program Manager for Reporting services has said this is high on the list
of needs for Reporting Services, but this did not make it into SQL 2005, but
will be in the following release...
--
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
"Arkiliknam" <Arkiliknam@.discussions.microsoft.com> wrote in message
news:8287446E-E4DD-4F90-B08D-DCEE258F9872@.microsoft.com...
> Hi all.
> Have been coming accross this same issue more and more. I am needed to
> take
> in some HTML and print it in a TextBox so that we can render a PDF with
> custom formatting.
> Up until now, I've written some custom code that replaces known HTML tags
> with ascii characters or line breaks, etc. But now I am required to
> recognize
> the BOLD and ITALICS properties of fonts. As far as I know, its imposible
> to
> set the format of text within a textbox (in line), without setting the
> entire
> object's format. Is that correct?
> The only thing I've come up with is the idea to create X amount of
> textboxes
> that are split up and used to dynamically change formats of text. This
> sounds
> like a huge thing to try and achieve, and I'm not sure it would even work.
> Anyone have ideas, or work arounds? There is no ASCII within a fontset
> that
> represtents the bold version that I could use?
> Any idea if RS 2005 will support inline formatting like this?
> Thanks,
> Andre|||Hi Wayne, thanks for the update, however do you know if it's possible or who
should be contacted in order to try to get this pushed up...possibly a
hotfix, this is something that is used in a number of reports if not all and
the workaround that was suggested above use to work prior to SP2 which
removes leading spaces therefore does not allow you to line up your "manually
formatted text" correctly. Any help in this matter is greatly appreciated.
"Wayne Snyder" wrote:
> The Program Manager for Reporting services has said this is high on the list
> of needs for Reporting Services, but this did not make it into SQL 2005, but
> will be in the following release...
> --
> 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
> "Arkiliknam" <Arkiliknam@.discussions.microsoft.com> wrote in message
> news:8287446E-E4DD-4F90-B08D-DCEE258F9872@.microsoft.com...
> > Hi all.
> >
> > Have been coming accross this same issue more and more. I am needed to
> > take
> > in some HTML and print it in a TextBox so that we can render a PDF with
> > custom formatting.
> >
> > Up until now, I've written some custom code that replaces known HTML tags
> > with ascii characters or line breaks, etc. But now I am required to
> > recognize
> > the BOLD and ITALICS properties of fonts. As far as I know, its imposible
> > to
> > set the format of text within a textbox (in line), without setting the
> > entire
> > object's format. Is that correct?
> >
> > The only thing I've come up with is the idea to create X amount of
> > textboxes
> > that are split up and used to dynamically change formats of text. This
> > sounds
> > like a huge thing to try and achieve, and I'm not sure it would even work.
> >
> > Anyone have ideas, or work arounds? There is no ASCII within a fontset
> > that
> > represtents the bold version that I could use?
> >
> > Any idea if RS 2005 will support inline formatting like this?
> >
> > Thanks,
> > Andre
>
>|||Greetings. I have the same issue. Our developers came accross a utility that
they run within their .Net code that strips off the tags but that is not what
I need. For example, the results is one big paragraph after it strips off all
<br>, etc... Is your custom code available for our use? Thanks.
Dave.Sundell@.Fiserv.Com
"Arkiliknam" wrote:
> Hi all.
> Have been coming accross this same issue more and more. I am needed to take
> in some HTML and print it in a TextBox so that we can render a PDF with
> custom formatting.
> Up until now, I've written some custom code that replaces known HTML tags
> with ascii characters or line breaks, etc. But now I am required to recognize
> the BOLD and ITALICS properties of fonts. As far as I know, its imposible to
> set the format of text within a textbox (in line), without setting the entire
> object's format. Is that correct?
> The only thing I've come up with is the idea to create X amount of textboxes
> that are split up and used to dynamically change formats of text. This sounds
> like a huge thing to try and achieve, and I'm not sure it would even work.
> Anyone have ideas, or work arounds? There is no ASCII within a fontset that
> represtents the bold version that I could use?
> Any idea if RS 2005 will support inline formatting like this?
> Thanks,
> Andre|||all my custom code does is StringReplace on a set of predefined things... and
then strips all remaining html out... nothing fancy
"Dave Sundell" wrote:
> Greetings. I have the same issue. Our developers came accross a utility that
> they run within their .Net code that strips off the tags but that is not what
> I need. For example, the results is one big paragraph after it strips off all
> <br>, etc... Is your custom code available for our use? Thanks.
> Dave.Sundell@.Fiserv.Com
> "Arkiliknam" wrote:
> > Hi all.
> >
> > Have been coming accross this same issue more and more. I am needed to take
> > in some HTML and print it in a TextBox so that we can render a PDF with
> > custom formatting.
> >
> > Up until now, I've written some custom code that replaces known HTML tags
> > with ascii characters or line breaks, etc. But now I am required to recognize
> > the BOLD and ITALICS properties of fonts. As far as I know, its imposible to
> > set the format of text within a textbox (in line), without setting the entire
> > object's format. Is that correct?
> >
> > The only thing I've come up with is the idea to create X amount of textboxes
> > that are split up and used to dynamically change formats of text. This sounds
> > like a huge thing to try and achieve, and I'm not sure it would even work.
> >
> > Anyone have ideas, or work arounds? There is no ASCII within a fontset that
> > represtents the bold version that I could use?
> >
> > Any idea if RS 2005 will support inline formatting like this?
> >
> > Thanks,
> > Andre|||I started the same thing. I am currently working on the List tags.
Thanks.
"Arkiliknam" wrote:
> Hi all.
> Have been coming accross this same issue more and more. I am needed to take
> in some HTML and print it in a TextBox so that we can render a PDF with
> custom formatting.
> Up until now, I've written some custom code that replaces known HTML tags
> with ascii characters or line breaks, etc. But now I am required to recognize
> the BOLD and ITALICS properties of fonts. As far as I know, its imposible to
> set the format of text within a textbox (in line), without setting the entire
> object's format. Is that correct?
> The only thing I've come up with is the idea to create X amount of textboxes
> that are split up and used to dynamically change formats of text. This sounds
> like a huge thing to try and achieve, and I'm not sure it would even work.
> Anyone have ideas, or work arounds? There is no ASCII within a fontset that
> represtents the bold version that I could use?
> Any idea if RS 2005 will support inline formatting like this?
> Thanks,
> Andresql

Formatting spoils when export to HTML Format

I have problem here. when I overlap two or more tables one on other and
export to PDF, it works fine. But when exported to HTML, it doesn't hold the
absolute position and renders tables sequentially.
Thanks,
JigneshThe same thing happens when you overlap charts. Charts render as images,
and are placed side-by-side in HTML rather than overlapping. I presume this
is because the HTML code required to overlap these items (charts, images,
tables), especially while maintaining appropriate transparency, would be
very complex, fragile and browser-specific.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jignesh Nakrani" <Jignesh Nakrani@.discussions.microsoft.com> wrote in
message news:068CD644-4EFF-40A6-B2D7-E86205EFC331@.microsoft.com...
>I have problem here. when I overlap two or more tables one on other and
> export to PDF, it works fine. But when exported to HTML, it doesn't hold
> the
> absolute position and renders tables sequentially.
> Thanks,
> Jignesh|||Jeff,
Thanks for the reply. Hope something comes up with the solution.
"Jeff A. Stucker" wrote:
> The same thing happens when you overlap charts. Charts render as images,
> and are placed side-by-side in HTML rather than overlapping. I presume this
> is because the HTML code required to overlap these items (charts, images,
> tables), especially while maintaining appropriate transparency, would be
> very complex, fragile and browser-specific.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Jignesh Nakrani" <Jignesh Nakrani@.discussions.microsoft.com> wrote in
> message news:068CD644-4EFF-40A6-B2D7-E86205EFC331@.microsoft.com...
> >I have problem here. when I overlap two or more tables one on other and
> > export to PDF, it works fine. But when exported to HTML, it doesn't hold
> > the
> > absolute position and renders tables sequentially.
> >
> > Thanks,
> > Jignesh
>
>

Formatted HTML input to Sql Server.

Hello,
I am having a html editor for headers and footers and would like to
pass this HTML to reporting services as a field.When i am doing this , i am
getting just the HTML (including Tags) Is there any way how to display the
html using reporting services.Not currently, no.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"kartheek via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:533FBF91F5CBD@.SQLMonster.com...
> Hello,
> I am having a html editor for headers and footers and would like to
> pass this HTML to reporting services as a field.When i am doing this , i
> am
> getting just the HTML (including Tags) Is there any way how to display the
> html using reporting services.

Format Textbox as HTML?

I am pulling some stuff from sharepoint and the text is formated as
html. Is it possible to have the textbox interpret this?This is not supported in the current release (but is on our future features
wishlist).
If you're really ambitious, you could post-process the rendered HTML to
convert < to < and > to >, thereby simulating support for this in the
HTML renderer. But that won't work for other renderers (PDF might
technically be possible to postprocess, but it would be a lot of work).
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Braden" <bluesv650@.hotmail.com> wrote in message
news:400eb9cb.0407090935.3f735bf2@.posting.google.com...
> I am pulling some stuff from sharepoint and the text is formated as
> html. Is it possible to have the textbox interpret this?

Format Expression

My client's want certain areas of my expression to be bold and also a
different color. Via HTML or CSS this would be the solution:
="<b><font color=blue>Resource(s) Name:</font></b> " &
Fields!ResourceName.Value & vbcrlf &
"<b><font color=blue>Role:</font></b> " & Fields!Role.Value & vbcrlf &
vbcrlf & "<b><font color=blue>Other Resource(s) Name:</font></b> " &
Fields!OtherResourceName.Value & vbcrlf & "<b><font color=blue>Other Resource
Role:</font></b> " & Fields!OtherResourceRole.Value
However, this does not work with SSRS. Is this something that will be
allowed in SSRS 2008 or is it possible with 2005?
--
<moojjoo/>RS 2008 is going support rich format. I have not played with the CTPs
(general pre-release software) so I am not totally firm in my head on how
this support will show itself.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Moojjoo" <Moojjoo@.discussions.microsoft.com> wrote in message
news:522D7736-6B3C-48BB-8DC7-D9147A802978@.microsoft.com...
> My client's want certain areas of my expression to be bold and also a
> different color. Via HTML or CSS this would be the solution:
> ="<b><font color=blue>Resource(s) Name:</font></b> " &
> Fields!ResourceName.Value & vbcrlf &
> "<b><font color=blue>Role:</font></b> " & Fields!Role.Value & vbcrlf &
> vbcrlf & "<b><font color=blue>Other Resource(s) Name:</font></b> " &
> Fields!OtherResourceName.Value & vbcrlf & "<b><font color=blue>Other
> Resource
> Role:</font></b> " & Fields!OtherResourceRole.Value
> However, this does not work with SSRS. Is this something that will be
> allowed in SSRS 2008 or is it possible with 2005?
> --
> <moojjoo/>|||So basically I am up the river without a paddle on what my client wants at
this time with formating the font?
--
<moojjoo/>
"Bruce L-C [MVP]" wrote:
> RS 2008 is going support rich format. I have not played with the CTPs
> (general pre-release software) so I am not totally firm in my head on how
> this support will show itself.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Moojjoo" <Moojjoo@.discussions.microsoft.com> wrote in message
> news:522D7736-6B3C-48BB-8DC7-D9147A802978@.microsoft.com...
> > My client's want certain areas of my expression to be bold and also a
> > different color. Via HTML or CSS this would be the solution:
> >
> > ="<b><font color=blue>Resource(s) Name:</font></b> " &
> > Fields!ResourceName.Value & vbcrlf &
> > "<b><font color=blue>Role:</font></b> " & Fields!Role.Value & vbcrlf &
> > vbcrlf & "<b><font color=blue>Other Resource(s) Name:</font></b> " &
> > Fields!OtherResourceName.Value & vbcrlf & "<b><font color=blue>Other
> > Resource
> > Role:</font></b> " & Fields!OtherResourceRole.Value
> >
> > However, this does not work with SSRS. Is this something that will be
> > allowed in SSRS 2008 or is it possible with 2005?
> > --
> > <moojjoo/>
>
>|||You can do things like put multiple text boxes next to each other and format
each of those (which really only works for very simple scenarios).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Moojjoo" <Moojjoo@.discussions.microsoft.com> wrote in message
news:17509CDD-B058-44DF-8DD9-004D6B027AF4@.microsoft.com...
> So basically I am up the river without a paddle on what my client wants at
> this time with formating the font?
> --
> <moojjoo/>
>
> "Bruce L-C [MVP]" wrote:
>> RS 2008 is going support rich format. I have not played with the CTPs
>> (general pre-release software) so I am not totally firm in my head on how
>> this support will show itself.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Moojjoo" <Moojjoo@.discussions.microsoft.com> wrote in message
>> news:522D7736-6B3C-48BB-8DC7-D9147A802978@.microsoft.com...
>> > My client's want certain areas of my expression to be bold and also a
>> > different color. Via HTML or CSS this would be the solution:
>> >
>> > ="<b><font color=blue>Resource(s) Name:</font></b> " &
>> > Fields!ResourceName.Value & vbcrlf &
>> > "<b><font color=blue>Role:</font></b> " & Fields!Role.Value & vbcrlf &
>> > vbcrlf & "<b><font color=blue>Other Resource(s) Name:</font></b> " &
>> > Fields!OtherResourceName.Value & vbcrlf & "<b><font color=blue>Other
>> > Resource
>> > Role:</font></b> " & Fields!OtherResourceRole.Value
>> >
>> > However, this does not work with SSRS. Is this something that will be
>> > allowed in SSRS 2008 or is it possible with 2005?
>> > --
>> > <moojjoo/>
>>|||Bruce, I totally can understand that the only problem is I have this in a
table... and they are wanting multiple items in a cell along with that
formatting I am referrring to.
--
<moojjoo/>
"Moojjoo" wrote:
> So basically I am up the river without a paddle on what my client wants at
> this time with formating the font?
> --
> <moojjoo/>
>
> "Bruce L-C [MVP]" wrote:
> > RS 2008 is going support rich format. I have not played with the CTPs
> > (general pre-release software) so I am not totally firm in my head on how
> > this support will show itself.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Moojjoo" <Moojjoo@.discussions.microsoft.com> wrote in message
> > news:522D7736-6B3C-48BB-8DC7-D9147A802978@.microsoft.com...
> > > My client's want certain areas of my expression to be bold and also a
> > > different color. Via HTML or CSS this would be the solution:
> > >
> > > ="<b><font color=blue>Resource(s) Name:</font></b> " &
> > > Fields!ResourceName.Value & vbcrlf &
> > > "<b><font color=blue>Role:</font></b> " & Fields!Role.Value & vbcrlf &
> > > vbcrlf & "<b><font color=blue>Other Resource(s) Name:</font></b> " &
> > > Fields!OtherResourceName.Value & vbcrlf & "<b><font color=blue>Other
> > > Resource
> > > Role:</font></b> " & Fields!OtherResourceRole.Value
> > >
> > > However, this does not work with SSRS. Is this something that will be
> > > allowed in SSRS 2008 or is it possible with 2005?
> > > --
> > > <moojjoo/>
> >
> >
> >|||You are out of luck. This is very common requirement which is why it is
being implemented in RS 2008.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Moojjoo" <Moojjoo@.discussions.microsoft.com> wrote in message
news:C4A3785A-A03A-4855-B524-F6E9A65D39E4@.microsoft.com...
> Bruce, I totally can understand that the only problem is I have this in a
> table... and they are wanting multiple items in a cell along with that
> formatting I am referrring to.
> --
> <moojjoo/>
>
> "Moojjoo" wrote:
>> So basically I am up the river without a paddle on what my client wants
>> at
>> this time with formating the font?
>> --
>> <moojjoo/>
>>
>> "Bruce L-C [MVP]" wrote:
>> > RS 2008 is going support rich format. I have not played with the CTPs
>> > (general pre-release software) so I am not totally firm in my head on
>> > how
>> > this support will show itself.
>> >
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "Moojjoo" <Moojjoo@.discussions.microsoft.com> wrote in message
>> > news:522D7736-6B3C-48BB-8DC7-D9147A802978@.microsoft.com...
>> > > My client's want certain areas of my expression to be bold and also a
>> > > different color. Via HTML or CSS this would be the solution:
>> > >
>> > > ="<b><font color=blue>Resource(s) Name:</font></b> " &
>> > > Fields!ResourceName.Value & vbcrlf &
>> > > "<b><font color=blue>Role:</font></b> " & Fields!Role.Value & vbcrlf
>> > > &
>> > > vbcrlf & "<b><font color=blue>Other Resource(s) Name:</font></b> " &
>> > > Fields!OtherResourceName.Value & vbcrlf & "<b><font color=blue>Other
>> > > Resource
>> > > Role:</font></b> " & Fields!OtherResourceRole.Value
>> > >
>> > > However, this does not work with SSRS. Is this something that will
>> > > be
>> > > allowed in SSRS 2008 or is it possible with 2005?
>> > > --
>> > > <moojjoo/>
>> >
>> >
>> >

Form that creates a temporal table

Hey,
I have a kind-of-newbie question.
I need to create a form that will eventually produce a report in html /
asp.
while in access that would not be a problem, I'm learning my ways
through this project in the asp world.
So, I created an access database that should hold the information
entered by the form and then the report will be just retieval of
information from it.
The thing is that the form is built in the way that you select a few
options and then click "submit" and that's one line in the database,
after you click "produce" it should take all that information you
loaded into the database and make it a report.
How will the report's query look like? how will it know what
information was enterd by that specific user at that time? is there a
way to make a temporal table that starts with the first "submit" and
ends when you click "produce" ?
Thanks,
Tomer.The answer is: primary key.
The procedure that inserts the data should return the primary key of the
newly inserted row after the insert, then you can use the primary key to
retrieve the row(s) that you want to display in the report.
In SQL 2005 this is even simpler - use the OUTPUT statement.
ML