如何在Sql Report Builder中使用参数获取值表单 [英] How to get Values form using paramters in Sql Report Builder

问题描述

大家好，

这是siddiqali首次在SQl Report Builder上工作.我有两个参数，一个命名为"Class"，另一个命名为"Section"，我应该基于3个条件获取值

条件1:当我仅选择类"并单击查看报告"按钮时，我应该获得报告，但不选择任何部分"参数.

条件2:在这里，当我仅选择部分"并单击查看报告"按钮时，我应该获得报告，但是没有选择任何类"参数

条件3:在这里，当我选择两个参数"并单击查看报告"按钮时，我应该基于2个参数获取报告

在上述3个条件中，我只能执行第3个条件

Hi to all,

This is siddiqali working on SQl Report Builder for the first time. I have two parameters one named as "Class" and other named and "Section", I should get the values based on 3 condition

Condition 1: When I select only "Class" and click on View Report Button I should get report ,But with out selecting any "Section" Parameter .

Condition 2:Here When I select only "Section" and click on View Report Button I should get report ,But with out selecting any "Class" Parameter

Condition 3:Here When I Select Both parameters and click View Report Button I should get report based on 2 parameters

In the above 3 conditions I am able to do it only 3rd condition

推荐答案

检查这些

在报表制作工具中使用参数 [ ^ ]
使用单值和多值参数(Report Builder 2.0) [ ^ ]
添加级联参数(Report Builder 2.0) [

Check these

Using Parameters in Report Builder[^]
Using Single-Value and Multivalue Parameters (Report Builder 2.0)[^]
Adding Cascading Parameters (Report Builder 2.0)[^]

这篇关于如何在Sql Report Builder中使用参数获取值表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！