Extended procedures question

Hi,
Is anyone familiar with an extended stored procedure that can be used to obtain the size of a file? If so, could you please point me in the right direction. Thanks in advance for your help.Not sure whether such XP is available, still using XP_FILEEXISTS save the details to temp table to read the data.

FOr more information on using above XP refer to this link (http://www.nigelrivett.net/CheckIfFileExists.html) .

HTH

Expression to alter the font size

I'm trying to use an expressions like these to alter the font size...
iif(Len(Fields!MyField.Value) > 12, "7pt","8pt")
iif(Len(Fields!MyField.Value) > 12, 7pt,8pt")
iif(Len(Fields!MyField.Value) > 12, 7,8)
Regardless of which expression I use, I get this error:
"<my expression> cannot be parsed as a unit because it does not contain
numeric values. Examples of valid unit strings are "1pt" and ".5in".
Any suggestions on how i can check the length of a string and alter the
font size in the table?
Thanks,
James
--This worked for me, =iif(Len(Fields!MyField.Value)>12,"7pt","8pt"). Make
sure that you are putting the expression in the FontSize property with the =.
daw
"James" wrote:
> I'm trying to use an expressions like these to alter the font size...
> iif(Len(Fields!MyField.Value) > 12, "7pt","8pt")
> iif(Len(Fields!MyField.Value) > 12, 7pt,8pt")
> iif(Len(Fields!MyField.Value) > 12, 7,8)
> Regardless of which expression I use, I get this error:
> "<my expression> cannot be parsed as a unit because it does not contain
> numeric values. Examples of valid unit strings are "1pt" and ".5in".
> Any suggestions on how i can check the length of a string and alter the
> font size in the table?
> Thanks,
> James
> --
>

Express Versus Standard Footprint

Is there a current estimate of the footprint of SQL Server Express 2005 versus the footprint of SQL Server Standard 2005? Is the size difference significant?

Are you talking in general or for Reporting Services? There is not a significant difference in the core relational database. The things that aren't included are additional services, documentation and tools. You can download Express and see what is included.

Exporting to Excel - File gets too big

Hi,

I have a report returning about 50000 rows, when i export this into excel it takes a few minutes and the file size is about 13MB, When i try to open up a 13mb file it is so slow...it is better for me to execute the dataset in SQL analyser and copy the results directly into excel whereby the file is 8mb and opens up also instantly...

My exported version is just data and no graphics however the page appears to be ''white'' although i set the fill in excel to transparent...maybe this is making the file hard to open...

Anybody have problems with exporting to excel and actually able to use it without running into long delays due to the file size...what can i do to fix this

thanks

Wait for SQL Server 2008 apparently.

One of the biggest resource hogs is output to Excel. One of the whitepapers suggests 2x-3x Ram (ratio to dataset size) is required for Excel gen.

Otherwise, set it on a schedule and email the report when it is done.

Exporting to Excel - File gets too big

Hi,

I have a report returning about 50000 rows, when i export this into excel it takes a few minutes and the file size is about 13MB, When i try to open up a 13mb file it is so slow...it is better for me to execute the dataset in SQL analyser and copy the results directly into excel whereby the file is 8mb and opens up also instantly...

My exported version is just data and no graphics however the page appears to be ''white'' although i set the fill in excel to transparent...maybe this is making the file hard to open...

Anybody have problems with exporting to excel and actually able to use it without running into long delays due to the file size...what can i do to fix this

thanks

Wait for SQL Server 2008 apparently.

One of the biggest resource hogs is output to Excel. One of the whitepapers suggests 2x-3x Ram (ratio to dataset size) is required for Excel gen.

Otherwise, set it on a schedule and email the report when it is done.