How to create large report?

Hi,

I have been tasked with trying to re-create out in-house reporting solution, based-on powerpoint and SQL Server, using Reporting Services 2005.

However when trying to create a demo report I find a number of problems:

1) I cannot make the page layout long enough or insert extra pages in order to caointain all of the test, charts and tables that we have in our reports (typically around 100 powerpoint slides)

2) I cannot find a way to set any global report styles for text or charts

3) I cannot find a way to have a flow layout instead of a grid layout - which does not allow me to insert items into the middle of a report

Any help/advice would be greatly appreciated,

Thanks,

Denham

1) Click on the Body band and set the Size property accordingly.

2) Currently, SSRS doesn't support styles or templates.

3) The List region allows you to create freeflowing reports.

|||

Hi Denham,

please forgive me if I have not understood you correctly...

1) I cannot make the page layout long enough or insert extra pages in order to caointain all of the test, charts and tables that we have in our reports (typically around 100 powerpoint slides)

This sounds like you are trying to create a 100 page report (?). If so, I would question the business value of such a report. May be better to suggest an alternative, such as using exception reports in a web page (BI style, which you can do in report designer), or cutting up the report into smaller chunks. Personally, I haven't had the need to create a report more than 30-odd pages long - which I thought was rather extravagant.

2) I cannot find a way to set any global report styles for text or charts

I don't know of any either. I tend to copy a graph/table/matrix and then change the dataset & values.

3) I cannot find a way to have a flow layout instead of a grid layout - which does not allow me to insert items into the middle of a report.

The only way I know of is to move everything on the page downwards to insert something in between. The layout can take quite a bit of getting used to, especially if you are familiar with banded report designers, such as Crystal. However, once you have been using it for a while, it becomes reasonably easy.

Hope that has been of some help to you.

NinetyNine

|||

Thanks for your reply.

1) Unfortunately our business needs to create these large reports in order to support the many different types of analyses that are used. However it may be possible to break them up into sub-reports in order for us to use Reporting Services

2) Shame about the lack of styles. Our current reporting solution is based on Powerpoint for which we can use templates.

3) Again, shame!

How to create large report?

Hi,

I have been tasked with trying to re-create out in-house reporting solution, based-on powerpoint and SQL Server, using Reporting Services 2005.

However when trying to create a demo report I find a number of problems:

1) I cannot make the page layout long enough or insert extra pages in order to caointain all of the test, charts and tables that we have in our reports (typically around 100 powerpoint slides)

2) I cannot find a way to set any global report styles for text or charts

3) I cannot find a way to have a flow layout instead of a grid layout - which does not allow me to insert items into the middle of a report

Any help/advice would be greatly appreciated,

Thanks,

Denham

1) Click on the Body band and set the Size property accordingly.

2) Currently, SSRS doesn't support styles or templates.

3) The List region allows you to create freeflowing reports.

|||

Hi Denham,

please forgive me if I have not understood you correctly...

1) I cannot make the page layout long enough or insert extra pages in order to caointain all of the test, charts and tables that we have in our reports (typically around 100 powerpoint slides)

This sounds like you are trying to create a 100 page report (?). If so, I would question the business value of such a report. May be better to suggest an alternative, such as using exception reports in a web page (BI style, which you can do in report designer), or cutting up the report into smaller chunks. Personally, I haven't had the need to create a report more than 30-odd pages long - which I thought was rather extravagant.

2) I cannot find a way to set any global report styles for text or charts

I don't know of any either. I tend to copy a graph/table/matrix and then change the dataset & values.

3) I cannot find a way to have a flow layout instead of a grid layout - which does not allow me to insert items into the middle of a report.

The only way I know of is to move everything on the page downwards to insert something in between. The layout can take quite a bit of getting used to, especially if you are familiar with banded report designers, such as Crystal. However, once you have been using it for a while, it becomes reasonably easy.

Hope that has been of some help to you.

NinetyNine

|||

Thanks for your reply.

1) Unfortunately our business needs to create these large reports in order to support the many different types of analyses that are used. However it may be possible to break them up into sub-reports in order for us to use Reporting Services

2) Shame about the lack of styles. Our current reporting solution is based on Powerpoint for which we can use templates.

3) Again, shame!

How to create configurations ?

When I attempt to create a new configuration named QA in
configuration manager.
I enter QA in the Solution Configuration Name and copy
setting from <Default>. I also select the checkbox "Also
create new project configuration". After pressing the OK
button, I cannot find the new configuration QA in the list.
Besides, I would like to know what does it mean for the
configuration - Does it mean that the different Report
Servers OR different folders in the same Report Server ?
ThanksSQL 2000 Reporting Services does not support creating new project
configurations. You can create a new solution configuration if you uncheck
"Also create new project configuration". To create a new project
configuration you need to edit the project file (*.rptproj).
The project configuration contains all the project properties: TargetFolder,
TargetServerURL and OverwriteDataSources.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:141b01c56b0d$42a6ed30$a401280a@.phx.gbl...
> When I attempt to create a new configuration named QA in
> configuration manager.
> I enter QA in the Solution Configuration Name and copy
> setting from <Default>. I also select the checkbox "Also
> create new project configuration". After pressing the OK
> button, I cannot find the new configuration QA in the list.
> Besides, I would like to know what does it mean for the
> configuration - Does it mean that the different Report
> Servers OR different folders in the same Report Server ?
> Thanks

How to create a row that has size greater than 8060

Hi all
When I updated database I got the error message that size of row can't
greater than 8060. Howerver, I think there must be a solution because 8060
is too small. Help me!
ThanksHi
You can ignore the error message and the table will be created although if
the data inserted into the table exceeds the size then the insert will fail.
A table with a size greater than 8060 is a very wide table and you may want
to think about re-designing the database so that you use several tables. You
can create a view that joins these tables if you always wish to avoid joinin
g
the tables "manually".
John
"ghostnguyen" wrote:

> Hi all
> When I updated database I got the error message that size of row can't
> greater than 8060. Howerver, I think there must be a solution because 8060
> is too small. Help me!
> Thanks
>
>|||And all this really, really, really needs to be in a single table? Can you
post some DDL, please?
ML|||Size of a Single row cannot be more than 8060 bytes
Madhivanan|||Create two tables related by a common primary key.
David Portas
SQL Server MVP
--|||Short of redesigning your table (using two tables, for example, as has been
suggested), you may want to consider using [text] instead of long [varchar]
columns. They will be harder to work with, but they are one way to get
around this limitation.
Steve Kass
Drew University
ghostnguyen wrote:

>Hi all
>When I updated database I got the error message that size of row can't
>greater than 8060. Howerver, I think there must be a solution because 8060
>is too small. Help me!
>Thanks
>
>|||If 8060 is too small, seriously look at your database design, or use
datatypes like ntext if you need large text storage.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:DB030F6E-7BA3-4187-817E-EA3FF8088575@.microsoft.com...
> Hi
> You can ignore the error message and the table will be created although if
> the data inserted into the table exceeds the size then the insert will
> fail.
> A table with a size greater than 8060 is a very wide table and you may
> want
> to think about re-designing the database so that you use several tables.
> You
> can create a view that joins these tables if you always wish to avoid
> joining
> the tables "manually".
> John
> "ghostnguyen" wrote:
>

How to create a field that may accoss multiple pages?

I have a memo field that may not fit into one page. Is there any solution to let crystal report create multiple pages automatically at runtime? Splitting the string manually may not be the solution because how many characters are displayed for each page cannot be determined at the design time.

Thanks in advance!Doesn't the 'Can Grow' option work? (Right click field, Format Field, Common tab)?|||'Can Grow' does not work because the displaying area has to be fixed while the message may be too long to fit into one page.