No Login Required

Is it possible to create a folder of reports that do not require a log
in to execute? I would like to be able to put specific reports in a
open folder so that people can run them without login.
Thanks
BobOn May 4, 12:12 pm, Bob <b...@.ebearings.com> wrote:
> Is it possible to create a folder of reports that do not require a log
> in to execute? I would like to be able to put specific reports in a
> open folder so that people can run them without login.
> Thanks
> Bob
You can select the folder, then press properties> Security. You can
add users there. There is a catch though because different Reporting
Servers work in different ways. Now, my company uses Windows Login
for the Reporting Server. Previously, this was separate and everyone
had a separate account for RptServ, SQLServ, and all other tools.
Just add the users under the security tab, make sure they're BROWSERS
otherwise you may go back to the folder and find it... blank.|||On May 4, 11:34 am, Ayman <ayma...@.gmail.com> wrote:
> On May 4, 12:12 pm, Bob <b...@.ebearings.com> wrote:
> > Is it possible to create a folder of reports that do not require a log
> > in to execute? I would like to be able to put specific reports in a
> > open folder so that people can run them without login.
> > Thanks
> > Bob
> You can select the folder, then press properties> Security. You can
> add users there. There is a catch though because different Reporting
> Servers work in different ways. Now, my company uses Windows Login
> for the Reporting Server. Previously, this was separate and everyone
> had a separate account for RptServ, SQLServ, and all other tools.
> Just add the users under the security tab, make sure they're BROWSERS
> otherwise you may go back to the folder and find it... blank.
Thanks, but right when I iopen my browser on my desktop and point to
the folder, I get login required. I am actually trying t use the
following logic and not even go to the report server.
http://rpt-serv/ReportServer?/sales%2fC+of+C&shipnum=2022222&rs:Format=PDF
If I put this in a browser, I can get my report output in .pdf format,
without going to the webpage. I would just like to retreive this
report without stopping for a login prompt. If I could do that, then
I can write a front end prompt in my app.
Enter ship number [1234544]
Make sense?
Bob
http://rpt-serv/ReportServer?/sales%2fC+of+C&shipnum=[variable
ship_no]&rs:Format=PDF|||On May 4, 12:56 pm, Bob <b...@.ebearings.com> wrote:
> On May 4, 11:34 am, Ayman <ayma...@.gmail.com> wrote:
>
> > On May 4, 12:12 pm, Bob <b...@.ebearings.com> wrote:
> > > Is it possible to create a folder of reports that do not require a log
> > > in to execute? I would like to be able to put specific reports in a
> > > open folder so that people can run them without login.
> > > Thanks
> > > Bob
> > You can select the folder, then press properties> Security. You can
> > add users there. There is a catch though because different Reporting
> > Servers work in different ways. Now, my company uses Windows Login
> > for the Reporting Server. Previously, this was separate and everyone
> > had a separate account for RptServ, SQLServ, and all other tools.
> > Just add the users under the security tab, make sure they're BROWSERS
> > otherwise you may go back to the folder and find it... blank.
> Thanks, but right when I iopen my browser on my desktop and point to
> the folder, I get login required. I am actually trying t use the
> following logic and not even go to the report server.http://rpt-serv/ReportServer?/sales%2fC+of+C&shipnum=2022222&rs:Forma...
> If I put this in a browser, I can get my report output in .pdf format,
> without going to the webpage. I would just like to retreive this
> report without stopping for a login prompt. If I could do that, then
> I can write a front end prompt in my app.
> Enter ship number [1234544]
> Make sense?
> Bobhttp://rpt-serv/ReportServer?/sales%2fC+of+C&shipnum=[variable
> ship_no]&rs:Format=PDF
I understand, you want the entire ReportServer not to have a login.
Here our's is passed through by Windows Accounts... so we never get
the login screen. Our DBA is out, I'll try to figure it out with him
on Monday and let you know. I'm sure if you can do a Windows
Authentication pass then there is a way to just keep it open to anyone
who is on your Intranet.|||On May 4, 12:11 pm, Ayman <ayma...@.gmail.com> wrote:
> On May 4, 12:56 pm, Bob <b...@.ebearings.com> wrote:
>
>
> > On May 4, 11:34 am, Ayman <ayma...@.gmail.com> wrote:
> > > On May 4, 12:12 pm, Bob <b...@.ebearings.com> wrote:
> > > > Is it possible to create a folder of reports that do not require a log
> > > > in to execute? I would like to be able to put specific reports in a
> > > > open folder so that people can run them without login.
> > > > Thanks
> > > > Bob
> > > You can select the folder, then press properties> Security. You can
> > > add users there. There is a catch though because different Reporting
> > > Servers work in different ways. Now, my company uses Windows Login
> > > for the Reporting Server. Previously, this was separate and everyone
> > > had a separate account for RptServ, SQLServ, and all other tools.
> > > Just add the users under the security tab, make sure they're BROWSERS
> > > otherwise you may go back to the folder and find it... blank.
> > Thanks, but right when I iopen my browser on my desktop and point to
> > the folder, I get login required. I am actually trying t use the
> > following logic and not even go to the report server.http://rpt-serv/ReportServer?/sales%2fC+of+C&shipnum=2022222&rs:Forma...
> > If I put this in a browser, I can get my report output in .pdf format,
> > without going to the webpage. I would just like to retreive this
> > report without stopping for a login prompt. If I could do that, then
> > I can write a front end prompt in my app.
> > Enter ship number [1234544]
> > Make sense?
> > Bobhttp://rpt-serv/ReportServer?/sales%2fC+of+C&shipnum=[variable
> > ship_no]&rs:Format=PDF
> I understand, you want the entire ReportServer not to have a login.
> Here our's is passed through by Windows Accounts... so we never get
> the login screen. Our DBA is out, I'll try to figure it out with him
> on Monday and let you know. I'm sure if you can do a Windows
> Authentication pass then there is a way to just keep it open to anyone
> who is on your Intranet.- Hide quoted text -
> - Show quoted text -
Thanks, I appreciate it.|||On May 4, 1:25 pm, Bob <b...@.ebearings.com> wrote:
> On May 4, 12:11 pm, Ayman <ayma...@.gmail.com> wrote:
>
> > On May 4, 12:56 pm, Bob <b...@.ebearings.com> wrote:
> > > On May 4, 11:34 am, Ayman <ayma...@.gmail.com> wrote:
> > > > On May 4, 12:12 pm, Bob <b...@.ebearings.com> wrote:
> > > > > Is it possible to create a folder of reports that do not require a log
> > > > > in to execute? I would like to be able to put specific reports in a
> > > > > open folder so that people can run them without login.
> > > > > Thanks
> > > > > Bob
> > > > You can select the folder, then press properties> Security. You can
> > > > add users there. There is a catch though because different Reporting
> > > > Servers work in different ways. Now, my company uses Windows Login
> > > > for the Reporting Server. Previously, this was separate and everyone
> > > > had a separate account for RptServ, SQLServ, and all other tools.
> > > > Just add the users under the security tab, make sure they're BROWSERS
> > > > otherwise you may go back to the folder and find it... blank.
> > > Thanks, but right when I iopen my browser on my desktop and point to
> > > the folder, I get login required. I am actually trying t use the
> > > following logic and not even go to the report server.http://rpt-serv/ReportServer?/sales%2fC+of+C&shipnum=2022222&rs:Forma...
> > > If I put this in a browser, I can get my report output in .pdf format,
> > > without going to the webpage. I would just like to retreive this
> > > report without stopping for a login prompt. If I could do that, then
> > > I can write a front end prompt in my app.
> > > Enter ship number [1234544]
> > > Make sense?
> > > Bobhttp://rpt-serv/ReportServer?/sales%2fC+of+C&shipnum=[variable
> > > ship_no]&rs:Format=PDF
> > I understand, you want the entire ReportServer not to have a login.
> > Here our's is passed through by Windows Accounts... so we never get
> > the login screen. Our DBA is out, I'll try to figure it out with him
> > on Monday and let you know. I'm sure if you can do a Windows
> > Authentication pass then there is a way to just keep it open to anyone
> > who is on your Intranet.- Hide quoted text -
> > - Show quoted text -
> Thanks, I appreciate it.
Sorry for the late reply, this may help:
http://odetocode.com/Articles/216.aspxsql

No Data Returned for report

Hi,

In RS 2005, if a specific query does not return any rows, the table also is not displayed in the report.

Is there any way to get around this and show an empty table?

Manish

Hi,

select all the cells and in the properties make "borderstyle" - "Solid"

and select the table and make same as above in the properties.

you can see the empty table.

Amarnath

|||

One option is to set the "NoRows" property of the table. You can also apply styles to that message.

-- Robert

|||

This is correct but only if the table has a Header or Footer row.

If the dataset associated with a table returns no data, and there is no "NoRows" message specified for the table, AND if there is a header or footer, the table will be shown.

-chris

no case statement in views + sql 7

I have a query which will be a subquery that I want to use a case statement on. (It is an outer join and I want to substitue nulls for a specific value.) I can make it work in query analyzer and can also make it work in a stored procedure, but I get a message that the case statement is not supported in views. So, I tried to make a function ,but they are not supported in SQL 7, and apparently stored procedures cannot be called inline in views, either. I can retrieve the desired recordset with exec sp_name, but I need the recordset to be used in another query and cannot figure out how to use the results from a Stored procedure as a subquery in a view. Any help is greatly appreciated.

Thanks,

Tman2Case statements are supported in views, but the GUI query designer built into Enterprise Manager cannot parse and graphically display statements using CASE. You can write your query using the Query Analyzer tool instead (no serious TSQL programmer uses the GUI).
Regardless, you do not need a CASE statement to substitute NULL for a specific value. Use the NULLIF() function instead.|||I was able to create a view in query designer that uses case, but it does not function correctly. (It defaults all values to 0). However, if I use the exact same SQL statement in query designer without it being a view, it works. (ie. create view sQL statement to create view, select * from view produces erroneous results, but SQL statement in query designer works.)

I will try the nullif function you mentioned, but htat will only work for this particular cases, and there will be many instances where I will need the case statement. Any ideas what to do? This only seems to be causing a problem in SQL 7, not the newer versions...|||Post your code if you want somebody here to review it. There could be a problem with default connection settings in Query Analyzer. The SET CONCAT NULL option, for instance, has bitten me several times...|||It probably is something like that. WHEN NULL was not identifying nulls as nulls. Any ideas, or this there something wrong with my syntax (ie must use isnull like in VB)? Thanks for all your help. I have it working now, (really can just use isnull without the case statement at all) but for academic purposes, I would be intrested to know if there is an option that changes this. I did a little research on the option you pointed out above, what a #!@.* that must have been to find...

Thanks again.