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


Post New Web Links

Report viewer web part: Dependency of parameter choices on user rights?

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :SharePoint
 

Hi there,

I am wondering if it is possible to restrict the choices for a parameter depending on the user rights. For instance, if an "administrator" can select three different options for one particular parameter, a "normal user" should only be able to choose from two.

I am using Sharepoint 2007 and Reporting Services 2005.

Best wishes

Oliver

 




View Complete Post


More Related Resource Links

Is it possible to give parameter to the Page Viewer web part?

  
Page viewer web part gives iView to the website eg. http://www.test.com. This works fine! Our customer would like give parameters like http://www.test.com/abc?name=John. First question is that is it possible to give personalized parameters to the url? Any chances to give SharePoint user name as parameter?  Kenny_I

Problem with Report parameter inside SSRS Report Viewer webpart with deployment from one server to a

  
Hi all,I've got this problem.me and my team have developed a lot of reports by using a SSRS configured in Sharepoint Integration Mode.For accessing these report we are using the Sql Server 2008 Report Viewer Webpart.One of its parameter is the Report ur that is an absolute url so the problem is when I move our solution from server1 to server2 I have to re-editing all pages where I've added the Report Viewer webpart for updating the report url with the new servername otherwise it's impossible to view the report.Is there any official or unofficial way to solve this problem ?many thanks

Report Parameter type for a list of Employees to prompt like AJAX Textbox intellisence when the user

  

Hi All,

I have around 300 employees report to run for a specific employee, I cannot have a Dropdown as it would be too long for the report user to choose from. Is it possible in SSRS 2008 to have a text box that would provide intellisence like AJAX textbox and provides user with Employee name to choose from database or is there any other better way to select the right mployee name to run this kind of report. being a newbie to SSRS I am unable to go furthur on this. All help is great help. Thanks in advance for responding.


Is it possible to customize the layout of the report viewer parameter section?

  

Hi there,

I am wondering if it is possible to customize the layout of parameter section in the report viewer web part such that parameters can be selected in a secton on top of the report rather than on the right hand side?

Many Thanks and Regards

Oliver


Best Practice for connect SSRS Report Viewer Web part with custom filter web part (With Dropdown\Lis

  

To make a filter provider web part, I implemented the interface ITransformableFilterValues.
Implemented the various properties of the ITransformableFilterValues interface
and method that creates an instance of our filter provider.

[aspnetwebparts.ConnectionProvider("AccountFilter", "ITransformableFilterValues", AllowsMultipleConnections = true)]
public ITransformableFilterValues SetConnectionInterface()
{
return this;
}

Is this a best practice .Please share your suggestion.

Regards,
Prashob


Best Practice for connect SSRS Report Viewer Web part with custom filter web part (With Dropdown\Lis

  

To make a filter provider web part, I implemented the interface ITransformableFilterValues.
Implemented the various properties of the ITransformableFilterValues interface
and method that creates an instance of our filter provider.

[aspnetwebparts.ConnectionProvider("AccountFilter", "ITransformableFilterValues", AllowsMultipleConnections = true)]
public ITransformableFilterValues SetConnectionInterface()
{
return this;
}

Is this a best practice .Please share your suggestion.

Regards,
Prashob


Can I "hard-code" a particular report in the report viewer web part?

  

Hi there,

I am wondering if it is possible to "hard-code" a particular report in the report viewer web part, such that this report is automatically loaded when a user visits a particular site. I am asking that question because I do not want to select the same report each time I want to view it; I just would like to have a link that will get me the report right away.

Best wishes

Oliver

 


Report viewer control is is displaying parameter item 'select a value' even when the default param

  

Hi,

I am using SSRS 2008 R2,

I have set the default parameter of dropdown and in the output "select a value" item text is removed ,also in the Report Manager 'select a value' removed .

But when I am displaying the same reports in the ReportViewer control as ReportViewer1.ServerReport  in the the vs 2010 asp.net project the item select a value is reappearing in the output.

Could you please help me remove the default item text 'select a value' from the ReportViewer control aswel.

Thanks,
Shyam


SPFeatureReceiver: Creating report viewer web part programmatically

  

I have a feature that adds a report viewer web part (SP integrated mode) into the newly created site page.

Problem: The feature activates without any problem through the UI, but I cannot activate it through STSADM (which will be the case when going to production).

Here is my code block that adds the web part to the page. This code block exists in FeatureActivated:

Assembly currentAssembly = Assembly.GetExecutingAssembly();
string dwpStr = string.Empty;

try
{
    using (Stream resourceStream = currentAssembly.GetManifestResourceStream("Report.dwp"))
    {
        using (StreamReader sr = new StreamReader(resourceStream))
        {
            dwpStr = sr.ReadToEnd();
            dwpStr = string.Format(dwpStr, web.Url);
            sr.Close();
        }
        resourceStream.Close();
    }

    using (StringReader sr = new StringReader(dwpStr))
    {
        string err = string.Empty;
        System.Web.UI.WebControls.WebParts.WebPart wp = wpMan.ImportWebPart((XmlReader.Create(sr as TextReader)), out err); //Exception thrown from this line
        wpMan.AddWebPart(wp, "HeaderZone", 0);
    }
}
catch (Exception ex)
{
    //Log errors
}
Report.dwp is as follows:
<?xml version="1.0" encoding="utf-8"?>
<WebPart xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&q

Report Viewer Web Part - MOSS 2007

  

 

Hi

     I am working with the Report Viewer webpart on sharepoint 2007 to display reports from another server (native reports). So now i am showing around 4 RS reports on the sharepoint site side by side. The reports seem to appear fine.

 

Now when i try to change the title of the Report Viewer webpart to display the name of the report it just dosent seem to change for more than one. Every time i click 'Modify Shared Webpart' the title of the report viewer webpart reverts back to the default 'Report Viewer'.

 

I also tried opening the sharepoint page using the 'Sharepoint Designer'. The titles seem to reflect the entries i have entered. But the titles just dont appear on the sharepoint page.

 

I have been trying to figure out if there is some autogeneration of webpart titles taking place but just cant seem to figure that out. Any help would be greatly appreciated as i have been stuck on this for quite some time.

 

 

 

 

Thanks

Sriraag

 


How To disable Export Format in Dropdown List of report viewer web part?

  

hi,

does any one knows how to disable the export option in the dropdown list of report viewer web part?

thnx


ssrs dropdown parameter with Week startDate and end date so that user selects only week and report s

  

Hi all,

I have a report where I have to show the Week start and end date in the dropdown instead of the date range. Please advice me how to proceed with this report parameter. Thanks a lot in advance, all help is appreciated.

 


SSRS Report w/Parameter won't work in web part

  

Any report without a parameter, I can run directly from a report library, or I can add it in the SSRS web part and it will work perfectly.

If I have a report WITH a parameter, it will run ok directly from the report library, but if I put it in a web part on a Site Page, fill in the date picker parameter, and click apply, the results will not show - - and there's a little Javascript error msg in the lower left corner of IE "Error On Page".

Then, when I double click on that error msg, I see "this_docMapSplitter is null or not an object". I've also gotten other cryptic errors, but that's what consistently shows up now.

any ideas on how to get a web part to work with a parameterized report?


How to import SQL Server Reporting Services Report Viewer Webpart on web part Page using code in Sha

  

Hi Every One,

I have use SQL Server Reporting Service in SharePoint integrated mode. I have deployed all reports and data source in SharePoint Document Library using CODE. I need to show those report in “SQL Server Reporting Services Report Viewer” Web Part on Web Part Page, I have created Web Part page by code. But I cannot import this Web Part on Page using Code.

How I can do this by code.

 


Navaratan Sharma

Report Viewer - Web Part Preview Error

  

Report viewer web part preview is showing the following error

Microsoft SQL Server Reporting Services
ErrorError
This web part has not been configured correctly. Please contact the document owner.

I have to resolve this error to customize the report viewer.  How to resolve this error


Dhanapal Chinnusamy

how to use Report viewer and report Explorer web part in sharepont 2007 for ssrs

  

i have to show ssrs report in the sharepoint 2007 using report viewer and report explorer how to user this two web part to get the ssrs report in sharepoint 2007.

i am new to the ssrs with sharepoint 2007.

 


Custom Multi Filter Web Part for Report Viewer

  
I want to create a custom web part that has more than 1 filter web part and that can be connected to Report Viewer Web Part (Integrated Mode) at runt time/design time.

I searched a lot but could not find a way to have single web part that is a provider to more than 1 filters.
Say for example -
  1. My Report accept 2 parameter Department and Region. 
  2. I want to connect both parameter with single web part having two drop down (one for Department and one for Region)
  3. Values from both the drop down should be passed to Department and Region
  4. Report should be rendered in Report Viewer Web Part

Solution Tried so far
  1. Create a web part that adds two custom drop down
  2. Custom Drop down class that Implements from ITransformableFilterValues
  3. Have 2 Methods on the web pat each having ConnectionProvider Attribute and return instance of drop down control
Problem:
  1. Even though 2 connection option is shown on my custom filter web part only one can be added
  2. For example - If I connect Filter1(custom web part) to Department then i am unable to connect to Report Viewer web part again.
     
My web part have methods like this 
     
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