A problem on count when calculating business days

Here is the information regarding problem.

1) I have three fields in the detail section. They are calculated and displayed on the report from crystal side. The fields I am displaying are the release numbers which are invoiced with in 3 business days, invoiced more than 3 business days and Not invoiced more than 3 business days. The report is grouped by market field. When I am inserting summary for each field by market it is also counting the blank fields and displaying the count. The data that I was pulling from database is correct. I am unable to figure it out why it is counting the blank fields while calculating summary.

2) And the other problem is, it is displaying the blank spaces in the report when the condition fails.

For reference here I am inserting report . Any Help could be greatly appeaciated. Its a little bit urgent.Hi all

I figured it out my self.

A newbies question

Hi everyone,

I am a newbie with Crystal Report. I am now working on an assignment but unfortunately I don't have much time to look through the Crystal Report books cover to cover to find out the information I need. I am posting my question here to see if anybody can help me out.

The question is: How can I display a number of rows on a report?

Any help would be highly appreciated.You want the number count or ?

Detail is needed...|||Right click on any field which can't be null (use one of your key fields), ->Insert->Summary.
Select 'Count' for 'Calculate this summary', ->OK.
The result will be placed in the RF.

If you need to have the quantity of records in the RH or PH, create a formula @.Count:

Count ({your_table.field})

and place it there.



For more info, read help file on
Count function
Insert Summary Dialog box

A newbie to Reporting Services seeking advice

I have been a long time Crystal Reports user but now due to a new
application, I want to switch over to SQL Server Reporting Services.
My question is whether I can do what I want with Reporting services.
My app is a 2 tier winforms app. The client will query the database through
a VPN. The database is a SQL Server 2005 database. Can my app call reports
located in a directory on the server and display them in a viewer in my app
and then the client either prints to their local machine or saves to file
ex. pdf file? The client does have an IIS server running on the same
machine as the database.
BillIf I understand your question correctly, yes, you can host a server-
based report inside of a client app and also output them to PDF by
using the ReportViewer control.
Start here: http://www.gotreportviewer.com/
On Apr 14, 12:44 am, "BillG" <billgo...@.charter.net> wrote:
> I have been a long time Crystal Reports user but now due to a new
> application, I want to switch over to SQL Server Reporting Services.
> My question is whether I can do what I want with Reporting services.
> My app is a 2 tier winforms app. The client will query the database through
> a VPN. The database is a SQL Server 2005 database. Can my app call reports
> located in a directory on the server and display them in a viewer in my app
> and then the client either prints to their local machine or saves to file
> ex. pdf file? The client does have an IIS server running on the same
> machine as the database.
> Bill

a little help :)

hi babu, I am italian and I'm new of crystal, I have a very very simple problem, something like this: I have to make a report once a day for all the week. how and where should I put the parameters in the window of selection formula?
I need to define the day not in a fixed way (star 12/3/2004 end
13/3/2004) but with a sort of global variable in which Crystal stores
the current day (start $TODAY/$MONTH/2004 end $TODAY+1/$MONTH/2004)
I'm working on crystal enterprise 9.
I will be very happy if you'll help me because I think that my chief will put me out if I don't do this! :(
thank you very much anyway, just for the attention! :)Hi,


use currentdate function for your date field in report selection formula. Then create an application to run the report (using any software like vb). Convert it as .exe.

Schedule the exe file using windows "Schduled task" and set the time.

Hope it'll help.

otherwise give more info