report from sharepoint list

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

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" />

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.

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.

Hai Friends,

     I am Ali, I need to retrive the all lists in to Report Builder and need to prepare Report and need to deploy in Sharepoint Library.

1. I Configured Reporting Services in Sharepoint Integrated mode and Credentials are in Windows Integrated Mode not in Trusted acount. 

2. In Report Builder 3.0 Connection Type "Microsoft Sharepoint List"

3. Connection String 'http://<server name>/sites/<site name>' like this, when i test the connectinons getting this error (The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified.)

Please anybody help me to proceed next steps.

Thanks,

Ali.  

Hi,

I have to prepare a report using the data in sharepoint list i.e., data which would be exported to excel when we click in action tab of sharepoint list. I found most the websites answering how to prepare a report using sharepoint list as datasource. But I want to use the data "IN" sharepoint list as my datasource. I really appreciate your quick response..!!

Thanks,

Sandy

Hi,

i am using SQl Server 2005 reporting services to generate reports from MOSS 2007 Lists.

I need to define a parameter in the report to filter the data repective to that parameter dynamically.

like: in moss list there are three fileds A, B and C and i want to define field A as the report parameter, whenever i select the value of field A then on "View report" value of field B and C pertaining to field A should be display in report.

I am able to add report parameters but not able to attach to the report so that filtering can work.

Please guide me with solution

I have a list that has a bunch of useful meta data, but management wants more of a detail and total area type of report from the data. I am at a loss for the best way to come up with a report like this from the list data in a fairly automated manner.

Has anyone done this? If so what do you recommend? I thought maybe excel services but that doesn't seem like it is quite what I need. I considered SSRS but my manager suggested I explore BDC. No idea if it can consume SharePoint itself though.

Hi Guys;

i'm new in reporting so thanks to be patient with me,

here is my problem, i have created a report then a report viewer,, i passed some parameters to the report it goes well.

i'm working with local data stored in List<object>, i tried to fill my dataset (data) with those local data stored in the list, i filed

looking for yor help

thanks!

Ihave created a Site definition and added a Posts Listview in the same.

<View List="$Resources:core,lists_Folder;/$Resources:core,blogpost_Folder;" BaseViewID="10" WebPartZoneID="Left" WebPartOrder="1"/>

This list is created using my own schema.xml which i have copied from the Blog site template.

I wanted to rename the title of the list [not Title field] which is coming to be Posts right now.

Is there anyway to do it?

Any help appreciated