Changes in Katmai

I've got a number of questions about the forthcoming release which hopefully can be answered:

1) What version of Excel will 2008 export too? Currently exported Excel files are in native 2000/2003 format. Please don't tell me they will only export in 2007 format!

2) Can you give any details on changes we can expect to the report viewer (web version) control? In particular will it behave better in an update panel? Also we have found the only way of getting the height property to set correctly with this control is to use some very (I'm mean very) dodgy java script. This seems to be a common problem looking through various forums.

3) Will we have the option of opening linked reports through the report viewer in a new window/tab (this is common complaint from my users currently).

4) In the code window of the report designer is there any chance of getting some IntelliSense?

5) Will there be support for stored procedures that return multiple recordsets?

Thanks

Simon

Hi Simon,

I can answer #1 of your questions. Reporting Services 2008 will export to the same Excel format as before. The XLS format can be used on Excel 2000-2007.

Best regards,
Chris|||

#5: It's not on the list for SSRS 2008.

Could you please explain in more detail why this is so important?

Can you write wrapper stored procedures that return a particular recordset you are interested in?

-- Robert

|||

Thanks for both the answers so far. In response to Robert's point about #5 - it's useful rather than requirement.

I worked recently on converting an ASP based reporting system into RS. Many of the existing procs returns multiple recordsets so we struggled to reuse the code. Agreed it could be done with a wrapper anyway. This certainly wouldn't stop me wanting to upgrade!

Any comments on the other points?

Thanks again

Simon

|||Robert,

I think support for multiple resultsets would be great.

At the moment we may have a report that shows the same basic data in more than one way, eg two tables and a chart. If a single resultset can't provide the data we need to execute more than one query from within the report. I appreciate that they can run in parallel, but if they are basically hitting the same underlying data it would be better for us to have one stored procedure that returned several resultsets.

This is especially true if the query can't be done in one statement and requires the production of temporary tables/variables. If we have to have separate queries we may have to recreate the temporary data in each query, whereas if we have one procedure with multiple resultsets it gets created just once and the second resultset can build on the first, the third on the second etc.

Regards,
Andrew

Changes in Katmai

I've got a number of questions about the forthcoming release which hopefully can be answered:

1) What version of Excel will 2008 export too? Currently exported Excel files are in native 2000/2003 format. Please don't tell me they will only export in 2007 format!

2) Can you give any details on changes we can expect to the report viewer (web version) control? In particular will it behave better in an update panel? Also we have found the only way of getting the height property to set correctly with this control is to use some very (I'm mean very) dodgy java script. This seems to be a common problem looking through various forums.

3) Will we have the option of opening linked reports through the report viewer in a new window/tab (this is common complaint from my users currently).

4) In the code window of the report designer is there any chance of getting some IntelliSense?

5) Will there be support for stored procedures that return multiple recordsets?

Thanks

Simon

Hi Simon,

I can answer #1 of your questions. Reporting Services 2008 will export to the same Excel format as before. The XLS format can be used on Excel 2000-2007.

Best regards,
Chris|||

#5: It's not on the list for SSRS 2008.

Could you please explain in more detail why this is so important?

Can you write wrapper stored procedures that return a particular recordset you are interested in?

-- Robert

|||

Thanks for both the answers so far. In response to Robert's point about #5 - it's useful rather than requirement.

I worked recently on converting an ASP based reporting system into RS. Many of the existing procs returns multiple recordsets so we struggled to reuse the code. Agreed it could be done with a wrapper anyway. This certainly wouldn't stop me wanting to upgrade!

Any comments on the other points?

Thanks again

Simon

|||Robert,

I think support for multiple resultsets would be great.

At the moment we may have a report that shows the same basic data in more than one way, eg two tables and a chart. If a single resultset can't provide the data we need to execute more than one query from within the report. I appreciate that they can run in parallel, but if they are basically hitting the same underlying data it would be better for us to have one stored procedure that returned several resultsets.

This is especially true if the query can't be done in one statement and requires the production of temporary tables/variables. If we have to have separate queries we may have to recreate the temporary data in each query, whereas if we have one procedure with multiple resultsets it gets created just once and the second resultset can build on the first, the third on the second etc.

Regards,
Andrew

Changes in Katmai

I've got a number of questions about the forthcoming release which hopefully can be answered:

1) What version of Excel will 2008 export too? Currently exported Excel files are in native 2000/2003 format. Please don't tell me they will only export in 2007 format!

2) Can you give any details on changes we can expect to the report viewer (web version) control? In particular will it behave better in an update panel? Also we have found the only way of getting the height property to set correctly with this control is to use some very (I'm mean very) dodgy java script. This seems to be a common problem looking through various forums.

3) Will we have the option of opening linked reports through the report viewer in a new window/tab (this is common complaint from my users currently).

4) In the code window of the report designer is there any chance of getting some IntelliSense?

5) Will there be support for stored procedures that return multiple recordsets?

Thanks

Simon

Hi Simon,

I can answer #1 of your questions. Reporting Services 2008 will export to the same Excel format as before. The XLS format can be used on Excel 2000-2007.

Best regards,
Chris|||

#5: It's not on the list for SSRS 2008.

Could you please explain in more detail why this is so important?

Can you write wrapper stored procedures that return a particular recordset you are interested in?

-- Robert

|||

Thanks for both the answers so far. In response to Robert's point about #5 - it's useful rather than requirement.

I worked recently on converting an ASP based reporting system into RS. Many of the existing procs returns multiple recordsets so we struggled to reuse the code. Agreed it could be done with a wrapper anyway. This certainly wouldn't stop me wanting to upgrade!

Any comments on the other points?

Thanks again

Simon

|||Robert,

I think support for multiple resultsets would be great.

At the moment we may have a report that shows the same basic data in more than one way, eg two tables and a chart. If a single resultset can't provide the data we need to execute more than one query from within the report. I appreciate that they can run in parallel, but if they are basically hitting the same underlying data it would be better for us to have one stored procedure that returned several resultsets.

This is especially true if the query can't be done in one statement and requires the production of temporary tables/variables. If we have to have separate queries we may have to recreate the temporary data in each query, whereas if we have one procedure with multiple resultsets it gets created just once and the second resultset can build on the first, the third on the second etc.

Regards,
Andrew

Change values in SSIS.

Howdy all. In DTS there was a way too change the values of a column during
and export to another table using ActiveX Script:
Source:
Table1
column1
column2
Destination
Table2
column1 (I want this to contain the exact values from Table1.column1)
column2 (I want this to contain the values of Table1.column2 + 10)
Basically you would do this through the mappings, instead of a Copy Column,
you would use an AxtiveX script for that column. How can this be done in
SSIS?
TIA, ChrisR
Hi Chris
You can use a script component as a transform task see
http://www.sqlis.com/default.aspx?307,1
John
"ChrisR" wrote:

> Howdy all. In DTS there was a way too change the values of a column during
> and export to another table using ActiveX Script:
> Source:
> Table1
> column1
> column2
> Destination
> Table2
> column1 (I want this to contain the exact values from Table1.column1)
> column2 (I want this to contain the values of Table1.column2 + 10)
> Basically you would do this through the mappings, instead of a Copy Column,
> you would use an AxtiveX script for that column. How can this be done in
> SSIS?
> TIA, ChrisR
>
>
>
|||Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5FAF7EA7-D0E7-41FB-AF37-B70DA73AE95E@.microsoft.com...[vbcol=seagreen]
> Hi Chris
> You can use a script component as a transform task see
> http://www.sqlis.com/default.aspx?307,1
> John
> "ChrisR" wrote:
during[vbcol=seagreen]
Column,[vbcol=seagreen]

Change values in SSIS.

Howdy all. In DTS there was a way too change the values of a column during
and export to another table using ActiveX Script:
Source:
Table1
column1
column2
Destination
Table2
column1 (I want this to contain the exact values from Table1.column1)
column2 (I want this to contain the values of Table1.column2 + 10)
Basically you would do this through the mappings, instead of a Copy Column,
you would use an AxtiveX script for that column. How can this be done in
SSIS?
TIA, ChrisRThanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5FAF7EA7-D0E7-41FB-AF37-B70DA73AE95E@.microsoft.com...
> Hi Chris
> You can use a script component as a transform task see
> http://www.sqlis.com/default.aspx?307,1
> John
> "ChrisR" wrote:
> > Howdy all. In DTS there was a way too change the values of a column
during
> > and export to another table using ActiveX Script:
> >
> > Source:
> > Table1
> > column1
> > column2
> >
> > Destination
> > Table2
> > column1 (I want this to contain the exact values from Table1.column1)
> > column2 (I want this to contain the values of Table1.column2 + 10)
> >
> > Basically you would do this through the mappings, instead of a Copy
Column,
> > you would use an AxtiveX script for that column. How can this be done in
> > SSIS?
> >
> > TIA, ChrisR
> >
> >
> >
> >
> >

Change values in SSIS.

Howdy all. In DTS there was a way too change the values of a column during
and export to another table using ActiveX Script:
Source:
Table1
column1
column2
Destination
Table2
column1 (I want this to contain the exact values from Table1.column1)
column2 (I want this to contain the values of Table1.column2 + 10)
Basically you would do this through the mappings, instead of a Copy Column,
you would use an AxtiveX script for that column. How can this be done in
SSIS?
TIA, ChrisRHi Chris
You can use a script component as a transform task see
http://www.sqlis.com/default.aspx?307,1
John
"ChrisR" wrote:

> Howdy all. In DTS there was a way too change the values of a column during
> and export to another table using ActiveX Script:
> Source:
> Table1
> column1
> column2
> Destination
> Table2
> column1 (I want this to contain the exact values from Table1.column1)
> column2 (I want this to contain the values of Table1.column2 + 10)
> Basically you would do this through the mappings, instead of a Copy Column
,
> you would use an AxtiveX script for that column. How can this be done in
> SSIS?
> TIA, ChrisR
>
>
>|||Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5FAF7EA7-D0E7-41FB-AF37-B70DA73AE95E@.microsoft.com...[vbcol=seagreen]
> Hi Chris
> You can use a script component as a transform task see
> http://www.sqlis.com/default.aspx?307,1
> John
> "ChrisR" wrote:
>
during[vbcol=seagreen]
Column,[vbcol=seagreen]

Change quality rendering to PDF

PDF - rendering of reports that contain images, makes very large pdf-files.
Is there any option that I can set the export quality of the images?
I have seen in this forum that there have been many questions about
rendering images, but very few good answers ... can anyone tell me if there
are any solution to my problem ? .... changes in SP2?What is your source for images? There are lots of good tools out there for
reducing the size of images. For example, if your images are stored in a
file system, IrfanView is an easy tool to use, and it has good compression
as well.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"TiJei" <TiJei@.discussions.microsoft.com> wrote in message
news:7BAA23AF-4337-4145-B957-06E80ABBB79B@.microsoft.com...
> PDF - rendering of reports that contain images, makes very large
> pdf-files.
> Is there any option that I can set the export quality of the images?
> I have seen in this forum that there have been many questions about
> rendering images, but very few good answers ... can anyone tell me if
> there
> are any solution to my problem ? .... changes in SP2?|||Thank you for your answer Jeff,
I know there is a lot of tools for resizing images, but why should the
pdf-rendering "enlarge" my images?
If i use a jpeg as source, with the size about 300kb and 96*96 dpi, I got a
export file at about 2,3 MB.
When rendering to pdf, I want to have the possibility to declare the
properties for the image, today the size of the exported file indicates that
the quality always are high?
"Jeff A. Stucker" wrote:
> What is your source for images? There are lots of good tools out there for
> reducing the size of images. For example, if your images are stored in a
> file system, IrfanView is an easy tool to use, and it has good compression
> as well.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "TiJei" <TiJei@.discussions.microsoft.com> wrote in message
> news:7BAA23AF-4337-4145-B957-06E80ABBB79B@.microsoft.com...
> > PDF - rendering of reports that contain images, makes very large
> > pdf-files.
> > Is there any option that I can set the export quality of the images?
> >
> > I have seen in this forum that there have been many questions about
> > rendering images, but very few good answers ... can anyone tell me if
> > there
> > are any solution to my problem ? .... changes in SP2?
>
>