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


Top 5 Contributors of the Month
david stephan
Asad Ali
Post New Web Links

Problem in parameter list while executing the report in sharepoint

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

Hi,

I have created one SSRS 2005 report with 3 dependent parameters ,they are BusinessUnit,Account,Project.In SSRS solution file when i click a specific BU name ,then at the same time Account parametr refreshes and shows the corresponding account names and the same for project.

I deployed the report in to sharepoint 2007,that time the account parameter filed is not refreshing paralleling when i click a BU and it shown as inactive.Only when i click the apply parameter acoount fild shows the corresponding account names.Please help me to avoid the issue.Thanks in advance.

 neesa




View Complete Post


More Related Resource Links

Querying a SharePoint List: Creating a Report Parameter based on a SharePoint List field

  
I have been struggling with this problem over a week now and am at my wits end.   I have created a RS(2005) report and am currently querying data from a SharePoint List.  If anybody is interested in seeing how I set it up I follow this simply walk through on Code Project.  http://www.codeproject.com/KB/reporting-services/ReportFromSharePoint.aspx.  

I need to create a custom report parameter and reference a field that I have created in my SharePoint list.   When I run the report I would like to 'Filter' the result set with the value selected in the report parameter field.  I have looked anywhere and everywhere and don't know if I am over complicating this problem but I have yet to find a solution. 

Please and Thank you
Software Engineer

Crystal Report vs 2003 convert to vs 2008 parameter problem

  

Hi friend,

I have a project develop with Visual Studio 2003, when i convert the project to Visual Studio 2005 is work well. But when i convert to Visual Studio 2008, the crystal report when have pass parameter will prompt the parameter field to re-type then show the report.

But in this converted project i create a new report and pass the parameter is ok. That means i wan re-do all report @.@??
 

Does someone can help me solve this problem??

Thank you


Item cannot be found.(rsItemNotFound) when executing a report from a sharepoint Website

  
Hello,
I have managed to integrate Report server with Sharepoint .
I created a report with it's data connection with microsoft Visual Studio 2005 , tested it , than deployed it to the specified document libraries in sharepoint.
Everything works fine till now.But when i try to execute the report from the document library in sharepoint the Message :
  • The item 'Reports/Report1.rdl' cannot be found. (rsItemNotFound) '. Even though the report1.rdl is inside the website and is returned when i do the search. Regards.

  • Problem with SharePoint Designer 2007 and Custom List Forms

      

    I created several forms (Create/Edit/View) for a SharePoint list, using Custom List Forms.  I'm using Content Types in the list to ensure that each item only has the necessary fields.  When I created the ASPX forms, and inserted the Custom List Forms, I selected the correct Content Type, and I got the right fields inserted in the form.

    Now, for some reason I can't identify, every time I create a new form, and insert a Custom List Form, SPD is bringing ALL fields from the list, instead of just bringing the fields included in the selected Content Type.

    I have tried many different things to solve the problem, including creating new lists/content types/forms, etc. but SPD is doing the same thing all the time.

    Can somebody tell me what may have gone wrong in SPD or MOSS?

    Thanks


    Sharepoint 2010 List Added Event Problem

      
    Hi All, I have created List Added Event Handler. In that Event I want to Add Custom Field in List as List is created. I get an Error "The Specified Program Requires    a newer version of windows" Is there ant solution for it. I have tried it also creating new instances of spweb and spsite rather than getting it from "Properties" Thanks Saumil Thakkar

    SharePoint 2010 Reporting Services report on sharepoint list rsExecutionNotFound

      
    I cannot get SQL Reporting Services 2008 R2 to work with a datasource that is a sharepoint list.  Reporting services seems to work fine setup in SharePoint 2010 Integrated mode. When I try and run a report that is based on a sharepoint list, I immediatly get the following error: The report execution tp15sp4515l3seqqo4do3e45 has expired or cannot be found. (rsExecutionNotFound) This seems to be something I am doing wrong with the sharepoint configuration, I would guess.  I haven't tried a regular database query, but they used to work when reporting services was configured for native mode.  So I assume this is just a problem connecting to sharepoint 2010 lists, with the new SharePoint 2010 List connection type. Edit This has got to have something to do with a permission setting for the app pool account of sharepoint.  I read something once where it said you had to grant it permissions, but every guide I've found since then doesn't mention anything about it. This log entry is where the problem seems to be occuring, I just don't know what permissions to give TESTDOMAIN\spweb which is the app pool account. library!ReportServer_0-3!1bdc!09/01/2010-09:58:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, tim

    Having problem accessing multi-choice parameter in SQL Query in Report.

      
    Hi, I have a report with a multi-choice input parameter. My report contains a dataset that uses CHARINDEX on this multichoice parameter. The dataset query is in text, not in stored procedure. When I run the report I get "the charindex requires 2-3 arguments the reason being that the SQL is run as follows (You can see the multi-choice list screws up the string: exec sp_executesql N'Select test.Region [Region], test.Location [Location], nvarchar3 [Year], nvarchar4 [StatisticType], nvarchar5 [StatisticType2], ntext2 [Detail], float1 [Amount]   from [WSS_Content].[dbo].[AllUserData] UD   inner join [WSS_Content].[dbo].[AllLists] AL on AL.tp_ID = UD.tp_ListId and AL.tp_Title=''Statistics''   left outer join   (       Select UD.tp_id [ID],nvarchar1 [Region],     nvarchar3 [Location]   from [WSS_Content].[dbo].[AllUserData] UD   inner join [WSS_Content].[dbo].[AllLists] AL on AL.tp_ID = UD.tp_ListID and AL.tp_Title=''Regions''   where UD.tp_ListId = AL.tp_ID   and UD.tp_ListId = AL.tp_ID   and UD.tp_DeleteTransactionId = 0x0   and tp_IsCurrentVersion = 1   ) test on test.id = UD.int1   where UD.tp_ListId = AL.tp_ID   and UD.tp_ListId = AL.tp_ID   and UD.tp_DeleteTransactionId = 0x0   and tp_IsCurrentVersion = 1  &n

    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

    Sharepoint list as Report Data Source

      
    My current environment is Sharepoint 2007 with SSRS 2008 in Sharepoint Integrated Mode. SSRS 2008 uses trusted authentication to communicate to Sharepoint 2007. Sharepoint 2007 is configured to use NTLM authentication (configured with a domain account). My settings within Central Admin are Authentication Type: Windows IIS authentication settings: Integrated windows authentication with NTLM. My question is: Do I need to configure Sharepoint to use kerberos to use Sharepoint Lists as a Report Data Source?  

    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.


    Sharepoint 2010 Standard Edition Custom List Reporting Using Report Builder 3.0

      

    hi, i'm making this report from a sharepoint list. i want to add some of the fields as the parameters for the report. (e.g : Category, Department)

    i tried to run the report, the parameters were shown as expected

    but the problem is when i create a query in the dataset.

    i'm using caml query builder for the query expression. it goes like this :

    <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <ListName>IT Helpdesk</ListName>
      <ViewFields>
        <FieldRef Name="Employee_x0020_Number" />
        <FieldRef Name="Title" />
        <FieldRef Name="Department" />
        <FieldRef Name="Category" />
        <FieldRef Name="Time_x0020_Spent" />
        <FieldRef Name="INT_x0020_Time_x0020_Spent" />
        <FieldRef Name="Severity_x0020_Level" />
        <FieldRef Name="Ticket_x0020_Source" />

    List of Month and Year in SSRS report parameter?

      
    Hi, I have two parameters in my SSRS Report i.e. Month and Year. I want to show the list of all Months in dropdown and years for a particular range say 1995-Current Year.
    Can any one suggest me the query for how to get it to work.
    Thanks!! MCP

    report from sharepoint list

      

    hi

    i want to create report for sharepoint 2010 list. I create "New Report" in Sql Server Business Intelligence Development Studio & deploy it to sharepoint site. In sharepoint site ,in web part i can see it. but i want to filter this report by "start date" & "end date" that user enter it.

    Note:we can connect to sharepoint list directly in sql server 2008 R2,

    how i can define "start date" & "end date" in Sql Server Business Intelligence Development Studio & how i can  filter report depend on value that users enter it in  "start date" & "end date" ?!

     I would really appreciate if anyone can help me out with this.

    Thanks.


    report from sharepoint list

      

     

    hi

    i want to create report for sharepoint 2010 list. I create "New Report" in Sql Server Business Intelligence Development Studio & deploy it to sharepoint site. In sharepoint site ,in web part i can see it. but i want to filter this report by "start date" & "end date" that user enter it.

    Note:we can connect to sharepoint list directly in sql server 2008 R2,

    how i can define "start date" & "end date" in Sql Server Business Intelligence Development Studio & how i can  filter report depend on value that users enter it in  "start date" & "end date" ?!

     I would really appreciate if anyone can help me out with this.

    Thanks.


    report from multiple list in sharepoint 2010

      

    hi

    I want to create report from multiple list in sharepoint 2010. In general Sql Server Business Intelligence,allow create report from 1 list.

    how i can create report from multiple list with Sql Server Business Intelligence?

    thanx.


    Sub Report parameter window - SharePoint Integrated

      

    We use SSRS in SharePoint integrated mode.   I have a report with parameters where the user can call into a sub-report.   When the sub-report is displayed, is there any way to cause the parameters panel (on the right side) to be open when the sub report runs?


    Thanks

    Chris Fleming


    Chris Fleming

    Problem with creating Custom List in SharePoint Designer

      

    Hello all,

    I have used SharePoint designer 2007 to create a custom list for my SharePoint 2003 portal.  The list is quite simple, without any extensive programming. 

    First I created a 'shell' for my list inside of SharePoint, where I name my fields and select their input types (Choice, Date, Currency, etc).

    I then create a new .aspx file, insert a Custom SharePoint List into the new file, and use the above mentioned 'shell' to insert my content.

    From this point, I rearrange the design, insert a few basic JavasScript elements - for image rollovers - and save.

    The page displays perfectly in my live SharePoint environment.  However, when I enter data into this form, and submit, it doesn't save the data correctly.  For instance, there's a Yes/No option near the end of the form, defaulted to No.  If I click that checkbox - to set it to Yes - and submit the form, the resulting record does not show that I had clicked the checkbox.  In fact, it shows the whole form as being blank, as if I had entered nothing at all.

    If this makes sense, how would I go about fixing 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