n00b question - permissions from website

Hi everyone,

I've inherited a website based on the dotnetnuke frameowork.

this website also uses the reporting services from sqlserver.

When the report button is clicked in the website, the user is prompted

with a login and password (standard windows dialog)

Entering the username/password for the web site fails,

entering username/password for the machine works.

The user - of course - doesn't want to enter enything, let alone see the darn dialog box,

just wants to see the report on the screen.

Does anyone have any ideas on where to start looking for a solution to this problem?

thanks

tony

The settings for the permissions of the report service are in the service's properties in IIS settings in control panel -> administrative tools. You might be able to set it to use the same password as the rest of the website there.

My report wont work :-) with a date param

Hi All,
I have inherited a report that at the Dataset level works fine. It takes a
date param eg. 02-Dec-2005 and returns 3 rows as I would expect.
The report page has the date param defined as Datetime and when I enter the
date ie. 02-Dec-2005 it returns 0 rows. I have tried inputting different date
formats
to no avail. kinda puzzled.
Any clues as to the cause of the problem.
Thanx in advancewell,i had kind of this problem.
I never use parm as datetime always as string and inside the dataset i use
CONVERT(datetime,@.FromTime,103) it works 4 me...
"Scotchy" wrote:
> Hi All,
> I have inherited a report that at the Dataset level works fine. It takes a
> date param eg. 02-Dec-2005 and returns 3 rows as I would expect.
> The report page has the date param defined as Datetime and when I enter the
> date ie. 02-Dec-2005 it returns 0 rows. I have tried inputting different date
> formats
> to no avail. kinda puzzled.
> Any clues as to the cause of the problem.
> Thanx in advance
>|||It sounds to me like your query parameter is not hooked up to your report
parameter. In the dataset click on the ..., parameters tab. Your query
parameters should be listed on the left and the report parameter they map to
on the right.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scotchy" <Scotchy@.discussions.microsoft.com> wrote in message
news:B64FE999-9EA6-40C0-896E-984BBDC4BDC4@.microsoft.com...
> Hi All,
> I have inherited a report that at the Dataset level works fine. It takes a
> date param eg. 02-Dec-2005 and returns 3 rows as I would expect.
> The report page has the date param defined as Datetime and when I enter
> the
> date ie. 02-Dec-2005 it returns 0 rows. I have tried inputting different
> date
> formats
> to no avail. kinda puzzled.
> Any clues as to the cause of the problem.
> Thanx in advance
>|||Thanks Bruse, but no, all params are mapped as required. Something else going
on here I think, might try a string param instead , although Ive not had this
issue before in Date param'd reps. Guess thats the problem when inheriting
others work. Thanx for your and others input. Much appreciated
"Bruce L-C [MVP]" wrote:
> It sounds to me like your query parameter is not hooked up to your report
> parameter. In the dataset click on the ..., parameters tab. Your query
> parameters should be listed on the left and the report parameter they map to
> on the right.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Scotchy" <Scotchy@.discussions.microsoft.com> wrote in message
> news:B64FE999-9EA6-40C0-896E-984BBDC4BDC4@.microsoft.com...
> > Hi All,
> >
> > I have inherited a report that at the Dataset level works fine. It takes a
> > date param eg. 02-Dec-2005 and returns 3 rows as I would expect.
> >
> > The report page has the date param defined as Datetime and when I enter
> > the
> > date ie. 02-Dec-2005 it returns 0 rows. I have tried inputting different
> > date
> > formats
> > to no avail. kinda puzzled.
> >
> > Any clues as to the cause of the problem.
> >
> > Thanx in advance
> >
>
>