I have a report that we give to our Doctors to fill out that has patient
information on it. One of the things we are supposed to have on the report
is a checkbox for symptoms found. I would like it if I could get a check box
to align with its associated text. If you have over 3 rows of this on your
report they all start to get out of alignment. The more rows you have the
more out of whack it becomes, until it looks like the texbox has no
association with its associated check box.
This is very frustrating. I just spent about four hours tweaking a report
to get them to look okay but yet they still are not aligned exactly as they
should be.
To create the check box I am using the wingdings font lower case 'o'
character. Of course I cannot put the wingdings font in the same text box as
the symptoms textbox as then the symptoms would be gibberish.
Any thoughts on how to make this process easier, more accurate? I am using
a listbox as my container.
--
Thank you,
Johnone thing I liked about crystal reports is you can change formatting of
individual characters in a text box... cant do this in reporting server
unfortinuatly...
"John A" <i-code4food@.newsgroups.nospam> wrote in message
news:D8DC91FB-52E7-41B4-8C83-6A8F03EF98E5@.microsoft.com...
>I have a report that we give to our Doctors to fill out that has patient
> information on it. One of the things we are supposed to have on the
> report
> is a checkbox for symptoms found. I would like it if I could get a check
> box
> to align with its associated text. If you have over 3 rows of this on
> your
> report they all start to get out of alignment. The more rows you have the
> more out of whack it becomes, until it looks like the texbox has no
> association with its associated check box.
> This is very frustrating. I just spent about four hours tweaking a report
> to get them to look okay but yet they still are not aligned exactly as
> they
> should be.
> To create the check box I am using the wingdings font lower case 'o'
> character. Of course I cannot put the wingdings font in the same text box
> as
> the symptoms textbox as then the symptoms would be gibberish.
> Any thoughts on how to make this process easier, more accurate? I am
> using
> a listbox as my container.
> --
> Thank you,
> John|||John,
Do you have to use a listbox as your container?
If you use a two column table with your check boxes in the first
column and your symptoms in the second, they should stay lined up.
Otherwise maybe use open and closed brackets or parens (e.g. [ ] or
{ } or ( ) ) as your "checkbox" inside the symptom's text boxes.
Good luck and happy reporting!!
Thursday, March 29, 2012
Aligning 2 charts
I have a report with 2 charts as subreports. The X axis is time and
the charts show different data over the same time period.
I would like to position the charts so that corresponding X axis
values are aligned vertically. This seems to work if the Y axis scales
are the same ie. the labels are the same length, but if the scales are
different the charts don't quite align. The chart types might also be
causing problems i.e. Area vs. Line - it looks like they may be drawn
with different margins as well as different values on the Y scale.
Essentially, I need to get the left hand edges of the charts to line
up.
Is there a way to align these charts the way I want?
--
Andrew RowleyOn Aug 21, 8:50 pm, Andrew Rowley <aj...@.newsgroup.nospam> wrote:
> I have a report with 2 charts as subreports. The X axis is time and
> the charts show different data over the same time period.
> I would like to position the charts so that corresponding X axis
> values are aligned vertically. This seems to work if the Y axis scales
> are the same ie. the labels are the same length, but if the scales are
> different the charts don't quite align. The chart types might also be
> causing problems i.e. Area vs. Line - it looks like they may be drawn
> with different margins as well as different values on the Y scale.
> Essentially, I need to get the left hand edges of the charts to line
> up.
> Is there a way to align these charts the way I want?
> --
> Andrew Rowley
I'm not sure if this will help, but you might try putting the 2 charts
in the same subreport or in the main report and/or inside a rectangle
control. Normally, subreports are a little difficult to align. Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||You could also try setting the scale (interval) of the y axis yourself.
"EMartinez" wrote:
> On Aug 21, 8:50 pm, Andrew Rowley <aj...@.newsgroup.nospam> wrote:
> > I have a report with 2 charts as subreports. The X axis is time and
> > the charts show different data over the same time period.
> >
> > I would like to position the charts so that corresponding X axis
> > values are aligned vertically. This seems to work if the Y axis scales
> > are the same ie. the labels are the same length, but if the scales are
> > different the charts don't quite align. The chart types might also be
> > causing problems i.e. Area vs. Line - it looks like they may be drawn
> > with different margins as well as different values on the Y scale.
> >
> > Essentially, I need to get the left hand edges of the charts to line
> > up.
> >
> > Is there a way to align these charts the way I want?
> > --
> > Andrew Rowley
>
> I'm not sure if this will help, but you might try putting the 2 charts
> in the same subreport or in the main report and/or inside a rectangle
> control. Normally, subreports are a little difficult to align. Hope
> this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||David <David@.discussions.microsoft.com> wrote:
>You could also try setting the scale (interval) of the y axis yourself.
The problem is the scales need to be different, e.g. one is 0-100 and
the other is 0-5.
--
Andrew Rowley|||Hello Andrew,
You need to get the same font size for your X Axis label of both Charts.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
the charts show different data over the same time period.
I would like to position the charts so that corresponding X axis
values are aligned vertically. This seems to work if the Y axis scales
are the same ie. the labels are the same length, but if the scales are
different the charts don't quite align. The chart types might also be
causing problems i.e. Area vs. Line - it looks like they may be drawn
with different margins as well as different values on the Y scale.
Essentially, I need to get the left hand edges of the charts to line
up.
Is there a way to align these charts the way I want?
--
Andrew RowleyOn Aug 21, 8:50 pm, Andrew Rowley <aj...@.newsgroup.nospam> wrote:
> I have a report with 2 charts as subreports. The X axis is time and
> the charts show different data over the same time period.
> I would like to position the charts so that corresponding X axis
> values are aligned vertically. This seems to work if the Y axis scales
> are the same ie. the labels are the same length, but if the scales are
> different the charts don't quite align. The chart types might also be
> causing problems i.e. Area vs. Line - it looks like they may be drawn
> with different margins as well as different values on the Y scale.
> Essentially, I need to get the left hand edges of the charts to line
> up.
> Is there a way to align these charts the way I want?
> --
> Andrew Rowley
I'm not sure if this will help, but you might try putting the 2 charts
in the same subreport or in the main report and/or inside a rectangle
control. Normally, subreports are a little difficult to align. Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||You could also try setting the scale (interval) of the y axis yourself.
"EMartinez" wrote:
> On Aug 21, 8:50 pm, Andrew Rowley <aj...@.newsgroup.nospam> wrote:
> > I have a report with 2 charts as subreports. The X axis is time and
> > the charts show different data over the same time period.
> >
> > I would like to position the charts so that corresponding X axis
> > values are aligned vertically. This seems to work if the Y axis scales
> > are the same ie. the labels are the same length, but if the scales are
> > different the charts don't quite align. The chart types might also be
> > causing problems i.e. Area vs. Line - it looks like they may be drawn
> > with different margins as well as different values on the Y scale.
> >
> > Essentially, I need to get the left hand edges of the charts to line
> > up.
> >
> > Is there a way to align these charts the way I want?
> > --
> > Andrew Rowley
>
> I'm not sure if this will help, but you might try putting the 2 charts
> in the same subreport or in the main report and/or inside a rectangle
> control. Normally, subreports are a little difficult to align. Hope
> this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||David <David@.discussions.microsoft.com> wrote:
>You could also try setting the scale (interval) of the y axis yourself.
The problem is the scales need to be different, e.g. one is 0-100 and
the other is 0-5.
--
Andrew Rowley|||Hello Andrew,
You need to get the same font size for your X Axis label of both Charts.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
alignement data
My application has production server and backup sever for data reporting .
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
StperAre you talking about transforming data? Have you explored DTS? See SQL
Server Books Online for more information.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"stefano perab" <stefano.perabo@.speedautomazione.it> wrote in message
news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
My application has production server and backup sever for data reporting .
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
Stper|||Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perab" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
.
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>|||In that case, I'd strongly recommend transactional replication. It is meant
to satisfy reporting requirements.
Log shipping is ideal for maintaining standby servers, but not really for
reporting purposes.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perab" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
.
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>|||Thanks Hari, i think the Transactional Replication is the solution for my
problem. Now i must study the configuration
I found this an article in
www.awprofessional.com/articles/article.asp?p=170234
Do you have some suggestion for examples and/or configuration
Thanks
Stper
"Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
> Hi Vyas,
> It seems Stper need to syncronize the report server with production server
> online.
> Stper,
> If above is the case you can go for either of the below approach
> 1. Transactional Replication
> 2. Log Shipping
> This method will sync. the Report server database with report server.
> Thanks
> Hari
> MCDBA
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
reporting[vbcol=seagreen]
> .
at[vbcol=seagreen]
>|||stper,
Books Online is a very valuable reference.
http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
to replication. There is a book coming soon on Snapshot and
Transactional replication from Hilary Cotter which is excellent, see the
link in my sig.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
stper wrote:
> Thanks Hari, i think the Transactional Replication is the solution for my
> problem. Now i must study the configuration
> I found this an article in
> www.awprofessional.com/articles/article.asp?p=170234
> Do you have some suggestion for examples and/or configuration
> Thanks
> Stper
> "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
>
> reporting
>
> at
>
>|||i made the configuration and now i testing my first "PULL SUbscription".
Unfortunately i have my first error message : "Unexpected EOF encountered in
BCP data-file" when i run with alignement.
Do yuo have some suggestion ?
stper
"Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> stper,
> Books Online is a very valuable reference.
> http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
> to replication. There is a book coming soon on Snapshot and
> Transactional replication from Hilary Cotter which is excellent, see the
> link in my sig.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> stper wrote:
my[vbcol=seagreen]
server[vbcol=seagreen]|||After testing and testying i can say (like Pitagora) : EUREKA !!!
now i must tuning the task but the functionality work very well.
Thanks
Stper
"stper" <stefano.perabo@.speedautomazione.it> ha scritto nel messaggio
news:eZICqZzbEHA.596@.TK2MSFTNGP11.phx.gbl...
> i made the configuration and now i testing my first "PULL SUbscription".
> Unfortunately i have my first error message : "Unexpected EOF encountered
in
> BCP data-file" when i run with alignement.
> Do yuo have some suggestion ?
> stper
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
> news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...
> my
> server
SQL[vbcol=seagreen]
message[vbcol=seagreen]
data[vbcol=seagreen]
>
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
StperAre you talking about transforming data? Have you explored DTS? See SQL
Server Books Online for more information.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"stefano perab" <stefano.perabo@.speedautomazione.it> wrote in message
news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
My application has production server and backup sever for data reporting .
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
Stper|||Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perab" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
.
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>|||In that case, I'd strongly recommend transactional replication. It is meant
to satisfy reporting requirements.
Log shipping is ideal for maintaining standby servers, but not really for
reporting purposes.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perab" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
.
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>|||Thanks Hari, i think the Transactional Replication is the solution for my
problem. Now i must study the configuration
I found this an article in
www.awprofessional.com/articles/article.asp?p=170234
Do you have some suggestion for examples and/or configuration
Thanks
Stper
"Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
> Hi Vyas,
> It seems Stper need to syncronize the report server with production server
> online.
> Stper,
> If above is the case you can go for either of the below approach
> 1. Transactional Replication
> 2. Log Shipping
> This method will sync. the Report server database with report server.
> Thanks
> Hari
> MCDBA
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
reporting[vbcol=seagreen]
> .
at[vbcol=seagreen]
>|||stper,
Books Online is a very valuable reference.
http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
to replication. There is a book coming soon on Snapshot and
Transactional replication from Hilary Cotter which is excellent, see the
link in my sig.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
stper wrote:
> Thanks Hari, i think the Transactional Replication is the solution for my
> problem. Now i must study the configuration
> I found this an article in
> www.awprofessional.com/articles/article.asp?p=170234
> Do you have some suggestion for examples and/or configuration
> Thanks
> Stper
> "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
>
> reporting
>
> at
>
>|||i made the configuration and now i testing my first "PULL SUbscription".
Unfortunately i have my first error message : "Unexpected EOF encountered in
BCP data-file" when i run with alignement.
Do yuo have some suggestion ?
stper
"Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> stper,
> Books Online is a very valuable reference.
> http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
> to replication. There is a book coming soon on Snapshot and
> Transactional replication from Hilary Cotter which is excellent, see the
> link in my sig.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> stper wrote:
my[vbcol=seagreen]
server[vbcol=seagreen]|||After testing and testying i can say (like Pitagora) : EUREKA !!!
now i must tuning the task but the functionality work very well.
Thanks
Stper
"stper" <stefano.perabo@.speedautomazione.it> ha scritto nel messaggio
news:eZICqZzbEHA.596@.TK2MSFTNGP11.phx.gbl...
> i made the configuration and now i testing my first "PULL SUbscription".
> Unfortunately i have my first error message : "Unexpected EOF encountered
in
> BCP data-file" when i run with alignement.
> Do yuo have some suggestion ?
> stper
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
> news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...
> my
> server
SQL[vbcol=seagreen]
message[vbcol=seagreen]
data[vbcol=seagreen]
>
alignement data
My application has production server and backup sever for data reporting .
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
Stper
Are you talking about transforming data? Have you explored DTS? See SQL
Server Books Online for more information.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"stefano perab" <stefano.perabo@.speedautomazione.it> wrote in message
news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
My application has production server and backup sever for data reporting .
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
Stper
|||Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perab" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
..
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>
|||In that case, I'd strongly recommend transactional replication. It is meant
to satisfy reporting requirements.
Log shipping is ideal for maintaining standby servers, but not really for
reporting purposes.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perab" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
..
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>
|||Thanks Hari, i think the Transactional Replication is the solution for my
problem. Now i must study the configuration
I found this an article in
http://www.awprofessional.com/articl...e.asp?p=170234
Do you have some suggestion for examples and/or configuration
Thanks
Stper
"Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Hi Vyas,
> It seems Stper need to syncronize the report server with production server
> online.
> Stper,
> If above is the case you can go for either of the below approach
> 1. Transactional Replication
> 2. Log Shipping
> This method will sync. the Report server database with report server.
> Thanks
> Hari
> MCDBA
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
reporting[vbcol=seagreen]
> .
at
>
|||stper,
Books Online is a very valuable reference.
http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
to replication. There is a book coming soon on Snapshot and
Transactional replication from Hilary Cotter which is excellent, see the
link in my sig.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
stper wrote:
> Thanks Hari, i think the Transactional Replication is the solution for my
> problem. Now i must study the configuration
> I found this an article in
> http://www.awprofessional.com/articl...e.asp?p=170234
> Do you have some suggestion for examples and/or configuration
> Thanks
> Stper
> "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
>
> reporting
>
> at
>
>
|||i made the configuration and now i testing my first "PULL SUbscription".
Unfortunately i have my first error message : "Unexpected EOF encountered in
BCP data-file" when i run with alignement.
Do yuo have some suggestion ?
stper
"Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> stper,
> Books Online is a very valuable reference.
> http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
> to replication. There is a book coming soon on Snapshot and
> Transactional replication from Hilary Cotter which is excellent, see the
> link in my sig.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> stper wrote:
my[vbcol=seagreen]
server[vbcol=seagreen]
|||After testing and testying i can say (like Pitagora) : EUREKA !!!
now i must tuning the task but the functionality work very well.
Thanks
Stper
"stper" <stefano.perabo@.speedautomazione.it> ha scritto nel messaggio
news:eZICqZzbEHA.596@.TK2MSFTNGP11.phx.gbl...
> i made the configuration and now i testing my first "PULL SUbscription".
> Unfortunately i have my first error message : "Unexpected EOF encountered
in[vbcol=seagreen]
> BCP data-file" when i run with alignement.
> Do yuo have some suggestion ?
> stper
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
> news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...
> my
> server
SQL[vbcol=seagreen]
message[vbcol=seagreen]
data
>
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
Stper
Are you talking about transforming data? Have you explored DTS? See SQL
Server Books Online for more information.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"stefano perab" <stefano.perabo@.speedautomazione.it> wrote in message
news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
My application has production server and backup sever for data reporting .
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
Stper
|||Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perab" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
..
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>
|||In that case, I'd strongly recommend transactional replication. It is meant
to satisfy reporting requirements.
Log shipping is ideal for maintaining standby servers, but not really for
reporting purposes.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perab" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
..
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>
|||Thanks Hari, i think the Transactional Replication is the solution for my
problem. Now i must study the configuration
I found this an article in
http://www.awprofessional.com/articl...e.asp?p=170234
Do you have some suggestion for examples and/or configuration
Thanks
Stper
"Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Hi Vyas,
> It seems Stper need to syncronize the report server with production server
> online.
> Stper,
> If above is the case you can go for either of the below approach
> 1. Transactional Replication
> 2. Log Shipping
> This method will sync. the Report server database with report server.
> Thanks
> Hari
> MCDBA
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
reporting[vbcol=seagreen]
> .
at
>
|||stper,
Books Online is a very valuable reference.
http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
to replication. There is a book coming soon on Snapshot and
Transactional replication from Hilary Cotter which is excellent, see the
link in my sig.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
stper wrote:
> Thanks Hari, i think the Transactional Replication is the solution for my
> problem. Now i must study the configuration
> I found this an article in
> http://www.awprofessional.com/articl...e.asp?p=170234
> Do you have some suggestion for examples and/or configuration
> Thanks
> Stper
> "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
>
> reporting
>
> at
>
>
|||i made the configuration and now i testing my first "PULL SUbscription".
Unfortunately i have my first error message : "Unexpected EOF encountered in
BCP data-file" when i run with alignement.
Do yuo have some suggestion ?
stper
"Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> stper,
> Books Online is a very valuable reference.
> http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
> to replication. There is a book coming soon on Snapshot and
> Transactional replication from Hilary Cotter which is excellent, see the
> link in my sig.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> stper wrote:
my[vbcol=seagreen]
server[vbcol=seagreen]
|||After testing and testying i can say (like Pitagora) : EUREKA !!!
now i must tuning the task but the functionality work very well.
Thanks
Stper
"stper" <stefano.perabo@.speedautomazione.it> ha scritto nel messaggio
news:eZICqZzbEHA.596@.TK2MSFTNGP11.phx.gbl...
> i made the configuration and now i testing my first "PULL SUbscription".
> Unfortunately i have my first error message : "Unexpected EOF encountered
in[vbcol=seagreen]
> BCP data-file" when i run with alignement.
> Do yuo have some suggestion ?
> stper
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
> news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...
> my
> server
SQL[vbcol=seagreen]
message[vbcol=seagreen]
data
>
alignement data
My application has production server and backup sever for data reporting .
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
StperAre you talking about transforming data? Have you explored DTS? See SQL
Server Books Online for more information.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
My application has production server and backup sever for data reporting .
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
Stper|||Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
.
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>|||In that case, I'd strongly recommend transactional replication. It is meant
to satisfy reporting requirements.
Log shipping is ideal for maintaining standby servers, but not really for
reporting purposes.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
.
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>|||Thanks Hari, i think the Transactional Replication is the solution for my
problem. Now i must study the configuration
I found this an article in
www.awprofessional.com/articles/article.asp?p=170234
Do you have some suggestion for examples and/or configuration
Thanks
Stper
"Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
> Hi Vyas,
> It seems Stper need to syncronize the report server with production server
> online.
> Stper,
> If above is the case you can go for either of the below approach
> 1. Transactional Replication
> 2. Log Shipping
> This method will sync. the Report server database with report server.
> Thanks
> Hari
> MCDBA
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> > Are you talking about transforming data? Have you explored DTS? See SQL
> > Server Books Online for more information.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> >
> >
> > "stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> > news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> > My application has production server and backup sever for data
reporting
> .
> > There is some tools in SQL 2K (or third part tool) for alignement data
at
> > run time between two servers?
> > Thanks in advance
> >
> > Stper
> >
> >
> >
>|||stper,
Books Online is a very valuable reference.
http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
to replication. There is a book coming soon on Snapshot and
Transactional replication from Hilary Cotter which is excellent, see the
link in my sig.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
stper wrote:
> Thanks Hari, i think the Transactional Replication is the solution for my
> problem. Now i must study the configuration
> I found this an article in
> www.awprofessional.com/articles/article.asp?p=170234
> Do you have some suggestion for examples and/or configuration
> Thanks
> Stper
> "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
>>Hi Vyas,
>>It seems Stper need to syncronize the report server with production server
>>online.
>>Stper,
>>If above is the case you can go for either of the below approach
>>1. Transactional Replication
>>2. Log Shipping
>>This method will sync. the Report server database with report server.
>>Thanks
>>Hari
>>MCDBA
>>"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
>>news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
>>Are you talking about transforming data? Have you explored DTS? See SQL
>>Server Books Online for more information.
>>--
>>HTH,
>>Vyas, MVP (SQL Server)
>>http://vyaskn.tripod.com/
>>
>>"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
>>news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
>>My application has production server and backup sever for data
> reporting
>>.
>>There is some tools in SQL 2K (or third part tool) for alignement data
> at
>>run time between two servers?
>>Thanks in advance
>>Stper
>>
>>
>|||i made the configuration and now i testing my first "PULL SUbscription".
Unfortunately i have my first error message : "Unexpected EOF encountered in
BCP data-file" when i run with alignement.
Do yuo have some suggestion ?
stper
"Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...
> stper,
> Books Online is a very valuable reference.
> http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
> to replication. There is a book coming soon on Snapshot and
> Transactional replication from Hilary Cotter which is excellent, see the
> link in my sig.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> stper wrote:
> > Thanks Hari, i think the Transactional Replication is the solution for
my
> > problem. Now i must study the configuration
> > I found this an article in
> > www.awprofessional.com/articles/article.asp?p=170234
> > Do you have some suggestion for examples and/or configuration
> >
> > Thanks
> > Stper
> >
> > "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> > news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
> >
> >>Hi Vyas,
> >>
> >>It seems Stper need to syncronize the report server with production
server
> >>online.
> >>
> >>Stper,
> >>
> >>If above is the case you can go for either of the below approach
> >>
> >>1. Transactional Replication
> >>
> >>2. Log Shipping
> >>
> >>This method will sync. the Report server database with report server.
> >>
> >>Thanks
> >>Hari
> >>MCDBA
> >>
> >>"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> >>news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> >>
> >>Are you talking about transforming data? Have you explored DTS? See SQL
> >>Server Books Online for more information.
> >>--
> >>HTH,
> >>Vyas, MVP (SQL Server)
> >>http://vyaskn.tripod.com/
> >>
> >>
> >>"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> >>news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> >>My application has production server and backup sever for data
> >
> > reporting
> >
> >>.
> >>
> >>There is some tools in SQL 2K (or third part tool) for alignement data
> >
> > at
> >
> >>run time between two servers?
> >>Thanks in advance
> >>
> >>Stper
> >>
> >>
> >>
> >>
> >>
> >
> >|||After testing and testying i can say (like Pitagora) : EUREKA !!!
now i must tuning the task but the functionality work very well.
Thanks
Stper
"stper" <stefano.perabo@.speedautomazione.it> ha scritto nel messaggio
news:eZICqZzbEHA.596@.TK2MSFTNGP11.phx.gbl...
> i made the configuration and now i testing my first "PULL SUbscription".
> Unfortunately i have my first error message : "Unexpected EOF encountered
in
> BCP data-file" when i run with alignement.
> Do yuo have some suggestion ?
> stper
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
> news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > stper,
> >
> > Books Online is a very valuable reference.
> > http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
> > to replication. There is a book coming soon on Snapshot and
> > Transactional replication from Hilary Cotter which is excellent, see the
> > link in my sig.
> >
> > --
> > Mark Allison, SQL Server MVP
> > http://www.markallison.co.uk
> >
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> >
> >
> > stper wrote:
> > > Thanks Hari, i think the Transactional Replication is the solution for
> my
> > > problem. Now i must study the configuration
> > > I found this an article in
> > > www.awprofessional.com/articles/article.asp?p=170234
> > > Do you have some suggestion for examples and/or configuration
> > >
> > > Thanks
> > > Stper
> > >
> > > "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> > > news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
> > >
> > >>Hi Vyas,
> > >>
> > >>It seems Stper need to syncronize the report server with production
> server
> > >>online.
> > >>
> > >>Stper,
> > >>
> > >>If above is the case you can go for either of the below approach
> > >>
> > >>1. Transactional Replication
> > >>
> > >>2. Log Shipping
> > >>
> > >>This method will sync. the Report server database with report server.
> > >>
> > >>Thanks
> > >>Hari
> > >>MCDBA
> > >>
> > >>"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > >>news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> > >>
> > >>Are you talking about transforming data? Have you explored DTS? See
SQL
> > >>Server Books Online for more information.
> > >>--
> > >>HTH,
> > >>Vyas, MVP (SQL Server)
> > >>http://vyaskn.tripod.com/
> > >>
> > >>
> > >>"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in
message
> > >>news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> > >>My application has production server and backup sever for data
> > >
> > > reporting
> > >
> > >>.
> > >>
> > >>There is some tools in SQL 2K (or third part tool) for alignement
data
> > >
> > > at
> > >
> > >>run time between two servers?
> > >>Thanks in advance
> > >>
> > >>Stper
> > >>
> > >>
> > >>
> > >>
> > >>
> > >
> > >
>sql
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
StperAre you talking about transforming data? Have you explored DTS? See SQL
Server Books Online for more information.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
My application has production server and backup sever for data reporting .
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
Stper|||Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
.
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>|||In that case, I'd strongly recommend transactional replication. It is meant
to satisfy reporting requirements.
Log shipping is ideal for maintaining standby servers, but not really for
reporting purposes.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
.
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>|||Thanks Hari, i think the Transactional Replication is the solution for my
problem. Now i must study the configuration
I found this an article in
www.awprofessional.com/articles/article.asp?p=170234
Do you have some suggestion for examples and/or configuration
Thanks
Stper
"Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
> Hi Vyas,
> It seems Stper need to syncronize the report server with production server
> online.
> Stper,
> If above is the case you can go for either of the below approach
> 1. Transactional Replication
> 2. Log Shipping
> This method will sync. the Report server database with report server.
> Thanks
> Hari
> MCDBA
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> > Are you talking about transforming data? Have you explored DTS? See SQL
> > Server Books Online for more information.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> >
> >
> > "stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> > news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> > My application has production server and backup sever for data
reporting
> .
> > There is some tools in SQL 2K (or third part tool) for alignement data
at
> > run time between two servers?
> > Thanks in advance
> >
> > Stper
> >
> >
> >
>|||stper,
Books Online is a very valuable reference.
http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
to replication. There is a book coming soon on Snapshot and
Transactional replication from Hilary Cotter which is excellent, see the
link in my sig.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
stper wrote:
> Thanks Hari, i think the Transactional Replication is the solution for my
> problem. Now i must study the configuration
> I found this an article in
> www.awprofessional.com/articles/article.asp?p=170234
> Do you have some suggestion for examples and/or configuration
> Thanks
> Stper
> "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
>>Hi Vyas,
>>It seems Stper need to syncronize the report server with production server
>>online.
>>Stper,
>>If above is the case you can go for either of the below approach
>>1. Transactional Replication
>>2. Log Shipping
>>This method will sync. the Report server database with report server.
>>Thanks
>>Hari
>>MCDBA
>>"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
>>news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
>>Are you talking about transforming data? Have you explored DTS? See SQL
>>Server Books Online for more information.
>>--
>>HTH,
>>Vyas, MVP (SQL Server)
>>http://vyaskn.tripod.com/
>>
>>"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
>>news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
>>My application has production server and backup sever for data
> reporting
>>.
>>There is some tools in SQL 2K (or third part tool) for alignement data
> at
>>run time between two servers?
>>Thanks in advance
>>Stper
>>
>>
>|||i made the configuration and now i testing my first "PULL SUbscription".
Unfortunately i have my first error message : "Unexpected EOF encountered in
BCP data-file" when i run with alignement.
Do yuo have some suggestion ?
stper
"Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...
> stper,
> Books Online is a very valuable reference.
> http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
> to replication. There is a book coming soon on Snapshot and
> Transactional replication from Hilary Cotter which is excellent, see the
> link in my sig.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> stper wrote:
> > Thanks Hari, i think the Transactional Replication is the solution for
my
> > problem. Now i must study the configuration
> > I found this an article in
> > www.awprofessional.com/articles/article.asp?p=170234
> > Do you have some suggestion for examples and/or configuration
> >
> > Thanks
> > Stper
> >
> > "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> > news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
> >
> >>Hi Vyas,
> >>
> >>It seems Stper need to syncronize the report server with production
server
> >>online.
> >>
> >>Stper,
> >>
> >>If above is the case you can go for either of the below approach
> >>
> >>1. Transactional Replication
> >>
> >>2. Log Shipping
> >>
> >>This method will sync. the Report server database with report server.
> >>
> >>Thanks
> >>Hari
> >>MCDBA
> >>
> >>"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> >>news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> >>
> >>Are you talking about transforming data? Have you explored DTS? See SQL
> >>Server Books Online for more information.
> >>--
> >>HTH,
> >>Vyas, MVP (SQL Server)
> >>http://vyaskn.tripod.com/
> >>
> >>
> >>"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> >>news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> >>My application has production server and backup sever for data
> >
> > reporting
> >
> >>.
> >>
> >>There is some tools in SQL 2K (or third part tool) for alignement data
> >
> > at
> >
> >>run time between two servers?
> >>Thanks in advance
> >>
> >>Stper
> >>
> >>
> >>
> >>
> >>
> >
> >|||After testing and testying i can say (like Pitagora) : EUREKA !!!
now i must tuning the task but the functionality work very well.
Thanks
Stper
"stper" <stefano.perabo@.speedautomazione.it> ha scritto nel messaggio
news:eZICqZzbEHA.596@.TK2MSFTNGP11.phx.gbl...
> i made the configuration and now i testing my first "PULL SUbscription".
> Unfortunately i have my first error message : "Unexpected EOF encountered
in
> BCP data-file" when i run with alignement.
> Do yuo have some suggestion ?
> stper
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
> news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > stper,
> >
> > Books Online is a very valuable reference.
> > http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
> > to replication. There is a book coming soon on Snapshot and
> > Transactional replication from Hilary Cotter which is excellent, see the
> > link in my sig.
> >
> > --
> > Mark Allison, SQL Server MVP
> > http://www.markallison.co.uk
> >
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> >
> >
> > stper wrote:
> > > Thanks Hari, i think the Transactional Replication is the solution for
> my
> > > problem. Now i must study the configuration
> > > I found this an article in
> > > www.awprofessional.com/articles/article.asp?p=170234
> > > Do you have some suggestion for examples and/or configuration
> > >
> > > Thanks
> > > Stper
> > >
> > > "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> > > news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
> > >
> > >>Hi Vyas,
> > >>
> > >>It seems Stper need to syncronize the report server with production
> server
> > >>online.
> > >>
> > >>Stper,
> > >>
> > >>If above is the case you can go for either of the below approach
> > >>
> > >>1. Transactional Replication
> > >>
> > >>2. Log Shipping
> > >>
> > >>This method will sync. the Report server database with report server.
> > >>
> > >>Thanks
> > >>Hari
> > >>MCDBA
> > >>
> > >>"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > >>news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> > >>
> > >>Are you talking about transforming data? Have you explored DTS? See
SQL
> > >>Server Books Online for more information.
> > >>--
> > >>HTH,
> > >>Vyas, MVP (SQL Server)
> > >>http://vyaskn.tripod.com/
> > >>
> > >>
> > >>"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in
message
> > >>news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> > >>My application has production server and backup sever for data
> > >
> > > reporting
> > >
> > >>.
> > >>
> > >>There is some tools in SQL 2K (or third part tool) for alignement
data
> > >
> > > at
> > >
> > >>run time between two servers?
> > >>Thanks in advance
> > >>
> > >>Stper
> > >>
> > >>
> > >>
> > >>
> > >>
> > >
> > >
>sql
Tuesday, March 27, 2012
align the parameters in reports
IS it possible to design the Parameters Layout in Reporting Service
reports
miniYou can modify styles in HTMLViewer.css style sheet present in Reporting
Services\ReportServer\Styles folder but you will only affect appearance of
the elements, not the distribution or type of controls you want to show.
If you want to fully customize that layout, you need to use reporting
services API, as I have done. For example, I have used radio buttons to
choose report parameters instead of the default combobox.
Jaime
"mini" wrote:
> IS it possible to design the Parameters Layout in Reporting Service
> reports
> mini
>|||thanks Jaime
can u explain how you use reporting
services API?
Can u reduce the Textbox width displayed in parameter layout?
thanks
mini
reports
miniYou can modify styles in HTMLViewer.css style sheet present in Reporting
Services\ReportServer\Styles folder but you will only affect appearance of
the elements, not the distribution or type of controls you want to show.
If you want to fully customize that layout, you need to use reporting
services API, as I have done. For example, I have used radio buttons to
choose report parameters instead of the default combobox.
Jaime
"mini" wrote:
> IS it possible to design the Parameters Layout in Reporting Service
> reports
> mini
>|||thanks Jaime
can u explain how you use reporting
services API?
Can u reduce the Textbox width displayed in parameter layout?
thanks
mini
Align image
I have an image in a table cell in my report. Naturally not all images fit 100% in the cell which is why I'd like to align the images in the middle of the cell, horisontally and vertically.
I've been unable to figure out how to do this in Reporting Services for SQL Server 2000. Am I missing something or is this simply not possible? Does anyone know whether it can be done in 2005?
try manipulating the padding values
|||I would but we're talking an entire column of images of varying sizes here thus I would have to calculate the correct padding size based on the size of the column and of the image itself. It seems like a little much for such a simple thing.|||I have not seen any built in functionality for this in reporting services so I guess your options are pretty limited. Padding values are a sure way to get this done but you could have the cell fixed sized and have your image fit proportionally|||http://blogs.msdn.com/ChrisHays/this link tells you what i been saying all along. paddings are the only way to go.
and the working sample is here
Subscribe to:
Posts (Atom)