"Carolyn Vo" wrote:

> I am trying to incorporate custom assembly code calls inside of my sql that
> comprises my dataset. I open up the Generic Query Designer, select Command
> type "Text", and give my dataset a name "TempFilterTable". This is what I
> have done so far:
>
> ="select * from " +
> MyClassLibrary.CarolynClass.GetTempFilterTable(Parameters!scenId.Value,
> Parameters!coId.Value, Parameters!facRollup.Value, Parameters!catId.Value,
> Parameters!sortField.Value, Parameters!sortDir.Value,
> Parameters!filterId.Value, Parameters!userId.Value)
>
> I am getting an error when I try to do a preview. Is it even legal for me
> to invoke assembly code inside of the Command Text??? If so, what am I doing
> wrong here? I have defined the parameters for this dataset via the
> parameters tab of the dataset properties window.
>