How can we design the report without having Columns in sharepoint list
Hi All,
I need to create the report which not having any columns in lists.
1. Imaging Using with Visual web part in user will create dynamic columns in sharepiont 2010 lists.
2. My Report Server is configured with SharePoint Integrated mode. Using with Sharepoint List connection type i am connecting to SharePoint lists. thats fine.
For Example:
Created SharePoint list named with "Fee Types", in visual webpart user added some Fee Types. These fee types are added as columns in sharepoint list.
Imagine User will add the Fee Types later, Now how should i design the report without columns in sharepiont list.
Please help me, if anybody did't get my issue i will explain..
Thanks & Regards
MD.Liakath ali
April 18th, 2011 4:01am
Hi MD.Liakath ali,
When you click the Query Designer after selecting the SharePoint List as datasource, you will see all the dataifelds on the sharepoint site just like below, you could choose which datafields you want to display on the report, vice versa all the datafields
on the report also come from sharepoint sites. If you don't want to display any the fields on the report, I think there is no need for you to create a dataset.
If I misunderstand you, please feel free to let me know.
Thanks,
Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
April 20th, 2011 2:11am