Search results for query: *

synapsevampire I'm sure it is not passing the where criteria. When using a View, I see the record counter in the report get over 2m before I am displayed the 10 or 20 pages of what I'm looking for. This is my record selection formula: IF {?Reference Code} <> &quot;&quot; AND {?Account...

Thanks Naith but, as I've been trying to explain, the proc is fine. I have no problem with the proc. I can exec the proc from the Query Analyser window and get exactly what I expect. What I need though, is to be able to exec it from Crystal Reports. I need to get Crystal Reports to send a value...

Stripping the values is not a problem, I just can't supply the multiple values. Crystal Reports will not allow multiple values to be entered-for/supplied-to any one parameter in a stored proc. The only solution I can see at the moment is to allow the users to enter 1 long string for the...

Hi Naith. Yes, I will be stripping the values from the parameter. Currently, I have set the proc to accept the values, then generate a text file containing the values that I intend to strip, hoping that I can then analyse the text file data and determine my delimiter. Unfortunately, when I point...

I'm using CR8 with an MSSQL7 database. My users want to be able to enter 0, 1, or Many account_codes as parameters for the report. I can accomplish this with a View, but the report is then too slow, so I want to use a stored procedure. I've tried having a huge nVarchar field in the proc, hoping...

Hi. I have a report that has stopped working since the server was rebuilt. The .rpt runs smoothly, but the compiled .exe just hangs after entering the password. I have registered the DLL that it requires, used the Report Distribution Expert (RDE), even built the report again from scratch but...