Solved

TO find number of rows returned by a selection formula

Posted on 2003-11-19
5
239 Views
Last Modified: 2010-08-05
hi experts,
  iam usin a selection formula to retreive records the problem is i don't want to display the report when ,no records is returned by the selection formula...so i want a way to find the number of rows returned by the selection formula ...moreover iam usin the special field record number in the report when..no row is returned the record number displays value 1 in the blank row  that is usually displayed...iam count in on your expertness than you do on yours...help meeeeeeeeeeeeeee

regrds
vairavamuthu
0
Comment
Question by:vairavamuthu
5 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 30 total points
Comment Utility
File>ReportOptions
Suppress Printing If No Data


Pete
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Should work.

mlmcc
0
 
LVL 1

Author Comment

by:vairavamuthu
Comment Utility
dear peter& mlmcc and all experts,
         the solution is working fine peter ,when i open the report in cr9.0..
                                     BUT as iam invoking the report in a asp.net application  through a crystal viwer..when no records is returned the reports is shown with a single blank row with the special field value as 1....iam using a selection formula to retreive the record ..so if i got a way to find the number of  rows  returned in the selection formula i can suppress the  report and can display a error msg that "no record found".so pleasehelp me  to find the number of rows returned by the selection formula .iam count in on your expertness than you do on yours...help meeeeeeeeeeeeeee

regrds
vairavamuthu

 
0
 

Expert Comment

by:casfion
Comment Utility
probably, you may need to write sql statement in your asp to check on the no. of rows to return. If the return is 0, you display error message; if not, then you active the crystal report.
0
 
LVL 1

Author Comment

by:vairavamuthu
Comment Utility
dear casfion,
                    Thank you very much for the tip. i used it and it worked ..

thanking you
vairavamuthu
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now