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 |
|
robhob
Starting Member
2 Posts |
 Posted - 2004-11-09 : 04:50:31
|
| HelloI've encountered a problem that I think might be a bug in RS. I have an SQL query that I've converted to an expression by enclosing it with quotation marks and prefixing it with an equals sign (lets get technical). Here's what it looks like:="SELECT MICJNB, MICMNB, SUM(MIBNQU) As MIBNQU, SUM(MIU1QU) + SUM(MIU2QU) + SUM(MIU3QU) + SUM(MIU4QU) + SUM(MIU5QU) + SUM(MIU6QU) As FIQty, STR(((((SUM(MIU1QU) + SUM(MIU2QU) + SUM(MIU3QU) + SUM(MIU4QU) + SUM(MIU5QU) + SUM(MIU6QU))/SUM(MIBNQU))-1)*100)*-1,10,2) As Percentage FROM quality GROUP BY MICJNB, MICMNB ORDER BY MICJNB DESC, MICMNB DESC"Without the expression formatting it works perfectly but as soon as I add the equals sign and the quotes the last column (red) appears blank. Not ideal as that's what the report is all about. The reason why I want to use an expression is because I want to add parameters so that I can filter the data. Any ideas would be great.CheersRob Hobson |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-09 : 12:46:57
|
| I don't understand. Why not add the query with parameters to a data set? You don't need an expression to work with parameters.Tara |
 |
|
|
robhob
Starting Member
2 Posts |
Posted - 2004-11-10 : 01:49:25
|
| HelloThanks for the info. I was following a MS example... didn't realise that you could do it any other way.I'll try it the other way and let you know how it went.Thanks againRob |
|
|
|
|
|
|
Using expressions