How to add parameter, without define

(0) Share

Report

Posted on by Community Member

how to add the default range on Query for report, so that range can be used by other users without having to be determined again

ex : user A add the range once, so user B do not have to add range again.

6014.2.PNG

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

André Arnaud de Cal... 304,508 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Harriadi,

Have a look at the blog from Axaptian: axaptian.blogspot.com/.../savecopy-filtersqueriesinquires-to.html

This blog describes a way to copy used queries from one user to another. It sould give you a great start.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

thanks andre,

but, I mean when i develop and how to make a default parameter ?

sorry i forgot to tell you that i'm a developer.

Was this reply helpful? Yes No
Suggested answer

István Orosz 2,137 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can add the range directly to the report query, and all users will be able to see it. What do you mean by 'default', and are we talking about a query based SSRS report?

Kind regards,

István

Was this reply helpful? Yes No
Verified answer

Catalyst619 355 on at

Like (0)

Report
Copy link

Link copied!

If this is a query based report, you can go into the report query and manually define a range like so:

Instead of PurchaseOrderCube, you would find the Query associated to your report.

If you're looking to do it programmatically, you can do so by using the addrange function on your QueryBuildDataSource:

https://msdn.microsoft.com/en-us/library/querybuilddatasource.addrange.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

thanks catalyst, its working

Was this reply helpful? Yes No