Calling SQL scalar function from SSRS

  • Hi,

    I know that it's possible to have code written in the report. But I would like to avoid this.

    My current problem is that I have time stored as float in the DB, I have sql function to convert float to time. I would like to call this function from within the report and avoid to recode the same function twice.

    Of course I could convert the float to time in the select statement, but this is not possible for everything (for ex subtotals specific to the report).

    So my question is is it possible to call a sql function from within a text box ? Or do you have any other solution?

  • ...ignore

  • ...ignore ?

  • I posted "put it in the SELECT statement", then reread your question...I don't know how to delete posts sorry!!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply