Crystal 8.5
I am creating a report that I want to have display a coverpage that lists all the groups that result from the select statement. It is undetermined which groups will be displayed and there will never be more than 10 groups overall.
In order to capture it I created a formula that...
It sounds like you need 2 groups.
First group by effective date
second group by account #
You can still use the same scenario for each account # group under the effective date.
Hope this helps
Are you trying to group by account # or by the gifteffdate initially?
You can create a group on the account # and then list the details of the account under that group or vice versa.
It is unclear from your writing but it seems that you need to create a balancing formula.
For each account #...
In the Font Format Formula editor for the date field on the report you can enter the following
if today - CurrentFieldValue > 3 and
WeekdayName (DayOfWeek ({your_referenced_date_field}))
in["Monday", "Tuesday", "Wednesday", "Thursday", "Friday"] then crred else crblack
//Enter whatever your...
In Format Crosstab, under the 'Customize Style' tab highlight the appropriate row that you want to suppress and check the box under Group Options 'Suppress Subtotal'
Crystal 8.5
SQL Database
There are 2 tables 'WorkOrders' & 'TimeCharges'.
I want to show all work order records only when there is no matching record in the timecharges table. Essentially I am trying to display when time has not been applied against a work order.
Linking field is 'wonumber'
I don't follow you on that.
Why is it that functions that contain caluculated variables don't show as available data elements in the graphing expert field list?
I simply want to be able to show a variable on a graph.
Crystal 8.5 SQL Database
I am trying to do a line graph that I want to display a variable that is a counter.
I am counting the number of work orders grouped by type and time period and am using an incrementer for the purpose because the counter has to be in a group header/footer.
How do I...
CR 8.5 SQL Database
How can I display the selection of multiple parameters that I have chosen on the report i.e. in the page or report header?
I have a crosss tab that tabulates work orders based on date created and type, but I use a parameter that allows you to select which shops you have...
It sounds like you have a database that allows the entry of various addresses under the record identifier. But the record identifier (family number) does not have to be unique or is it? Is there a unique identifier that you can key off of?
Is there a parent table that keeps just the...
I was able to perform the Crystal suggestion and was able to identify what was complete or incomplete.
I am unfamiliar as to how to implement the SQL suggestion you gave me.
I will still need to subtotal the completes and incompletes.
I'm not sure if you tried this, but you can right click on the individual fields and select Format Field, then under the Common tab check the suppress if duplicated box.
If this leaves you with a blank label you can the go to the Format Section and check the Suppress blank section box.
Hope...
I also posted this in the formulas forum
I am trying to design a report that will group records based on date range parameters.
There is a WORK ORDER table joined to a TIME CHARGES table by the WORK ORDER NUMBER.
I need to indicate the work order as completed based on when time was entered...
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.