outlook web access - weird

I have subscriptions setup to deliver reports in PDF format to users email
address. No problem there. When the email is opened in the Outlook client,
the attachment appears as expected and can be opened. The problem is when
the user accesses their email using Outlook web access (OWA). The email
appears and even has the paper clip identifying the attachment. However,
when the email is opened. the attachment is gone."chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
news:F54988C0-2987-484D-AE80-F0B50F002E1D@.microsoft.com...
>I have subscriptions setup to deliver reports in PDF format to users email
> address. No problem there. When the email is opened in the Outlook
> client,
> the attachment appears as expected and can be opened. The problem is when
> the user accesses their email using Outlook web access (OWA). The email
> appears and even has the paper clip identifying the attachment. However,
> when the email is opened. the attachment is gone.
Can they open other pdf-files from their OWA?
Any security settings in play?
Did they test their OWA on a machine they knew there was a PDF-reader
installed on?
I know that sometimes I need to download pdf-files on my computer before
opening them in my OWA. But I'm quite sure the link for downloading is there
when I open the message, though.
Kaisa M. Lindahl|||they can open other pdf's through OWA, just not the ones delivered through
reporting services.
"Kaisa M. Lindahl" wrote:
> "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
> news:F54988C0-2987-484D-AE80-F0B50F002E1D@.microsoft.com...
> >I have subscriptions setup to deliver reports in PDF format to users email
> > address. No problem there. When the email is opened in the Outlook
> > client,
> > the attachment appears as expected and can be opened. The problem is when
> > the user accesses their email using Outlook web access (OWA). The email
> > appears and even has the paper clip identifying the attachment. However,
> > when the email is opened. the attachment is gone.
> Can they open other pdf-files from their OWA?
> Any security settings in play?
> Did they test their OWA on a machine they knew there was a PDF-reader
> installed on?
> I know that sometimes I need to download pdf-files on my computer before
> opening them in my OWA. But I'm quite sure the link for downloading is there
> when I open the message, though.
> Kaisa M. Lindahl
>
>

Outlook Data as a Source

We have a few legacy Crystal Reports that we have written that group,
calculate, etc. Outlook Calendar and conctact information. We are looking to
replace these with SQL Reports, but when I looked at my connection info under
SQL Reporting, I did not see anything that can effectively query Outlook
Calendar and Contact information. Does anyone know how I can effectively
connect to Outlook Calendar and Contact information as a source for my
reports?Hi,
You can use an OLEDB connection string to connect to Outlook/Exchange:
<code>
Outlook
9.0;MAPILEVEL="";Provider=Microsoft.Jet.OLEDB.4.0;TABLETYPE=0;DATABASE=C:\Temp\
</code>
With this connection you can simple query the contacts: <code>select * from
Contacts</code>. I haven't been able to query the calendar yet, but you can
try using MS Access to create a link to Outlook and look for that properties.
Hope this would help you.
Jan Pieter Posthuma
"Jack Bender" wrote:
> We have a few legacy Crystal Reports that we have written that group,
> calculate, etc. Outlook Calendar and conctact information. We are looking to
> replace these with SQL Reports, but when I looked at my connection info under
> SQL Reporting, I did not see anything that can effectively query Outlook
> Calendar and Contact information. Does anyone know how I can effectively
> connect to Outlook Calendar and Contact information as a source for my
> reports?

Outer Join - shifting result set.

I'm a quantitative securities analyst working with Compustat data
(company fiscal reports and pricing feeds).

My coworker came across a problem that we fixed, but I'd like to
understand 'why' it was happening and just don't get it yet.

Here's the starting query (reduced to simple prefixes):

--INITIAL--

declare @.mthDate datetime
set @.mthDate = (select max(datadate) from t)
declare @.wkDate datetime
set @.wkDate = (select max(datadate) from z)

Select
...
from
z
left join a on a.idA = z.idA and a.idB = z.idB
and a.datadate = z.datadate
left join b on b.idA = z.idA and b.idB = z.idB
and b.datadate = @.mthDate
left join c on c.idA = z.idA and c.idB = z.idB
and c.datadate = @.mthDate
left join d on d.idA = z.idA and d.idB = z.idB
and d.datadate = z.datadate
left join e on e.idA = z.idA
and e.datadate = @.mthDate
left join f on f.idA = e.idA and f.datadate=e.date2
left join g on g.idA = e.idA and g.datadate=e.date2
left join h on h.idA = z.idA
left join k on k.ticker = z.ticker
left join m on m.idA = z.idA and m.idB=z.idB
where
z.datadate = @.wkDate
<..some other expression filters...>
and k.ticker is null

--END INITIAL----

As you can see 'z' is the main table that things are linked to via
outer joins (our security master). Table 'k' has a list of securities
that we wish not to have results for.

There are 77 entries in table k and 4933 in table z for that given
time. We'd expect 4856 to be in this, but no. it's 4400, and then the
next time you run it (no changes whatsover) it's 2312, and so on.
Every time you execute you get a different record count.

My thought/and fix was to move the (k.ticker) predicate out of the
where clause and get a differenced set from z using NOT EXISTS:

--AMENDED-----
from
(z where not exists(select * from k where k.ticker=y.ticker)) y
left join a on a.idA = y.idA and a.idB = y.idB
and a.datadate = y.datadate
left join b on b.idA = y.idA and b.idB = y.idB
and b.datadate = @.mthDate
left join c on c.idA = y.idA and c.idB = y.idB
and c.datadate = @.mthDate
left join d on d.idA = y.idA and d.idB = y.idB
and d.datadate = y.datadate
left join e on e.idA = y.idA
and e.datadate = @.mthDate
left join f on f.idA = e.idA and f.datadate=e.date2
left join g on g.idA = e.idA and g.datadate=e.date2
left join h on h.idA = y.idA
left join k on k.ticker = y.ticker
left join m on m.idA = y.idA and m.idB=y.idB
where
y.datadate = @.wkDate
<..some other expression filters...
--------

And this works. It's stable now.

I'm hoping someone here can help me up the wisdom curve by explaining
to me 'why' the recordset kept changing before.

My guess is that the cost-based optimizer was resorting the outer joins
and handing back different sets as a result, but i want to understand,
and thought i'd come to this group for help.

I appreciate your time and look forward to replies.

Greg McIntireGreg,

it sounds like a bug to me. If the data doesn't change, then the query
result shouldn't change.

What version and service pack are you running? Can you create a
(simplified?) script that reproceduces the problem?

Gert-Jan

Greg wrote:
> I'm a quantitative securities analyst working with Compustat data
> (company fiscal reports and pricing feeds).
> My coworker came across a problem that we fixed, but I'd like to
> understand 'why' it was happening and just don't get it yet.
> Here's the starting query (reduced to simple prefixes):
> --INITIAL--
> declare @.mthDate datetime
> set @.mthDate = (select max(datadate) from t)
> declare @.wkDate datetime
> set @.wkDate = (select max(datadate) from z)
> Select
> ...
> from
> z
> left join a on a.idA = z.idA and a.idB = z.idB
> and a.datadate = z.datadate
> left join b on b.idA = z.idA and b.idB = z.idB
> and b.datadate = @.mthDate
> left join c on c.idA = z.idA and c.idB = z.idB
> and c.datadate = @.mthDate
> left join d on d.idA = z.idA and d.idB = z.idB
> and d.datadate = z.datadate
> left join e on e.idA = z.idA
> and e.datadate = @.mthDate
> left join f on f.idA = e.idA and f.datadate=e.date2
> left join g on g.idA = e.idA and g.datadate=e.date2
> left join h on h.idA = z.idA
> left join k on k.ticker = z.ticker
> left join m on m.idA = z.idA and m.idB=z.idB
> where
> z.datadate = @.wkDate
> <..some other expression filters...>
> and k.ticker is null
> --END INITIAL----
> As you can see 'z' is the main table that things are linked to via
> outer joins (our security master). Table 'k' has a list of securities
> that we wish not to have results for.
> There are 77 entries in table k and 4933 in table z for that given
> time. We'd expect 4856 to be in this, but no. it's 4400, and then the
> next time you run it (no changes whatsover) it's 2312, and so on.
> Every time you execute you get a different record count.
> My thought/and fix was to move the (k.ticker) predicate out of the
> where clause and get a differenced set from z using NOT EXISTS:
> --AMENDED-----
> from
> (z where not exists(select * from k where k.ticker=y.ticker)) y
> left join a on a.idA = y.idA and a.idB = y.idB
> and a.datadate = y.datadate
> left join b on b.idA = y.idA and b.idB = y.idB
> and b.datadate = @.mthDate
> left join c on c.idA = y.idA and c.idB = y.idB
> and c.datadate = @.mthDate
> left join d on d.idA = y.idA and d.idB = y.idB
> and d.datadate = y.datadate
> left join e on e.idA = y.idA
> and e.datadate = @.mthDate
> left join f on f.idA = e.idA and f.datadate=e.date2
> left join g on g.idA = e.idA and g.datadate=e.date2
> left join h on h.idA = y.idA
> left join k on k.ticker = y.ticker
> left join m on m.idA = y.idA and m.idB=y.idB
> where
> y.datadate = @.wkDate
> <..some other expression filters...>
> --------
> And this works. It's stable now.
> I'm hoping someone here can help me up the wisdom curve by explaining
> to me 'why' the recordset kept changing before.
> My guess is that the cost-based optimizer was resorting the outer joins
> and handing back different sets as a result, but i want to understand,
> and thought i'd come to this group for help.
> I appreciate your time and look forward to replies.
> Greg McIntire|||It's Version 8.00.194

While my ego would like to say it's not me, it's Microsoft, I'm pretty
doubtful. I think it's much more likely that it's a mental mistake...

Greg|||Well, could be, but I would install a service pack anyway. 8.00.194
means you have not installed any SQL-Server service pack, which
basically means you are missing all bug fixes of the last 5 years...

Gert-Jan

Greg wrote:
> It's Version 8.00.194
> While my ego would like to say it's not me, it's Microsoft, I'm pretty
> doubtful. I think it's much more likely that it's a mental mistake...
> Greg|||alright will talk to our tech guy. thanks a bunch.

Greg|||Greg (jacore70@.hotmail.com) writes:
> Select
> ...
> from
> z
> left join a on a.idA = z.idA and a.idB = z.idB
> and a.datadate = z.datadate
> left join b on b.idA = z.idA and b.idB = z.idB
> and b.datadate = @.mthDate
> left join c on c.idA = z.idA and c.idB = z.idB
> and c.datadate = @.mthDate
> left join d on d.idA = z.idA and d.idB = z.idB
> and d.datadate = z.datadate
> left join e on e.idA = z.idA
> and e.datadate = @.mthDate
> left join f on f.idA = e.idA and f.datadate=e.date2
> left join g on g.idA = e.idA and g.datadate=e.date2
> left join h on h.idA = z.idA
> left join k on k.ticker = z.ticker
> left join m on m.idA = z.idA and m.idB=z.idB
> where
> z.datadate = @.wkDate
> <..some other expression filters...>
> and k.ticker is null

The part with e, f and g looks suspicious to me. Not if I can tell
whether they are the cause of your SELECT:s returning a different
number. But you might want to have said:

left join (e
join f on f.idA = e.idA and f.datadate=e.date2
join g on g.idA = e.idA and g.datadate=e.date2)
on e.idA = z.idA
and e.datadate = @.mthDate

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"Greg" <jacore70@.hotmail.com> wrote in message
news:1110566766.025803.171120@.l41g2000cwc.googlegr oups.com...
> I'm a quantitative securities analyst working with Compustat data
> (company fiscal reports and pricing feeds).
> My coworker came across a problem that we fixed, but I'd like to
> understand 'why' it was happening and just don't get it yet.
> Here's the starting query (reduced to simple prefixes):
>
> --INITIAL--
> declare @.mthDate datetime
> set @.mthDate = (select max(datadate) from t)
> declare @.wkDate datetime
> set @.wkDate = (select max(datadate) from z)
> Select
> ...
> from
> z
> left join a on a.idA = z.idA and a.idB = z.idB
> and a.datadate = z.datadate
> left join b on b.idA = z.idA and b.idB = z.idB
> and b.datadate = @.mthDate
> left join c on c.idA = z.idA and c.idB = z.idB
> and c.datadate = @.mthDate
> left join d on d.idA = z.idA and d.idB = z.idB
> and d.datadate = z.datadate
> left join e on e.idA = z.idA
> and e.datadate = @.mthDate
> left join f on f.idA = e.idA and f.datadate=e.date2
> left join g on g.idA = e.idA and g.datadate=e.date2
> left join h on h.idA = z.idA
> left join k on k.ticker = z.ticker
> left join m on m.idA = z.idA and m.idB=z.idB
> where
> z.datadate = @.wkDate
> <..some other expression filters...>
> and k.ticker is null
> --END INITIAL----
> As you can see 'z' is the main table that things are linked to via
> outer joins (our security master). Table 'k' has a list of securities
> that we wish not to have results for.
> There are 77 entries in table k and 4933 in table z for that given
> time. We'd expect 4856 to be in this, but no. it's 4400, and then the
> next time you run it (no changes whatsover) it's 2312, and so on.
> Every time you execute you get a different record count.
> My thought/and fix was to move the (k.ticker) predicate out of the
> where clause and get a differenced set from z using NOT EXISTS:
>
> --AMENDED-----
> from
> (z where not exists(select * from k where k.ticker=y.ticker)) y
> left join a on a.idA = y.idA and a.idB = y.idB
> and a.datadate = y.datadate
> left join b on b.idA = y.idA and b.idB = y.idB
> and b.datadate = @.mthDate
> left join c on c.idA = y.idA and c.idB = y.idB
> and c.datadate = @.mthDate
> left join d on d.idA = y.idA and d.idB = y.idB
> and d.datadate = y.datadate
> left join e on e.idA = y.idA
> and e.datadate = @.mthDate
> left join f on f.idA = e.idA and f.datadate=e.date2
> left join g on g.idA = e.idA and g.datadate=e.date2
> left join h on h.idA = y.idA
> left join k on k.ticker = y.ticker
> left join m on m.idA = y.idA and m.idB=y.idB
> where
> y.datadate = @.wkDate
> <..some other expression filters...>
> --------
> And this works. It's stable now.
> I'm hoping someone here can help me up the wisdom curve by explaining
> to me 'why' the recordset kept changing before.
> My guess is that the cost-based optimizer was resorting the outer joins
> and handing back different sets as a result, but i want to understand,
> and thought i'd come to this group for help.
> I appreciate your time and look forward to replies.
> Greg McIntire

Your guess sounds pretty reasonable to me.

If you use the show query plan setting in Query Analyzer, you can look and
see if the plan selected changes from execution to execution.

As a general rule ... I would take the variable comparison filtering out of
the joining and into the where clause.|||> As a general rule ... I would take the variable comparison filtering out of
> the joining and into the where clause.

You can't do that with outer joins, because that changes the meaning
(i.e. the resultset).

Gert-Jansql

Out of the box reports

Hi
My company is planning to deploy SQL Server 2005 Reporting Services to
monitor usage of a number of sites we've created using Sharepoint.
The marketing blurb says that a number of out-of-the-box reports are
available but doesn't say exactly what these reports are. Can someone
help by giving me the details?
Thanks
Tony
> My company is planning to deploy SQL Server 2005 Reporting Services to
> monitor usage of a number of sites we've created using Sharepoint.
> The marketing blurb says that a number of out-of-the-box reports are
> available but doesn't say exactly what these reports are. Can someone
> help by giving me the details?
>
The reports and the deployment guide are available for free from
Microsoft. Do a seach on microsoft.com about "Report Pack for
Sharepoint" and "Report Pack for Sharepoint Deployment Guide".
Regards,
lucm
sql

Out of the box reports

Hi
My company is planning to deploy SQL Server 2005 Reporting Services to
monitor usage of a number of sites we've created using Sharepoint.
The marketing blurb says that a number of out-of-the-box reports are
available but doesn't say exactly what these reports are. Can someone
help by giving me the details?
Thanks
Tony> My company is planning to deploy SQL Server 2005 Reporting Services to
> monitor usage of a number of sites we've created using Sharepoint.
> The marketing blurb says that a number of out-of-the-box reports are
> available but doesn't say exactly what these reports are. Can someone
> help by giving me the details?
>
The reports and the deployment guide are available for free from
Microsoft. Do a seach on microsoft.com about "Report Pack for
Sharepoint" and "Report Pack for Sharepoint Deployment Guide".
Regards,
lucm

Out of the box reports

Hi
My company is planning to deploy SQL Server 2005 Reporting Services to
monitor usage of a number of sites we've created using Sharepoint.
The marketing blurb says that a number of out-of-the-box reports are
available but doesn't say exactly what these reports are. Can someone
help by giving me the details?
Thanks
Tony> My company is planning to deploy SQL Server 2005 Reporting Services to
> monitor usage of a number of sites we've created using Sharepoint.
> The marketing blurb says that a number of out-of-the-box reports are
> available but doesn't say exactly what these reports are. Can someone
> help by giving me the details?
>
The reports and the deployment guide are available for free from
Microsoft. Do a seach on microsoft.com about "Report Pack for
Sharepoint" and "Report Pack for Sharepoint Deployment Guide".
Regards,
lucm

OTP: Accessing RDL Reports from Visual Basic 6.0 Application

Hai! I don't know is this a silly question. Is it possible to execute and display the rdl (Sql server 2005 reporting services) report from visual basic 6.0 application.

I have a full fledged Visual basic windows application and using crystal reports. I want to create the reports using SQL server 2005 reporting services and access it from my Visual Basic 6.0 Windows application.

Thanks in advance

I'm afraid VB6 support has ended, and so VB6 questions are off topic here. Try www.vbcity.com instead.|||I'm trying to do the same and wondered whether you have found a solution.

Thanks

OS Defrag?

My 220GB DB resides mostly on one RAID 5 logical drive. This drive reports
fragmentation. Will I see any potential improvements in disk access if I
choose to defrag? Due to text columns and fairly large/wide rows,
performance is rock bottom. As a for instance, I have a 2.2GB file and
shrinking 1MB ran overnight without completing.Yes, it can help. see
http://www.microsoft.com/technet/abouttn/subscriptions/flash/tips/tips_083104.mspx
for more details.
Why are you trying to shrink your data files btw?
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:90631664-5FA2-4EC2-93FC-CBA5F47ADD8E@.microsoft.com...
> My 220GB DB resides mostly on one RAID 5 logical drive. This drive
> reports
> fragmentation. Will I see any potential improvements in disk access if I
> choose to defrag? Due to text columns and fairly large/wide rows,
> performance is rock bottom. As a for instance, I have a 2.2GB file and
> shrinking 1MB ran overnight without completing.|||The original problem was the disk performance, specifically disk reads, was
slow enough to make the system unusable. I since discoved that the purging
of some historical tables had a dramatic effect on what objects where in
cache which virtually eliminated the disk reads. The 220GB database was in 4
files on one logical drive(80GB, 40GB, 40GB, 40GB). I had created an
additional file on the same logical drive before creating files on other
logical drives in hopes of spreading out this and other DBs across 3 logical
drives each on their own channel. For the smaller database, this worked out
OK. For the 220GB DB, there are several GB free in each file. Neither DBCC
shrinkfile(emptyfile) or truncate_only finish and eventually deadlock. For
the smaller DB, I wrote a loop that shrunk the files a few MB at a time. I'm
trying to close the large files so no more data gets written to them. At 80
and 40GB, the files are too large to manage given my current level of
performance.
"Paul S Randal [MS]" wrote:
> Yes, it can help. see
> http://www.microsoft.com/technet/abouttn/subscriptions/flash/tips/tips_083104.mspx
> for more details.
> Why are you trying to shrink your data files btw?
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
> message news:90631664-5FA2-4EC2-93FC-CBA5F47ADD8E@.microsoft.com...
> > My 220GB DB resides mostly on one RAID 5 logical drive. This drive
> > reports
> > fragmentation. Will I see any potential improvements in disk access if I
> > choose to defrag? Due to text columns and fairly large/wide rows,
> > performance is rock bottom. As a for instance, I have a 2.2GB file and
> > shrinking 1MB ran overnight without completing.
>
>