Showing posts with label provided. Show all posts
Showing posts with label provided. Show all posts

Wednesday, March 28, 2012

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.

Tuesday, March 20, 2012

Report Builder not appearing in Report Server 2005 Web page

I have provided required permissions, still user not able to view report builder option in his console.

what could be wrong? what needs to be done to provide report builder to users.

Deleep P

Please review the link below and let us know if this fixes your issue.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1697246&SiteID=1

|||

Thanks for that hint. I have an issue now regarding rights of system users. Now they have delete rights from Root directory. What needs to be done to avert this. I want system user be able to only modify his folders and contents.

Deleep P

|||

Double-click on My Computer, right-click on the root-drive in question and select properties and then select the security tab. Highlight the Users group [ ex: Users(Servername\Users) ] ensure that only the Special Permission box has a checkmark in it. Then click on the Advanced button and this will bring you to the permission tab where you can specify the rights you wish your users to have on the root drive.

|||

I think i misled you, after opening the webpage as follows "http://<report_server _ip>/reports " I get "HOME' page. Here i am creating folders. My intention is to create separate directories in the name of different teams first. Then provide complete access to the team within their folder. One team should not delete the folder created for another team from the home page. currently for all report server users i have given "System user" access through site SITE SETTING IN THE HOME PAGE. After clicking on the SITE SETTINGS I selected configure site wide security and provided "system user" rights to all report server users. Plus all users will have "folder view" rights on the HOME folder. this is provided through HOME PAGE, PROPERTIES, SECURITY, NEW ROLE ASSIGNMENT.

Report Builder not appearing in Report Server 2005 Web page

I have provided required permissions, still user not able to view report builder option in his console.

what could be wrong? what needs to be done to provide report builder to users.

Deleep P

Please review the link below and let us know if this fixes your issue.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1697246&SiteID=1

|||

Thanks for that hint. I have an issue now regarding rights of system users. Now they have delete rights from Root directory. What needs to be done to avert this. I want system user be able to only modify his folders and contents.

Deleep P

|||

Double-click on My Computer, right-click on the root-drive in question and select properties and then select the security tab. Highlight the Users group [ ex: Users(Servername\Users) ] ensure that only the Special Permission box has a checkmark in it. Then click on the Advanced button and this will bring you to the permission tab where you can specify the rights you wish your users to have on the root drive.

|||

I think i misled you, after opening the webpage as follows "http://<report_server _ip>/reports " I get "HOME' page. Here i am creating folders. My intention is to create separate directories in the name of different teams first. Then provide complete access to the team within their folder. One team should not delete the folder created for another team from the home page. currently for all report server users i have given "System user" access through site SITE SETTING IN THE HOME PAGE. After clicking on the SITE SETTINGS I selected configure site wide security and provided "system user" rights to all report server users. Plus all users will have "folder view" rights on the HOME folder. this is provided through HOME PAGE, PROPERTIES, SECURITY, NEW ROLE ASSIGNMENT.

Tuesday, February 21, 2012

Replication/mirroring on tables without a primary key

One of my clients is using an SQL Server 2000 database provided by a
third party. I attempted to setup transactional replication, but this
failed as a number of their tables do not have primary keys.
What they are really after is simply a mirrored database for reporting
purposes. So far, my position is that this cannot be done unless:-
(1) The vendor adds primary keys to the database
(2) The vendor upgrades to 2005 (and then I can use mirroring)
Notes:
A. I have discounted using snapshot replication due to the dynamic
nature of some of the tables that don't have a primary key
B. Although I can change the database schema myself to set the primary
keys, I do not want to do this as the vendor wont support the app, it
is risky and would involve a lot of work.
Are there any other solutions to this? eg third party products?
You could use log shipping in standby mode for this if you can control when
the reports are accessed. The main problem is that the restore of the logs
will drop all user connections, but in some cases this can be manageable.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Thanks Paul
I discounted log shipping as the interface is via the web and we
cant/dont want to drop user connections.
On Jan 24, 11:14 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> You could use log shipping in standby mode for this if you can control when
> the reports are accessed. The main problem is that the restore of the logs
> will drop all user connections, but in some cases this can be manageable.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.
|||In that case I'd upgrade to SQL Server 2005 and use mirroring/database
snapshots. Can't see another option as the requirements are incompatible
with current options
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||You mention manageable regarding the user connections, I see a couple
of options here:
(1) More frequent logs (eg 15 mins). This would minimise the risk of
getting disconnected as applying the transactions would be very quick
AND/OR (2) Build a level of fault tolerance into the s/w so that if
they get the message regarding disconnected because of the transaction
log being applied, the s/w retries.
Is this the sort of thing you were meaning?
On Jan 25, 5:22 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> In that case I'd upgrade to SQL Server 2005 and use mirroring/database
> snapshots. Can't see another option as the requirements are incompatible
> with current options
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.
|||I was really thinking of latency. If you can allow say a day's latency, you
could ship the logs each evening during the out of hours time and this way
keep things going.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Thanks so much for your feedback Paul, I really appreciate it.
Unfortunately, the day's latency is unacceptable by the client. I did
try that initially but with no luck. They need data to be no more than
30mins late.
So given that log-shipping is the only possible alternative for SQL
Server 2000, I need to give the developers/query writers some guidance
on how they need to develop in this regime. So far, what I have been
thinking was:
(1) When developing SQL queries don't develop using the server that
uses log shipping as you will frequently lose your connection.
(2) In the application, do not keep keep connections open
unnecessarily. Open the connection,. perform the query and close the
connection as quick as possible. I am assuming 'pooled connections'
are still the best way to go.
(3) Try and build in fault tolerance into the application, ie if you
cannot open a connection, then retry within a set period. Also, if you
get an error when executing your query, close the connection (if you
can) and retry. Finally, if you cant close the connection, then just
ignore.
(4) Keep your queries short and snappy and avoid cursors.
Is there any white paper or guidance from Microsoft on this issue or
anyone with practical experience in running an app against a database
that uses 'log shipping'?
On Jan 25, 7:11 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> I was really thinking of latency. If you can allow say a day's latency, you
> could ship the logs each evening during the out of hours time and this way
> keep things going.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.
|||You could set the rowguid column that is used by replication as the
primary key - just don't make it clustered.
PromisedOyster wrote:
> One of my clients is using an SQL Server 2000 database provided by a
> third party. I attempted to setup transactional replication, but this
> failed as a number of their tables do not have primary keys.
> What they are really after is simply a mirrored database for reporting
> purposes. So far, my position is that this cannot be done unless:-
> (1) The vendor adds primary keys to the database
> (2) The vendor upgrades to 2005 (and then I can use mirroring)
> Notes:
> A. I have discounted using snapshot replication due to the dynamic
> nature of some of the tables that don't have a primary key
> B. Although I can change the database schema myself to set the primary
> keys, I do not want to do this as the vendor wont support the app, it
> is risky and would involve a lot of work.
> Are there any other solutions to this? eg third party products?
>
|||You could set the rowguid column that is used by replication as the
primary key - just don't make it clustered.
PromisedOyster wrote:
> One of my clients is using an SQL Server 2000 database provided by a
> third party. I attempted to setup transactional replication, but this
> failed as a number of their tables do not have primary keys.
> What they are really after is simply a mirrored database for reporting
> purposes. So far, my position is that this cannot be done unless:-
> (1) The vendor adds primary keys to the database
> (2) The vendor upgrades to 2005 (and then I can use mirroring)
> Notes:
> A. I have discounted using snapshot replication due to the dynamic
> nature of some of the tables that don't have a primary key
> B. Although I can change the database schema myself to set the primary
> keys, I do not want to do this as the vendor wont support the app, it
> is risky and would involve a lot of work.
> Are there any other solutions to this? eg third party products?
>
|||You could set the rowguid column that is used by replication as the
primary key - just don't make it clustered.
PromisedOyster wrote:
> One of my clients is using an SQL Server 2000 database provided by a
> third party. I attempted to setup transactional replication, but this
> failed as a number of their tables do not have primary keys.
> What they are really after is simply a mirrored database for reporting
> purposes. So far, my position is that this cannot be done unless:-
> (1) The vendor adds primary keys to the database
> (2) The vendor upgrades to 2005 (and then I can use mirroring)
> Notes:
> A. I have discounted using snapshot replication due to the dynamic
> nature of some of the tables that don't have a primary key
> B. Although I can change the database schema myself to set the primary
> keys, I do not want to do this as the vendor wont support the app, it
> is risky and would involve a lot of work.
> Are there any other solutions to this? eg third party products?
>