When I create a report in report designer, I can't seem to get past adding paramer with drop down.Whenever I add a parameter data source (Store proc) it says Error occured, check stack trece for details but the stack trace is actually not visible.
Another issue is I can't reorder parameters once they've been picked automatically from a stored procedure.It sorts by by parameter name automatically so if I have two params with name like StartDate and EndDate,
Expected
StartDate should be on left most side of the visual followed by EndDate parameter on right side so that someone can easily (predictably) pick start and end date when running report.
BUT,
currently,everything is autosorted and no option to manually reorganize on visual screen.
Can some one help with with this blocker issue??? please.
Otherwise the report server is OK.