Never used it so maybe someone else can enlighten us.
If they are always using the same params then just set up linked reports.
For a given parameter on a report you can:
- accept the default
- override the default
- hide or show the param with either of the above
To create a linked report, go to properties (on the report) where you'll see a button to do it.
Enter the description for the new report and which folder you would like it to appear in.
Then within the linked report, go to 'properties' 'parameters' where you can set them as you wish.
A faster way to create linked reports is to use the "RS linked report generator" (free from sqldbatips.com)
The user does not realise they are running a linked report, it saves them time and it can give you better control over security (by either using groups on the folder permissions or within a report using the "globals!reportfolder" parameter, which will show the linked report path and not the 'master' report path.|||
Neither of these options meet our requirements.
As I understand it MyReports is an ad-hoc query builder / an area that rdls can be uploaded to for each user. We have lots of non IT literate Reps who will need their own particular set of parameters applied to each report. I can't see them setting these up. I don't want to have to manage linked reports for every user or to set up linked reports either. Both of these options are onerous on the admin side.
The save to favourites would be the easiest solution though thinking it through, I don't think it will be possible. Thanks anyway.
|||'non IT literate reps' if ever there was an oxymoron...Why can't you just make the report dynamically figure out who it is?
e.g. using the globals!username, pass it through to sql to filter the results, then just give everyone the same report
I have found that using the two RS tools on the sqldbatips site, along with some clever scripting ©/paste find/replace, can create all the reports you need without having to touch report manager.|||
true say - the moron bit is also applicable
I had considered this option - we also have users who aren't reps but I guess that's not the end of the world. For reps, we'd also need to know their Sales Division which we don't store in AD. I was just looking for a quick fix to be honest.
What kind of things are you doing? Are you scripting the report from scratch using code? How are you delivering them?
|||You're talking about "saving to favorites" in the browser favorites list, right?
Do the parameters show in the url/address bar/location at the time you want to save them?
I think this may be possible, but I'm not clear on the action sequence you're talking about -- are they sitting in the browser having selected some parameters, are you giving them the URL in an email (or documentation), or what?
I definitely have parameters embedded in URLs that I give to users and they definitely save them that way to favorites. The only problem is constructing the personal values for them, right?
I have done this by using a bit of javascript, in a page that asks them for the stuff I need to add to the base URL, such as Sales Div, constructing it and showing it to them, with instructions in the page to click on the link and then add to Favorites...
But, here's a thought -- assuming that you do have all your parameter values (such as Sales Div) stored *somewhere* , whether active directory or not, it would be cool to set up a meta-report that listed people's names with constructed URLs next to them, each with the properly constructed URL. You could call it something like the "Favorites Center" report, and it could have different columns next to each person for the different reports you wanted to expose in this way.
>L<
|||I am talking about adding to browser favourites. The situation is that they open the report and then select a set of parameters pertinent to them. The report is accessed by clicking on a link on an html menu page.
Thanks for the ideas. I think I like the solution that you're currenlty running best. I will see what I can pull together based on your tip.
|||Have fun! You can get the parameters for a report from the Catalog table of the ReportServer database, btw. (or from a SOAP call, probably a better idea, but hadn't thought about automating this part until just now <g>)
>L<
|||Oh yeah - thanks.|||I'm just getting my feet wet with Vista and don't know about parameters; however, I should not need them. I only want to save some web pages to Favorites and I only get unspecified error. and there it stops of course. It seems a simple thing to ask and a very stupid excuse for not doing it!! Sure would like to resolve this problem. Thankx Merri|||
What does the URL look like and what do you see when you get the "unspecified error"? Do you see a report manager page, just a "dead" browser, or what?
>L<
No comments:
Post a Comment