Showing posts with label export. Show all posts
Showing posts with label export. Show all posts

Friday, March 30, 2012

Korean wording appear as ? in PDF

Can anyone help me ?
My question is :
My report contains some Korean wording. When I export to PDF, the Korean
word appear as ?. Then I export the report in Excel format, there is no
problem in the Korean wording. But when I try to print it, the default page
orientation is 'Landscape' and there is default left and right margin no
matter how I adjust the report size in reporting services.Make sure the font you're using exists on both the server and the client
viewing the PDF.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:17D5F204-6D94-4ECA-93A1-E287442C8C5D@.microsoft.com...
> Can anyone help me ?
> My question is :
> My report contains some Korean wording. When I export to PDF, the Korean
> word appear as ?. Then I export the report in Excel format, there is no
> problem in the Korean wording. But when I try to print it, the default
> page
> orientation is 'Landscape' and there is default left and right margin no
> matter how I adjust the report size in reporting services.
>

Monday, March 12, 2012

Key export: exception

Recently as part of the process of upgrading to RS SP2 I followed the
normal procedure to export my crypto keys. Unfortunately instead of
providing me with the key file, it gave me an "External component has
thrown an exception" message on the console. At the same time the RS
service shut itself down.
As it turns out, I already have the crypto key tucked away on a CD. I
went ahead and updated to RS SP2 successfully, but the key export is
still giving me trouble.
The trace log isn't doesn't appear to contain any error information.
Has anyone run into this before? How did you resolve it?I've googled and looked through the knowledgebase, but still haven't
found a solution to this.|||We also had this problem. The solution for us was to amend the
web.config file to <customErrors mode="Off"> (we were using a custom
error handler). If you have custom errors "On" then turn them off and
seeing what happens. It didn't fix the problem but it did give a
proper error page showing what the actual problem was and on what line
of code, etc. Good luck.

Friday, March 9, 2012

KeepTogether not working.

Hi all,

I am using RS2005.
KeepTogether=true is not working both in the Preview tab nor when I export to PDF.
My tables still get split by a page break.
RepeatHeaderOnNewPage works as expected.
For a while I was simply putting each table on its own page, but this is such a tacky solution.
Any ideas?

As of now, repeating header on every new page is the only solution.

Shyam

|||

OK.

Thanks Shyam.

|||

So, can you please mark the post as answer?

Shyam

KeepTogether not working.

Hi all,

I am using RS2005.
KeepTogether=true is not working both in the Preview tab nor when I export to PDF.
My tables still get split by a page break.
RepeatHeaderOnNewPage works as expected.
For a while I was simply putting each table on its own page, but this is such a tacky solution.
Any ideas?

As of now, repeating header on every new page is the only solution.

Shyam

|||

OK.

Thanks Shyam.

|||

So, can you please mark the post as answer?

Shyam

Wednesday, March 7, 2012

Keeping PK and identity when moving db from one server to another

We have a database at an external hosting provider.
I would like to move the database to another provider,
If I use the Import or Export tools in Enterprise Manager (db -> db), the
PK's and Indentities are not set on the new server....
...is there somehow I can move the database including the PK's and
Identities...?
Does it have to be through: Backup -> Manually file transfer -> Restore?
There are ca. 50 tables in that database, and restoring all the keys and
identities is full time job.
Thanx!
Regards,
Taras DKTaras
What's a problem with BACKUP and then RESTORE commands?
"Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
news:uIpt7YJ8DHA.2472@.TK2MSFTNGP10.phx.gbl...
> We have a database at an external hosting provider.
> I would like to move the database to another provider,
> If I use the Import or Export tools in Enterprise Manager (db -> db), the
> PK's and Indentities are not set on the new server....
> ...is there somehow I can move the database including the PK's and
> Identities...?
> Does it have to be through: Backup -> Manually file transfer -> Restore?
>
> There are ca. 50 tables in that database, and restoring all the keys and
> identities is full time job.
> Thanx!
> Regards,
> Taras DK
>|||Hi Uri
Well nothing actually.
Though I do not have access to the local file system on either of the
servers.
Therefor it would decrease the down time, if I could perform this task
without involving several dba's at each hosting facility.
So I should take that as a no!
Thanx!
Taras
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23P7EKcJ8DHA.696@.tk2msftngp13.phx.gbl...
> Taras
> What's a problem with BACKUP and then RESTORE commands?
> "Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
> news:uIpt7YJ8DHA.2472@.TK2MSFTNGP10.phx.gbl...
> > We have a database at an external hosting provider.
> > I would like to move the database to another provider,
> >
> > If I use the Import or Export tools in Enterprise Manager (db -> db),
the
> > PK's and Indentities are not set on the new server....
> >
> > ...is there somehow I can move the database including the PK's and
> > Identities...?
> > Does it have to be through: Backup -> Manually file transfer -> Restore?
> >
> >
> > There are ca. 50 tables in that database, and restoring all the keys and
> > identities is full time job.
> >
> > Thanx!
> >
> > Regards,
> >
> > Taras DK
> >
> >
>|||Taras
Take a look at DTS object that called Copy SQL Server Objects Task.
You will be able transfer PK, indexes....
"Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
news:uDfvRjJ8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> Hi Uri
> Well nothing actually.
> Though I do not have access to the local file system on either of the
> servers.
> Therefor it would decrease the down time, if I could perform this task
> without involving several dba's at each hosting facility.
> So I should take that as a no!
> Thanx!
> Taras
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23P7EKcJ8DHA.696@.tk2msftngp13.phx.gbl...
> > Taras
> > What's a problem with BACKUP and then RESTORE commands?
> > "Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
> > news:uIpt7YJ8DHA.2472@.TK2MSFTNGP10.phx.gbl...
> > > We have a database at an external hosting provider.
> > > I would like to move the database to another provider,
> > >
> > > If I use the Import or Export tools in Enterprise Manager (db -> db),
> the
> > > PK's and Indentities are not set on the new server....
> > >
> > > ...is there somehow I can move the database including the PK's and
> > > Identities...?
> > > Does it have to be through: Backup -> Manually file transfer ->
Restore?
> > >
> > >
> > > There are ca. 50 tables in that database, and restoring all the keys
and
> > > identities is full time job.
> > >
> > > Thanx!
> > >
> > > Regards,
> > >
> > > Taras DK
> > >
> > >
> >
> >
>|||Hi Uri
Perfect... I't works (almost) like a charm.
Except it only copies the tables and objects owned by dbo, and not the ones
owned by the db_owner ?
Could you please elaborate ?
Thanx!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%236KX8lJ8DHA.3052@.TK2MSFTNGP09.phx.gbl...
> Taras
> Take a look at DTS object that called Copy SQL Server Objects Task.
> You will be able transfer PK, indexes....
>
> "Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
> news:uDfvRjJ8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> > Hi Uri
> >
> > Well nothing actually.
> > Though I do not have access to the local file system on either of the
> > servers.
> > Therefor it would decrease the down time, if I could perform this task
> > without involving several dba's at each hosting facility.
> >
> > So I should take that as a no!
> >
> > Thanx!
> >
> > Taras
> >
> > "Uri Dimant" <urid@.iscar.co.il> wrote in message
> > news:%23P7EKcJ8DHA.696@.tk2msftngp13.phx.gbl...
> > > Taras
> > > What's a problem with BACKUP and then RESTORE commands?
> > > "Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
> > > news:uIpt7YJ8DHA.2472@.TK2MSFTNGP10.phx.gbl...
> > > > We have a database at an external hosting provider.
> > > > I would like to move the database to another provider,
> > > >
> > > > If I use the Import or Export tools in Enterprise Manager (db ->
db),
> > the
> > > > PK's and Indentities are not set on the new server....
> > > >
> > > > ...is there somehow I can move the database including the PK's and
> > > > Identities...?
> > > > Does it have to be through: Backup -> Manually file transfer ->
> Restore?
> > > >
> > > >
> > > > There are ca. 50 tables in that database, and restoring all the keys
> and
> > > > identities is full time job.
> > > >
> > > > Thanx!
> > > >
> > > > Regards,
> > > >
> > > > Taras DK
> > > >
> > > >
> > >
> > >
> >
> >
>

Keeping PK and identity when moving db from one server to another

We have a database at an external hosting provider.
I would like to move the database to another provider,
If I use the Import or Export tools in Enterprise Manager (db -> db), the
PK's and Indentities are not set on the new server....
...is there somehow I can move the database including the PK's and
Identities...?
Does it have to be through: Backup -> Manually file transfer -> Restore?
There are ca. 50 tables in that database, and restoring all the keys and
identities is full time job.
Thanx!
Regards,
Taras DKTaras
What's a problem with BACKUP and then RESTORE commands?
"Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
news:uIpt7YJ8DHA.2472@.TK2MSFTNGP10.phx.gbl...
> We have a database at an external hosting provider.
> I would like to move the database to another provider,
> If I use the Import or Export tools in Enterprise Manager (db -> db), the
> PK's and Indentities are not set on the new server....
> ...is there somehow I can move the database including the PK's and
> Identities...?
> Does it have to be through: Backup -> Manually file transfer -> Restore?
>
> There are ca. 50 tables in that database, and restoring all the keys and
> identities is full time job.
> Thanx!
> Regards,
> Taras DK
>|||Hi Uri
Well nothing actually.
Though I do not have access to the local file system on either of the
servers.
Therefor it would decrease the down time, if I could perform this task
without involving several dba's at each hosting facility.
So I should take that as a no!
Thanx!
Taras
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23P7EKcJ8DHA.696@.tk2msftngp13.phx.gbl...
> Taras
> What's a problem with BACKUP and then RESTORE commands?
> "Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
> news:uIpt7YJ8DHA.2472@.TK2MSFTNGP10.phx.gbl...
the
>|||Taras
Take a look at DTS object that called Copy SQL Server Objects Task.
You will be able transfer PK, indexes....
"Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
news:uDfvRjJ8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> Hi Uri
> Well nothing actually.
> Though I do not have access to the local file system on either of the
> servers.
> Therefor it would decrease the down time, if I could perform this task
> without involving several dba's at each hosting facility.
> So I should take that as a no!
> Thanx!
> Taras
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23P7EKcJ8DHA.696@.tk2msftngp13.phx.gbl...
> the
Restore?
and
>|||Hi Uri
Perfect... I't works (almost) like a charm.
Except it only copies the tables and objects owned by dbo, and not the ones
owned by the db_owner ?
Could you please elaborate ?
Thanx!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%236KX8lJ8DHA.3052@.TK2MSFTNGP09.phx.gbl...
> Taras
> Take a look at DTS object that called Copy SQL Server Objects Task.
> You will be able transfer PK, indexes....
>
> "Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
> news:uDfvRjJ8DHA.2796@.TK2MSFTNGP09.phx.gbl...
db),
> Restore?
> and
>

Keeping details together in pdf

My reports will keep data regions together with no problems in web reports
but once I export them to pdf I frequently get data split in silly places. Is
there a way to keep the data together in pdf without having to break after
every item?Can you define ‘Silly' places.. ?
nntp://news.microsoft.com/microsoft.public.sqlserver.reportingsvcs/<64A271C0-B0AD-4B87-8AAD-4403A7A33BD4@.microsoft.com>
My reports will keep data regions together with no problems in web reports
but once I export them to pdf I frequently get data split in silly places. Is
there a way to keep the data together in pdf without having to break after
every item?
[microsoft.public.sqlserver.reportingsvcs]|||I know exactly what your talking about. However Adobe over rides the page
breaking.
-rwiethorn
nospamsme-rwiethorn2002@.yahoo.com
"DTimmins" wrote:
> My reports will keep data regions together with no problems in web reports
> but once I export them to pdf I frequently get data split in silly places. Is
> there a way to keep the data together in pdf without having to break after
> every item?|||I have exactly the same problems The web report looks o.k. but when I export
to PDF page breaks are inserted in very unreasonable places. Some pages are
more than 50% empty! I tried everything (sub reports instead of grouping,
rectangles, keeping data fields close together) but PDF simply ignores that.
Klaus
"DTimmins" wrote:
> My reports will keep data regions together with no problems in web reports
> but once I export them to pdf I frequently get data split in silly places. Is
> there a way to keep the data together in pdf without having to break after
> every item?|||I am having this exact problem too. Has anyone solved it yet?
"DTimmins" wrote:
> My reports will keep data regions together with no problems in web reports
> but once I export them to pdf I frequently get data split in silly places. Is
> there a way to keep the data together in pdf without having to break after
> every item?|||I am having this same problem? Can anyone tell us how to fix it?
"DTimmins" wrote:
> My reports will keep data regions together with no problems in web reports
> but once I export them to pdf I frequently get data split in silly places. Is
> there a way to keep the data together in pdf without having to break after
> every item?