Report Design Question

Hi everyone!
I am developing a Work Order report similar to the "Adventure Works Cycles"
sample provided with Reporting Services. What I would like to do is repeat
the "Header" information on each page. I am looking at the samples for an
example on how to do this but no luck. I even reduced the height of the
"Adventure Works Cycles" sample report to see if it's Header data is carried
over and it isn't.
How do I get my "Header" data to carry over to the next page. I tried adding
it to the page Header but it doesn't like field data in it.
Thanks in advance,
YoshiLook at the Header attibute for the Table. It can be set to repeat on each
page.
--
| From: "Yoshi" <yoshi@.home.com>
| Subject: Report Design Question
| Date: Wed, 17 Nov 2004 10:06:03 -0600
| Lines: 17
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#YmgY9LzEHA.1292@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: cs24174142-174.satx.rr.com 24.174.142.174
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10|||My header data is not in the table as I am confined to the column width. I
placed the header data in the body of the report above the table. I used the
"Adventure Works Cycles" sample provided by Microsoft, as my guide.
My problem is when the detail lines carry over to the next page. I would
like page 2 to have the same header data that page 1 has. In fact, I want
subsequent pages to look like page 1 with the header data.
Make sense?
Thanks,
Yoshi
""Brad Syputa - MS"" <bradsy@.Online.Microsoft.com> wrote in message
news:wbVFvhNzEHA.2916@.cpmsftngxa10.phx.gbl...
> Look at the Header attibute for the Table. It can be set to repeat on each
> page.
> --
> | From: "Yoshi" <yoshi@.home.com>
> | Subject: Report Design Question
> | Date: Wed, 17 Nov 2004 10:06:03 -0600
> | Lines: 17
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
> | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#YmgY9LzEHA.1292@.TK2MSFTNGP10.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: cs24174142-174.satx.rr.com 24.174.142.174
> | Path:
> cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10
> phx.gbl
> | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:35173
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Hi everyone!
> |
> | I am developing a Work Order report similar to the "Adventure Works
> Cycles"
> | sample provided with Reporting Services. What I would like to do is
> repeat
> | the "Header" information on each page. I am looking at the samples for
> an
> | example on how to do this but no luck. I even reduced the height of the
> | "Adventure Works Cycles" sample report to see if it's Header data is
> carried
> | over and it isn't.
> |
> | How do I get my "Header" data to carry over to the next page. I tried
> adding
> | it to the page Header but it doesn't like field data in it.
> |
> | Thanks in advance,
> |
> | Yoshi
> |
> |
> |
>|||Place the header in a table group - go to Edit Group and select the
"Repeat Header" option.|||Unfortunately, my header will not work in the "Table" header row. The
columns do not allow for the correct width.
Thanks for the response.
"papaboom" <smith.jamie@.gmail.com> wrote in message
news:1100725306.172333.164530@.z14g2000cwz.googlegroups.com...
> Place the header in a table group - go to Edit Group and select the
> "Repeat Header" option.
>|||Techinically - Yoshi - you are not confined to keeping your header
outside the table. If this is the problem - then place the header back
in the header (or group header) section of the table. If for example
this is a single header in the header section of the table then you can
put the header in the left-most cell then select the adjacent cells in
the header row (by pressing Ctrl-click.) Once all the cells from that
row are selected - right-click the slected cells and select the "Merge
Cells" option. This will merger the cels an that row only - and will
leave the Details section rows intact.
Lastly if this is a stand alone text-object over a table - then right
click the textbox you want to repeat and select Properties. Then select
the Advanced button at the bottom left corner - on the General tab
there should be an option selected called "Repeat report item..." and
beneath it is a drop-down - select the table you wish the object to
repoeat with in each page and you should be in business. If your table
is named Table1 - then select Table1.
Let us know how it turns out.|||I really appreciate everyone's input. Thank you!
Hi. I tried the 2nd suggestion where I selected my stand alone text-object
that is over my table.
I right clicked the textbox and selected Properties. I then clicked the the
Advanced button at the bottom left corner on the General tab. I then clicked
the "Repeat report item with data region on every page" and selected the
"table 1" Data region in the drop down.
I run the report and it doesn't repeat the header textbox on the subsequent
pages. I believe this is all I need to do. This should repeat the text box
for the data region when it spans multiple pages, correct?
Basically, I want my header text boxes to repeat on each page. Just as if I
placed then in the Group header row in the table. Unfortunately, the header
data is formatted in such a way that the table does not lend itself for this
design.
Thanks again!
Yosh
"papaboom" <smith.jamie@.gmail.com> wrote in message
news:1100731569.214512.82360@.z14g2000cwz.googlegroups.com...
> Techinically - Yoshi - you are not confined to keeping your header
> outside the table. If this is the problem - then place the header back
> in the header (or group header) section of the table. If for example
> this is a single header in the header section of the table then you can
> put the header in the left-most cell then select the adjacent cells in
> the header row (by pressing Ctrl-click.) Once all the cells from that
> row are selected - right-click the slected cells and select the "Merge
> Cells" option. This will merger the cels an that row only - and will
> leave the Details section rows intact.
> Lastly if this is a stand alone text-object over a table - then right
> click the textbox you want to repeat and select Properties. Then select
> the Advanced button at the bottom left corner - on the General tab
> there should be an option selected called "Repeat report item..." and
> beneath it is a drop-down - select the table you wish the object to
> repoeat with in each page and you should be in business. If your table
> is named Table1 - then select Table1.
> Let us know how it turns out.
>|||The textbox will only repeat each time the table repeats - so if it's
one table spanning multiple pages then you may be SOL with option 2.
How is the header formatted in such a way that it cannot be displayed
in a table header? Unfortunately I think you are going to have to put
that header in the table if you want to see it repeat across multiple
pages - if option 2 didnt work.|||It seems that if the table itself repeats then the text box will repeat
- but since it is a single table spanning mulitple pages that it will
not repeat. What is special about the header that it can't be placed in
the table itself? Because it seems at this point that you will have to
go with option A (header in the table) if you want this to work.|||Option 2 was a great suggestion but your right, it's not working because of
what you said.
Option 1 will have to do. I will need to change the format of the header so
that it works and looks nice. I hope the client says it's ok.
Thank you for being so patient and persistant with my questions/posts. I
really appreciate it!
Take care,
Yosh
"papaboom" <smith.jamie@.gmail.com> wrote in message
news:1100733672.095005.163320@.z14g2000cwz.googlegroups.com...
> The textbox will only repeat each time the table repeats - so if it's
> one table spanning multiple pages then you may be SOL with option 2.
> How is the header formatted in such a way that it cannot be displayed
> in a table header? Unfortunately I think you are going to have to put
> that header in the table if you want to see it repeat across multiple
> pages - if option 2 didnt work.
>|||I believe part of the problem is the original "report" was done in Excel. I
come from the Crystal Report side of development where I could put data
fields pretty much anywhere using "free-form" placement.
I am not used to inserting column after column and merging cells to get a
very wide data field to look right in a table? That make sense?
Learning curve I guess. =0}
"papaboom" <smith.jamie@.gmail.com> wrote in message
news:1100734006.823128.176120@.z14g2000cwz.googlegroups.com...
> It seems that if the table itself repeats then the text box will repeat
> - but since it is a single table spanning mulitple pages that it will
> not repeat. What is special about the header that it can't be placed in
> the table itself? Because it seems at this point that you will have to
> go with option A (header in the table) if you want this to work.
>|||Absolutely - I come from Crystal Reports side also. I have just started
with this Reporting Services stuff about a month ago. The learning
curve can be steep here. All I can say is get ready for some more pain.
This table header business you will find to be the least of your
problems.|||Hey... Thanks Papaboom! =0}
Reporting Services makes me appreciate Crystal alot more. However, I do see
how powerful Reporting Services can become. I am very excited about the ease
of use.
Maybe you can answer this question. I have a page footer that has 1 textbox
with today's date. When I export the report, the page footer is left out.
It's not exported.
I don't know why this is happening.
Thanks so much!
Y
"papaboom" <smith.jamie@.gmail.com> wrote in message
news:1100795491.349175.78160@.f14g2000cwb.googlegroups.com...
> Absolutely - I come from Crystal Reports side also. I have just started
> with this Reporting Services stuff about a month ago. The learning
> curve can be steep here. All I can say is get ready for some more pain.
> This table header business you will find to be the least of your
> problems.
>|||Sorry Yosh - on this one I havent the slightest. The most I've done
with exporting is export a couple of reports to PDF.

Report Builder Query Timeout?

Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.

My ultimate goal is to be able to limit ad-hoc report users running Report Builder from waisting resources on my SQL instance. This has nothing to do with a report being published to a report server and setting a reports execution time limit.

Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.

This feature is under consideration for the next release.

|||

I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:

An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]

This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?

Any information would be great!

|||

I am getting the same error message.

"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

How can I resolve this timeout issue?

|||"You can specify a query timeout in Report Designer"

How?
|||

I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?

Report Builder Query Timeout?

Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.

My ultimate goal is to be able to limit ad-hoc report users running Report Builder from waisting resources on my SQL instance. This has nothing to do with a report being published to a report server and setting a reports execution time limit.

Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.

This feature is under consideration for the next release.

|||

I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:

An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]

This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?

Any information would be great!

|||

I am getting the same error message.

"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

How can I resolve this timeout issue?

|||"You can specify a query timeout in Report Designer"

How?
|||I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?

Report Builder Query Timeout?

Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.

My ultimate goal is to be able to limit ad-hoc report users running Report Builder from waisting resources on my SQL instance. This has nothing to do with a report being published to a report server and setting a reports execution time limit.

Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.

This feature is under consideration for the next release.

|||

I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:

An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]

This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?

Any information would be great!

|||

I am getting the same error message.

"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

How can I resolve this timeout issue?

|||"You can specify a query timeout in Report Designer"

How?
|||

I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?

Report Builder Query Timeout?

Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.

My ultimate goal is to be able to limit ad-hoc report users running Report Builder from waisting resources on my SQL instance. This has nothing to do with a report being published to a report server and setting a reports execution time limit.

Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.

This feature is under consideration for the next release.

|||

I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:

An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]

This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?

Any information would be great!

|||

I am getting the same error message.

"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

How can I resolve this timeout issue?

|||"You can specify a query timeout in Report Designer"

How?
|||

I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?

Report Builder Query Timeout?

Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.

My ultimate goal is to be able to limit ad-hoc report users running Report Builder from waisting resources on my SQL instance. This has nothing to do with a report being published to a report server and setting a reports execution time limit.

Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.

This feature is under consideration for the next release.

|||

I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:

An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]

This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?

Any information would be great!

|||

I am getting the same error message.

"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

How can I resolve this timeout issue?

|||"You can specify a query timeout in Report Designer"

How?
|||

I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?sql

Report builder - open error - (401) Unauthorized.

Hi,
Does anyone have similar error for Report Builder? It seems odd for the
messages. I don't know what is going wrong after the installation.
Many thanks.
Kenny
kenny_tm_cheng@.hotmail.com
=============
PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
SOURCES
Deployment url :
http://sql2005client/ReportServer/ReportBuilder/ReportBuilder.application
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later
in the log.
* Activation of
http://sql2005client/ReportServer/ReportBuilder/ReportBuilder.application
resulted in exception. Following failure messages were detected:
+ Downloading
http://sql2005client/ReportServer/ReportBuilder/ReportBuilder.application did
not succeed.
+ The remote server returned an error: (401) Unauthorized.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [08/02/2006 15:19:48] : Activation of
http://sql2005client/ReportServer/ReportBuilder/ReportBuilder.application has
started.
ERROR DETAILS
Following errors were detected during this operation.
* [08/02/2006 15:19:57]
System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading
http://sql2005client/ReportServer/ReportBuilder/ReportBuilder.application did
not succeed.
- Source: System.Deployment
- Stack trace:
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at
System.Deployment.Application.FileDownloader.Download(SubscriptionState
subState)
at
System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri&
sourceUri, String targetPath, IDownloadNotification notification,
DownloadOptions options, ServerInformation& serverInformation)
at
System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore
subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState,
IDownloadNotification notification, DownloadOptions options,
ServerInformation& serverInformation)
at
System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore
subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState,
IDownloadNotification notification, DownloadOptions options)
at
System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at
System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
-- Inner Exception --
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.I am getting a very similar error:
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed
later in the log.
* Activation of
http://rgv-bos-bl2/ReportServer/ReportBuilder/ReportBuilder.application
resulted in exception. Following failure messages were detected:
+ Downloading
http://rgv-bos-bl2/ReportServer/ReportBuilder/ReportBuilder.application
did not succeed.
+ The remote server returned an error: (401) Unauthorized.
+ The target principal name is incorrect
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
In my case it looks like a security related issue. I gave my account
all possible rights on the report server but no luck.
Radu|||HI, Radu.
Yes, I searched the KB for support but no luck.
I use the standalone server but no active directory.. not sure it relates to
security rights.
One throught may be related to the ASP.NET app pool is running under
NetworkService? it may not have access right to run Report Builder for the
users?
kenny|||I'm not sure if this will work for you but I managed to get report builder to
work on my servers, both development and production. I changed so many
things that I cannot say for certain this is what has to be done, but I
thought it might give you a direction.
The error indicates that it is a permission problem even though everything
seems to be set properly, right? In my scenario I've got Anonymous access
disabled and basic authentication configured, Integrated Windows
authentication is deselected. All of these settings are the same on the
report server, report manager, and report builder virtual directories and
even the files underneath each directory.
Here's what I did, I opened c:\program files\Microsoft SQL
Server\MSSQL.2\Reporting Services\Report Server\web.config
I edited the web.config file to reflect forms authentication instead of
Windows and told it not to impersonate
<authentication mode="Forms" />
<identity impersonate="false" />
I saved the file and opened https://www.server.com/reports - it of course
errored because the server is not configured for forms authentication. I
then reset the Web.Config file back to the original configuration
<authentication mode="Windows" />
<identity impersonate="true" />
Save the Web.config file
Open IIS and navigate to Web Sites | Default Web Site | ReportServer |
ReportBuilder
Right click ReportBuilder.application
Click Properties
Click File Security
Click Edit under Authentication and Access Control
Select Integrated Windows Authentication
Leave the Basic Authentication option selected as well if already selected.
Click OK
Repeat the above steps for ReportBuilder.exe and ReportBuilder.exe.manifest
From a workstation, not the server console
Browse to https://www.server.com/reports log in click Report Server
Click Report Builder and login again.
Report Builder opens
If you want you can then go back and remove the Integrated Windows
Authentication on ReportBuilder.exe.manifest and Reportbuilder.exe. Do not
change Reportbuilder.application or reportbuilder will not work.
I'm not sure what security holes I may have opened, but at least its working
for now.
Let me know if this works for you.
"Kenny Cheng" wrote:
> HI, Radu.
> Yes, I searched the KB for support but no luck.
> I use the standalone server but no active directory.. not sure it relates to
> security rights.
> One throught may be related to the ASP.NET app pool is running under
> NetworkService? it may not have access right to run Report Builder for the
> users?
> kenny