Singanan Krishnasamy (9/6/2011)

---

There are few more I identified, if someone can verify these issues are correct would be great.

1. Drill down, the + and - symbol conflicts...

My Favourite bad thing about SSRS

is exporting reports to excel, when the rows resize so you lose half your cell

2. another pet hate is having to use CTRL+C ,...

HA! when I was first tasked with this I looked at RS Scripter , but I didn't know you could generate the entire solution

Much Appreciated!

Declare @LiveRS Table (

RDL varchar(MAX),

CompletePath nvarchar(max)

)

Insert Into @LiveRS

select convert(varchar(max), convert(varbinary(max), content)) [RDL],Path + Name [CompletePath]

from [TEST].[Reportserver].[dbo].catalog

where content is not null

Declare @SourceControlRS Table (RDL varchar(max),

CompletePath nvarchar(max))

Insert Into @SourceControlRS

select convert(varchar(max), convert(varbinary(max),...

The reason it flagged the generation of the email as a virus was due to McAfee thinking that some unreputable program had been creating HTML emails

But i do agree...

I remember when I was doing something along the same sort of lines before but McAfee Anti-Virus always flagged some emails as a virus

Does your method get round this somehow?

How on Earth is that going to help?

katesl (11/12/2009)

---

What I meant to say in my first post is that programmers should know what a programmer's editor can do and when to use it. Time estimates based...

you mean I could get 10k just for writing a script ... right im on that 🙂

Nice Spreadsheet, in my job , I Tend to get the Data in the Tables rather the the Spec's , it is up to me/the team to decide the specifications...

One thing you might want to check is whether ConsumeContainerWhitespace is set to True. This Property could be causing the initial page to span across 2 pages.

When Set to...

Taking a long shot here without know the full description :

neither you could do this in Excel with SQL

create a separate excel sheet for you to download the data into...

just a thought , but try editing the report and putting a text box that will always render ,

like a dot or something , make it almost white too...

oh yes very gutsy , we did have other servers we could point to and run the reports if everything went to pot, so not AS scary as it sounds....

How about trying a formating for that particular field

In the properties for that field, in the formatting tab try using this as:

£#,##0.00;-£#,##0.00;-

the last dash represents the zero , and when...