Bar codes ?

Hi guys
I am new in SQL RS. I want to print bar codes on my report. Is it
possible with RS ? Do I need external procedure ? Any suggestion will
be welcome !
Thanks
Jean-MarcJean-Marc,
In one of our projects I ran into the same requirement and was able to
handle it very easily with a barcode font. There are a number of sources
barcode fonts on the Internet which you can find quickly using the search
engine of your choice. Once you install the barcode font on your system you
can just select it in the report designer and your reports will display
barcodes. Just remember that any system running the report that uses the
barcode font will have to have the barcode font installed in order for them
to work.
Hope this helps.
Walter Voytek - Co-Author, "Pro SQL Server Reporting Services" (Apress)
http://www.sqlpros.com/
<jean-marc.audrin@.future.ca> wrote in message
news:1102619463.420068.212260@.f14g2000cwb.googlegroups.com...
> Hi guys
> I am new in SQL RS. I want to print bar codes on my report. Is it
> possible with RS ? Do I need external procedure ? Any suggestion will
> be welcome !
> Thanks
> Jean-Marc
>|||Hi Jim
Thanks a lot for your answer. Now I know that it is possible.
I'm going to try what you say.
Jean-Marc
Jim wrote:
> Jean-Marc,
> In one of our projects I ran into the same requirement and was able
to
> handle it very easily with a barcode font. There are a number of
sources
> barcode fonts on the Internet which you can find quickly using the
search
> engine of your choice. Once you install the barcode font on your
system you
> can just select it in the report designer and your reports will
display
> barcodes. Just remember that any system running the report that uses
the
> barcode font will have to have the barcode font installed in order
for them
> to work.
> Hope this helps.
> Walter Voytek - Co-Author, "Pro SQL Server Reporting Services"
(Apress)
> http://www.sqlpros.com/
>
> <jean-marc.audrin@.future.ca> wrote in message
> news:1102619463.420068.212260@.f14g2000cwb.googlegroups.com...
> > Hi guys
> >
> > I am new in SQL RS. I want to print bar codes on my report. Is it
> > possible with RS ? Do I need external procedure ? Any suggestion
will
> > be welcome !
> > Thanks
> > Jean-Marc
> >

Bar chart and Pie chart reports

Hello guys,

Does anyone has a good resource on "working with Chart Data Region" topic. I really appreciate if anyone provide me a resource that shows a step-by-step procedure to create a report using Bar Chart and Pie Chart data regions. A web cast presentation is more appreciated.

Waiting to hear from you soon

Sincerely,

Amde

Amde,

There is a documentation topic called "Working with Chart Data Regions". Perhaps that will put you on the right track:

http://msdn2.microsoft.com/en-us/library/ms155847(SQL.90).aspx

-Chris

Bar chart and Pie chart

Hello guys,

Does anyone has a good resource on "working with Chart Data Region" topic. I really appreciate if anyone provide me a resource that shows a step-by-step procedure to create a report using Bar Chart and Pie Chart data regions. A web cast presentation is more appreciated.

Waiting to hear from you soon

Sincerely,

Amde

Does the following Books Online topic help?
http://msdn2.microsoft.com/en-us/library/ms155847.aspx

-- Robert

Bad ordering when ordering by varchar field

Hi guys,
did anyone come across this problem?
I have a query where I ORDER BY Part_Number field which is varchar but
the ordered result is
10169-G
10169-MVS
10169
which is mess because normal person would put first the 10169 and then
the others?
Thanks for any help Milan
hi Milan,
Milan Reznicek wrote:
> Hi guys,
> did anyone come across this problem?
> I have a query where I ORDER BY Part_Number field which is varchar
> but the ordered result is
> 10169-G
> 10169-MVS
> 10169
> which is mess because normal person would put first the 10169 and
> then the others?
> Thanks for any help Milan
can you please post your actual code, as simple repro are correct, on my
instance..
SET NOCOUNT ON
DECLARE @.t TABLE ( Part_Number varchar(10) )
INSERT INTO @.t VALUES ( '10169-G' )
INSERT INTO @.t VALUES ( '10169-MVS' )
INSERT INTO @.t VALUES ( '10169' )
SELECT t.Part_Number
FROM @.t t
ORDER BY t.Part_Number
--<--
Part_Number
10169
10169-G
10169-MVS
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||What collation is your database using?
"Milan Reznicek" <reznicek@.rezna.info> wrote in message
news:uZCQw9ZSFHA.356@.TK2MSFTNGP14.phx.gbl...
> Hi guys,
> did anyone come across this problem?
> I have a query where I ORDER BY Part_Number field which is varchar but
> the ordered result is
> 10169-G
> 10169-MVS
> 10169
> which is mess because normal person would put first the 10169 and then
> the others?
> Thanks for any help Milan
>
|||Thanks both, you and JJ. Your code is working all right until I add my
collation which is SQL_Czech_CP1250_CI_AS (JJ pointed about it) - and which
completely messes up the ordering.
Milan
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> pe v diskusnm pspvku
news:3d4df0F6opoh9U1@.individual.net...
> hi Milan,
> Milan Reznicek wrote:
> can you please post your actual code, as simple repro are correct, on my
> instance..
> SET NOCOUNT ON
> DECLARE @.t TABLE ( Part_Number varchar(10) )
> INSERT INTO @.t VALUES ( '10169-G' )
> INSERT INTO @.t VALUES ( '10169-MVS' )
> INSERT INTO @.t VALUES ( '10169' )
> SELECT t.Part_Number
> FROM @.t t
> ORDER BY t.Part_Number
> --<--
> Part_Number
> --
> 10169
> 10169-G
> 10169-MVS
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Milan,
Milan Reznicek wrote:
> Thanks both, you and JJ. Your code is working all right until I add my
> collation which is SQL_Czech_CP1250_CI_AS (JJ pointed about it) - and
> which completely messes up the ordering.
of course collation change the way the sort order is performed...
you can, if you are allowed to from your app design, change the sort order
rules for queries like that like
SET NOCOUNT ON
DECLARE @.t TABLE ( Part_Number varchar(10) )
INSERT INTO @.t VALUES ( '10169-G' )
INSERT INTO @.t VALUES ( '10169-MVS' )
INSERT INTO @.t VALUES ( '10169' )
SELECT t.Part_Number
FROM @.t t
ORDER BY t.Part_Number COLLATE Latin1_General_BIN
you specify that way a different sort order and rule the order by clause
must conform with... but verify this do not comprimise other app designs and
constraints...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Backups

Hi Guys,

I'm pretty new to SQL Server. I have a ? regarding backups.

I have a database which I'm backing up everyday using BACKUP DATABASE db TO db_bak WITH INIT. This job runs everyday successfully, but I'm having an evergrowing transaction log file. I presumed a full database backup will apply transaction logs and will truncate the log files. Isnt it so, or am i missing some concepts? This database can have a data loss of 1 day which is covered by my full database backup job. I dont need a transaction log backup. But to reduce log file size should I do a log backup?

-Sunil.Depends...(love that answer)

What's your recovery model? Simple would do what you're thinking...

I have a feeling it's FULL...in which case you need to dump the tranny too...

Look at the maint plan wizard to help you out

Also you need to determine what type of strategy you need to employ...

Basically, how much time/data can you afford to lose...|||Thanks Brett,

My recovery model is FULL and i prefer to keep it that way. So, i reckon I should set transaction log backups aswell. I have set database backup to run every 6PM, if i create another job to backup transaction logs at 7PM, will it do? Also, since my database is big (It is MSProject database) database backup is done everyday in overwrite mode to avoid appending 200MB everyday to the backup file. Could transaction log backup be done in overwrite mode aswell or is it necessary to be appended every day? If there is a recovery scenario, will it all add well?

I'm still wondering why isnt transaction log truncated after a successful full backup. Why do we need transaction logs if the database itself is fully backed up.

-Sunil.|||Originally posted by sunilthomas98
I'm still wondering why isnt transaction log truncated after a successful full backup. Why do we need transaction logs if the database itself is fully backed up.
-Sunil.

Because it is a point in time backup...logs are usually dumped periodically to recover data throughout the daya (I do mine every 10 minutes)

Why not first go through the db maint wizard...it'll show you all the things you can do, without having to code them in T-SQL...it'll even schedule the jobs...

Then by a book...one of my favorites is SQL Server 911 by Brian Knight..good book

Here's a real story...

HR "dba" (the quotes are on purpose) had the type of scenario you mention..

It was time to enter in all the work for the bonuses...which got done...

Now scrub boy messed something up...we think he had a glitch a decided to recover the db from last nights dump...effectivley wiping out all the work the clerks had enetered...soooooo no bonuses...right?

Wrong...the vp called ALL of the clerks in plus IT staff to re-enter the data...so at about 4:00 am it was done...and the file went out the next day...

He's not with us anymore...|||Thanks Brett, I'll do that not to miss my next bonus (if it comes)