0

I build SSRS reports in Visual Studio 2013 and I have to use excel file as data source. Each month new .xlsx file is uploaded into the folder of the following structure: \\[yyyy-yy]\[yyyy.mm]\{somefilename}[ mmm yy].xlsx.

Is it possible to specify SSRS data source conditionally, so it will pick up the latest file available?

P.S. I know that the best solution would be a stored procedure on SQL side to pump all data to server, but unfortunately this is not the case.

Improve this question
2
  • 1
    You can set the connection string dynamically with an expression. See stackoverflow.com/a/19830931/2033717 Commented Jan 11, 2017 at 22:10
  • not sure how you're currently defining the datasource, but connection strings can be expressions, so you can try using an expression to build the connection string based on current date Commented Jan 11, 2017 at 22:12
Related questions
8
SSRS run SQL/DataSet conditionally
2
Conditional DropDown List with SSRS
2
conditional filter SSRS
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.