Error text string in creating report from Sage ACT

[Former Member]

Hi there,

I am using Crystal Report Viewer to make a list of Opportunities from Sage ACT.  There are Notes attached to each Opportunity which are displayed below each Opportunity.  At the start of each Note a string of text is being pulled through, for some reason, stating eg. the font of the text.  Other people had the problem before, when they copied and pasted text into the Notes text box, but when they deleted the Note then re-added it, the problem went away.  For me the problem has stayed and now all Notes that I add I get the error text.  I did copy and paste some text a while ago but don't do it every time (ie problem has stayed)

Coding within the part of Crystal that pulls through the text string is in the text file attached.  The error text that gets displayed is the line that contains Microsoft Sans Serif.

Screenshot also attached.

I'm using Sage ACT! Pro 2011, Version 13.1.111.0, Hot Fix 6 and SAP Crystal Reports 2013 Support Pack 1 version 14.1.1.1036

If anybody is able to offer any help on this then that would be very much appreciated!

Kind regards,

Noel

Coding.txt.zip

[former_member183750 · Accepted solution]

Hi Noel

1st place to start will SP 6 as you are on SP 1. See the Downloads Portal:

https://websmp130.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/patch_download/main_public.htm

Now, to be honest, I get totally lost in your description of what it is you are trying to do. Perhaps a screenshot or two may help(?).

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter

[Former Member · Accepted solution]

Hi Ludek,

Thanks very much for this.  I've actually realised it's a lot easier than I thought...  Basically in my ACT the notes have in code, in advance of the note content, \fs17, whereas others in my company have \fs16.  Therefore in the code below all I have to do is replace the 7 with a wildcard...

Replace(Mid({SQL_Query.NOTE}, InStr({SQL_Query.NOTE},"\fs17") + 6, len({SQL_Query.NOTE}) - Instr({SQL_Query.NOTE},"\fs17")-6, "\par","")

...then it will take the notes which have either \fs17 or \fs16 in front of them.  For example if I edit the 7 to a 6 in the above it puts the error string in front of all the other notes (that didn't have them before).

Do you or anybody else know how to do this?  I've tried *, ? and _ but I think there must be something else in the code which means that it's not seeing it as a wildcard, as none of them work?

Thank you,

Noel

[Former Member · Accepted solution]

Hi All,

This is sorted now.  I took out the 7 at the end of fs17 therefore didn't need a wildcard.  Then edited the later 6 to a 5 to start at the right place.

Thanks for your help anyway.

Noel