Search results for query: *

Thanks Gordon, you pointed me in the right direction. The insertion formula was looking at a discrete date. Changing it to maximum(date) rectified the issue. regards, David CRXIR2 with CRXIR2 server and SQL 2005 CR2008 with CR2008V1 Server and SQL 2005

Why did this happen to my crosstab?? I created the report last week with the two calculated members to the right. I would have expected March figures to be after February. The formula for 6 months Avg is: average([ GridValueAt(currentrowindex, currentcolumnindex-1, currentsummaryindex)...

I have a report looking at @customers (Group 1) and @Contract (Group 2) I need to select Customers based on a Contract Start Month. A Customer with multiple Contracts may have Contracts starting in different months. If one of a Customers Contracts starts in a given month, I want to return all...

I have a report with a SQL parameter (Customer). on the report is a subreport also with a SQL parameter (Customer). Can I pass the parameter from the main report SQl to the subreport SQL? regards, David CRXIR2 with CRXIR2 server and SQL 2005 CR2008 with CR2008V1 Server and SQL 2005

CR2008.. I have a report looking at a call centre stats. It has 2 groups, date - weekly (G1) and Vendor (G2) In the report footer I have a bar chart with 2 series measuring calls taken {@calls} by agent and fix by agent {@fix}. I now need to chart on {@fix}%{@calls} by agent to measure...

I used this sometime ago, might be able to adapt.. Function (DateVar v1) //Q1 = Mar Apr May If Month(Today) >=3 and Month(Today)<=5 then (Year(v1) = Year(Today) AND Month(v1) in [3,4,5]) Else //Q2 Jun Jul Aug If Month(Today) >=6 and Month(Today)<=8 then (Year(v1) =...

Legend Pete!! thanks very much for your prompt reply. regards, David CRXIR2 with CRXIR2 server and SQL 2005 CR2008 with CR2008V1 Server and SQL 2005

I have been working on a report in designer and using some text fields to create a date field and choose a day to display. whileprintingrecords; global stringvar GVAR1:= if {Command.User ID} = "Date" then left( WeekdayName (DayOfWeek (Date(totext({Command.1}) + "/" +...

I am developing a response time report where I need to make allowances for public holidays. Simple you may say, use Ken Hamady's business days formula. In Australia, and probably elsewhere too, we have holidays that are state based so this formula wont work. In my ERP I have table of public...

Has anyone got any thoughts on this?? regards, David CRXIR2 with CRXIR2 server and SQL 2005 CR2008 with CR2008V1 Server and SQL 2005

I have a report with 5 columns calculating business days between milestone business dates. I am trying to chart these values in a 3D bar chart using count of values. ie, column 3 in data below would show a count of 3 for 1 and a count of 1 for 5. C1 C2 C3 C4 C5 35_14__1__1_12 _1_12__5_34__1...

From Crystal Help: Use the Space function to easily add a specific number of spaces to a text string. {customerID}+{customer_name}+ Space(5) regards, David CRXIR2 with CRXIR2 server and SQL 2005 CR2008 with CR2008V1 Server and SQL 2005

http://www.sql-server-helper.com/tips/date-formats.aspx regards, David CRXIR2 with CRXIR2 server and SQL 2005 CR2008 with CR2008V1 Server and SQL 2005

Hi there, I have a table of printer meter readings that show monthly reads. GH1 is the printer serial no and detail contains the reads. GH ABCD1234 D 35409 01/07/2010 D 36251 05/08/2010 D 0 21/09/2010 D 0 11/10/2010 What I am trying to do is show the pages printed in the 4...

Is it possible to use a sql parameter to first limit the data and then follow up with a dynamic parameter? regards, David CRXIR2 with CRXIR2 server and SQL 2005 CR2008 with CR2008V1 Server and SQL 2005

I have a report that uses a Dynamic Data Connection. The same DC is used for the subreport but a different BV. Can I pass this DC to the subreport so I do not have 2 parameters to fill. regards, David CRXIR2 with CRXIR2 server and SQL 2005 CR2008 with CR2008V1 Server and SQL 2005

Is it possible to see report alerts in Crystal Server 2008? regards, David CRXIR2 with CRXIR2 server and SQL 2005

I need to report similar to a vehicle log book where you fill in the odometer reading daily, not distance travelled. At the end of the month I total the km travelled using maxread - min read. Quite simple really.. I also have a second and third vehicle that I do the same for. How do I get a...

Thanks Turkbear, Join was a function that I had forgotten. In my case I just used a formula Join({?Criteria}) and then suppress section using "1" in {@CriteriaArray} Works perfectly. regards, David CRXIR2 with CRXIR2 server and SQL 2005

I have a report that has multiple subreports, each contained in a separate report header. I can suppress each of these reports seperately with an individual parameter ie. parameter to hide RHa, RHb and so on. This looks very messy when the report is run and because the list is so long, a fair...