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 |
|
s_anr
Yak Posting Veteran
81 Posts |
 Posted - 2009-06-21 : 12:49:39
|
| Hi,I have two issues on which I'm looking for some help.1 ) I have scheduled a report using subscription. It is mailed to me as an excel attachment at a specific time. But This Excel sheet has "Blanks". How do I modify the query so that it shows NULL instead of Blanks in the report.2) In the same report which i get in Excel, All the columns are expanded according to the content. How do i make the changes in the query / design so that Both Height and Width of Cells are fixed? I see that the width is fixed but only the height expands according to the content.I'd appreciate if someone can help.. Pleaseeeeeee. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-22 : 10:51:52
|
| 1.you need to replace null values with string "NULL" in your report else it will render it as blanks2.Set autogrow property of cell to false |
 |
|
|
s_anr
Yak Posting Veteran
81 Posts |
Posted - 2009-06-22 : 23:27:38
|
| Thanks Vikash,I am totally new to SSRS. Would you please explain. |
|
|
|
VipulM
Starting Member
9 Posts |
Posted - 2009-06-23 : 11:28:50
|
1. In expression for the data you will be having "=Fields!dsname.value" instead of this set the expression as:=IIf(IsNothing(Fields!dsname.value),"NULL",Fields!dsname.value)This will make sure that for null value you have "NULL" written into the textbox.You need to do this for all the textbox where you are expecting null values and you want to see "NULL".  2. Set text box property > layout > CanGrow = TrueCheers !!--Vipul Mochi |
|
|
|
s_anr
Yak Posting Veteran
81 Posts |
Posted - 2009-06-24 : 20:11:25
|
| Thank you much Vipul. I'll check these options. I was wondering, instead of changing the expresiion for each field, is it possible to chnage in the query itself? |
|
|
|
s_anr
Yak Posting Veteran
81 Posts |
Posted - 2009-06-24 : 22:48:28
|
| Well, I figured out the query part. Thaks vipul.I have one more question. How do I schedule multiple reports? I mean multiple reports should go in one mail (preferrably zipped / compressed). Is that possible? |
|
|
|
|
|
|
Query results shows Blank and formatting problem