Showing posts with label sub. Show all posts
Showing posts with label sub. Show all posts

Friday, March 9, 2012

Problem: render a report which should show data in coulmns

Hello,
I'm designing a report which contains a sub report. The sub report show a
list of data (firstname, lastname).
I'm tyring to display data separated by columns.
When you use the report Item "List" there is only the possibility to use a
page break before or after.
Is there a way to use or implement a kind of "column break" ?
ThanksIs it possible to change the query which displays your subreport?. if yes why
cant you change the query by just adding something like this.
select firstname, ' ', lastname .......
Amarnath
"Joes" wrote:
> Hello,
> I'm designing a report which contains a sub report. The sub report show a
> list of data (firstname, lastname).
> I'm tyring to display data separated by columns.
> When you use the report Item "List" there is only the possibility to use a
> page break before or after.
> Is there a way to use or implement a kind of "column break" ?
> Thanks
>
>

Monday, February 20, 2012

Problem with Updatable Subscriptions

Hi all,

I have a problem with "Updatable Subscriptions" under concurrent transactions on both pub and sub effecting same data. At high level of concurrency it Subscriber starts giving error msg "Rows do not match between Publisher and Subscriber. Run the Distribution Agent to refresh rows at the Subscriber.".Please tell me any way arround for this.

Quick question: how much update are you doing on your subscriber and how frequent?

Here is a direct quote from BOL http://msdn2.microsoft.com/en-us/library/ms152570.aspx

The following types of replication and replication options allow you to make changes at a Subscriber and have those changes flow to the Publisher:

Type of replication

Use when…

Merge replication

There are a large number of Subscribers.

Data is replicated to mobile users.

Replicated data is frequently updated at the Subscriber.

Data filtering is needed so that Subscribers receive different partitions of data.
|||There was also a recent QFE fixed to address a similar issue, but like Gary said, it depends on how frequently you're updating the same data at both ends. The QFE fix will make it into SP2, but if you need the fix immediately, you can call CSS.|||Thank you for help i wll go with peer to peer replication