StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3158277
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2010-07-01T13:35:19.993
FavoriteCount
0
LastActivityDate
2010-07-02T11:41:42.083
LastEditDate
2017-05-23T11:48:23.957
LastEditorUserId
-1
OwnerUserId
373418
ParentId
3156689
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Hmmmmmm I wouldn't / haven't done it, but what you might be able to do is set the report source to a sql clr table valued function, which takes as a parameter a full path and file name, then parses out the data? <ul> <li><a href="http://msdn.microsoft.com/en-us/library/cc655659%28SQL.90%29.aspx#ssrsndtbevldfnct_topic5" rel="nofollow noreferrer">Looks</a> like this can be done.</li> <li>Here is an <a href="http://www32.brinkster.com/srisamp/sqlArticles/article_46.htm" rel="nofollow noreferrer">article</a> I used when learning clr tvfs.</li> </ul> <hr> Then, according to your comments, what I would do is take the csv of ints and pass it to a sproc. The sproc would then turn the csv into a temporary table using a table valued function. The table produced by the table valued function would then be used in your query. I would avoid this entire scenario if I could. If you can provide the user with list of valid parameter choices, so much the better. Or if that csv is a regular, slowly changing list, perhaps it is better to make it a separate report. SSRS allows you to 'copy' or 'link' ( i forget the term ) to base/master reports. All you're really doing is changing the set of input parameters. The basics of the report remain the same. See: <ul> <li><a href="http://www.logiclabz.com/sql-server/split-function-in-sql-server-to-break-comma-separated-strings-into-table.aspx" rel="nofollow noreferrer">here</a></li> <li><a href="http://msdn.microsoft.com/en-us/library/ms191165.aspx" rel="nofollow noreferrer">here</a></li> <li><a href="https://stackoverflow.com/questions/2821054/how-can-i-join-on-a-csv-varchar">here</a></li> </ul> Good LUCK!
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSSRS parameter - Upload text file?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USJeff Maass
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COThanks for the answer. This would require users placing the file in network share. I think the preferred option will be have a parameter field which takes comma separated contract id's and split it. Thanks again
 singulars
 PostPostId
 PO
 UserUserId
 USDan Black

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.