We have a fairly standard real life example where this would be useful and not a indication of poor table design. We get daily data feeds from third party...

Value assigment only uses one equal sign. But I think in the expression builder you can only set the full value to another value, not part of the value...

I suggested several ways that you could append the date and time to the file name:

1. Rename the file AFTER loading to the database

2. Use a variable to hold the...

What it sounds like is that the current time has changed between when you named the file and when the connection manager is trying to connect. Is it necessary...

You can add custom code to a report. I don't have 2008, but in 2005 you added code selecting the report and then the properties page (or right clicking...

You saying that you are getting all null values for the Question Code and suffix when trying to use them as calculated measures? If so, that usually means that...

Does this work?

WITH MEMBER [Measures].[Question Code] AS '[Questionnaire].Properties("Question Code")'

MEMBER [Measures].[Question Code Suffix] AS [Questionnaire].Properties("Question Code Suffix")'

SELECT {[Measures].[Survey Count],[Measures].[Question Code], [Measures].[Question Code Suffix]} ON 0,

([Customer].[First Name].[First Name],

[Customer].[Last Name].[Last Name]) ON 1

FROM...

Have you tried moving any of those Customer attributes to calculated members instead of having them in the cross joins?

Have you tried using the MEMBER_CAPTION property to get the month name?

WITH MEMBER [Measures].[ParameterCaption] AS LinkMember([Id Fecha Orden Pago].[N Mes].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Id Fecha Orden Pago].[Mes].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS...

We use LogParser http://www.microsoft.com/downloads/details.aspx?familyid=890cd06b-abf8-4c25-91b2-f8d975cf8c07&displaylang=en. Basic setup is LogParser in a batch script run by a scheduled job. There are a lot of examples for LogParser out there to...

I have the 2005 version of that book and I didn't find it very helpful for more complex SSRS reports and admin. It spends a lot of time on...

We are going through the same assessment for our production systems, however we are going from SQL 2005 to 2008. Our hardware is pretty beefy as we upgraded it...

Start with the extensive Microsoft documentation on upgrading: http://msdn.microsoft.com/en-us/library/bb500469(v=SQL.100).aspx. I recommend that you use the Upgrade Advisor to help identify any possible issues or incompatibilities.

If you are just jumping to another report and Report1 is the report name then you just need to fix up your code replacing the empty string with Nothing:

=IIF(Fields!structID.Value >...

You need to put an equal sign in front of the values in the value setting of the filter.