Search results for query: *

Hi all, I don't understand why this is not working. To me, it should so I must be missing something! I have a main report with 3 subreports, each in different sections. I want to suppress the sections dependent on the value of a field. This is working fine, unless that value is null. If the...

Hi again all, I have another issue with an excel export. Basically, I have a shell report which purely contains sub reports. These subreports work fine by themselves, but when added as a subreport. Some of the fields become merged cells when exported to excel. I suspected I may have some...

Hi all, I have a Crystal report which has values which could be number or string. The aim is to have them formatted as number if they are numbers and string if they are not - once they are exported to excel. I have tried writing a conditional formula but since they are both going to live...

Hi All, I have a crystal report with a pie chart on it. The report is fine but the user would like the chart to be sorted going clockwise so that the biggest section would be in the top right, then go round so that the smallest section would be in the top left. Is there any way to sort a...

Hi All, We have recently upgraded to Crystal reports 2008 from Crystal Reports 9. I have been making some changes to a report that was created in Crystal 9 today and it appears that every time I export it to csv from Crystal 2008 the data is getting duplicated many times. It works fine when...

Crystal 2008 HI , Im trying to export a report as csv but currently nulls show as simply that, nulls. I want to have a formula field that will replace the field in the section to force the report to show "" istead of nulls. The issue has arisen since we have upgraded from CR9 to 2008. CR9...

Hi Guys, Im writing a report that is going to export to xml. The report has multiple detail sections as I need this for the receiver of the xml. My question is, How can I have a formula field, that can appear on both detail sections but show different values. What I specifically need is a...

Crystal 9 Oracle 9i Hi Guys, I havent been able to do much with Crystal for a while so feeling a little rusty! I have a formula field that holds the customer name and address, this is then being grouped by. Due to the address being in the group I need can grow on the group header. My...

Hi Guys, im running CR9. Im trying to get the prvious days data unless its monday, then I want to return Fridays, Saturdays and Sundys data. I have the following in my record selection but the report is still returning wrong data. {wmTransaction.TransactionDate} < currentdate and...

Hi guys, getting with error on a script 'Cannot insert duplicate key row in object 'CUBE_DIM_PC_PART_TAB' with unique index 'ixCubeDimPcPart_ItemKey'. The statement has been terminated.' This is the result of this script if exists (select * from dbo.sysobjects where id =...

Hi Guys, My sisters been in the settings again. surprise, surprise, she has broken something. Although this isnt on pro edition i dont really know where else to go. She has xp home edition so i thought you guys might be able to help anyway. From what she has told me she has either changed one...

enterprise 9 Hi Guys, I have been asked to set up a schedule using enterprise that uses FTP to send a file to somewhere else. i have never done this before so i dont really know what i need. I currently have the address of an FTP site ftp:\\blahblah-blah.blah (obviously not the real address i...

Crystal 9 Hi guys. Im getting an unwanted extra comma when exporting to CSV from Crystal. I have the report running from a command with the column names in a union as our version of crystal doesnt work properly when exporting to CSV. The exports im getting are like below but i want the last...

Crystal 9 Oracle 9i Im tring to get the group headers to print on every page but only if drilldowngrouplevel > 1. I know of the 'Show Group Header on Every page' function on change group options, but there is no formula section to control this so it will show on top level also. Im not sure...

Oracle 9i Crystal 9 Hi guys I have some problems with my version of Crystal and doing anything with lines, in that it makes it crash. I know that other people I work with have the same problems. Was wondering if anyone knows of a hot fix for this?

Crystal 9 Oracle 9i Hi guys, Im having an issue with one of my parameters in a command i have. I have set the parameter up in the command and have set the defaults to S or L. For some reason tho, Crystal keeps telling me that 'S' is an invalid identifier. Can anyone see anything wrong with the...

Does anyone know how to get a group header to appear on every page? Apparently it is possible

Oracle 9i Crystal 9 I have been asked to show a summary that is currently in the report header on every page. I tried to just dragging it down but it didnt work. I then tried to make a running total summarising the same field and placing that in the page header, but thats only summarising the...

Hi guys, I have a machine running 98 se, well it did. Everytime I try and start, it goes into the startup menu where it says windows didnt shut down properly and gives you options of starting it into safe mode etc etc. If I try to start it in normal mode it hangs on the windows logo screen...

Does anyone know how i would be able to produce summarys at the begginging of a report? What it basically is, is that Im reading from a file with different types of suppliers in it. These suppliers can either be a L type or an E type. What i need to do is count how many of each are in the...