CODEWITHSUNDEEP
t-sqlreporting-services
Mishelbi
Mishelbi

Reputation: 75

in SSRS, is there a way to have a query get variable data from custom code in the report?

I am working on a report created by someone else. In the query for the Dataset it has two variables: @Start_Date and @End_Date but when the report is run, it does not ask for those dates. In stead it asks for the Year and Quarter. In the code section of the report I can see custom code functions that convert Year and Quarter to the Start and End date but cannot find where those functions are called.

Is there a way in SSRS to call a function for a query and return that data and where do I find that function call?

Upvotes: 0

Views: 571

Answers (1)

reas
reas

Reputation: 469

SSRS reports are just xml reports. If you're using Visual Studio, just right-click the rdl file and select View Code. From there you can search for the function name to see where it's being used.

Upvotes: 0

Related Questions