It works if i run the Data flow component in isolation. However, when the package is run through a scheduled job each night, the issue persists. Very strange.

The only control...

Fixed the issue- Had to modify the expression to

(DT_I2)(["ColumnX"] == "True" ? 1 : 0)

Also wanted to add, the source is a .CSV file-not excel.

Yes, i checked and and the metadata for column X is DT_STR.

I'm using a Flat File Source component to bring the data in from excel. When i put the Data...

Thanks.. It looks like the MS material for the non-upgradable exams will be out by EOY. Will have to compare the course material..

Fixed this issue..instead of passing in the value of the parameter..one should pass in the pathname to the drillthrough report

for ex-

Fields!.ForecastID.Uniquename

This will pass in the pathname instead os the...

It depends on what attributes you have in your query. It will sum up according to whatever dimension attributes you have put in your query.

First try creating a new dataset...

PaulB-TheOneAndOnly (11/5/2010)

Here is the root...

Martin Schoombee (11/5/2010)

tmitchelar (11/5/2010)

From what I gathered in his post, the calculations only occur at the higher grain level, not the lowest. So he loses those calculations at the...

Thanks for the resources & tips. This should keep me busy for some time!!:-)

Thanks..i would like to work a lot more the BI domain(Microsoft BI, OBIEE,cognos,business objects etc). My group does not use anything out of the Micorsoft space(they are venturing into using...

Hi Jeff,

Fantastic article, i have to create a Dynamic cross tabbed report, where the column tabs are each week of a year not monthly!! 🙂 !!!!this article is exactly...

I had the same problem....please use this URL in the deploymentfolder

http://myservername:8080/ReportServer_%5Bi%5DInstanceName%5B/i%5D

I'm sorry what i had meant was- It would be possible to store the source data as XML. There are thousands of these records in the DB. If there is...

Thankyou..

But how do i get it into XML format?- when i tried to insert the content (which is html stored as varchar) i get the following error-

XML parsing: line 1,...