Forms Authentication and Unattended Report Execution

I have implemented forms authentication security extension as described in the MSDN whitepaper "Using Forms Authentication in Reporting Services" and it works fine. However, I ran into problems trying to create scheduled execution snapshot for a report when it fails with unable to authenticate. How do I configure RS to authenticate for unattended execution with forms authentication?

Thanks,Please disregard this one. Stopping and restarting the ReportServerService resolved the issue.

Forms Authentication and Unattended Report Execution

I have implemented forms authentication security extension as described in the MSDN whitepaper "Using Forms Authentication in Reporting Services" and it works fine. However, I ran into problems trying to create scheduled execution snapshot for a report when it fails with unable to authenticate. How do I configure RS to authenticate for unattended execution with forms authentication?

Thanks,Please disregard this one. Stopping and restarting the ReportServerService resolved the issue.sql

formatting output

Hi, I am running a script which inserts certain rows into a table and at the end of the execution, I do a select statement to show the inserted data as output in the results pane and it is showing as truncated...How can I show the full results..
Here is my script to show the results.
----
SET NOCOUNT ON
DECLARE @.errorCount INT
SELECT @.errorCount = COUNT(*) FROM error_report WHERE id != - 2 AND id != - 5
IF @.errorCount = 0
BEGIN
INSERT INTO error_report VALUES( '' , - 1 , 'No error found.' )
END
INSERT INTO error_report VALUES( '' , - 2 , 'The Report was generated on ' + CAST(CONVERT(VARCHAR(23), GETDATE(), 1) AS VARCHAR) )
GO
SELECT table_name + ' table has bad data at id = ' + CAST(CONVERT(VARCHAR(23), id) AS VARCHAR) + ' (' + CAST(reason AS VARCHAR) + ')'FROM error_report WHERE id > 0
SELECT table_name + ' table has bad data (' + CAST(reason AS VARCHAR) + ')' FROM error_report WHERE id = 0
SELECT reason FROM error_report WHERE id = - 1
SELECT ''
SELECT reason FROM error_report WHERE id = - 2
SET NOCOUNT OFF
GO
--------
The Results in the bottom pane looks like this below
------
NODETABLE table has bad data (There are 2 duplicate subclass)
Propertytable table has bad data (at Parentid = 2000000859 and p)
Propertytable table has bad data (at Parentid = 10122 and proper)
------
But, when I do a select, they are like this below
--

NODETABLE 0 There are 2 duplicate subclass name: Specification
Propertytable 0 at Parentid = 2000000859 and propertyid = 721
Propertytable 0 at Parentid = 10122 and propertyid = 9That sounds like a grid limitation to me. I'd suggest Ctrl-T to set text mode, then Ctrl-E to execute the query again.

-PatP|||Hi Pat,
It outputted in the text format but the results are the same. However when I do select statement, it is fine.|||You need to explicitly specify the size for VARCHAR fields.|||Hi LOOKING AT THE ABOVE CODE, CAN YOU TELL ME WHERE IT IS?|||For example, here:

'The Report was generated on ' + CAST(CONVERT(VARCHAR(23), GETDATE(), 1) AS VARCHAR(8)) )

But you also don't need that CAST.

'The Report was generated on ' + CONVERT(VARCHAR(8), GETDATE(), 1)

Format parameter comboboxes shown before report execution

Dear all
is there a way to control the parameter comboboxes shown before report
execution? I do not like that the comboboxes show different length and I want
to change it.
I know that I can add and drop parameters in the report --> report
parameters menu, but I did not find a way how to control the format.
Regards,
MarcHi Marc,
Thank you for using MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You want to
change the length of the parameter textbox of the Report Layout. If I
misunderstood your concern, please feel free to let me know.
Based on my scope, you could not change the length of the textbox. Thank
you for taking the time to provide feedback on this product. We are very
interested in your thoughts and opinions for improvements that we can make
to provide the features and functionality you and your customers would like
to see.
To provide your feedback directly to the product groups:
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Thanks a lot!
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 wrote:
> Hi Marc,
> Thank you for using MSDN Managed Newsgroup Support.
> From your description, my understanding of this issue is: You want to
> change the length of the parameter textbox of the Report Layout. If I
> misunderstood your concern, please feel free to let me know.
> Based on my scope, you could not change the length of the textbox. Thank
> you for taking the time to provide feedback on this product. We are very
> interested in your thoughts and opinions for improvements that we can make
> to provide the features and functionality you and your customers would like
> to see.
>
> To provide your feedback directly to the product groups:
> http://lab.msdn.microsoft.com/productfeedback/default.aspx
> Thanks a lot!
> 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,
we did a big effort to get additional buttons into the parameter frame
that links to our own parameter windows as calendar in RS2000 as well
as a complete portfolio tree. The result will be written back into the
standard parameter combox.
It would be very helpful, if the WEBReportViewerControl of SSRS2005
would offer an .net programmable interface the add other parameter,
buttons, styles etc. - especially for the PARAMETER Frame (that in
RS2005 seems to be integrated in the WebReportViewControl).
That would make RS2005 more or less perfect. :-)
regards
BB|||Hi Bruce,
Thank you for your great suggestion.
You could provide your feedback to our product team directly.
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Thank you for taking the time to provide feedback on this product.
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 Wei, Hello Bruce
Thanks for your feedback - I placed this issue in Microsoft Connect -
Microsoft consider this feature to implement in a future release.
Best Regards
Marc|||Hi Marc,
Thank you for your feedback. If you have any questions or concerns, please
feel free to let me know!
Have a nice day!
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.