473,396 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

graphical count in reports

I have parameter que ry with auto Rpt Tabular, when i give parameter
like 1/5/2007 & 3/15/2007 it shows me all the records including 2006 i
have test box in detail section where control source is
=iif([cr_Status]="completed",1,0) again it doesnt work .
I want query to show me only those record for the date i specify &
also i wanr the status field in report i want it to show me in the end
Completed 100, Cancelled 50, discontinued 25, in progress 200 it
should show me the records & the count .

Apr 26 '07 #1
2 1271
For the dates query maybe you want something like this:

= #1/5/2007# OR = #3/15/2007#

in order to retrieve records for those two dates.
<bh*****@gmail.comwrote in message
news:11**********************@n15g2000prd.googlegr oups.com...
>I have parameter que ry with auto Rpt Tabular, when i give parameter
like 1/5/2007 & 3/15/2007 it shows me all the records including 2006 i
have test box in detail section where control source is
=iif([cr_Status]="completed",1,0) again it doesnt work .
I want query to show me only those record for the date i specify &
also i wanr the status field in report i want it to show me in the end
Completed 100, Cancelled 50, discontinued 25, in progress 200 it
should show me the records & the count .

Apr 27 '07 #2
On Apr 27, 1:59 am, "Squirrel" <wise...@covad.netwrote:
For the dates query maybe you want something like this:

= #1/5/2007# OR = #3/15/2007#

in order to retrieve records for those two dates.

<bhav...@gmail.comwrote in message

news:11**********************@n15g2000prd.googlegr oups.com...
I have parameter que ry with auto Rpt Tabular, when i give parameter
like 1/5/2007 & 3/15/2007 it shows me all the records including 2006 i
have test box in detail section where control source is
=iif([cr_Status]="completed",1,0) again it doesnt work .
I want query to show me only those record for the date i specify &
also i wanr the status field in report i want it to show me in the end
Completed 100, Cancelled 50, discontinued 25, in progress 200 it
should show me the records & the count .- Hide quoted text -

- Show quoted text -
it should me records between 1/5/2007 & 3/15/2007 and report footer
the count of records howmany cancelled or in process

Apr 27 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: (Pete Cresswell) | last post by:
I've got this little app that tracks metadata from about a dozen different systems and feeds. Seems to have all the mapping info that's needed to follow a data element from one place to...
2
by: RSB | last post by:
Hi Everyone , i am working on this Project and we do have a requirement of creating Graphical reports .. like Charts etc. So how do i achive that .. DO we use a third party tool like crystal...
10
by: jantod | last post by:
Is there any chance of itertools.count() ever becoming one of the built-in functions? It's a wonderful little function and I find myself importing it in every module I write. -Janto
0
by: ZRexRider | last post by:
Hi, I have some relatively simple reports that pass parameters to SQL Server stored procedure to retrieve data. These reports are set to group the data by an individual's name and print their...
2
by: jonathan184 | last post by:
Hi I am having a problme where the results of the sql count is not matching the results of the perl script sql count. The script was working fine up till Wed last week and after that the results...
5
by: Brian Blais | last post by:
Hello, I was wondering what the approximate minimum age to learn python is. Has anyone had experience teaching middle school students, or elementary school students Python? What brought this up...
7
by: CampbellJD1 | last post by:
I am using Access 2003 Professional. I have been working with Access for some time and I have created an MDB with a Linked Table and the Data there is temporarily transferred to other Table for...
1
by: Serenityquinn15 | last post by:
Hi! I'm using crystal reports, And I have some trouble in counting numbers.. because even Blank field are counted... and I dont know why???? Im using this code: Count({Field}) Want...
7
by: jimgym1989 | last post by:
import java.util.*; import java.io.*; import javax.swing.*; import java.awt.*; import java.awt.event.*; import java.util.Scanner; public class solano extends JFrame{ private JLabel letterL...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.