We have Sql reports in a server and I have permission to open the report in Browser. I am showing the sql report in content editor web part in SharePoint2007 site. Now, In my browser, if I have Security settings User Authentication as ‘Automatic logon with Username and password’, then my report generates fine in content editor web part. But, In my browser, if I have Security settings User Authentication as ‘Prompt for User Name and Password', then my report does not get generates in content editor web part. It is showing empty in content editor web part.