.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

save reports in Private and Public folder using Report Builder 2.0

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server
 

Hi,

 

I have a report builder built on RB2.0. Users are able to create their reports and browse them.

Now, Users wants these reports to be saved in their Private folder and public folder.

 

Also, I have a UI developed in .Net 3.5 from where I am calling this report builder.  In the UI, I need to show the users those reports that they have created in a drop down list. And when the user clicks on any report (that they created should) open.

 

I have searched a lot but not getting any clue how to allow the business user to save a report


View Complete Post


More Related Resource Links

Report Builder 2.0: duplicate rows do not show on reports

  
Hello,Created a report using a report model.the problem is that duplicate rows do not show on the report.Why?And also how can this be fixed?the report shows product ids, that may or may not have serial numbersticket numbers can have mulitple products associated with them and they may or may not have serial numbersthe report data row is as follows:example:order number, ticket number, product id, manufacturer id, serial number123                  456               dsl_router 12  cisco123                  456               dsl_router 12  ciscothe above data shows as one row on the report, thus, showing it to be one product, but really there are 2 products and there should be 2 rows.is this a bug?how can this be fixed?Thanks.

Report Builder 3.0 issue - can view existing rdl files but cannot create new reports

  
I have Report Builder 3.0 deployed on my local machine pointing to a remote SQL Server 2008 R2 instance outside of my local domain.  Within this local Report Builder 3.0 instance I am able to open up previously created rdl files from the remote SQL Server 2008 R2 instance that I am connecting to.  However, if I try to create a new report on my local instance of Report Builder 3.0 and attempt to use the same data source as was used to create these existing rdl files, I receive the error: "Unable to connect to data source. The user credentials provided in the connection string do not have permission to connect to Reporting Services."  So why can I open existing rdl files from this remote SQL Server 2008 R2 instance, but not create new ones even though I'm using the same data source as the existing rdl files?  Thanks, Mark

I'm getting exception while running Report builder 2.0 for SSRS Reports

  
Hi,
I'm getting Exception like Failed to Preview Report "The request failed with HTTP status 401: Unauthorized." for SSRS Reports from Report Builder 2.0 application? May i know the reason?
Also please inform any other way to Preview Reports On SSRS through Report Builder.?

Note : I'm Using the Report Server as remote machine.

sunmoon_1411

Copy reports to a different folder on Report Server

  

My report server has 2 folders: ProductionReports - about 50 reports AND TestReports - 0 reports

I want to copy all the reports from Production to Test. One method is to save each Prodcution .rdl then upload each one to Test and then change its datasource. This will take a long time!!!! Is there a way and can copy them all together and then go change their data source? I am hesitant to deploy the reports from VS because I don't know if the project has the correct report versions (it is not my server).

Is there an easier way to do this? Thanks!!!! Linda

 

 

 


Report Builder 3.0 renders empty page for Reports with Matrix (column group) in Landscape orientatio

  

I need some help.

 

If I create a Report with a Matrix Tablix (with row Groups and column groups) in landscape layout and preview it in print layout, the report generates me some extra empty page every 2nd page.

I don't understand the rule, why it's doing that.

 

My Report settings are:

  • PageSize: width: 29.7 cm, height: 21 cm
  • InteractiveSize: width: 29.7cm, height: 21 cm
  • Margins : 0cm,0cm,0cm,0cm
  • Report Body : widht: 25cm, height: 10cm

According my Report settings this shouldn't happen, should it. The width of my Tablix is max 22cm.

What I noticed is, that when I shrink the width of my Report Body to 21 cm (to the width of the portrait layout) or less, the emtpy pages disappear.

Or when I delete the column group, it also renders the report without some empty pages.

I think this problem has something to do with column groups.

 

Is this a bug or am I missing a setting?


SSRS - Subscriptions - Can I tell a report substription to save the report to a specfic folder based

  

Version: SQL Server 2008 R2 Standard - SQL Reporting Services

SSRS - Subscriptions - Can I tell a report substription to save the report to a specfic folder based on a field value in the report?

The report has a field called TestID. This value changes everytime the report runs for a new Test. For each new Test, I want to be able to save the report to a folder on my C drive that represents the TestID being processed. When you choose "Save to File System" you have the option of specifiying a location. Can that location be changed based on the TestID of the report being generated? Something like, "C:\MyReports\" + @TestID + "\".


SSRS - Subscriptions - Can I tell a report substription to save the report to a specfic folder based

  

SSRS - Subscriptions - Can I tell a report substription to save the report to a specfic folder based on a field value in the report?

The report has a field called TestID. This value changes everytime the report runs for a new Test. For each new Test, I want to be able to save the report to a folder on my C drive that represents the TestID being processed. When you choose "Save to File System" you have the option of specifiying a location. Can that location be changed based on the TestID of the report being generated? Something like, "C:\MyReports\" + @TestID + "\".


Report Builder 3.0 Can NOT see 2005 built reports, report models or datasource

  

We have 2005 bids but have installed 3.0,  thought I would be able to use datasources and report models and retrieve RDL for review or changes.  Is this possible?  I sort of understand that If I want to republish these reports it would have to be on an 2008 installed instance of visial studio.

How far off am I and can any help or point me in the right direction,

Thanks in advance,

Terry


Reports designed with Report Builder 3

  

Hi everybody,

I develop some reports using Report Builder 3 on my Reports Server.
I would like to know where are my reports rdl saved when I save them on the portal?

Thanks

Pierre


SSRS 2008 R2 and sharepoint 2007 report builder problems

  

I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu


Report Builder in sharepoint is not working.

  

Hi,

We are using below Topology in production
Topology is 3 servers:
Sever1: Sharepoint Form (wss3.0 no MOSS)
Sever2: Sql server 2008
Server3: Reporting Services 2008
Operating system on 3 servers: Windows server 2008.
Authentication mode: Form based authentication.

 SSRS reports are working success fully in SharePoint using above topology, The issue is through SharePoint library when i am trying to access report builder reports the client is installing, after enter the credentials it is not connecting to server and am getting the following error "Unable to connecting server at 'http://servername/Reports/Forms/AllItems.aspx'  please use different url

The above issue on production only.

But in local development box there is no problem (in my development box SharePoint t, database (sql) and reporting service sits on my box only)


Thanks for your he

SSRS - Where are the Sharepoint Report Usage Reports provided by Microsoft

  

HI,

Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.

Thanks.

John.

 


[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

  
Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

report builder 3.0 How do I set a dataset property filter to null

  
seems to be every other imaginable option ...  "NULL" is not accepted, [NULL] returns an error ... this should be obvious!

How to disable the Drop down that comes during the mouse hover over to the folder/report in SSRS 200

  
Hi All, Is there a way to disable the Drop down that comes (with options to Manage/Delete/Move etc.) during the mouse hover over to the folder/report in SSRS R2? Our users are getting confused and some of the smart users have tried to take certain actions that are offered in the drop down. Thanks.GBM

Report Builder Report manage data sources - relink programmatically

  
As part of a site definition solution several report builder report rdl files are uploaded to a report folder.  After a site is created with the defintion, the reports must be manually re-linked to the data source through the UI context menu ("Manage Data Sources").  I have been trying to figure out how to do the re-linking programmatically without luck.  Any ideas? ( Reporting Services is configured as integrated with sharepoint)

Report Model/Report Builder/Out of Memory Exceptions

  
We are getting out of memory exceptions on our server. We are using Report Builder against a Report Model in RS2008. Here is part of the errors we are getting. I cannot find any information for an error 200. Here is part of the error log:   processing!ReportServer_0-2!17d8!08/25/2010-10:07:29:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;  Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.ReportIntermediateFormat.Sorting' threw an exception. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.    at Microsoft.ReportingServices.ReportIntermediateFormat.Sorting..cctor()    --- End of inner exception stack trace ---    at Microsoft.ReportingServices.ReportIntermediateFormat.Sorting..ctor(ConstructionPhase phase)    at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.ProcessingRIFObjectCreator.CreateRIFObject(ObjectType objectType, IntermediateFormatReader& context)    at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.ReadRIFObject(Boolean ve
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend