I am using Crystal 8.5, I have subreport with a shared numbervar Monthly_Charges := that distinctcounts total failures, "monthly" and a main report that sums total mileage, "monthly". I can't get the shared numbervar to reset monthly. The last month total is 110 and in the main report the total...
I am creating a crosstab that has 4 years of data (i.e 2009 to 2012).
I only want to show the results for January of each year.
A B C
2009 (Jan) (Jan) (Jan)
2010 (Jan) (Jan) (Jan)
2011 (Jan) (Jan) (Jan)
2012 (Jan) (Jan) (Jan)
I have two groups (Date, "annually" and System type). I'm using running totals for counts on system by month in a year. For example:
GH#1 2010 JAN FEB MAR
GH#2 AB 5 8 3
CB 4 2 3
DB 6 2 3
GH#1 2011 JAN FEB MAR
GH#2 AB 8 3 5
CB 2 3 4
DB 2 3 6
I want to show the variance per year, per month...
I'm using Crystal X and I am trying to create the option ALL in my parameter. My parameter is 1,2,3,4,5 How do I select all of them without clicking on each one?
I have a parameter that allows for multiple values. I want to add this to my title. For example my parameter is either A or B or Both. If a user selects A then A should be in the title. How do I create a title that shows a user as entered in Both (A&B)?
I want my report to show the first day of the week in the title. My query is for the lastfullweek and my formula in my title is minimum({datefield.field}). If I don't have any data for Sunday the title displays the minimum date. How can I show the first day of the week (Sunday)in my title?
I am using CR 8.5 and CR X, I have a crosstab that is too wide for one page. I want to have the remainder of the crosstab display below the 1st part of the crosstab on the same page. Can this be done? if so how?
I want to display the week ending date (i.e. Work Orders created for the week ending 9/29/07).
I am using the create date field (wo_create_date). The create date can be any day in the week.
I'm using Crystal 8.5,In the select expert Crystal allows a user to query in the period of "thelast7days". I want to run a query for the period of "Last 30 Days" or "Last 60 Days" etc...
I want to show the following
Monday Tuesday Wednesday
Team Car Team Car Team Car
01 7261 01 7233 01 7248
02 7264 02 7334 02 7658
03 7111 03 6555 03 6767
I can't use a crosstab because there are no calculations to be performed. I want the week days to go across the page rather...
I created a formula to find the difference between one record and the previous record. My problem occurs when I want to total the formula column. I can not add a summary. If i try a formula i.e. Sum (@MBI) I get the following error message "The summary/running total could not be created
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.