PDFs... Automatically open?

We setting up an intratnet site that is generating PDF output from Reporting
Services 2005.
The WWW Server for the applications is on ServerA
The SQL Server & Reporting Services are on ServerB
From ServerA we are generating a HTTP request to the Reporting Services to
generate the report.
The report is generated as a PDF.
Everything works fine, except that IE always askes if they want to Download
or Open the document.
We simply want it to not ask, and always Open the PDF.
The users will be in a locked Citrix enviornment, so even if we have to stop
it from asking for ANYTHING that is okay as well.
Any ideas?Earl, this is probably because the users have the Confirm open on download
checkbox checked for the PDF filetype. In the Windows Explorer goto Tools,
Folder options, Filetypes, find PDF, click Advanced. Same is true for many
other types like .Doc, Xsl etc.
Ed Richard
"Earl Bonovich" <earl.bonovich...nospam...@.dciinc.org> wrote in message
news:OPlbDBf9FHA.952@.TK2MSFTNGP12.phx.gbl...
> We setting up an intratnet site that is generating PDF output from
> Reporting Services 2005.
> The WWW Server for the applications is on ServerA
> The SQL Server & Reporting Services are on ServerB
> From ServerA we are generating a HTTP request to the Reporting Services to
> generate the report.
> The report is generated as a PDF.
> Everything works fine, except that IE always askes if they want to
> Download or Open the document.
> We simply want it to not ask, and always Open the PDF.
> The users will be in a locked Citrix enviornment, so even if we have to
> stop it from asking for ANYTHING that is okay as well.
> Any ideas?
>

PDF-Reporting with SQL2005 Reporting Services

Hi All,
in SQL Server Business Intelligence Development Studio the reporting output
(for SQL2005 Reporting Services) can for instance be chosen as pdf or excel.
choosing pdf as output, if the tables contain more data than one DIN-A-4
page can display the tables are continued on the next page. the table header
is fortunately also repeated on each new pdf-page.
however choosing excel as output, the whole output of one table is written
into one excel spreadsheet. even if the height of the table containing the
data is more than the height of DIN-A-4 then the table is not continued on
another spreadsheet. this leads to the unfortunate phenomenon that printing
the excel workbook (with tables higher than DIN-A-4) results in DIN-A-4
printouts in which the table header is unfortunately NOT repeated on each
new printout-page. (this is due to the fact that the tables in the
spreadsheets are highre than DIN-A-4.)
unfortunately in our case the generated pdf output can not used to be
printed, because for each report there have to made slight adjustments by
each user which cannot be processed within the reporting workflow.
hence we really need a solution to programmatically adjust the excel-output
provided by the SQL Server Business Intelligence Development Studio so that
within the excel-output the spreadsheets will have the same page breaks like
the pdf-pages within the pdf-output.
we are desperately looking for a solution for this issue. can anybody state
A) if it is either impossible or
B) if it would be possible and which steps would be involved to achieve this
aim?
thanks a lot in advance for your assistance!
best regards, janHi All,
doesn't anybody have an idea on how to generate Excel-Reportings with
SQL2005 Reporting Services (with tables in the spreadsheets that are higher
than DIN-A-4 printouts) which are printable?
Has anybody yet managed to generate Excel-Output and make this output
printable so that on each printed DIN-A-4-printout the table headers are
repeated and the tables have correct page breaks?
best regards, jan
"Jan" <no@.no.com> schrieb im Newsbeitrag
news:OEjOaBiGHHA.1264@.TK2MSFTNGP03.phx.gbl...
> Hi All,
> in SQL Server Business Intelligence Development Studio the reporting
> output (for SQL2005 Reporting Services) can for instance be chosen as pdf
> or excel.
> choosing pdf as output, if the tables contain more data than one DIN-A-4
> page can display the tables are continued on the next page. the table
> header is fortunately also repeated on each new pdf-page.
> however choosing excel as output, the whole output of one table is written
> into one excel spreadsheet. even if the height of the table containing the
> data is more than the height of DIN-A-4 then the table is not continued on
> another spreadsheet. this leads to the unfortunate phenomenon that
> printing the excel workbook (with tables higher than DIN-A-4) results in
> DIN-A-4 printouts in which the table header is unfortunately NOT repeated
> on each new printout-page. (this is due to the fact that the tables in the
> spreadsheets are highre than DIN-A-4.)
> unfortunately in our case the generated pdf output can not used to be
> printed, because for each report there have to made slight adjustments by
> each user which cannot be processed within the reporting workflow.
> hence we really need a solution to programmatically adjust the
> excel-output provided by the SQL Server Business Intelligence Development
> Studio so that within the excel-output the spreadsheets will have the same
> page breaks like the pdf-pages within the pdf-output.
> we are desperately looking for a solution for this issue. can anybody
> state
> A) if it is either impossible or
> B) if it would be possible and which steps would be involved to achieve
> this aim?
> thanks a lot in advance for your assistance!
> best regards, jan
>

PDF generation

What is implemented in the released version of Reporting Services concidering
generating PDF output directly out of reporting serivces?
The white paper says: â'You are not required to run any Adobe software on the
report server in order to render reports in PDF.â' In the hand book to
Reporting Services of Brian Larson it is written: ""First of all, you will
need some type of utility to produce output in a PDF format. This could be
Adobe's full version of Acrobat or some other utility."I have Reporting Services with service pack 1 on it and it can output
directly to PDF.
"pwi" <pwi@.discussions.microsoft.com> wrote in message
news:73B22850-0B00-4CF5-80F6-3372B8E0CD58@.microsoft.com...
> What is implemented in the released version of Reporting Services
concidering
> generating PDF output directly out of reporting serivces?
> The white paper says: "You are not required to run any Adobe software on
the
> report server in order to render reports in PDF." In the hand book to
> Reporting Services of Brian Larson it is written: ""First of all, you will
> need some type of utility to produce output in a PDF format. This could be
> Adobe's full version of Acrobat or some other utility."
>|||Thank you very much for your help, Paul
"Paul" wrote:
> I have Reporting Services with service pack 1 on it and it can output
> directly to PDF.
>
> "pwi" <pwi@.discussions.microsoft.com> wrote in message
> news:73B22850-0B00-4CF5-80F6-3372B8E0CD58@.microsoft.com...
> > What is implemented in the released version of Reporting Services
> concidering
> > generating PDF output directly out of reporting serivces?
> > The white paper says: "You are not required to run any Adobe software on
> the
> > report server in order to render reports in PDF." In the hand book to
> > Reporting Services of Brian Larson it is written: ""First of all, you will
> > need some type of utility to produce output in a PDF format. This could be
> > Adobe's full version of Acrobat or some other utility."
> >
>
>

PDF Formatting Problem

Dear All,
I have written a database application in SQL and am using SQL Reporting
Services (for the first time) to generate the reports. I have come across a
problem to which I cannot see a solutions.
As part of the database application we store 'Visit Reports' which sales
people use to record information about customer that they have visited. I
have written a report which should display each record on a seperate page.
However, when someone has written a particularly long report and this spans 2
or more pages the report formats correctly on the screen, but when you export
to pdf you have the header information on 1 page (let's say the top 1/3 of
the page) and the detail of the report moves on to the next page. What I
want to happen is for the report to move on to a new page when appropriate
(i.e. when the 1st page is full).
Has anyone come across this? Is there a solution?
Thanks in advance,
Mike SwannIt looks like your report is either wider than 8½" or taller than 11".
Remember to take into account the body of your report, and the height of
header and footer (if there are any). I keep a safety margin of ½" to 1" to
avoid such issues.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
news:C806740E-EE41-4E99-9F71-4D0610E6B7F2@.microsoft.com...
> Dear All,
> I have written a database application in SQL and am using SQL Reporting
> Services (for the first time) to generate the reports. I have come across
> a
> problem to which I cannot see a solutions.
> As part of the database application we store 'Visit Reports' which sales
> people use to record information about customer that they have visited. I
> have written a report which should display each record on a seperate page.
> However, when someone has written a particularly long report and this
> spans 2
> or more pages the report formats correctly on the screen, but when you
> export
> to pdf you have the header information on 1 page (let's say the top 1/3 of
> the page) and the detail of the report moves on to the next page. What I
> want to happen is for the report to move on to a new page when appropriate
> (i.e. when the 1st page is full).
> Has anyone come across this? Is there a solution?
> Thanks in advance,
> Mike Swann|||Thanks for your response.
However, this is a UK A4 format and that is all correct. It is purely when
the report data forces it on to 2 pages. If there is only enough data for 1
page then it will convert to a pdf perfectly well.
Any other ideas?
Thanks
Mike
"Alain Quesnel" wrote:
> It looks like your report is either wider than 8½" or taller than 11".
> Remember to take into account the body of your report, and the height of
> header and footer (if there are any). I keep a safety margin of ½" to 1" to
> avoid such issues.
>
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
> news:C806740E-EE41-4E99-9F71-4D0610E6B7F2@.microsoft.com...
> >
> > Dear All,
> >
> > I have written a database application in SQL and am using SQL Reporting
> > Services (for the first time) to generate the reports. I have come across
> > a
> > problem to which I cannot see a solutions.
> >
> > As part of the database application we store 'Visit Reports' which sales
> > people use to record information about customer that they have visited. I
> > have written a report which should display each record on a seperate page.
> > However, when someone has written a particularly long report and this
> > spans 2
> > or more pages the report formats correctly on the screen, but when you
> > export
> > to pdf you have the header information on 1 page (let's say the top 1/3 of
> > the page) and the detail of the report moves on to the next page. What I
> > want to happen is for the report to move on to a new page when appropriate
> > (i.e. when the 1st page is full).
> >
> > Has anyone come across this? Is there a solution?
> >
> > Thanks in advance,
> >
> > Mike Swann
>|||You say that your header occupies 1/3 of the page. Did you try a smaller
header? Or no header at all?
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
news:D41B4154-8BDA-4534-9B60-3619D81E995E@.microsoft.com...
> Thanks for your response.
> However, this is a UK A4 format and that is all correct. It is purely
> when
> the report data forces it on to 2 pages. If there is only enough data for
> 1
> page then it will convert to a pdf perfectly well.
> Any other ideas?
> Thanks
> Mike
>
> "Alain Quesnel" wrote:
>> It looks like your report is either wider than 8½" or taller than 11".
>> Remember to take into account the body of your report, and the height of
>> header and footer (if there are any). I keep a safety margin of ½" to 1"
>> to
>> avoid such issues.
>>
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
>> news:C806740E-EE41-4E99-9F71-4D0610E6B7F2@.microsoft.com...
>> >
>> > Dear All,
>> >
>> > I have written a database application in SQL and am using SQL Reporting
>> > Services (for the first time) to generate the reports. I have come
>> > across
>> > a
>> > problem to which I cannot see a solutions.
>> >
>> > As part of the database application we store 'Visit Reports' which
>> > sales
>> > people use to record information about customer that they have visited.
>> > I
>> > have written a report which should display each record on a seperate
>> > page.
>> > However, when someone has written a particularly long report and this
>> > spans 2
>> > or more pages the report formats correctly on the screen, but when you
>> > export
>> > to pdf you have the header information on 1 page (let's say the top 1/3
>> > of
>> > the page) and the detail of the report moves on to the next page. What
>> > I
>> > want to happen is for the report to move on to a new page when
>> > appropriate
>> > (i.e. when the 1st page is full).
>> >
>> > Has anyone come across this? Is there a solution?
>> >
>> > Thanks in advance,
>> >
>> > Mike Swann
>>

PDF files with images get unexpectedly large in SQL Server 2000 Reporting Services

When using quite small JPEGS (~ 800 KB) in a report the exported PDF is a few megabytes of size. Am I missing something (e.g. some kind of compression)?

Can anyone give me a hint on this one?

Thanks,
Neno

There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into.

|||

i want to download some programme so i need urgent thanks

|||

I would suggest installing RS SP2 and the latest QFE available (KB912424).

Thank you,

Nico

|||This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211

PDF files with images get unexpectedly large in SQL Server 2000 Reporting Services

When using quite small JPEGS (~ 800 KB) in a report the exported PDF is a few megabytes of size. Am I missing something (e.g. some kind of compression)?

Can anyone give me a hint on this one?

Thanks,
Neno

There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into.

|||

i want to download some programme so i need urgent thanks

|||

I would suggest installing RS SP2 and the latest QFE available (KB912424).

Thank you,

Nico

|||This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211sql

PDF files with images get unexpectedly large in SQL Server 2000 Reporting Services

When using quite small JPEGS (~ 800 KB) in a report the exported PDF is a few megabytes of size. Am I missing something (e.g. some kind of compression)?

Can anyone give me a hint on this one?

Thanks,
Neno

There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into.

|||

i want to download some programme so i need urgent thanks

|||

I would suggest installing RS SP2 and the latest QFE available (KB912424).

Thank you,

Nico

|||This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211

PDF Export error in reporting services 2000

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

amit_800 wrote:

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

|||

I have seen this only once before and reinstalling the Arial font fixed this issue. The error message you see comes from the Windows GDI library. To reinstall Arial, do the following. Note that these instructions are for Windows XP or Windows Server 2003 only.

1. In Windows Explorer, navigate to C:\Windows\Fonts

2. Right-click the Arial (TrueType) font and select delete

3. Reboot

4. Expand Arial.tt_ from the i386 or AMD64 directory on your Windows CD to a directory on your hard drive. To expand, you can use the expand.exe file in the i386/amd64 directory or an application like 7-Zip.

5. In Windows Explorer, navigate to C:\Windows\Fonts

6. From the File menu, choose Install New Font and then select the Arial.TTF file you expanded.

7. Reboot

Thanks.

PDF Export error in reporting services 2000

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

amit_800 wrote:

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

|||

I have seen this only once before and reinstalling the Arial font fixed this issue. The error message you see comes from the Windows GDI library. To reinstall Arial, do the following. Note that these instructions are for Windows XP or Windows Server 2003 only.

1. In Windows Explorer, navigate to C:\Windows\Fonts

2. Right-click the Arial (TrueType) font and select delete

3. Reboot

4. Expand Arial.tt_ from the i386 or AMD64 directory on your Windows CD to a directory on your hard drive. To expand, you can use the expand.exe file in the i386/amd64 directory or an application like 7-Zip.

5. In Windows Explorer, navigate to C:\Windows\Fonts

6. From the File menu, choose Install New Font and then select the Arial.TTF file you expanded.

7. Reboot

Thanks.

PDF export error

I've created a report and it works fine in html,
but when I export to PDF, I receive next error:
Reporting Services Error
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError)
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown
Index and length must refer to a location within the string.
Parameter name: length
Any suggestions please?
Regards,
Miguel.Check what the report language property is set to. If it's not a
language-country pair, you might run into this error. For instance, if you
choose "English", this error might occur. Change it to a language-country
pair (for example en-US).
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Miguel Esteban" <mestebanpt@.yahoo.es> wrote in message
news:eUEQ258cEHA.3420@.TK2MSFTNGP12.phx.gbl...
> I've created a report and it works fine in html,
> but when I export to PDF, I receive next error:
> Reporting Services Error
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError)
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown
> Index and length must refer to a location within the string.
> Parameter name: length
>
> Any suggestions please?
> Regards,
> Miguel.
>

PDF export error

When I try to export a 2400 pages report to pdf get the reporting services
error:
exception of type Microsoft.Reporting.Services.ReportRenderingException was
thrown. index was out of range. Must be non-negative and less than the size
of the collection. Parameter name: index.
The report ran before SP2 fine and after SP2 fine too.
Any help will be greatly appreciated.These are the error I get when debug.
A first chance exception of type 'System.ArgumentOutOfRangeException'
occurred in mscorlib.dll
Additional information: Index was out of range. Must be non-negative and
less than the size of the collection.
--
A first chance exception of type
'Microsoft.ReportingServices.ReportRendering.ReportRenderingException'
occurred in microsoft.reportingservices.imagerendering.dll
--
A first chance exception of type
'Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException' occurred in microsoft.reportingservices.processing.dll
Additional information: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
--
A first chance exception of type
'Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException' occurred in microsoft.reportingservices.processing.dll
Additional information: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
"Ehsan Khan" wrote:
> When I try to export a 2400 pages report to pdf get the reporting services
> error:
> exception of type Microsoft.Reporting.Services.ReportRenderingException was
> thrown. index was out of range. Must be non-negative and less than the size
> of the collection. Parameter name: index.
> The report ran before SP2 fine and after SP2 fine too.
> Any help will be greatly appreciated.

PDF EXPORT

Dear All

I use sql server reporting services..in visual studio 2005..

when exporting report to pdf in the report viewer alignment varies..

single table report split up in to two pages not in proper manner..

how to tackle this export to pdf event in report viewer..

did anyone can help me in this.

Regards

Senthil

You need to do adjust the table correctly. just decrease the width of the table and other objects.

if width of the objects does not fit in a page than it will be divided into two pages in pdf. so try to adjust the width of the objects.

|||

I had the same problem and this is what I found. If the report is defined as an 11 x 8.5 (landscape) report with .5 margins (defined in report properties) all around your report data cannot exceed 10".

10" + .5 left margin + .5 right margin = 11.

If you exceed this the page will split.

|||

Thnx jhaberer

its working fine!...

sql

PDF and attribute

I have reporting service 2005 report, Through Render method, populating PDF
file. Is there anyway, we can set PDF attrubute file to prevent user to
modify?
with Readyonly attribute, user can change the property of a file?
any othereway, we can make PDF can not be modifed using Editor?
in short, make the PDF readyonly.On Dec 10, 2:20 pm, Kalyan <Kal...@.discussions.microsoft.com> wrote:
> I have reporting service 2005 report, Through Render method, populating PDF
> file. Is there anyway, we can set PDF attrubute file to prevent user to
> modify?
> with Readyonly attribute, user can change the property of a file?
> any othereway, we can make PDF can not be modifed using Editor?
> in short, make the PDF readyonly.
Normally, if a user has a PDF creator software, it is hard to keep
them from modifying the PDF file; however, to set the attributes to
read only, you could try something like this in a custom ASP.NET
application.
http://www.java2s.com/Tutorial/VB/0240__Stream-File/SetfileattributesHiddenReadOnly.htm
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

PDC - SQLServer Reporting Services Beta Install

I am having difficulty installing the server components of the SQLServer
Reporting Services Beta copy I received at the PDC. My server is the domain
controller for a small home network, and I received the following error:
An error occurred while applying security settings. <machineName>\ASPNET is
not a valid user or group.
This could be a problem with the package, or a problem connecting to a
domain controller on the
network. Check your network connection and click Retry, or Cancel to end
the install.
I have verified that the ASPNET machine account exists - but I suspect a
recent upgrade from .NET framework 1.0 to 1.1 may have influenced this
error. I would like to try changing the account that the Report Server Web
Service runs as, but I don't see an option to accomodate thisoption.
Does anyone have any suggestions?
I have the following installed:
Recently upgraded .NET Framework from 1.0 to 1.1
Windows 2000 Server
SQLServer Standard Edition, SP3a
Thanks in advance,
RobYou might have more luck posting this message on the RS newsgroup.
It's :- microsoft.beta.reporting.services.general
--
HTH
Ryan Waight, MCDBA, MCSE
"Rob Patterson" <rpatterson@.ztr.com> wrote in message
news:uRRZqKGpDHA.384@.tk2msftngp13.phx.gbl...
> I am having difficulty installing the server components of the SQLServer
> Reporting Services Beta copy I received at the PDC. My server is the
domain
> controller for a small home network, and I received the following error:
> An error occurred while applying security settings. <machineName>\ASPNET
is
> not a valid user or group.
> This could be a problem with the package, or a problem connecting to a
> domain controller on the
> network. Check your network connection and click Retry, or Cancel to end
> the install.
> I have verified that the ASPNET machine account exists - but I suspect a
> recent upgrade from .NET framework 1.0 to 1.1 may have influenced this
> error. I would like to try changing the account that the Report Server
Web
> Service runs as, but I don't see an option to accomodate thisoption.
> Does anyone have any suggestions?
> I have the following installed:
> Recently upgraded .NET Framework from 1.0 to 1.1
> Windows 2000 Server
> SQLServer Standard Edition, SP3a
> Thanks in advance,
> Rob
>|||How do I subscribe to microsoft.beta.reporting.services.general
I have a similar problem, but I am unable to subscribe.
Thanks,
Hanna

PC shutdown while printing from report

Hi all,

I m new to SQL Server Reporting Service. I hope you guys can find some solutions to my problem.

When i try to print from report's toolbar, my pc suddenly restart. and I thought it may be some printer driver

conflict, and check my event logs also. but i can't find any error or warning message there at all.

Can anybody knows the source of the problem and solution.

Regards,
gakuci

Any luck with this? Are you aware of any special anti virus/spy software that could be causing this?

|||

Looks like this is a driver problem. Try this KB article

http://support.microsoft.com/kb/935843

Pb with group and lost of informations in the report

But I have problem with reporting services. Could you help me?

For exemple, I have some informatins who don't appear in my report. For example, I have a list of agricultur who are ranged in three different groups( A,B or C). I want to put their names by grouping them in their departement and their town.

Then, a second group on the departement

And finally, a group on the town. But agriculteurs can have a departement and no town, that's why I put them under the departement, and before, the towns of the departement.

For examples for a group, I want to see :

Group A

Auvergne

Mr smith

Mr nicoli

Mr autain

Aubière

Mr potier

Mr dupont

Clermont-ferrand

Mme Pilla

Mr tilmont

Mr aubigny

But, in fact, with reporting services, you don't see Mr nicoli and Mr autain. And I don't understand why? Could you help me?

Salut,

Si j'ai bien compris, tu aurais une dimension Gographie avec une hirarchie

Groupe|||

what i suggest is...

only group by ur groups i.e A B & C and under that group by department ,

then sort the records by Town wise, display town beside the name of the agricultur and make it display only once .

do not have a group for Town.

hope it works for u

|||Oui, tu as tout compris, je dois mettre le nom des agriculteurs sous le nom de dpartement et/ou de ville.J'ai stock mes donnes dans un tableau, j'ai insr un group 1 sur groupe(A,B,ou C) un group 2 sur dpartement, et un group 3 sur ville. Et entre group 2 et 3, c'est à dire sous dpartement, j'ai des agriculteurs qui n'appartiennent à aucune ville. Et comme ce sont des lignes de groupes, et pas des lignes de dtails, j'ai l'impression que reporting services, ne prend pas tous les agriculteurs. Et là est mon soucis.Comment lui faire afficher les agriculteurs qui me manquent. Tu veux d'autres prcisions?|||

Hum, well,I must display the name of the town before the agricultur sometimes, when I have agriculturs in the town. I can't inverse the town and the agriculturs. But do you know a way to display all the information between two groups? Or is it a bug of reporting services?

Moreover, for another thing, I want not to display an empty line, but I don't find, so I do Iif(condition, " " ,my treatment) and I have big white. Normal, But I can't find anything else to display what I want.

|||

you cannot say it as bug, only it is designed like that, the grouping will always be Hierarchical(vertical). you can have only one group under a group .

practically think , can u have multiple bosses or a single boss. 99% of people will have a single boss. that means only one group under a group.

Unless manual method, i think u never find a reporting tool to support ur cause..

if u do not want to display blank line or empty line. u can use CASE statement in ur SQL query to replace blank or null values in Town Column by whatever u want.

Password Proctected Excel Subscription

I need to send protected information via a reporting services subscripiton. Unfortunately the receiver can not access our reporting services web page so I have to send it as an excel attachment with email. Is there a way I can protect the spreadsheet automatically before it is sent via the subscription.

Thanks

Reporting Services doesn't currently have a DRM/IRM or Excel password feature, so you would have to post-process the Excel files that RS generates.|||Thanks but I'm still not sure how I'd do that without programming.|||You will have to do some programming, or open the Excel files in Excel and modify them.

Passing Subreport info to Header

Hello,
I am new to reporting services and have a need to pass information from a subreport to a header and haven't found a way to do so. Does anyone have any sugguestions for me?

I would greatly appreciate it.
RickI don't think you can pass anything from a subreport. You can pass information from the report body to the header though.

passing row to custom code

I wish to pass the current row to a custom function in reporting
services...does anyone have the syntax for this?
It would looking like: txtMybox.value = ParseInformation( current_row)
ThanksRoy.
Your value should be
=Code.ParseInformation(Fields!CurrentRow.Value)
Now, this is subject to what "current row" is refering to. If your
referencing just 1 field in the current row then the above is approriate;
however if you are trying to pass 2, or n number of fields, you need to
either
a) concatenate them together such as
Code.ParseInformation(FIelds!Field_1.Value+Fields!Field_2.Value+...Fields!Field_n.Value)
OR make in your custom code create a variable for each field to be passed,
and call the code like:
Code.ParseInformation(Fields!Field_1.Value,Fields!Field_2.Value,...,Fields!Field_n.Value)
Michael C
"roy@.mgk.com" wrote:
> I wish to pass the current row to a custom function in reporting
> services...does anyone have the syntax for this?
> It would looking like: txtMybox.value => ParseInformation( current_row)
>
> Thanks
>