How to do?! 1

[Vavan]

ASP.NET, VS.NET, VB.NET & CR.NET.
I have report made up on "SELECT * FROM USERS" but I need to get report pronted based on "SELECT * FROM USERS WHERE UserNAme LIKE 'A%'". Parameter field doesn't accept LIKE. What the solution?

 

[cbguru]

write your LIKE 'A%' clause in Selection Expert. Use '*' in your code and Crystal will replace it with a '%'.

Example:

TABLE_FIELD LIKE {?PARM} + '*'

 

[Vavan]

Can I do it in code, not with CR?

 

[Vavan]

You told "write your LIKE 'A%' clause in Selection Expert." but what should I select in expert - formula? but it doesnt allow to put LIKE. What to do? Help!!!!!!!!!!!!!!!!!!!

 

[LV]

You can set the report record selection formula programmaticaly:
reportObject.RecordSelectionFormula = "{table.table_field} like '" + myString + "*'"

This should do it.

 

[cbguru]

Did any of this work?

 

[Vavan]

Yes. I is working for TEXT fields, now I am trying to do for NUMBER field. I think it should be like ToText (...). am I right?

 

[LV]

Âîâà,
Íó êàê, ïîëó÷àåòñÿ?

 

[Vavan]

Ïðîáóþ. Òîëêî-÷òî çà êîìï ñåë.

 

[LV]

Äàé çíàòü åñëè ÷òî íàäî, ÿ ñ Crystal ðàáîòàþ ïîñòîÿííî. Ñïàñèáî çà çâåçäó lev.vigdorov@tgworldwide.com