DAn,

And using the set dateformat function ?

set dateformat dmy

You can do this indeed with the default language.

You can also use the set dateformat in T-qsl, I guess

what do u mean about that ?

Indeed he is asking this for helping me, which I am thankfull for.

We just resolved this matter using union queries and using 0 values.

Perhaps not the most powerfull result, but...

Jeff

The code is a field in the orderlinetable.

Primary key is, i thnik so, not important for this.

Thx in advance

El Jefe

Hi

We have had problem with same w3wp.exe but this was due to an asp site (no asp.net, just asp !)

We didn't have this issue concerning report server

Kind regards

El Jefe

found solution

this is query, don't know if it's the best one, but i get the results :

SELECT distinct Item.No_ as artikelcode,

Item.Description as omschrijving,

[Description 2] as [omschrijving 2],

((select...

sorry

doesn't seem to work

I only receive like 40 results where there should be a 10thousand.

Mark, not all items have an extra description

NE idea ?

Hi renderign reports with subreports to excel gives trouble. Perhaps same problem with PDF.

Is know by Microsoft.

the users need to subscript the report.

Is a property of the report. So they can ask excel output being sent to their mail.

PErhaps stupid questions but how is yr sql server installed ?

Only SQL server security or mixed with nt authentication ?

In your SQL Reporting, check the security property of your folder.

The you can edit item security and add, delete or change.

Normally security is parental.

Good luck

El Jefe

thx, i should looked up into help first, found it there,

nevertheless much obliged

yes u r correct indeed. There still some issues concerning dtsx packages. There is already a big difference if u r using x64 or x86.

The other issue is the secutiry...

r u running 64 bit ?