pdf size due to images

We have a report with a number of external images. When the report is run
and exported to pdf, the resulting document is over 2mb (regardless of
whether the report is run in VS or the ReportManager). When the images are
changed from external to embedded, the resulting pdf document is around
500kb. This is great since the 2mb was causing issues with our client's
email server. When the modified rdl is imported to our client's system, the
resulting document is still around 500kb.
When the original rdl is modified on the client's system using
ReportDesigner - and all of the images are changed from external to embedded
- the resulting pdf document is still over 2mb!! I've verified any number
of times that the images are of type embedded.
Both systems are have reporting services at sp1. The only obvious
difference is that our environment is a developer edition of SQL Server and
the client's is Standard.
Is the difference in SQL the reason? Any other ideas/suggestions'
ThanksThis is NOT an issue between external vs. embedded images. During testing
the wrong image file was being used.
It DOES appear to be an issue with the way images are rendered to PDF.
Using other document types such as Word results in a smaller overall document
size.
Any suggestions/ideas for rendering to pdf are appreciated.
"PD" wrote:
> We have a report with a number of external images. When the report is run
> and exported to pdf, the resulting document is over 2mb (regardless of
> whether the report is run in VS or the ReportManager). When the images are
> changed from external to embedded, the resulting pdf document is around
> 500kb. This is great since the 2mb was causing issues with our client's
> email server. When the modified rdl is imported to our client's system, the
> resulting document is still around 500kb.
> When the original rdl is modified on the client's system using
> ReportDesigner - and all of the images are changed from external to embedded
> - the resulting pdf document is still over 2mb!! I've verified any number
> of times that the images are of type embedded.
> Both systems are have reporting services at sp1. The only obvious
> difference is that our environment is a developer edition of SQL Server and
> the client's is Standard.
> Is the difference in SQL the reason? Any other ideas/suggestions'
> Thanks|||The issue was resolved by: (1) upgrading to SP2 AND (2) reducing the size of
jpg images that are used in the report. ONLY upgrading to SP2 DID NOT solve
the problem - the original images were simply distorted/gray AND without a
reduction in overall pdf document size. The size of the images were reduced
using MS Photo Editor, although other editors seem to work also.
"PD" wrote:
> This is NOT an issue between external vs. embedded images. During testing
> the wrong image file was being used.
> It DOES appear to be an issue with the way images are rendered to PDF.
> Using other document types such as Word results in a smaller overall document
> size.
> Any suggestions/ideas for rendering to pdf are appreciated.
>
> "PD" wrote:
> > We have a report with a number of external images. When the report is run
> > and exported to pdf, the resulting document is over 2mb (regardless of
> > whether the report is run in VS or the ReportManager). When the images are
> > changed from external to embedded, the resulting pdf document is around
> > 500kb. This is great since the 2mb was causing issues with our client's
> > email server. When the modified rdl is imported to our client's system, the
> > resulting document is still around 500kb.
> >
> > When the original rdl is modified on the client's system using
> > ReportDesigner - and all of the images are changed from external to embedded
> > - the resulting pdf document is still over 2mb!! I've verified any number
> > of times that the images are of type embedded.
> >
> > Both systems are have reporting services at sp1. The only obvious
> > difference is that our environment is a developer edition of SQL Server and
> > the client's is Standard.
> >
> > Is the difference in SQL the reason? Any other ideas/suggestions'
> > Thanks

PDF Rendering Problem - blank pages

I have a report that consists of a number of subreports. When I export to
PDF I get blank pages on every second page. No data is missing, it looks
like an incorrect margin setting or additional page break. If I export the
original "Sub"reports to PDF, then the problem does not occur.
I have checked the margins in the report and the subreports, and they are
all identical. Does anyone have any ideas I can try?
AndreCheck your master report.
Look at your report width as well as your left and right margins.
"Andre" <Andre@.discussions.microsoft.com> wrote in message
news:05B0EB7A-8DE7-4323-A4AF-383F4E4D8543@.microsoft.com...
>I have a report that consists of a number of subreports. When I export to
> PDF I get blank pages on every second page. No data is missing, it looks
> like an incorrect margin setting or additional page break. If I export
> the
> original "Sub"reports to PDF, then the problem does not occur.
> I have checked the margins in the report and the subreports, and they are
> all identical. Does anyone have any ideas I can try?
> Andresql

Patient query... Pls help

Hi Guys,

I have got a table of patients where each patient has got a unique patient number.There are different services which a patient can undertake such as resthome, dementia etc.

Here is the sample data

Service patientNo startDate EndDate

resthome 12 01/04/2003 03/05/2003

resthome 13 12/9/2004 13/10/2006

Dementia 44 12/08/2002 13/01/2004

dementia 12 05/05/2003 06/12/2006

................................. ............ ................................

Each patient has got a start date when he started undertaking that service and end date when the service finished .

Now I need to count total patients for each catagory but here is the main issue....

A patient can move from one servcice to another but cant be in two services at the same time and I need to count the most recent service which the patient is currently enrolled in..

How do I do that?

Pls help me guys as you have always done:wow:

Thanks

This will get you a list of the most recent service by startdate that the patient was enrolled in

Code Snippet

select ps.*

from patientservice ps

inner join

(select patientno, max(startdate) as startdate

from patientservices

group by patientno) z

on z.patientno = ps.patientno

and z.startdate = ps.startdate

|||

Hi Cam

Thanks for your help

I ran this query but I dont know why is it giving me an error saying:

Invalid column name: startdate

Thanks