I'm hoping you all could help me with an issue....
I have a report with 3 parameters:
The DateFunction parameter retrieves values from a small table in a sql database:
So, want i want to do is have the user be able to select an option from the DateFunction parameter. The parameter will automatically send the key to a stored procedure that will figure out what calculations to do based on the key. I am assuming that I will have to call a function from the stored procedure since I need to return 2 values. Then I need the StartDate and EndDate parameters to automatically be populated with the values.
I hope I explained it good enough. If someone already has a function that does this, it would be greatly appreciated if you could upload it for me.
thanks for all your help!