Hi

I have a report that displays a set of generated numbers, these numbers being generated by a function, and this function is called by a procedure. I am using this procedure as the data source for my report.

Because I am using a procedure and not a view, when I created the report it is asking me to set the values of the parameters in the procedure (a start and end number) but i tick set to null, although when I actually run the report in CR it asks me for the number range, I put them in and it runs ok and shows correct data.

I can run the report as print previewer but when I upload the report to our VB app it crashes out with a windows error and i'm not sure why.

I'm not sure if it is something to do with the function returning a table variable rather than seperate rows, to be honest I do not know. All I know is it runs in the CR app ok but in VB app it causes windows system error and asks if I want to send error report, then it shuts down.

Maybe someone has had a similar problem and can lend me some advice or someone knows the ins and outs of displaying a table variable from a sql server function in CR?

Thanks

G

There is an option to do that in VB app and I can do this and then when I run it, it crashes out.