Friday, March 9, 2012
Problem: render a report which should show data in coulmns
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:
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
Blog Archive
-
▼
2012
(490)
-
▼
March
(401)
- Problems Linking to Oracle Server
- Problems linking Access to SQL replicated tables
- problems joing data that contains quotes.....
- Problems ith Connection string to SQL Express
- Problems integrating reporting services into a web...
- Problems instancing Reporting Services
- Problems installing/accessing SQL server via web
- Problems installing/accessing SQL server via web
- Problems installing SSRS on web server
- Problems installing SRS
- problems installing sqlxml 3.0
- Problems installing SQLServer 2000 Developer Editi...
- Problems installing SQL7 Desktop on WinXP
- Problems Installing SQL Server when CTP was previo...
- Problems installing SQL Server 2005 SP 1
- Problems installing SQL Server 2005 SP 1
- Problems installing SQL Server 2005 SP 1
- Problems installing SQL Server 2005 Mobile on device
- Problems installing SQL Server 2005
- Problems installing SQL Server 2005
- Problems installing SQL Server 2005
- Problems installing sql server 2005
- Problems installing SQL Server 2000
- Problems installing SQL Reporting Services
- Problems installing SQL 2005 Express after trying ...
- Problems installing SQL 2005 Express after trying ...
- Problems installing SQL 2000
- Problems installing SP4 on MSDE 2000 (SP3)
- problems installing security patch.
- problems installing security patch of sql server 2000
- problems installing security patch of sql server 2000
- problems installing security patch of sql server 2000
- Problems installing RS 2005
- Problems Installing Reporting Services on Win2003
- Problems installing Reporting Services
- Problems installing msde2000a
- Problems installing MSDE with the Server Service d...
- Problems installing MSDE Desktop SP3a SQL server
- Problems Installing MSDE 2000
- Problems installing MSDE
- Problems installing MSDE
- Problems installing MSDE
- Problems installing External Stored procedure
- Problems installing Client tools and BOL
- Problems Installation MSDE 2000 - URGENT
- Problems instaling IIS & Notification Service
- Problems inserting records into non dbo schema
- Problems inserting into table
- Problems inserting into database :(
- Problems inserting decimal numbers
- Problems Inserting DateTimeStamp into database
- Problems inserting datetime object into sql server...
- Problems Inserting Data- Am I doing something wrong?
- Problems insalling SP3
- Problems insalling SP3
- Problems insalling SP3
- Problems Initializing Reporting Serivices
- Problems in SQL, Updating many rows at once
- Problems in SQL, Updating many rows at once
- problems in sql server 2005 installation
- Problems in selecting record.
- Problems in Search opertion using Like
- Problems in Search opertion using Like
- Problems in Search opertion using Like
- Problems in Report Presentation
- Problems in opening the Enterprise Manager
- Problems in Loading configuration file
- problems in Like
- problems in installing sql server 2000 standard ed...
- problems in Hands-On-Lab, MED302
- problems in Hands-On-Lab, MED302
- Problems in exporting constraints and keys
- Problems in executing SQL or Stored Procs with ASP
- problems in editing a record... why? help pls....
- Problems in Creating Views in Sql
- Problems in Creating Views in Sql
- problems in creating report (parent child hierarchy)
- Problems In Connecting Using New Driver
- Problems in attaching db
- problems in variable passing from shell to procedure
- Problems importing TXT files using DTS
- Problems importing text files with double-quotes a...
- Problems importing text files with double-quotes a...
- Problems importing text files with double-quotes a...
- Problems importing data into sql server
- Problems importing data from an ODBC source
- Problems importing backup DB into Express
- Problems importing a datetime from a flat file
- Problems hitting SqlServer from Global.asax Applic...
- Problems having moved from SQL 7 to SQL 2000
- Problems having moved from SQL 7 to SQL 2000
- Problems having moved from SQL 7 to SQL 2000
- Problems grasping ado.net - coming from asp backgr...
- Problems getting to the uninstall tool for SQl Server
- Problems getting to the uninstall tool for SQl Server
- Problems getting SQL Server 2005 Express to run on...
- Problems getting SQL Server 2005 Express to run on...
- Problems getting information out of a SQLDataSource
- Problems getting Date
- Problems getting all the data back with a XML query
- Problems getting 200 SPs to work in 2005...
- Problems getting 200 SPs to work in 2005...
- Problems getting 200 SPs to work in 2005...
- Problems formatting my table...
- Problems Exporting To Excel When Using Report Subs...
- Problems exporting to Excel
- Problems exporting to Excel
- Problems exporting to Excel
- problems exporting to excel
- Problems exporting reports to Excel
- Problems exporting Reports programatically
- Problems exporting from reporting services 2005 to...
- Problems Executing Stored procedure OLEDB
- Problems Executing Stored procedure OLEDB
- Problems executing DML via linked server
- Problems executing Database Engine Tuning Advisor
- Problems executing Database Engine Tuning Advisor
- Problems executing Database Engine Tuning Advisor
- problems executing a SELECT inside a TRAN against ...
- Problems during the installation of Integration Se...
- Problems during the installation of Integration Se...
- problems during the deployment phase
- Problems during the deployment of a report
- Problems due to @@IDENTITY
- problems downloading Microsoft SQL Server Manageme...
- problems downloading Microsoft SQL Server Manageme...
- problems displaying images
- Problems displaying default value of first cascadi...
-
▼
March
(401)