Hello
I'm creating a database that will contain information on committee events. Each committee will contain the following information.
Committee Name (Text)
Committtee Date (Date)
Pre Agenda Date (Date)
Manager Deadline (Date)
Draft Deadline (Date)
Final Deadline (Date)
I am looking for the...
Hi
The only way I can think of solving this problem is to create the SQL command below so my data will look like:
Learner_ID Product_Ref mdate type
1 1 01/04/2007 Expected
1 1 01/05/2007 Expected
1...
Hello
I would like to group my report by the following groups based on the below database design but I don't appear to be getting anywhere. Any help to get me up and running would be greatly appreciated.
Expected Milestones
Achieved Milestones
Expected Qualification
Achieved Qualification...
Hello
When I run my report I get the following error message:
A running total cannot refer to a print time formula.
I think the reason I am getting this error message is because my formula dates are worked out in a subreport then passed to the main report for processing.
The subreport works...
I've created a report in crystal XI which includes two sub reports. When I run the report, sub report two starts on the second page even though report header a and b only take up 45% of page 1. I would expect report header c to start on page 1 and take up the remaining 55% of the page.
Report...
Hello
I have a report which is grouped by officer and development type. Everything displays correctly, except if there are no development type against an officer, the development type does not display. For example using the below database information the only development type that would...
Hi
I have a database table that contains dates for the last 3 years. I know its possible to find out the period 1 from date for 2007 using a running total but is it possible to find out the value using a formula ?
Database Table
------------------
Year Period SetID DateFrom DateTo
2007 1...
Hello
I would like to pass two formula's(Period 1 From Date, Period 1 To Date) from the sub report to the main report then use these formulas in a running total to work out how many clients have been registered during the first period of the financial year. I've followed the article at the...
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.