Thursday, March 29, 2012
Drawing Circles and line and text note in report
would ask. In MS Word, you are able to select an option to â'drawâ' a line or
object on the screen. thought that it would be useful to allow a user to add
a circle or line and a text note to the report prior to printing it. I want
to know whether this is possibleExample: if I wanted to circle the name of
one employee on the report before printing it.
Is this possible with the SQL report writer?
Thanks!Currently there is no feature in RS for users to be able to modify the report in anyway after the report is generated, but would like to have this feature in the later versions.
>--Original Message--
>I am not sure if this is possible with the reporting tool, but I thought I >would ask. In MS Word, you are able to select an option to =E2?odraw=E2?=9D a line or >object on the screen. thought that it would be useful to allow a user to add >a circle or line and a text note to the report prior to printing it. I want >to know whether this is possibleExample: if I wanted to circle the name of >one employee on the report before printing it.
>Is this possible with the SQL report writer?
> >Thanks!
> >
>.
>
Monday, March 19, 2012
doubt
How to search a word in the sqltable?.ie suppose the field name has data type nvarchar(200). From there i enter the persional address of that persion. now i want to know the information whoes are coming from particular city?. The city value can enter in the address field. how we can make search?...
with regards,
ks.kumar
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...753175428d29c27
*****************************************You can use LIKE:
... WHERE col LIKE '%London%'
but this type of search is costly.
If you need to do this type of search then I suggest you separate the
address with a different column for each element: building, street, city,
state/region, postal code, country, etc. This is much easier and more
efficient to search.
--
David Portas
SQL Server MVP
--