Trying to get a stored procedure to run in report builder. Not finding any good examples. Attached is the code I am using but not returning data

pGetPart “(@PartNumber)”

I am going to assume that @PartNumber is your parameter for the stored procedure.
Have you tried just

pGetPart @PartNumber

I have tried that but get this error

WARN: Simple Query could not be completedMust declare the scalar variable “@PartNumber”.

You need to replace @PartNumber with the component value that you want to pass to the stored procedure.

Got it working thanks