Recent content by nixy2000

You could just wrap the SQL inside a stored procedure and pass the parameter to that? e.g. create proceedure spnamehere @parameter as nvarchar(50) as Select E.bandlabel FROM ECL_Ranges E where E.testsectionabbr='S' AND E.eclabbr = 'A' and E.FP_Key = @parameter

I have crystal 8.5 and am trying to connect to a cube running on SQL Analysis Services on a seperate machine. There are approximately 10 cubes on this machine. I have set up a role to allow me to access three of them. If I try and connect with Excel it all works fine, If I try and connect with...

That worked a treat, Had a minor issue with the linking but it worked in the end Thanks

Apologies, New to this so here goes. I have a report that contains approx 9 subreports, each of which is passed a date parameter {?Running Date}. When the report was initially specified there was no indication given that this was not satisfactory. However now we want to set up a schedule and...

I have two parameters and want to override the first based on the value of the second. i.e. Something like if {?Use Current Date} then {?Running Date} := CurrentDateTime Anyone know how/where I can do this as I am having problems getting it to run