Parameters in modified query

rbuser

Hi!

I have a modified sql query with 2 parameters like this:

select convert(varchar,DATE_A,112) as date_transaction,
sum(Amount) as Amount,
from [dbo].[VW_BILLS]
where (convert(varchar,DATE_A,112) between :A_date and :B_date)

"Incorrect syntax near the keyword 'and'"

How I can insert these parameters?


Thanks a lot!

nicocizik

Hi Guillermo,

For future reference, please give detailed information about your
product versions and environment when posting questions.

1. Which version of Delphi and ReportBuilder are you using?

2. Which DB are you connecting to, which Delphi connectivity (FireDAC,
ADO, etc.)?

3. Are you using DADE (Data tab) to create your query? If so are you
editing the SQL manually or using the Query Designer?

ReportBuilder does support the parameter syntax from within the query as
you posted. You will need to create corresponding Report Parameters to
populate the values before executing the report.

http://www.digital-metaphors.com/rbWiki/End-User/Fundamentals/Report_Parameter_Fundamentals

http://www.digital-metaphors.com/rbWiki/index.php?title=General/What's_New/RB_11/Parameters_and_AutoSearch

rbuser

Hi Guillermo,

I sent you a email with some info that might help.

Walter Fordham