Search results for query: *

Hi lbass, Thanks for your reply. I have the same problem with the display of the string simply removing the Chr(9)! Not only does it not detect the Chr(9) using InStr, but it misses it out when displaying it and doesn't even display a space instead. Since I am fortunate enough to still be...

Hello, I have a database field containing text that is split using the "Horizontal tab" character, i.e. ASCII code 9 (vbTab). My Crystal Formula (Basic syntax) needs to detect this using InStr but this does not appear to find it. e.g. using iChar = InStr(iStartChar, strToSearch, Chr(9), 1)...

1) Yes. Maybe I need to somehow reset the report, as I have deleted other things from the report that USED to try and use this SP? More double-checking needed that they're all gone... 2) Thanks - I shall look them up. This has got me started again anyway - Cheers! Liam

Hi Reebo, Thanks for your reply. I have tried this out but now I get asked for the parameter to the stored procedure when I run the report (it appears to ask me several times, perhaps once for each header?) If I can get round this, does this mean that any formulas I write within this new...

I am trying to create a crystal report (Using Crystal Reports for Visual Studio.NET) that uses a formula to decide how to lay out text for a Group on the report. I have a stored procedure called sp_GetTestSetLevel that takes the ID of a TestSet record, and recursively works out what level it is...