Search results for query: *

Thanks for all your inputs. I went back to the company we are importing the file on their platform with the files rejected and they confirmed there was an issue with the template they provided and sent through a revised template with different column names. Import is now successful without use...

Neither "textname"&chr(13)&chr(10) nor "textname"&chr(10)&chr(13) has worked. IdoMillet - I don't think issue is with BOM. What I have tested so far is that, I run my report and export to CSV. So far so good. When I try to import into the client's platform it fails. When I take the CSV...

Just tried "textname"&chr(13) and that didn't work. trying "textname"&chr(13)&chr(10) and if this doesn't work, i'll change this over as "textname"&chr(10)&chr(13) to see if it works. Thanks for all your response. I will advise shortly or let me know if the formula should be written in a...

I understand what you mean. Problem is how do i diagnose this? Just reading through the document provided along side the template from the client about upload to the platform. It says must be CSV and column headers have Carriage return line feed (Crlf) as end of line delimiter. I am going to...

Good day, Hoping someone can help. I exported my report from crystal report to CSV format with the headers and all columns coming out right as expected. I have a client platform that says a file must be imported as CSV and the CSV format exported from crystal report seem to fail during import...

Perfect! Works fine. Thanks again.

I did remove the reset the formula. Should have mentioned that.

Yes, i am using option 1. I moved the sub-report to the report header and nothing changed. 745 is not highlighted, but 240 only is.

Lbass - just wondering if i had the following Stockname: Amazon Shares Order Ref | Amount 123 | 240 345 | 345 678 | 2,898 789 | 745 978 | 240 998 | 120 999 | 63 Stockname: Amazon Shares B Order Ref | Amount 222 | 745 456 | 888 How can i get the duplicate to look across the all sections for...

Thanks for your help. I will test option 2 also, no harm having more alternative solutions to a problem. Really appreciate it

Just added the reset formula and works perfect! Thanks very much lbass

Saved a Sub-report version of the main report and created a formula by copying and pasting your {@dupe} to mine and Substituting sum totals with mine. >> insert the formula in the group header 2b which is {table.orderef}. Created a new formula in the main report using what you provided...

Hello lbass. Thanks so much for taking the time to test and post this process. I used option 1 for the colour highlight and worked well, however it seems that the first row of every sub group is always highlighted irrespective if it has a duplicate or not. Where duplicate exist, this worked but...

No, not more than 1000.

Thanks lbass, both duplicate sums should be highlighted e.g 240 both highlighted. And where another another sum duplicate is found, a different highlight e.g 745, if possible.

Hello, I have a report that has a grouping and the amount is a sum of Amount totals based on this group. What i will like to do is check within the same column if an entry already exist and highlight it in bold or colour. Example: I am grouping by example Stock Name: Stockname: Amazon Shares[...

Fantastic! Worked perfect. Many thanks Ian.

Thanks for that Ian. problem however is that should the currentdate be the 1st of a new quarter, i want the from and to date to show previous quarter as this is what the record selection is picking up. Example, if current date is 01/04/2012, your formula will be showing the heading as...

Hi, I am using Crystal 2008 and am trying to display the actual dates used in my record selection. I have a formula used in the record selection run for quarter period as: Formula: If currentdate in Calendar1stQtr Then {CLIENT.VALUATION_DATE} in...

Thanks LB Appreciate the help. For now the decimals displayed (for my calc) is 2dp, but glad you gave the example for 4dp as well as both logic are very handy. Much appreciated. Sol