For dynamic ordering use the same approach but make the field to be ordered by a case statement.

or you could download 3D (stands for data driven design) it's a modelling tool from Wherescape. Provided at the moment as a free beta quite a powerful tool, check it...

If you are doing data warehousing then I think surrogate keys are a must for two reasons

1. Storage - particularly in large fact tables, a 4 byte int is going...

Any update on the potential error in the function?

Martin

in order to get around the problem of one dataset per report item I was thinking you could just create a table valued sql function and join it to your...

if you intend on installing analysis services and reporting services as well then i'd go for enterprise, also from memory partitioning and online index rebuilds are ent only features, if...

unless you have a pretty large cube i'm not sure why you're bothered too much, at the end of the day there are calcs that can be performed easily in...

we use db mirroring and run our etl's against a snapshot of the mirror, works pretty well but they both need to be sql05 instances.

ditto on the datawarehouse design thing,...

i'd say that the comma del string is being passed in as separate params to your function eg...

[dbo].[fn_FindStringInString](fullnamecountries,'Fiji','Austria')='TRUE'

you could either use a stored procedure and set the param as a...

SRS multi-select lists are in a comma delimited format by default... have you tried just binding the report parameter to the @productid variable? It should work from what you are...

The master report file prints just as expected so I don't think this is the problem. Rather the properties of the Linked Report seem to be the problem but there...

try this article

http://www.sqlservercentral.com/columnists/bKhawaja/2945.asp

only works with SS2005 though

HTH

sounds like you want a multi value parameter on the record number field, only Reporting Services 2005 supports multi value parameters out of the box so you'll need to check...

Hope this helps... I've had problem and it's to do with using Windows credentials...

Excerpt from: http://msdn2.microsoft.com/en-US/library/ms190041.aspx

---------------------------------------------------------------

Windows integrated security

Use the Windows credentials of the current user to access the...

you could set the timeout on the Site to a sensible number this should override whatever they put in their report. You can give them the Report Builder role but...