Search results for query: *

Right, but would it be possible to pass in what the formula returns to my SQL command parameter, essentially doing the same thing?

Another thing I just thought of, would it be possible to set that parameter equal to the formula? For instance: {?UserGroupSet} = {@UserGroup} Or SetParameterValue("{?UserGroupSet}", "{@UserGroup}") Not sure of the syntax but something like that done in Crystal. That would keep me from having...

I'm thinking a SQL command will work. I can create the parameter in the command and set it in .NET just like any other parameter (hopefully). I will keep you updated. Thanks for the suggestions.

The group formula has a parameter that is passed in through .NET to determine which grouping was selected by the user. Select Case {?UserGroup1} Case "Agent" If IsNull({@Name of Agent}) Then formula = " Unassigned" Else formula = {@Name of Agent}...

Yep, that is what I need to do. The problem is that I have dynamic groups based on a formula. My SQL expression would need to look like: ( SELECT STDEV(DATEDIFF(DAY, mod_appMilestones.AppReceivedDate, mod_appMilestones.PolicyToAgentDate)) FROM mod_appMilestones GROUP BY {@UserGroup} ) Trying...

I'm trying to create an "outlier" filter for a Crystal Report. We have some values that are throwing off averages and want to filter them out. Using standard deviation to filter out the upper end of values seemed like a good solution. In my select formula I originally had the following...

Looks like it has something to do with the subreport that's being used. If I add the @ClientName formula to the subreport, no error. Do I have to keep the formulas and tables between the main report and subreports synced?

I typed the field name in, but I can't find any errors regarding spaces or misspellings.

I had it set at the top to use Basic Syntax. Changing to Crystal Syntax still gives the error.

I have dumbed things down to make sure it is happening at @ClientName: reportDocument.RecordSelectionFormula = " {@ClientName} = 'Smith' " Same error ... @ClientName formula contains: formula = {aw_illust.CL1LNAM} I can also set it to just a blank string and it still gives 'This field name...

Here is a strange problem I have run into. My record select formula is as follows: {aw_illust.ORGID} in [55] and {aw_illust.AGENCY} = 'HCB' and {mod_illustrationDetails.CRTDATE} in #12/1/2009# to #12/31/2009# and ( InStr(UCase({@ClientName}), UCase("Smith")) > 0) and {aw_eCEntUsr.ENDDATE} =...