Report Builder not appearing in Report Server 2005 Web page

I have provided required permissions, still user not able to view report builder option in his console.

what could be wrong? what needs to be done to provide report builder to users.

Deleep P

Please review the link below and let us know if this fixes your issue.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1697246&SiteID=1

|||

Thanks for that hint. I have an issue now regarding rights of system users. Now they have delete rights from Root directory. What needs to be done to avert this. I want system user be able to only modify his folders and contents.

Deleep P

|||

Double-click on My Computer, right-click on the root-drive in question and select properties and then select the security tab. Highlight the Users group [ ex: Users(Servername\Users) ] ensure that only the Special Permission box has a checkmark in it. Then click on the Advanced button and this will bring you to the permission tab where you can specify the rights you wish your users to have on the root drive.

|||

I think i misled you, after opening the webpage as follows "http://<report_server _ip>/reports " I get "HOME' page. Here i am creating folders. My intention is to create separate directories in the name of different teams first. Then provide complete access to the team within their folder. One team should not delete the folder created for another team from the home page. currently for all report server users i have given "System user" access through site SITE SETTING IN THE HOME PAGE. After clicking on the SITE SETTINGS I selected configure site wide security and provided "system user" rights to all report server users. Plus all users will have "folder view" rights on the HOME folder. this is provided through HOME PAGE, PROPERTIES, SECURITY, NEW ROLE ASSIGNMENT.

Report Builder not appearing in Report Server 2005 Web page

I have provided required permissions, still user not able to view report builder option in his console.

what could be wrong? what needs to be done to provide report builder to users.

Deleep P

Please review the link below and let us know if this fixes your issue.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1697246&SiteID=1

|||

Thanks for that hint. I have an issue now regarding rights of system users. Now they have delete rights from Root directory. What needs to be done to avert this. I want system user be able to only modify his folders and contents.

Deleep P

|||

Double-click on My Computer, right-click on the root-drive in question and select properties and then select the security tab. Highlight the Users group [ ex: Users(Servername\Users) ] ensure that only the Special Permission box has a checkmark in it. Then click on the Advanced button and this will bring you to the permission tab where you can specify the rights you wish your users to have on the root drive.

|||

I think i misled you, after opening the webpage as follows "http://<report_server _ip>/reports " I get "HOME' page. Here i am creating folders. My intention is to create separate directories in the name of different teams first. Then provide complete access to the team within their folder. One team should not delete the folder created for another team from the home page. currently for all report server users i have given "System user" access through site SITE SETTING IN THE HOME PAGE. After clicking on the SITE SETTINGS I selected configure site wide security and provided "system user" rights to all report server users. Plus all users will have "folder view" rights on the HOME folder. this is provided through HOME PAGE, PROPERTIES, SECURITY, NEW ROLE ASSIGNMENT.

Report Builder Date Range Filter

When selecting From To date range filter you can no longer choose
prompt for input. Why is this? Is there a fix for it.
I can replicate the required functionality by using On or Before and On
or After but it seems a bit messy.
Regards
TobiThis is a known issue and is under consideration to be fixed in a future
release.
"Tobi" wrote:
> When selecting From To date range filter you can no longer choose
> prompt for input. Why is this? Is there a fix for it.
> I can replicate the required functionality by using On or Before and On
> or After but it seems a bit messy.
> Regards
> Tobi
>

Report Builder - A filter is required

Using Report Builder, I am querying a table that has:

85,000 rows
5 columns

The report will run with only 4 of the columns, but when I add the 5th (data type is nvarchar(1024)), I get an error message that says:

Cannot run this report.
A filter must be specified.

When I add a filter on that 5th column, it will run.

Does anyone know if there is a record limit in Report Builder? Is there some sort of governor that I can modify?

Thanks in advance!I think I figured this out. The entity in my model had a property called "InstanceSelection" with the value of "MandatoryFilter." I cannot completely explain what this property does, but I changed the value to "List" and fixed the problem.

I don't know why the filter was mandatory only when the 5th column was there.

report as side by side records display

I want to generate a report for information related to different libraries. It is required to print two library information (two records) side by side in a page. I do not know how to do so.like

libraray name: abc libraray name: abc
address: abc address:abc
phone:30 phone:abc

best regards
kashifIf there is a link between these table, then u can use linking concept and retrieve data from any of the tables.

If not, try to look at the sub reports concept. May be helpful to you.