Reporting Services 2000 Export Excel Issue

Hello All,
I am currently creating a Reporting Services report whose total
page width is 33in. I use three data tables to simulate one very large table.
My issue is:
When I export this data to the EXCEL format, tables two and three are not
visible past the first sheet. Is there something that I should do to ensure
that all three tables are visible on every Excel WorkSheet?
Thanks
EricOn May 3, 2:52 pm, Eric <E...@.discussions.microsoft.com> wrote:
> Hello All,
> I am currently creating a Reporting Services report whose total
> page width is 33in. I use three data tables to simulate one very large table.
> My issue is:
> When I export this data to the EXCEL format, tables two and three are not
> visible past the first sheet. Is there something that I should do to ensure
> that all three tables are visible on every Excel WorkSheet?
> Thanks
> Eric
I'm not sure about the maximum width of a report; however, you can try
adding all 3 table controls into a single rectangle control. This
should conserve width space. Also, make sure that the properties of
the table controls include 'Fit table on one page if possible.' Sorry
I could not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Reporting Services - use of temp tables

Hello all,

I need to create a report based on a stored procedure. This stored procedure contains temp tables. At the time of creating the report, I receive a message mentioning - There is an error in the query. Invalid object name '<temp table name'>

Doesn't Reporting Services support temp tables?

Thanks all,
SauravYou can use temporary tables. I tend to do it like...

-- Create temporary tables
declare @.MyTempTable table
(
field1 int,
field2 smalldatetime,
field3 int,
field4 smallint
)

You can then use @.MyTempTable for your SP.

Hope that helps.sql

Reporting On Sproc Update Dates?

Does anyone know the system tables I need to query to produce a report of stored procedures (SQL 2005) that had any changes made to them in a user-specified date range?

In SQL 2005, I saw the canned database reports, but this one didn't exist. Any help would be greatly appreciated.

Thanks!

Wow, already off the first page so quickly?

Sorry for the bump, I just wanted to be sure there was no quick answer to this. I would have thought it would be an easy thing to do, I may be mistaken.

Any takers?

Thanks again.

|||

You can get any object now using the sys.objects view. For sprocs, you'd want something like this:

Code Snippet

select * from sys.objects where type='P' and modify_date between getdate() - 1000 and getdate()

-Jessica

|||

Perfect! I knew it must be something simple I was missing.

Thanks, Jessica!

Reporting On Sproc Update Dates?

Does anyone know the system tables I need to query to produce a report of stored procedures (SQL 2005) that had any changes made to them in a user-specified date range?

In SQL 2005, I saw the canned database reports, but this one didn't exist. Any help would be greatly appreciated.

Thanks!

Wow, already off the first page so quickly?

Sorry for the bump, I just wanted to be sure there was no quick answer to this. I would have thought it would be an easy thing to do, I may be mistaken.

Any takers?

Thanks again.

|||

You can get any object now using the sys.objects view. For sprocs, you'd want something like this:

Code Snippet

select * from sys.objects where type='P' and modify_date between getdate() - 1000 and getdate()

-Jessica

|||

Perfect! I knew it must be something simple I was missing.

Thanks, Jessica!