Comments for SELECT STUFF FROM SQL https://sqlprogramming.wordpress.com a blog about SQL programming Thu, 04 Nov 2021 05:31:56 +0000 hourly 1 http://wordpress.com/ Comment on SSRS report throws an error that says a parameter doesn’t exist when the report designer clearly shows the parameter exists by Andrew Partridge https://sqlprogramming.wordpress.com/2012/04/26/ssrs-report-throws-an-error-that-says-a-parameter-doesnt-exist-when-the-report-designer-clearly-shows-the-parameter-exists/#comment-230 Thu, 04 Nov 2021 05:31:56 +0000 http://sqlprogramming.wordpress.com/2012/04/26/ssrs-report-throws-an-error-that-says-a-parameter-doesnt-exist-when-the-report-designer-clearly-shows-the-parameter-exists/#comment-230 I just had this very problem again (it pops up from time to time at just long enough intervals that it throws me every time). This time the parameter in question is an internal parameter with a default value that is a fixed string – no dependencies. I simply dragged it from the bottom of the parameter grid to near the top and the error vanished.

Liked by 1 person

]]> Comment on SSRS report throws an error that says a parameter doesn’t exist when the report designer clearly shows the parameter exists by Richard https://sqlprogramming.wordpress.com/2012/04/26/ssrs-report-throws-an-error-that-says-a-parameter-doesnt-exist-when-the-report-designer-clearly-shows-the-parameter-exists/#comment-213 Wed, 28 Oct 2020 18:53:20 +0000 http://sqlprogramming.wordpress.com/2012/04/26/ssrs-report-throws-an-error-that-says-a-parameter-doesnt-exist-when-the-report-designer-clearly-shows-the-parameter-exists/#comment-213 In reply to Chuck as Salerno.

Sorry, Chuck. I’m not really an SSRS expert. Have you tried asking your question on Stack Exchange?

Like

]]> Comment on SSRS report throws an error that says a parameter doesn’t exist when the report designer clearly shows the parameter exists by Chuck as Salerno https://sqlprogramming.wordpress.com/2012/04/26/ssrs-report-throws-an-error-that-says-a-parameter-doesnt-exist-when-the-report-designer-clearly-shows-the-parameter-exists/#comment-211 Tue, 20 Oct 2020 12:52:49 +0000 http://sqlprogramming.wordpress.com/2012/04/26/ssrs-report-throws-an-error-that-says-a-parameter-doesnt-exist-when-the-report-designer-clearly-shows-the-parameter-exists/#comment-211 I understand the order of parameters but need to be able to test whether a parameter has been established or not. I’ve tried to use IIF( IsNothing(Parameters!Param1.Value) but still errors out with “The expression references the paramter ‘Param1″ which does not exist” is there another test?

Like

]]> Comment on SSRS report throws an error that says a parameter doesn’t exist when the report designer clearly shows the parameter exists by Richard https://sqlprogramming.wordpress.com/2012/04/26/ssrs-report-throws-an-error-that-says-a-parameter-doesnt-exist-when-the-report-designer-clearly-shows-the-parameter-exists/#comment-117 Mon, 13 Feb 2017 16:47:30 +0000 http://sqlprogramming.wordpress.com/2012/04/26/ssrs-report-throws-an-error-that-says-a-parameter-doesnt-exist-when-the-report-designer-clearly-shows-the-parameter-exists/#comment-117 In reply to RJ Gilmore.

Hmm… This is a tough one, RJ. Did you try matching the order in each list? What happened when you did that? Sadly, this is something you may just have to play with. Try and get your head into the interpreter and think about the order it needs the parameters and put them into that order. If that doesn’t work, let me know. I’ll be mulling over what else might work.

Like

]]> Comment on SSRS report throws an error that says a parameter doesn’t exist when the report designer clearly shows the parameter exists by RJ Gilmore https://sqlprogramming.wordpress.com/2012/04/26/ssrs-report-throws-an-error-that-says-a-parameter-doesnt-exist-when-the-report-designer-clearly-shows-the-parameter-exists/#comment-116 Fri, 10 Feb 2017 19:05:50 +0000 http://sqlprogramming.wordpress.com/2012/04/26/ssrs-report-throws-an-error-that-says-a-parameter-doesnt-exist-when-the-report-designer-clearly-shows-the-parameter-exists/#comment-116 I know this is my problem, too, but have tried everything in the XML to arrange the order and nothing is working. Do I change the data sent parm order to match the parms in the SSRS parm list or what? I have 12 data sets and 5 totals parms which are not all used in each data set. Any suggestions would be hlp

Like

]]> Comment on SSRS report throws an error that says a parameter doesn’t exist when the report designer clearly shows the parameter exists by Richard https://sqlprogramming.wordpress.com/2012/04/26/ssrs-report-throws-an-error-that-says-a-parameter-doesnt-exist-when-the-report-designer-clearly-shows-the-parameter-exists/#comment-100 Mon, 02 Nov 2015 15:20:34 +0000 http://sqlprogramming.wordpress.com/2012/04/26/ssrs-report-throws-an-error-that-says-a-parameter-doesnt-exist-when-the-report-designer-clearly-shows-the-parameter-exists/#comment-100 In reply to ajitha m k.

Glad to hear that!

Like

]]> Comment on Automating ER/Studio with C# code. by Richard https://sqlprogramming.wordpress.com/2014/09/01/automating-erstudio-with-c-code/#comment-99 Mon, 02 Nov 2015 15:20:22 +0000 http://sqlprogramming.wordpress.com/?p=216#comment-99 In reply to Jim.

If I recall correctly, I had to browse for it. I think I had to find the name of the files in the ER/Studio docuemntation or maybe I just guessed which file it was.

Like

]]> Comment on SSRS report throws an error that says a parameter doesn’t exist when the report designer clearly shows the parameter exists by ajitha m k https://sqlprogramming.wordpress.com/2012/04/26/ssrs-report-throws-an-error-that-says-a-parameter-doesnt-exist-when-the-report-designer-clearly-shows-the-parameter-exists/#comment-98 Mon, 02 Nov 2015 07:44:38 +0000 http://sqlprogramming.wordpress.com/2012/04/26/ssrs-report-throws-an-error-that-says-a-parameter-doesnt-exist-when-the-report-designer-clearly-shows-the-parameter-exists/#comment-98 This helped, Thanks.

Liked by 1 person

]]> Comment on Automating ER/Studio with C# code. by Jim https://sqlprogramming.wordpress.com/2014/09/01/automating-erstudio-with-c-code/#comment-84 Mon, 29 Dec 2014 21:43:46 +0000 http://sqlprogramming.wordpress.com/?p=216#comment-84 Great article..thanks for sharing! I do have one question though. Did the ERStudio type library show up in your COM references tab? Because I don’t see it in mine.

Liked by 1 person

]]> Comment on Broaden your vision by Automating ER/Studio with C# code. | SELECT STUFF FROM SQL https://sqlprogramming.wordpress.com/2012/10/01/broaden-your-vision/#comment-81 Thu, 30 Oct 2014 20:10:04 +0000 http://sqlprogramming.wordpress.com/2012/09/30/broaden-your-vision/#comment-81 […] can see a sample of the work I did with that here and a more efficient version of the same script here.) But for some reason I couldn’t get the ER/Studio assemblies to load in PowerShell. So, I turned […]

Like

]]>