Extract Exchange 2003 data

I have searched everywhere for an answer and seems I am either blind or there is no simple solution. Basically I have a need to report on data stored in an Exchange 2003 data store. There is mention of a OLE DB for Exchange 2000 but nothing for Exchange 2003. For example, A company report on time spent on various categories in a staff's calendar, etc. I would like to use SQl 2005 SSIS to extract and reporting services to report. Why is this so difficult? I come from a Lotus Notes / Domino background and there are numerous articles and ways to do this? Please can some MS guru please give me some direction on where to look?

Cheers

Damien

Damien,

Have a look at this Microsoft support page: http://support.microsoft.com/?kbid=813349

It lists the various methods to access Exchange programmically and status of support. I used to use CDO for this type of access...

Frank

|||

Frank,

Once again this artile is date 2005 and yet still only mentions Exchange 2000 and 5.5? I am confused does microsoft not know that 2003 exists at this date?

Sureley there must be a relevant article for 2003? Anywhere?

Cheers

Damien

|||

Damien,

Try this link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/e2k3/e2k3/_exchserv2k_provider_extensions.asp

This is from the Exchange 2003 SDK. It lists relevant API's for accessing the Exchange 2003 store.

Frank

Extra White Space

Hi All,
I've got a report that is set up with the Report Properties layout as
follows: page width = 8.5in; page height = 11in; left/right margins = .25in;
top/bottom margins = .50in.
When the report displays in IE7, there is a large white area (blank) to the
right of the report and it's full length. When I export as a PDF document,
this area seems to cause extra pages to be created in the PDF output.
Since I'm not sure "why" this extra white space is appearing, I thought I'd
post this here.
Thanks in advance!
Kind regards - FredHi Fred,
I've found, that meters of extra white space on the right side, before all
when viewed in HTML, are created when there are overlapping visible textboxes.
When textboxes overlap where one is invisible, there are also minor layout
differences, but never so dramatically.
Yours, Henry

Extra Space....

Hello!

I have written a report that is being displayed in a table. For some reason all the way to the right of the table has a HUGE amount of space......I checked to make sure there was no layers over it and I looked in the properties and saw no padding....ANY IDEAS? I am so frusterated because this defies all logic!!! Has anybody experienced this?

TIA!

That happened to me and I checked the width of the object that contained the table. In my case, the width of the rectangle that contained my table was way bigger than it should have been.|||

Oh Thank you for responding!! Are you talking about the width of the table itself....or the width of the page?

Thanks Again!

|||

Hi,

Check what the parent of the table is. If it says "body", then that is what you would adjust the width of.

|||Oh great! thanks!

Extra space at bottom of page

I keep getting extra space at the bottom of each page on my report when it is deployed to the web server but I don't get this extra space on the report server. Does anyone know if this is in the report layout or if the problem is in the web page itself?

Thanks,

messed around with report printer properties and re-deployed.sql

Extra Pages with Landscape

I have a report that is landscape (11w x 8.5h). The left margin is .2 and the
right margin is .2 and the body is 10.149w. The total (10.549) is under the
11 inches of the width but when I go to print preview, the report is 15 pages
with only 10 containing data. The last five pages are blank.
I then go to print it and the printer still sees the report a portrait
document instead of landscape so I have to manually adjust for this each
time.
Any ideas or suggestions?
I thought that this would be a good challenge for Peter Blackburn...In Visual Studio report designer make sure that the white canvas page is at
minimum size.
If the canvas (The white page you start with when designing a report) is
greater than the width of your paper then the print out will strech more
pagers...
"Kipp C" wrote:
> I have a report that is landscape (11w x 8.5h). The left margin is .2 and the
> right margin is .2 and the body is 10.149w. The total (10.549) is under the
> 11 inches of the width but when I go to print preview, the report is 15 pages
> with only 10 containing data. The last five pages are blank.
> I then go to print it and the printer still sees the report a portrait
> document instead of landscape so I have to manually adjust for this each
> time.
> Any ideas or suggestions?
> I thought that this would be a good challenge for Peter Blackburn...

Extra Page in Adobe Export

I also have the same problem. When I export the report out in pdf format,
there is an extra page.
I am running RSR2 and adobe 7.0.2
Is there any solution to this?yes,
Make sure there is no extra space in the report body after a table and chart
"qjlee" wrote:
> I also have the same problem. When I export the report out in pdf format,
> there is an extra page.
> I am running RSR2 and adobe 7.0.2
> Is there any solution to this?

Extra Page in Adobe Export

Using SRS SP2 and Adobe 7.0.2
When my report renders in the preview pane it it limited to one page but
when exported to Adobe it prints an extra page. The report has Page
Header/Body/Page Footer sections.
Is this a bug or am I missing something in the config?
ThanksI have the same problem. Would like to know if there is a solution.
"Mike Harbinger" wrote:
> Using SRS SP2 and Adobe 7.0.2
> When my report renders in the preview pane it it limited to one page but
> when exported to Adobe it prints an extra page. The report has Page
> Header/Body/Page Footer sections.
> Is this a bug or am I missing something in the config?
> Thanks
>
>|||make sure there is no extra space after the table and chart
"Mike Harbinger" wrote:
> Using SRS SP2 and Adobe 7.0.2
> When my report renders in the preview pane it it limited to one page but
> when exported to Adobe it prints an extra page. The report has Page
> Header/Body/Page Footer sections.
> Is this a bug or am I missing something in the config?
> Thanks
>
>|||That was it! I had moved a field in from the right margin and after
tightening it up the extra page was gone.
Many thanks!
"RP" <RP@.discussions.microsoft.com> wrote in message
news:94E1BCC1-F540-46DE-95F7-56F242097113@.microsoft.com...
> make sure there is no extra space after the table and chart
> "Mike Harbinger" wrote:
>> Using SRS SP2 and Adobe 7.0.2
>> When my report renders in the preview pane it it limited to one page but
>> when exported to Adobe it prints an extra page. The report has Page
>> Header/Body/Page Footer sections.
>> Is this a bug or am I missing something in the config?
>> Thanks
>>

Extra Page for a Key or Legend

I would like to know if I can create an extra page in a dynamic report that
will appear as the final page in a report and house the Key Legend and
glossary for the contained report.
I can think of two ways in theory that it can be done one by being able to
manipulate the page break to creak a final page and another to conbine two
seperate reports at runtime.
This is however a theory and I by no means think either of these is possible.
Does anyone have any Ideas at all on this?
Please and thank you.How about putting this information in its own table at the end of what you
currently have and then going into the properties of the table and choose
page break before this table? I've done this before.
"pcrtrg" wrote:
> I would like to know if I can create an extra page in a dynamic report that
> will appear as the final page in a report and house the Key Legend and
> glossary for the contained report.
> I can think of two ways in theory that it can be done one by being able to
> manipulate the page break to creak a final page and another to conbine two
> seperate reports at runtime.
> This is however a theory and I by no means think either of these is possible.
> Does anyone have any Ideas at all on this?
> Please and thank you.

Extra empty pages in PDF report

Report looks great in Visual studio and in a Browser, but when I convert it
to pdf for printing, I am getting extra pages after every good page with just
a header printed on those pages.
I tried decrease the size of the report and make sure that it fits into 8
1/2 x 11 inches, but it did not help.
I still have those annoying empty pages in the printed report.
Any other suggestions on how can I fix it?
Thank you.Simon if are you having problem with client side printing then you will want
to try the following.
Try setting body width to 8.46 if you are using letter/portrait. If you are
using letter/landscape then set the width to 10.96.
I hope that helps.
This is an issue Microsorft is now aware of.
"Simon Gold" wrote:
> Report looks great in Visual studio and in a Browser, but when I convert it
> to pdf for printing, I am getting extra pages after every good page with just
> a header printed on those pages.
> I tried decrease the size of the report and make sure that it fits into 8
> 1/2 x 11 inches, but it did not help.
> I still have those annoying empty pages in the printed report.
> Any other suggestions on how can I fix it?
> Thank you.
>|||Thanks Kevin. I figured it out about one hour before I got your e-mail. :-)
"Kevin Weir" wrote:
> Simon if are you having problem with client side printing then you will want
> to try the following.
> Try setting body width to 8.46 if you are using letter/portrait. If you are
> using letter/landscape then set the width to 10.96.
> I hope that helps.
> This is an issue Microsorft is now aware of.
> "Simon Gold" wrote:
> > Report looks great in Visual studio and in a Browser, but when I convert it
> > to pdf for printing, I am getting extra pages after every good page with just
> > a header printed on those pages.
> > I tried decrease the size of the report and make sure that it fits into 8
> > 1/2 x 11 inches, but it did not help.
> > I still have those annoying empty pages in the printed report.
> > Any other suggestions on how can I fix it?
> > Thank you.
> >

Extra columns in Excel with SP2

I would like to upgrade to Reporting Services service pack 2 so that I can
specify report colours and specify to move the header into Excel's header.
However when we upgrade to Service Pack 2 it causes extra totals columns to
appear at the end of the months in the generated reports. These columns
could possibly acceptable if they were titled as Total however they are not.
Can anybody make any suggestions in how to generate the report in excel
without the additional columns appearing in the excel output? Many thanks.Does anybody have any ideas about how to do this - any guesses even would be
appreciated. Thanks
"Nicola Jones" wrote:
> I would like to upgrade to Reporting Services service pack 2 so that I can
> specify report colours and specify to move the header into Excel's header.
> However when we upgrade to Service Pack 2 it causes extra totals columns to
> appear at the end of the months in the generated reports. These columns
> could possibly acceptable if they were titled as Total however they are not.
> Can anybody make any suggestions in how to generate the report in excel
> without the additional columns appearing in the excel output? Many thanks.

Extra column in matrix

Hello,

I'm trying to make a report with the following layout:

Car Sales 2004 2005 Var %
Total 10 20 50%
Green 7 14 50%
Red 3 6 50%

I'm using a matrix and the data is coming from a cube. One dimension called 'Years' is used to fill the matrix columns and the data corresponding to the car sales is filled by a measure called 'Sales'.
I've built part of the example but I can't add the final column ( the VAR% column).
If I try to add a static column in the end it apears only one year.
The behavior that I would like to have is simillar to the situation when we add the Subtotal column. Although, instead the sum() made by subtotal I would like to calculate the variation percentage between years.
Is there any way to add a final column into a matrix avoiding the problem that I'm having or maybe change the behavior of Subtotal column?

Thanks and best regards.

vjn

I have a very similar need. I have two levels of columns and two row groups. I need to calculate a percentage difference between the 2nd level column values:

Month

Quarter

Year

Mar-06

Mar-07

Q1 2006

Q1 2007

2006

2007

Company

Product

$1,000

$2,000

$3,000

$6,000

$12,000

$24,000

Change above to this:

Month

Quarter

Year

Mar-06

Mar-07

% Change

Q1 2006

Q1 2007

% Change

2006

2007

% Change

Company

Product

$1,000

$2,000

$3,000

$6,000

$12,000

$24,000

I need to calculate a % Change column. I can't seem to find a way to do this. I can add a subtotal easily enough but how can I do a custom calculation? This is based on a sql query not an analysis cube. I had to use a matrix to "cross tab" the data. The data is not in cross tab format at the source otherwise I would just calculate the % in the query.

Can anyone help?

Thanks!

|||Right click in the cell where you need to add the extra column to its right and select Add Column from the popup menu. HTH.|||

Thanks for the reply however that does not get me to what I need. Adding a column simply changes it to this:

Month

Quarter

Year

Mar-06

Mar-07

Q1 2006

Q1 2007

2006

2007

Company

Product

1000

2000

3000

6000

12000

24000

I need the % change from Mar-06 to Mar-07, Q1 2006 to Q1 2007, and 2006 to 2007.

|||

I also need to be able to add an extra column to my matrix - I've searched high and low on the net and I cant seem to find the answer anywhere.

I have grouped data which displays as it should and I can get the SubTotal part for my Dailys to run - I need to add a total for MTD and YTD (which is a part of the SQL Data) after the subtotal - is there a straight forward way of doing this?

This is an example of how I want my report to look (I can already achieve the bits highlighted bold)

Daily Data

Commission (GroupData cell 1)

Interest (GroupData CELL 2)

GroupData etc …

SUBTOTAL (DTD)

MTD TOTAL

YTD TOTAL

Book

Currency

=sum(Fields!DTD.VALUE)

........

=sum(Fields!MTD.VALUE)

=sum(Fields!YTD.VALUE)

and this is an example of the data being returned by my Sproc

Book

CCY

GroupedData

DTD

MTD

YTD

ABC

GBP

Commission

￡0.01

￡0.09

-￡0.10

ABC

GBP

Interest

￡0.02

￡0.29

￡0.11

ABC

GBP

Brokerage

￡0.12

￡0.06

￡0.20

Like the person above - if i use the "Add Column" functionality - I get a repeat of the MTD and YTD under each of the groupData cells - where as i only need it as a summary after the subtotal.

Daily Data

Grouped Data CELL 1

Grouped Data CELL 2

Book Name

Currency

DTD TOTAL

MTD TOTAL

YTD TOTAL

DTD TOTAL

MTD TOTAL

YTD TOTAL

=sum(Fields!DTD.VALUE)

Does anyone out there know how to do it?

|||

Hi Everyone,

I solved a similar issue by adding a new column to the matrix and using this expression to find the percentage of change from month to month.

=(Sum(Fields!TotalSales.Value)-(SUM(Fields!TotalSales.Value,"matrix1_FiscalMonth")-Sum(Fields!TotalSales.Value)))/(SUM(Fields!TotalSales.Value,"matrix1_FiscalMonth")-Sum(Fields!TotalSales.Value))

NOTE: matrix1_FiscalMonth is my row group name

To find the percentage of change take the “after” amount, minus the “before” amount and divide that result by the before amount. i.e.(60-50)/50 = 20%

Regard,

AA

"Small things done consistently in strategic places create major impact"

sql

Extra column in matrix

Hello,

I'm trying to make a report with the following layout:

Car Sales 2004 2005 Var %
Total 10 20 50%
Green 7 14 50%
Red 3 6 50%

I'm using a matrix and the data is coming from a cube. One dimension called 'Years' is used to fill the matrix columns and the data corresponding to the car sales is filled by a measure called 'Sales'.
I've built part of the example but I can't add the final column ( the VAR% column).
If I try to add a static column in the end it apears only one year.
The behavior that I would like to have is simillar to the situation when we add the Subtotal column. Although, instead the sum() made by subtotal I would like to calculate the variation percentage between years.
Is there any way to add a final column into a matrix avoiding the problem that I'm having or maybe change the behavior of Subtotal column?

Thanks and best regards.

vjn

I have a very similar need. I have two levels of columns and two row groups. I need to calculate a percentage difference between the 2nd level column values:

Month Quarter Year Mar-06 Mar-07 Q1 2006 Q1 2007 2006 2007 Company Product $1,000 $2,000 $3,000 $6,000 $12,000 $24,000

Change above to this:

Month Quarter Year Mar-06 Mar-07 % Change Q1 2006 Q1 2007 % Change 2006 2007 % Change Company Product $1,000 $2,000 $3,000 $6,000 $12,000 $24,000

I need to calculate a % Change column. I can't seem to find a way to do this. I can add a subtotal easily enough but how can I do a custom calculation? This is based on a sql query not an analysis cube. I had to use a matrix to "cross tab" the data. The data is not in cross tab format at the source otherwise I would just calculate the % in the query.

Can anyone help?

Thanks!

|||Right click in the cell where you need to add the extra column to its right and select Add Column from the popup menu. HTH.|||

Thanks for the reply however that does not get me to what I need. Adding a column simply changes it to this:

Month Quarter Year Mar-06 Mar-07 Q1 2006 Q1 2007 2006 2007 Company Product 1000 2000 3000 6000 12000 24000

I need the % change from Mar-06 to Mar-07, Q1 2006 to Q1 2007, and 2006 to 2007.

|||

I also need to be able to add an extra column to my matrix - I've searched high and low on the net and I cant seem to find the answer anywhere.

I have grouped data which displays as it should and I can get the SubTotal part for my Dailys to run - I need to add a total for MTD and YTD (which is a part of the SQL Data) after the subtotal - is there a straight forward way of doing this?

This is an example of how I want my report to look (I can already achieve the bits highlighted bold)

Daily Data Commission (GroupData cell 1) Interest (GroupData CELL 2) GroupData etc … SUBTOTAL (DTD) MTD TOTAL YTD TOTAL Book Currency =sum(Fields!DTD.VALUE) ........ =sum(Fields!MTD.VALUE) =sum(Fields!YTD.VALUE)

and this is an example of the data being returned by my Sproc

Book CCY GroupedData DTD MTD YTD ABC GBP Commission ￡0.01 ￡0.09 -￡0.10 ABC GBP Interest ￡0.02 ￡0.29 ￡0.11 ABC GBP Brokerage ￡0.12 ￡0.06 ￡0.20

Like the person above - if i use the "Add Column" functionality - I get a repeat of the MTD and YTD under each of the groupData cells - where as i only need it as a summary after the subtotal.

Daily Data Grouped Data CELL 1 Grouped Data CELL 2 Book Name Currency DTD TOTAL MTD TOTAL YTD TOTAL DTD TOTAL MTD TOTAL YTD TOTAL =sum(Fields!DTD.VALUE)

Does anyone out there know how to do it?

|||

Hi Everyone,

I solved a similar issue by adding a new column to the matrix and using this expression to find the percentage of change from month to month.

=(Sum(Fields!TotalSales.Value)-(SUM(Fields!TotalSales.Value,"matrix1_FiscalMonth")-Sum(Fields!TotalSales.Value)))/(SUM(Fields!TotalSales.Value,"matrix1_FiscalMonth")-Sum(Fields!TotalSales.Value))

NOTE: matrix1_FiscalMonth is my row group name

To find the percentage of change take the “after” amount, minus the “before” amount and divide that result by the before amount. i.e.(60-50)/50 = 20%

Regard,

AA

"Small things done consistently in strategic places create major impact"

Extra column in matrix

Hello,

I'm trying to make a report with the following layout:

Car Sales 2004 2005 Var %
Total 10 20 50%
Green 7 14 50%
Red 3 6 50%

I'm using a matrix and the data is coming from a cube. One dimension called 'Years' is used to fill the matrix columns and the data corresponding to the car sales is filled by a measure called 'Sales'.
I've built part of the example but I can't add the final column ( the VAR% column).
If I try to add a static column in the end it apears only one year.
The behavior that I would like to have is simillar to the situation when we add the Subtotal column. Although, instead the sum() made by subtotal I would like to calculate the variation percentage between years.
Is there any way to add a final column into a matrix avoiding the problem that I'm having or maybe change the behavior of Subtotal column?

Thanks and best regards.

vjn

I have a very similar need. I have two levels of columns and two row groups. I need to calculate a percentage difference between the 2nd level column values:

Month

Quarter

Year

Mar-06

Mar-07

Q1 2006

Q1 2007

2006

2007

Company

Product

$1,000

$2,000

$3,000

$6,000

$12,000

$24,000

Change above to this:

Month

Quarter

Year

Mar-06

Mar-07

% Change

Q1 2006

Q1 2007

% Change

2006

2007

% Change

Company

Product

$1,000

$2,000

$3,000

$6,000

$12,000

$24,000

I need to calculate a % Change column. I can't seem to find a way to do this. I can add a subtotal easily enough but how can I do a custom calculation? This is based on a sql query not an analysis cube. I had to use a matrix to "cross tab" the data. The data is not in cross tab format at the source otherwise I would just calculate the % in the query.

Can anyone help?

Thanks!

|||Right click in the cell where you need to add the extra column to its right and select Add Column from the popup menu. HTH.|||

Thanks for the reply however that does not get me to what I need. Adding a column simply changes it to this:

Month

Quarter

Year

Mar-06

Mar-07

Q1 2006

Q1 2007

2006

2007

Company

Product

1000

2000

3000

6000

12000

24000

I need the % change from Mar-06 to Mar-07, Q1 2006 to Q1 2007, and 2006 to 2007.

|||

I also need to be able to add an extra column to my matrix - I've searched high and low on the net and I cant seem to find the answer anywhere.

I have grouped data which displays as it should and I can get the SubTotal part for my Dailys to run - I need to add a total for MTD and YTD (which is a part of the SQL Data) after the subtotal - is there a straight forward way of doing this?

This is an example of how I want my report to look (I can already achieve the bits highlighted bold)

Daily Data

Commission (GroupData cell 1)

Interest (GroupData CELL 2)

GroupData etc …

SUBTOTAL (DTD)

MTD TOTAL

YTD TOTAL

Book

Currency

=sum(Fields!DTD.VALUE)

........

=sum(Fields!MTD.VALUE)

=sum(Fields!YTD.VALUE)

and this is an example of the data being returned by my Sproc

Book

CCY

GroupedData

DTD

MTD

YTD

ABC

GBP

Commission

￡0.01

￡0.09

-￡0.10

ABC

GBP

Interest

￡0.02

￡0.29

￡0.11

ABC

GBP

Brokerage

￡0.12

￡0.06

￡0.20

Like the person above - if i use the "Add Column" functionality - I get a repeat of the MTD and YTD under each of the groupData cells - where as i only need it as a summary after the subtotal.

Daily Data

Grouped Data CELL 1

Grouped Data CELL 2

Book Name

Currency

DTD TOTAL

MTD TOTAL

YTD TOTAL

DTD TOTAL

MTD TOTAL

YTD TOTAL

=sum(Fields!DTD.VALUE)

Does anyone out there know how to do it?

|||

Hi Everyone,

I solved a similar issue by adding a new column to the matrix and using this expression to find the percentage of change from month to month.

=(Sum(Fields!TotalSales.Value)-(SUM(Fields!TotalSales.Value,"matrix1_FiscalMonth")-Sum(Fields!TotalSales.Value)))/(SUM(Fields!TotalSales.Value,"matrix1_FiscalMonth")-Sum(Fields!TotalSales.Value))

NOTE: matrix1_FiscalMonth is my row group name

To find the percentage of change take the “after” amount, minus the “before” amount and divide that result by the before amount. i.e.(60-50)/50 = 20%

Regard,

AA

"Small things done consistently in strategic places create major impact"