Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2005-05-17 : 05:22:53
|
| I have the following line which passes RecordSelectionFormula to a crystal report. It doesn't work,the report is blank. If I step through the code the value appears as Like '%CALL CENTRE COMPLETED%'strDIV is dfefined soDim strDiv As String = Me.ddlDivision.SelectedValue req.ReportState.RecordSelectionFormula = "{tblSL_Calls.Division} Like '" + "%" + strDiv + "%" + "'"If I run the code using this line the report returns the correct records.req.ReportState.RecordSelectionFormula = "{tblSL_Calls.Division} ='" & strDiv & "' "What I'm trying to achieve is that if the user doesn't pick a value from the dropdownlist all values will be returned. |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2005-05-17 : 07:16:17
|
| Looks like you are not connecting to your SQL Server. If you run the code in analyzer and get a result set, but your code in your page(form) does NOT return anything, either you are not connecting or you have no permissions to execute the SQL.*need more coffee* |
 |
|
|
|
|
|
What's wrong with these wildcards ????