Run report without Login

Is there any way to run a report via a URL without having the user login?

Could I provide special parameters on the url or define a user/password in the report itself?

We do NOT use active directory.

Thanks.

You can store the credentials needed for the data source access on the report server.

Check this BOL link: http://msdn2.microsoft.com/en-us/library/ms160330(SQL.90).aspx
Also check the links at the bottom of that page which describe how to manage data source credential settings via Report Manager and Management Studio.

-- Robert

|||

I have the data source setup ok - that's not what is generating the login request. It's report server itself and it's not obvious how I can get around that.

|||

Most likely, in IIS the virtual roots for /reportserver or /reports have a directory security configuration -> authentication methods different from "Integrated Windows Authentication" only. So it is really IIS asking to login - not Reporting Services.

-- Robert

|||That's it - thanks.

Rules and defaults

Hi,

Can any one provide me information on creating rules and defaults in SQL Server2005, when i tried right clicking rules or defaults in management studio instead of new option i'am getting only refresh option.

This feature was working smoothly in sql2000.....I'am trying this on Microsoft SQL Server2005 Standard Edition.

thanks in advance

Mat

Rules and defaults are deprecated in 2005. You should now use constraints, which you define in the table designer. Rules and defaults are still supported, but you have to create them manually by writing the code yourself. You cannot create them in Management Studio because you should not be using them any more.

This comes from the 2000 documentation
"Rules are a backward-compatibility feature that perform some of the same functions as CHECK constraints. CHECK constraints are the preferred, standard way to restrict the values in a column."
"Defaults, a backward compatibility feature, perform some of the same functions as default definitions created using the DEFAULT keyword of ALTER or CREATE TABLE statements. Default definitions are the preferred, standard way to restrict column data because the definition is stored with the table and automatically dropped when the table is dropped."

And this from the 2005 documentation
"CREATE RULE will be removed in a future version of Microsoft SQL Server. Avoid using CREATE RULE in new development work, and plan to modify applications that currently use it. We recommend that you use check constraints instead."
"CREATE DEFAULT will be removed in a future version of Microsoft SQL Server. Avoid using CREATE DEFAULT in new development work, and plan to modify applications that currently use it. Instead, use default definitions created using the DEFAULT keyword of ALTER TABLE or CREATE TABLE."

RTF/GIF/JPEG Report Export

Hi,
I want to provide the functionality for exporting reports to rtf/gif/jpeg
from the html report viewer. How do I do that? Is it possible to add/remove
formats from the export list on the reportviewer.
Thanking you,
Jd.Please see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_security_87oi.asp
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:FE43C3CD-DEAE-41E9-8C7E-500CF4129B1F@.microsoft.com...
> Hi,
> I want to provide the functionality for exporting reports to rtf/gif/jpeg
> from the html report viewer. How do I do that? Is it possible to
add/remove
> formats from the export list on the reportviewer.
> Thanking you,
> Jd.