Hi,
I checked old post from "Connected parameters" forum but don't receive any information about from Connected parameters :/.
meanwhile check the manual about "Connected parameters", can make same example with different data but don't functionaly correctly
My report
create procedure sp_DBR_Municipios(
@idEstado int,
@idmunicipio int)
as
begin SELECT
camu.idmunicipio,
camu.nombre FROM
CICG_SEG.core.catmunicipios AS camu
INNER JOIN CICG_SEG.core.catestados AS caest ON camu.fkidestado = caest.idestado
WHERE
caest.idestado = @idmunicipio
in section Admin Tools / Parameter queries make two drop list
first list is normal query and name is cat_Estados
SELECT
caest.idestado,
caest.nombre FROM
CICG_SEG.core.catestados AS caest
for the second list i did a procedure with the next code and receive the first id from first parameter query
create procedure sp_ADBR_municipios(@idestado int)
as
begin SELECT
camu.idmunicipio,
camu.nombre FROM
CICG_SEG.core.catmunicipios AS camu
INNER JOIN CICG_SEG.core.catestados AS caest ON camu.fkidestado = caest.idestado
WHERE
caest.idestado = idestado
in section Admin Tools / Parameter queries make second drop list
name = cat_Municipios and code is the next
sp_ADBR_municipios
when execute a report get these error
SQLSTATE: 42000, code: 201
Procedure or function 'sp_ADBR_municipios' expects parameter '@idestado', which was not supplied.
SQL: sp_ADBR_municipios
the first drop down list is selected from first record
Note: Mydbr is for Microsoft SQL Server
Best regards
Ing. Juan Garcia
