I believe this will work for you, if I am understanding your question correctly.
Make a new formula field. I'll use the name DateChk for this example. Place the following formula in this field.
IF year(hiredate) = year(currentdate()) AND month(hiredate) = month(currentdate()) THEN 1
ELSE IF...
In the table you are pulling this info from: is the field allowed to be null or is it set to default to zero?
If it is null in the table I would assume it would be blank in the report (mine normally is unless I script it to default for null values).
You could always make a formula field. Is...
Sorry, I didn't get that there was no record in the table at all for that instance. I was just thinking of a null field. Let mw think about it - that is a bigger problem.
Don't try to add {current_transaction.amount} to 100. Crystal can't add a number to NULL. If 100 is the answer you want just do
...then
100
else
{current_transaction.amount}
I'm not sure what your layout looks like. I assume you will be using a group on name. I would try placing a count in the group footer on dates of service. You could supress the field so it didn't show. That would give you a field to filter by in your selection criteria. Worked on the quick...
I believe the code below will do what you are looking for. I tried to clean it up some without changing your overall layout much. In my experience all of the parenthesis are not necessary. They just make it more difficult because you have to match them. I prefer to just stick to a "tabbing...
I'm not 100% sure what you are looking at. If you would like a different way to look at setting up an ODBC connection try this site:
http://www.herongyang.com/jdbc/JDBC-ODBC-DSN-for-SQL-Server.html
I personally have never tried to use one of the strings they are talking about on...
You've probably solved this by now. However, I had to do some searching lately to fix a report I had created with a csv file. I've never created a report in Crystal from a csv file before and I found out the reason my report was so terribly slow (9 min) was that I had used the wrong kind of...
Would anyone have an idea on how to use a count from the previous time a report was run in a calculation when the report is refreshed?
What I'd like to do is track the change in the # of orders (in each group) on the report from the previous day to today. I assume that it would involve storing...
The original graph that I am trying to duplicate showed the production categories along the y-axis and dates (current date forward in week increments) on the x-axis. The actual date was then plotted on this chart.
The purpose was to visually see where the minimum starting date would appear in...
I am trying to use Crystal Reports XI to recreate reports and graphs that were originally done in Access/Excel. I am pretty familiar with designing reports in this software but have never used the graphs before now. What I would like to do is graph the minimum start date per production...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.