Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kdnichols
Posting Yak Master
232 Posts |
 Posted - 2006-11-16 : 10:08:52
|
Hello,I am asking this question here, because it appears that I don't get as fast a response in reporting services as I do on this forum.I am trying to add an extra parameter in a report title called SummaryBy.ValueHere is my current code:="BY " & UCase(Parameters!SummaryBy.Value & IIF(Parameters!SummaryBy2.Value<>"", " / " & Parameters!SummaryBy3.Value,"")) If I add the extra parameter I get an error because of the IIf. How do I get around this to display all three parameters?Please let me leave this post here also. I need to get an answer asap.TIA and have a great day! Kurt |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2006-11-17 : 07:10:21
|
| Allow me to explain to you why you have not had a response and what your problem is.Reporting Services is something that Satan made for a laugh. It is as evil as it is useless. Find a better tool for you solution or make your own. Microsoft have some work to do before anyone will ever commit the Reporting Services to any noticeable degree. It really is a pile of poo. Thankfully that is not the case with Analysis Services!------------------------Me: What do you want to know from your data warehouse?Client: Err...Emm...EverythingMe: OK, that's great. That's all I need to know. I'll see you when it's done. |
 |
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2006-11-17 : 08:47:34
|
| Your reply is not appreciated!If you don't have anything constructive to say then don't say it!Thanks for wasting my time.I also posted this in Reporting Services FYI. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-11-17 : 13:18:20
|
Kd, you might want to post the reply here when you get one. We would appreciate it. Also, post Reporting Services questions in the reporting services category. There are more people watching that category than this one. Also, ignore coolerbob. He's a little bitter from his time fighting the great conquerors when William of Normandy invaded. We're all hoping he gets over it sometime in the next century.    MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2006-11-17 : 14:34:22
|
Hello Derrick,Yeah he must still be bitter. Thanks for the explanation. lolHere is something that I am trying to sort out at the moment that may help this problem:=IIf(Parameters!SummaryBy.Value, " / " iff(Parameters!SummaryBy2.Value, " / " iif(Parameters!SummaryBy3.Value, ""))) However, I still get an error message. I know that the IIf statement has to do with Conditional Formatting. Does anyone have any suggestions?TIAKurt |
|
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2006-11-17 : 15:04:00
|
Hello Derrick and Everyone,Regis the final answer is:="BY " & UCase(Parameters!SummaryBy.Value & IIf(Parameters!SummaryBy2.Value <> "", " / " & Parameters!SummaryBy2.Value, "") & IIf( Parameters!SummaryBy3.Value <> "", " / " & Parameters!SummaryBy3.Value, "")) This works beautifully!Have a great day everyone.coolerbob get over the invastion!When you work for a company you work with what they give you. In my case it is Reporting Services!Kurt |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2006-11-20 : 11:43:42
|
quote:
Originally posted by kdnichols
When you work for a company you work with what they give you. In my case it is Reporting Services!Kurt
Or you give them the sound technical reasons why Reporting Services is not an extensible solution for their business needs...Most good developers can write a better reporting tool in a matter of weeks - one that actually meets the unique and custom requirements of the business. I was not being antagonistic. I was trying to save you some time. But it's your decision.I don't believe in war. |
|
|
|
|
|
|
|
|
Need to add parameter to report title