What I want to do:
IF the row in Column AG and AH are both blank then don’t show that row, but if only one of the columns contain a blank or both contain data then show that row.
I tried this with an advanced Filter, doing an AND but it doesn't work. If I filter using <> under 1 column...
I receive a sheet each week with the data in the following format. What I have to do is select rows based on the number in col D then move those rows to a new workbook. So all the rows with 10 in the D col go into a new book, then all the rows with 12 in the D col go into another new book etc...
In Word 2003 I used to be able to create a style - Format menu - New - name it, then click on the Format button - Numbering - then select Outline Numbering - Then when I made my Table of Contents, the Numbering was brought into the TOC at the start of the text. The option to pick Outline...
You are allowed to put in 25 separate items into a Word drop down field - I would like to place more than that, say 40. How do I do this? Also, the character width per line, is 50 characters, can this be extended?
Many thanks
Does anyone know how to put in the Average sign - the X with the line above it - in Word (2000 or XP)? I've gone through the Insert menu and Symbol and can't find it, I've also tried Excel. Any help would be appreciated.
I am using Crystal 11. I have a date field and I need to look up the last month, which works fine using the LastFullMonth function. However, I also want to be able to see information for the month previous to that, whatever that month is. So, if I use this function today:
{Book.DateIn} =...
I am a Crystal Reports end user training instructor. A client I dealt with has asked for help with an issue they are having since upgrading from Crystal V6 to V9. I have tried, unsuccessfully, to recreate the problem and was wondering if any of you might know how to get around this. The...
Can Crystal Reports be used on a PDA? Would there be any particular limitations? What versions could be placed on a PDA?
I'm just looking for general information really.
Many thanks
In Crystal Reports 8.5 you could go to the File menu - Options - Reporting tab heading and click the down arrow beside 'Convert Date-Time field:' and choose 'To Date'. This facility is not available in Crystal Reports 9.0 or 10.0. Does anyone know how to carry out that same action in versions...
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.