向SQL查询添加提示 [英] Adding a prompt to sql query

问题描述

您好，我是使用sql的新手，正在创建要在网络服务器上发布的报告.但是，我想在报告中添加一个提示，以便观众可以根据我建立的提示输入他们想查看的特定数据.我不确定如何完成这项任务.请指教.谢谢！

Hi, I am new to using sql and I am creating a report to publish on a webserver. However, I would like to add a prompt to the report so the viewers have the option to enter specific data they would like to view based on the prompt I establish. I am not sure how to accomplish this task. Please advise. Thanks!

推荐答案

您可以使用参数来获取报告的值.例如，请参阅: http://www.sql-server-performance.com/2007/report- parameters/ [^ ].只要确保您没有为所有参数定义默认值即可.

You can use parameters to get values for your report. For example, see: http://www.sql-server-performance.com/2007/report-parameters/[^]. Just make sure that you don''t define default values for all of the parameters.

尝试
提示SQL语句对话框 [

Try
Prompt SQL Statement Dialog Box[^]

检查是否有帮助，http://www.bigresource.com/Tracker/Track-ms_sql-NfE9LTCm/ [

Check if this helps, http://www.bigresource.com/Tracker/Track-ms_sql-NfE9LTCm/[^]

这篇关于向SQL查询添加提示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！