Search results for query: *

I want to conditionally format a whole column in a sheet so if the data held is less than today it will change colour eg Format > Conditional Formatting 1st box as "Cell Value Is" 2nd box "Less Than" 3rd Box - type =Today() fill format Pink BUT the trouble is I want to exclude those rows...

Using Excel 365 I have historical data on one tab and pivot table in another. I want the pivot table to automatically include date=> today () , but in row filter selection it looks like you cant put arguments like this in?

I have an Excel workbook, te first sheet contains data I enter plus lookup and formula etc. I save this as a CSV and import to a system - all good. The issue is my formula and lookups go down to row 250 and my number of rows I enter data in is variable. I ONLY want to save to CSV the "full"...

I am using Crystal XI I have data showing in seconds. I created a formula called ' @non-available HH:MM 'to convert to time format as below : WhilePrintingRecords; StringVar Hours; StringVar Minutes; //StringVar Seconds; NumberVar nonavailactivityscheduled...

Is it possible to export a hierarchical (grouped) report into PDF format and take the group tree with it so you can see and select the data in the PDF

I am using Crystal XI, I want to do create summary data in various hierarchy groups I have in report. Unfortunately the data in details can be the same for each record sometimes so I have to do my first grup summary on maximum. But how do I then do summaries on that maximum eg records...

I have a problem driving me crazy. I have afeeling that arrays may be the answer although i have NEVER used them,but can someone help me. I am using Crystal XI I want to group into ' date buckets ' a count when date is logged as below Time bucket Date logged Logged Day no Current day no...

I am using CR XI I have a time axis and want to plot 2 items against time on same chart but they have vastly different values. One is a count of calls (C) and can run into 000's a month, the other is the %SLA (S) I want it as a bar chart with C axis amonuts on left and S axis amounts on right...

I am using BOE XI I have a report where I have set up a hyperlink to a website. It works as a stand alone report and web site opens when you click on it When the report is saved in Enterprise and run from within it the hyperlink doesnt work as it puts the url of the server before the url...

I am using CR XI I have some call center data arranged in group hierarchy I want o show the maximum call length and convert to HH MM SS I have no problem with the data and grand total but cant seem to show the max by each group To prove the figs I have the data and ahave done a max by each...

I started new role yesterday and trying to run reports is nightmare. Using Crystal XI on Oracle call center system -it has about 1.5 mill records over last 7 years Had quick and mean quick review of reports design . They all run from linked tables of about 4 or 5 (generally the same ones) using...

I have a time as a number in a field unfortunately eg 150221 or 95022 and I need to convert to HH : MM : SS so on these example would like to show 15:02:21 and 9:50:22 (or maybe even 09:50:22 to look better?) I am using CR 8.5 Many thanks

I am used to conditinaly seting colour attribute to change depending on condition in the X-2 formula format box eg crRed to crBlack I am using Crystal v 8.5 I want to test flags and make bold instead of regular and also make Underline instead of not undelined depending on result in appropriate...

I have a report as below Group1 - Action Shows Field headings Group2 - Batch Hidden Detail A Before data Detail B After data I have grouped each transaction by its batch no (before and after in effect) Each transaction before and after has the SAME id and...

I am using Crystal 8.5 I have times in would you beleive in number format eg 153810 which is 15 : 38 :10 , How do I make the conversion

I want to format alternate rows in different background colour in Crystal 8.5 I cant remember how to do this - I think it was on remainder being 1 on record count in format display. can somebody remind me please