 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / June 2005Report parameters appear disabled in Preview Mode
Hi all.. I have created 3 report parameters, named: NUMERO_POLIZA, CUATRIMESTRE, AÑO (in this order). When I preview the report, only NUMERO_POLIZA appears enabled. All others disabled. One strange thing is that when, in report parameters dialog, I move NUMERO_POLIZA parameter down, for example, placing it between CUATRIMESTRE and AÑO, in preview mode, CUATRIMESTRE and NUMERO_POLIZA appear enabled. AÑO appears disabled. Similarly, when I place NUMERO_POLIZA after AÑO, All parameters appear disabled. I don't understand what may be happening, so any help would be greatly appreciated. Thanks Jaime Jaime, This can occur when one parameter is dependent on another. For example, having start and end date parameters, you may wish the user to select a start param first and then an end param (or vice versa) that must be after the start param. Then the param ordering becomes paramount and the end param will appear disabled until the start param is entered. Tony > Hi all.. > [quoted text clipped - 13 lines] > Thanks > Jaime None of those disabled parameters depends on NUMERO_POLIZA. The common fact with CUATRIMESTRE and AÑO is that both are calculated parameters. For example, CUATRIMESTRE is defined as follows: Name: CUATRIMESTRE Prompt: Cuatrimestre Data Type: Integer Available Values (Non-queried): ENERO - ABRIL 0 MAYO - AGOSTO 1 SEPTIEMBRE - DICIEMBRE 2 Default Values (Non-queried): =(Month(Now) - 1) \ 4 Another fact is that the only parameter that is used directly in the query is NUMERO_POLIZA. Other parameters are used to calculate others, for example, FECHA_TERMINO. FECHA_TERMINO parameter is also a calculated value depending on CUATRIMESTRE and AÑO value (using a custom VB.NET code) and is used in the WHERE clause of the query. But in any case, NUMERO_POLIZA is used in other formula other than the query. Jaime > Jaime, > This can occur when one parameter is dependent on another. For example, [quoted text clipped - 22 lines] > > Thanks > > Jaime |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.