DaveDB (11/1/2013)

---

I have a several reports that accept date range parameters. These are not the textboxes that show you a calendar when you click the box, but just 2 simple...

Was the report .rdl stored in SharePoint or on a server that might have a shadow copy of the report? This may shed some light on who deleted the...

Blair McKeever (11/3/2013)

---

The reports being run by SSRS are not being logged in the ExecutionLog table correctly any more. It used to log every report execution but approx three...

Use the Derived Column Transformation (as mentioned earlier in the thread).

Rob

manickam (10/15/2013)

---

Many thanks for the reply.

Need one more suggestion.

As per current requirment Issue can be logged at

1. asset level

2. applicaiton level

3. process level

4. line of business...

I've always found ERWin to be a good modeling tool, though it is moderately pricey. I had a coworker who swore by Sybase's PowerDesigner.

Rob

manickam (10/5/2013)

---

2. Actually issues will be associated with many deatiled text and lattributes. Do we need to capture this information in the FACT_ISSUE table as per this model. As of...

vinay4444 (10/8/2013)

---

Can some one help me to set up DIMENSION USAGE for below tables

Fact: SQLExecutions_Fact

No of Executions ( measure )

Physical_TableNameID

Dimension 1: PhysicalTableName_Dim

Physical_TableNameID (PK)

Dimension 2: LogicalTableName_Dim

Logical_TableNameID (PK)

Physical_TableNameID

Dimension1 -> Dimension 2 is...

I've purchased books on T-SQL query tuning,...

Amazon is going to offer a service soon that allows you to purchase a eBook/Kindle version of a physical book you've purchased from Amazon for a low cost ($0.99 -...

When you add a group, couldn't you just add a group header? (See attached graphic) See if that gets you what you want.

HTH,

Rob

RVO (9/10/2013)

---

Page size and margins have nothing to do with it.

I don't get a blank page in PDF problem or something like that.

It's a different type of problem.

Table fits perfectly...

And you're sure that your admin account is listed in the membership for the Admin role (pictured in your graphic)? (I know it's a dumb question)

Rob

Datetime datatype doesn't preclude Nulls, but if you're sure you don't have Nulls, I don't have any...

Take a look at the DATEDIFF() function: http://technet.microsoft.com/en-us/library/ms189794(v=sql.105).aspx

DATEDIFF ( datepart , startdate , enddate )

HTH,

Rob