promt for parameters

0 vote

avatar

Hi All,
it's now the time to request a new feature:
would it be possible to have sth. like a "promt for paramters". I would like to store a sql query/precedure at RDM, but this sql command needs for example a customernr or an adressid or sth like this...

All Comments (10)

avatar

Hi,
Do you mean to add a prompt for parameter in the Data Report?

David Hervieux

avatar

exactly...

avatar

Excellent. Thank you

David Hervieux

avatar

would this be possible ad this feature to the current beta or are you already feature completed?

avatar

André has just came back from vacation and he has a lot of work to catch up. I will see if he do this in then next few weeks.

David Hervieux

avatar

Hi David,
first i would like to say thank you for your implementation!

would it be possible, to add these parameters also to the sql-query-session-tools-type?
and could you change the sql-report-sessions, to allow more than one select statements?
i'd like to do sth like this:
declare @FirmID int = @Param1

SELECT VetsXL_Firms.*
FROM VetsXL_Firms
WHERE VetsXL_Firms.FirmID=@FirmID

SELECT VetsXL_Addresses.*
FROM VetsXL_Firms, VetsXL_Addresses
WHERE VetsXL_Firms.FirmID=@FirmID and VetsXL_Firms.AddressID = VetsXL_Addresses.AddressID

SELECT VetsXL_Users.*
FROM VetsXL_Users
WHERE VetsXL_Users.FirmID=@FirmID

avatar

This means that we will need to generate 3 results (datagrid), isn't it?

David Hervieux

avatar

yeah, thats exactly what i would like to have. I think it's "just" a foreach datagrid ;)

avatar

Added to our todo list :)

David Hervieux

avatar

Thank you