Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3154
  • Last Modified:

SQL Reporting Services - How to use conditional Count in Report

Is there any way we use variables in SQL Reporting Services as we use in Crystal like

if {Query.cur_status}="Approved" then
    shared numbervar A:= A + 1

and then in Group Footer we use variable A to display the counts for Approved.


  • 2
1 Solution
Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:
Yes you can Use Expression where you can use Conditional formating or counting like we cabn say you can use function in Expression...
Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:
Refer my previous post..

you can place one text box in report where you want to use expression like you can place that textbox in Page Header or footer.
and then Right Click on to the TextBOX where you can see Expression.
when you goes into Expression window there you can see many things Like function (As you can see in crystal report )...

Expression are used as formula in crystal report...

I think this can be usefull for u..


Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now