Liveware Publishing Support Forum

I have R&R10 and I have the following problem.__I have declared a ParameterR Field named Fecha_dsd wich have default value {} and format dd/mm/yyyy.____In filter section, when I want to insert a condition, I put Fecha_dsd and I want to compare with a datetime field in a SQL Server table but I cannot see this field in combo to select. I suspect that the problem is in the field type.____Any suggestion?______I have another problem, when i press Print Preview never prompt me for parameters although I marked the option prompt at runtime.____Thanks.____Ale.

You need a datetime parameteRR and to have the parameteRR prompt when the report is run, it needs to be actually used in the report.____Kathleen__R&R Support

I have a datetime ParameterR, the default value is {} and format is dd/mm/yyyy. I tried with all formats but when I select this parameter in the filter only shows fields to be compared and any of these fields is the datetime field in SQL Server table.__I don´t know why, may be it has different types between the database and RR.

You are sure that the parameteRR is datetime and not date.____For datetime you would have entered both a date and a time for the default value.____Kathleen__R&R Support

I solve creating a calculated field of the datetime field Ctod(Dtoc(datetime_field)).____Using this calculated field I could compare the ParameterR and this calculated field.____Thanks.