Search results for query: *

cheers, worked fine . I was tryin exactly what you had except instead of "" I was putting in NULL :(

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?

ah ok think i understand what you mean now, yes I jave reference the formula now and works fine cheers

sorry, i dont understand your reply

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...

when you say XI R2 do you mean just Crystal Reports XI or upgrade to Enterprise XI (which we have). I hope to be running the report using Enterprise at 11pm each night

thanks, as soon as I posted I knew I should have said what version i was using (XI) but I think we dont have R2 ! Is it free upgrade I wonder. I used to do this about 4 years ago usin Visual Cut for about £100 and only now do BO come up with their solution!!! thanks again

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...

Yes it worked and I split so one chart was under the other. Two questions , can the bars of data now line up under one another rather than be shifted to right. Could one of the charts be bar chart and one a line chart

yes thanks Dan, I have done this before but I just could not remember how I found it via the menus. BO have still not got act together on taking users through the charting options/process in a methodical manner!

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...

Not sure I understand your reply This is what I need : Report Header maxofthemaxansdelaygrand Group 1 Header maxansdelayHead1 X Group 2 Header maxansdelayHead2 X Group 3 Header (Suppressed) Data maxansdelay Group 3 Footer...

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...

OK as I said just started yesterday, I think it will be monday before I can gather this info. Will get back with this

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...