Hi Nabha,

Tnx a lot,

Thats idd what i wanted to get as result.

I really need to learn the Partition By statement, it is so powerfull when you need stuff like...

Seems to me that your best bet would be to use the IsNumeric function in SSRS

this combined with the iif clause would work altimes even when there would be a...

Grashopper,

There's no fault in your sum clause , nor is there one...

Ryan,

Would not work,

cause "mm" stands for minutes, not Months

if you have the need for the day first :

go to the filed expression

type : =format(fields!fieldname.value,"dd/MM/yyyy") , gives 19/11/2009

=format(fields!fieldname.value,"MM/dd/YYYY"), gives 11/19/2009

=format(fields!fieldname.value,"yyyy/dd/MM"), gives...

Marianne,

Super neat,

Did try that already but wasn't working cause he could not find textbox17

i tried the expression =textbox17.value

Did not know you had to put ReportItems! before the actual textbox

Tnx a...

Hi steve,

Idd it seems to work when you publisch it to a server,

Can't put it neither in header nor footer doh.,

But just right above my tablelayout is quite ok as...

Hi Steve,

No that i did not.

Wonder whether it would even be possible to publisch it,

Cause while trying to preview the report i get an error that there is an...

Hi SteveFromOz,

I have tried your solution, but fortunately, it didn't work.

It seems that the report while creating it in the BI Studio, does not recognize the "datasources" object.

Ive tried as...

Hello steveFromOz,

That indeed seems like a good solution,

Will try it tomorrow @ work and will give feedback on this subject,

Tnx already for the support in this,

Wkr,

Eddy

Hello Steve,

No, thats just the whole point of it.

We upload 1 report to the reportserver,

but on the reportserver we have 3 datasources defined,

Now, newly created reports will be uploaded...

Sorry to stick me head in between but:

1 Tempdb file per cpu-core

I have put tempdb on the OS drive (only thing running on the os = Sql server ( Raid...

Hi,

Re-creating the index did not really make a real difference, altough its a bit faster,

But you were right about the table scans.,

File growth is not the issue, Database is...

Hi Luke,

Sorry for the delay, Have been going home on thursday afternoon cause i was getting sick, was stuck with the flew..., but now I'm back, not for the full...

Hi Luke,

The networkcongestion is fine, server is running on dual gigabit,

My laptop is conencted on 1 gbps link.

The text file is localy stored on my laptop so idd i have...

Hi Sanjay,

Thank you for your response.

Have done several tests and it seems that it was my .net console application that was slowing down.

Even though there was no memory loss nor...