0 vote
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...
Hi,
Do you mean to add a prompt for parameter in the Data Report?
David Hervieux
exactly...
Excellent. Thank you
David Hervieux
would this be possible ad this feature to the current beta or are you already feature completed?
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
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
This means that we will need to generate 3 results (datagrid), isn't it?
David Hervieux
yeah, thats exactly what i would like to have. I think it's "just" a foreach datagrid ;)
Added to our todo list :)
David Hervieux
Thank you