Qury regarding SQl Reporting services 2005(Authentication Problem)

Hi experts,
I have some questions on Sql server reporting services 2005.
First one is that on my report server there are some reports for which
i want to remove authentication
i.e. Any body can run those reports without giving any user name and
password, How i can do this please tell me.
Second thing is
For multiple selection, how to implement it because previously i was
working on SSRS 2000
I can show now multipple selection check list boxes now but in quert
how i can implement that
in query i wrote like this
Select * from Table where
City like @.Dataset2
But when i select multiple parameters for city it is giving error
if i select one parameter then it is running fine
So please tell me how to do these.
Thanks & Regards
DineshOn Mar 18, 2:51 pm, "Dinesh" <dinesh...@.gmail.com> wrote:
> Hi experts,
> I have some questions on Sql server reporting services 2005.
> First one is that on my report server there are some reports for which
> i want to remove authentication
> i.e. Any body can run those reports without giving any user name and
> password, How i can do this please tell me.
> Second thing is
> For multiple selection, how to implement it because previously i was
> working on SSRS 2000
> I can show now multipple selection check list boxes now but in quert
> how i can implement that
> in query i wrote like this
> Select * from Table where
> City like @.Dataset2
> But when i select multiple parameters for city it is giving error
> if i select one parameter then it is running fine
> So please tell me how to do these.
> Thanks & Regards
> Dinesh
To remove report authentication (on a report-by-report basis), select
a report in the Report Manager, then select the Properties tab and
select the very bottom radio button that says 'Credentials are not
required' and then 'Apply.'
Something like the below query should work for the multi-select
parameter:
--CREATE PROC SomeProc
DECLARE
@.CityList VARCHAR(MAX)
--AS
DECLARE @.CityListBuffer VARCHAR(MAX),
@.END_POSITION INT;
--TEST DATA--
SET @.CityList = 'Chicago, New York, Miami, San Diego, Los Angeles,
Nashville';
--TEST DATA--
CREATE TABLE #CityList (City INT);
SET @.CityListBuffer = @.CityList;
WHILE (LEN(@.CityListBuffer) > 0)
BEGIN
IF (CHARINDEX(',', @.CityListBuffer) > 0)
BEGIN
SET @.END_POSITION = CHARINDEX(',', @.CityListBuffer);
INSERT INTO #CityList VALUES (SUBSTRING(@.CityListBuffer, 1,
(@.END_POSITION - 1)));
END
IF (CHARINDEX(',', @.CityListBuffer) = 0)
BEGIN
SET @.END_POSITION = LEN(@.CityListBuffer);
INSERT INTO #CityList VALUES (SUBSTRING(@.CityListBuffer, 1,
(@.END_POSITION + 1)));
END
SET @.CityListBuffer = RIGHT(@.CityListBuffer, (LEN(@.CityListBuffer)
- @.END_POSITION));
END
SELECT * FROM TABLE WHERE CITY IN (SELECT City FROM #CityList)
DROP TABLE #CityList;
You may have to change the charindexes above for a different delimiter
(i.e., ''',''' for strings, etc); but it should work.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||On Mar 19, 4:25 pm, "EMartinez" <emartinez...@.gmail.com> wrote:
> On Mar 18, 2:51 pm, "Dinesh" <dinesh...@.gmail.com> wrote:
>
>
> > Hi experts,
> > I have some questions on Sql server reporting services 2005.
> > First one is that on my report server there are some reports for which
> > i want to remove authentication
> > i.e. Any body can run those reports without giving any user name and
> > password, How i can do this please tell me.
> > Second thing is
> > For multiple selection, how to implement it because previously i was
> > working on SSRS 2000
> > I can show now multipple selection check list boxes now but in quert
> > how i can implement that
> > in query i wrote like this
> > Select * from Table where
> > City like @.Dataset2
> > But when i select multiple parameters for city it is giving error
> > if i select one parameter then it is running fine
> > So please tell me how to do these.
> > Thanks & Regards
> > Dinesh
> To remove report authentication (on a report-by-report basis), select
> a report in the Report Manager, then select the Properties tab and
> select the very bottom radio button that says 'Credentials are not
> required' and then 'Apply.'
> Something like the below query should work for the multi-select
> parameter:
> --CREATE PROC SomeProc
> DECLARE
> @.CityList VARCHAR(MAX)
> --AS
> DECLARE @.CityListBuffer VARCHAR(MAX),
> @.END_POSITION INT;
> --TEST DATA--
> SET @.CityList = 'Chicago, New York, Miami, San Diego, Los Angeles,
> Nashville';
> --TEST DATA--
> CREATE TABLE #CityList (City INT);
> SET @.CityListBuffer = @.CityList;
> WHILE (LEN(@.CityListBuffer) > 0)
> BEGIN
> IF (CHARINDEX(',', @.CityListBuffer) > 0)
> BEGIN
> SET @.END_POSITION = CHARINDEX(',', @.CityListBuffer);
> INSERT INTO #CityList VALUES (SUBSTRING(@.CityListBuffer, 1,
> (@.END_POSITION - 1)));
> END
> IF (CHARINDEX(',', @.CityListBuffer) = 0)
> BEGIN
> SET @.END_POSITION = LEN(@.CityListBuffer);
> INSERT INTO #CityList VALUES (SUBSTRING(@.CityListBuffer, 1,
> (@.END_POSITION + 1)));
> END
> SET @.CityListBuffer = RIGHT(@.CityListBuffer, (LEN(@.CityListBuffer)
> - @.END_POSITION));
> END
> SELECT * FROM TABLE WHERE CITY IN (SELECT City FROM #CityList)
> DROP TABLE #CityList;
> You may have to change the charindexes above for a different delimiter
> (i.e., ''',''' for strings, etc); but it should work.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer- Hide quoted text -
> - Show quoted text -
Hi Enrique,
I have tried what you suggested for removing the authentication but
after doing like that report is not rendring it is showng error that
credential is not set.
So please tell what to do... This i done for a single report only
suppoese if i want to remove authentication from my report server it
self then what to do, how i can implement that.
Regards
Dinesh