SSRS / Visual Studio help

[mjh01210]

I'm fairly new to SSRS, and while I have a good grasp of Visual Studio I'm being asking to create some reports at work that require some pretty advanced parameters. Well, maybe they're not advanced, but I haven't been able to figure it out or find any online resources that describe what they're looking for.

In a nutshell, if someone could direct me to a good resource for SSRS report creation in general it would be really helpful. Here is an overall description of what I'm being asked for.

They want a report that will look at the user role that is being passed from the website to the report, and based on what role they are, require the user to enter in one parameter or the other. Basically depending on what role they are they will either be entering in one kind of account number of the other. Once that account number parameter is selected the report will generate. I don't see how to apply a conditional requirement like this on a parameter. If they are one role we don't want them to even see the parameter option for the other role. How could this be accomplished? Thanks in advance for any help anyone can offer.

 

[Agman]

Why don't you do the logic of figuring out what type of account number to type in before you get over to the SSRS side? and just send in the account parameter and whatever else you need.

It should be pretty easy to create a form that accomplishes this.

 

[Emulex]

i just code the reports myself in php and use sql server. i mean really is SSRS that cool? we used to use crystal reports but you can do some major crazy reports in php (or asp) that just can't be done in any other language. plus you can sign deliver them to the people on schedule that they like. every second even.

 

[Arcex]

Why don't you do the logic of figuring out what type of account number to type in before you get over to the SSRS side? and just send in the account parameter and whatever else you need.

Good point, but unfortunately the account number has to be entered in manually by the user, it's not linked to them in any way, and at times they will have multiple account numbers to enter.


It's like this: to generate the proper data they will need some parameters to be passed through from the site, but others will have to be entered manually. I just don't have enough experience with that level of parameter customization.

i just code the reports myself in php and use sql server. i mean really is SSRS that cool? we used to use crystal reports but you can do some major crazy reports in php (or asp) that just can't be done in any other language. plus you can sign deliver them to the people on schedule that they like. every second even.

Also good points, but they have already made the decision to use SSRS, a large segment of their data reporting is already set up through there, so it's unlikely they will be changing it to something more user friendly any time soon.

 

[Nothinman]

i just code the reports myself in php and use sql server. i mean really is SSRS that cool?

Yes, it is actually. The major downside that I've seen so far is that embedded code is VB which sucks, but other than that it makes it dead simple to bust out a report in a few minutes once you've got the view, query, etc worked out. One thing MS does exceptionally well is dev tools.

It's like this: to generate the proper data they will need some parameters to be passed through from the site, but others will have to be entered manually. I just don't have enough experience with that level of parameter customization.

I haven't had to do this myself and the article is a little old, but have you tried it? http://www.mssqltips.com/tip.asp?tip=1336