Search results for query: *

Managed to get this working now.... For some reason, I have to check for nulls first. This code works isnull({CERT_AN_REP\.COA_FMT}) or {CERT_AN_REP\.COA_FMT} = '' or {CERT_AN_REP\.COA_FMT} <> "COA_SHET"

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

Thanks, It appears as though this does work. However, it appears as though it still struggles with export - Data only. Its not an issue, I have spoken to the user and they wont be using that option anyway.

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

Poblem solved. I Used the top N button in chart expert and selected all. seems to do the trick

Sorry, Im using Crystal Reports 2008

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

Do you mean it gives you a blank page before the group? If so, if you select the option from above on the group footer and not the header it should be ok.

in the section export on the paging tab you can tick the new page before box. That should do it

Do you kno what the values in column B could be? Are they all letters from the alphabet? if so, there is a way this can be done. You could create a formula field that checks the value and shows it eg. If column_b = "A" then column_b else "" and then you would have a formula field for b, c...

I would make a formula field that does If treetype = "I" then "S" else treetype and then group by that field. Then create a summary field for quantity. What do you need to show for item code?

I think there are different ways depending on the format you want your export to be in. The easiest way is to format as pdf and set the shedule to only do pages 2 to 2 (Im not sure what will happen if you need more than 2 pages but I asume this will handle them, if not the second value may need...

Do you want to stop the run or not show it in the history? Im not sure if this will help but in the past we have had reports that get emailed out but could be empty very often so didnt want them emiled if they were. To get around this we set the report up to have an empty page as the first...

I have just tried to re-create your problem with no joy. However looking at your formula, maybe it needs some brackets? IF ({PAYLIST.AMOUNT}+ sum{CUST.CREDIT}) <> ({PAYLEDGER.AMOUNT}+sum{CUST.CREDIT}) then ({PAYLEDGER.AMOUNT}+sum{CUST.CREDIT}) else ({PAYLIST.AMOUNT}+sum{CUST.CREDIT}) dont...

No, I hadnt. That was the solution. Thanks!

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

thanks for your replies. Yes, I need to reserve the space in details b. It seems that surpressing the field leaves it out of the xml export though. I basically need a field that appears in both deatils a and details b but has the value in details a but be blank in detail b. However the field...

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