Problem with Connected parameters

(3 posts) (2 voices)
  • Started 2 weeks ago by ingjgarciad
  • Latest reply from ingjgarciad

Tags:

No tags yet.

  1. ingjgarciad, Member

    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

    Posted 2 weeks ago #
  2. myDBR Team, Key Master

    You have mixed case @idEstado vs @idestado.

    --
    myDBR Team

    Posted 2 weeks ago #
  3. ingjgarciad, Member

    Nice, i don't see this mistake :D

    Best regards

    Ing. Juan GarcĂ­a

    Posted 2 weeks ago #

Reply

You must log in to post.