ActiveX print button on SQL RS 2000 formatting to .5"

Is there any way to get the print button to format *automatically * the
margins based on what was written in the RDL?
For some reason it appears to want to be 0.5". I hate to tell the users to
keep changing it or exporting to PDF to get the margins I intended when I set
them from the Report Designer.I am new at RS, but it seems it takes the margins from the printer (and the
default values, in other words, it resets the values after you run it). In
fact, I read in the readme of the RS - SP2 that that is what it does.
I have a question for you (or anybody else that might want to answer): when
I print using the activex print button the report fonts, etc are bigger, for
instance, if I have a line of 6 inches wide it will take all the width of a
letter page (which is 8.5 inches). It is like printing with zoom.
Have you run into that problem?
Thanks for any info... José Araujo.
"David Bienstock" <davidleebspam-sqlrs@.yahoo.com> wrote in message
news:931F70D0-693C-408B-B082-8D6719F1A6BC@.microsoft.com...
> Is there any way to get the print button to format *automatically * the
> margins based on what was written in the RDL?
> For some reason it appears to want to be 0.5". I hate to tell the users
> to
> keep changing it or exporting to PDF to get the margins I intended when I
> set
> them from the Report Designer.|||My driver for an HP 8150 doesn't appear to have default values, but they
would certainly be closer, as the printer can print to less than .2 inches.
--
"José Araujo" wrote:
> I am new at RS, but it seems it takes the margins from the printer (and the
> default values, in other words, it resets the values after you run it). In
> fact, I read in the readme of the RS - SP2 that that is what it does.
> I have a question for you (or anybody else that might want to answer): when
> I print using the activex print button the report fonts, etc are bigger, for
> instance, if I have a line of 6 inches wide it will take all the width of a
> letter page (which is 8.5 inches). It is like printing with zoom.
> Have you run into that problem?
> Thanks for any info... José Araujo.
>
> "David Bienstock" <davidleebspam-sqlrs@.yahoo.com> wrote in message
> news:931F70D0-693C-408B-B082-8D6719F1A6BC@.microsoft.com...
> > Is there any way to get the print button to format *automatically * the
> > margins based on what was written in the RDL?
> >
> > For some reason it appears to want to be 0.5". I hate to tell the users
> > to
> > keep changing it or exporting to PDF to get the margins I intended when I
> > set
> > them from the Report Designer.
>
>|||Well u can use Report Properties->layout->There's The Print setup
"David Bienstock" wrote:
> My driver for an HP 8150 doesn't appear to have default values, but they
> would certainly be closer, as the printer can print to less than .2 inches.
> --
> "José Araujo" wrote:
> > I am new at RS, but it seems it takes the margins from the printer (and the
> > default values, in other words, it resets the values after you run it). In
> > fact, I read in the readme of the RS - SP2 that that is what it does.
> >
> > I have a question for you (or anybody else that might want to answer): when
> > I print using the activex print button the report fonts, etc are bigger, for
> > instance, if I have a line of 6 inches wide it will take all the width of a
> > letter page (which is 8.5 inches). It is like printing with zoom.
> >
> > Have you run into that problem?
> >
> > Thanks for any info... José Araujo.
> >
> >
> > "David Bienstock" <davidleebspam-sqlrs@.yahoo.com> wrote in message
> > news:931F70D0-693C-408B-B082-8D6719F1A6BC@.microsoft.com...
> > > Is there any way to get the print button to format *automatically * the
> > > margins based on what was written in the RDL?
> > >
> > > For some reason it appears to want to be 0.5". I hate to tell the users
> > > to
> > > keep changing it or exporting to PDF to get the margins I intended when I
> > > set
> > > them from the Report Designer.
> >
> >
> >|||That's the point. I have .25 inches on Left and Right but the ActiveX prints
it to .5" so it always comes out on 2 times the pages.
--
"Everyone knows something you don't know"
"ש×?×?×?" wrote:
> Well u can use Report Properties->layout->There's The Print setup
> "David Bienstock" wrote:
> > My driver for an HP 8150 doesn't appear to have default values, but they
> > would certainly be closer, as the printer can print to less than .2 inches.
> > --
> >
> > "José Araujo" wrote:
> >
> > > I am new at RS, but it seems it takes the margins from the printer (and the
> > > default values, in other words, it resets the values after you run it). In
> > > fact, I read in the readme of the RS - SP2 that that is what it does.
> > >
> > > I have a question for you (or anybody else that might want to answer): when
> > > I print using the activex print button the report fonts, etc are bigger, for
> > > instance, if I have a line of 6 inches wide it will take all the width of a
> > > letter page (which is 8.5 inches). It is like printing with zoom.
> > >
> > > Have you run into that problem?
> > >
> > > Thanks for any info... José Araujo.
> > >
> > >
> > > "David Bienstock" <davidleebspam-sqlrs@.yahoo.com> wrote in message
> > > news:931F70D0-693C-408B-B082-8D6719F1A6BC@.microsoft.com...
> > > > Is there any way to get the print button to format *automatically * the
> > > > margins based on what was written in the RDL?
> > > >
> > > > For some reason it appears to want to be 0.5". I hate to tell the users
> > > > to
> > > > keep changing it or exporting to PDF to get the margins I intended when I
> > > > set
> > > > them from the Report Designer.
> > >
> > >
> > >

ActiveScripting specific error

Hi,
I have written active script in SQL Server Agent job to
connect to a FTP site using third party FTP/X control.
When I run the job, I get an error as "ActiveScripting
specific error 257 occurred. The step failed".
I tried using the same piece of code in VB 6.0 and its
working fine.
Any advice will be appreciated. Thanks.
regards,
Hemansu
The error is usually due to threading issues. SQL Server,
SQL Agent are multithreaded processes and more than one
thread can access the object. The object may not be able to
handle that due to the threading model it was written under.
Try using a CmdExec step instead of an ActiveX script job
step as CmdExec job steps run in their own thread. You could
write the code to a VB Script file and then execute that
script using CmdExec, e.g.
csript c:\YourScript.vbs
-Sue
On Thu, 9 Sep 2004 16:26:36 -0700, "Hemansu Amin"
<hemansu_amin@.yahoo.com> wrote:

>Hi,
>I have written active script in SQL Server Agent job to
>connect to a FTP site using third party FTP/X control.
>When I run the job, I get an error as "ActiveScripting
>specific error 257 occurred. The step failed".
>I tried using the same piece of code in VB 6.0 and its
>working fine.
>Any advice will be appreciated. Thanks.
>regards,
>Hemansu
|||Thanks Sue. It works!!!

>--Original Message--
>The error is usually due to threading issues. SQL Server,
>SQL Agent are multithreaded processes and more than one
>thread can access the object. The object may not be able
to
>handle that due to the threading model it was written
under.
>Try using a CmdExec step instead of an ActiveX script
job
>step as CmdExec job steps run in their own thread. You
could
>write the code to a VB Script file and then execute that
>script using CmdExec, e.g.
>csript c:\YourScript.vbs
>-Sue
>On Thu, 9 Sep 2004 16:26:36 -0700, "Hemansu Amin"
><hemansu_amin@.yahoo.com> wrote:
>
>.
>
|||Your welcome Hemansu and thanks for posting back that it worked. It
always helps to get verification when something helps work around an
issue.
-Sue
On Thu, 9 Sep 2004 20:37:38 -0700, "Hemansu Amin"
<hemansu_amin@.yahoo.com> wrote:
[vbcol=seagreen]
>Thanks Sue. It works!!!
>
>to
>under.
>job
>could

Accessing mySQL from .NET

Hello all,

We are planning to migrate an application written in Perl + mySQL to .NET + MS-SQL Server. The test machine now has SQL Server running. During the development phase in .NET, we would want to access the mySQL database which is being updated at real time, from the Windows box. This is how I think it has to be done:

1. Use DTS to migrate data from mySQL. Does DTS take care of migrating schema and the difference in data types between the mySQL and MS-SQL? Is there any 3rd party software out there that takes care of the migration without any manual labor?

2. Synchronize the data between 2 DBs by creating some kind of a batch job? If so, whats the best way of doing this?

Instead, is it easier to access the live mySQL database on the Linux box from the .NET code and move the DB only after development in the new environment is completed?

Any help/ideas is greatly appreciated.

TIAIn order to handle the schema, you use the transformation portion of dts(data transformation task). Do you need to have "live" information in the sql server database while you are creating the application in .Net ? If not, just take a snapshot of the data from mysql to sql server and perform the complete migration when you are ready to switch database servers.|||Ok, so if you have an ODBC driver for mySQL you should be able to use DTS to do SQL-92 compliant stuff with your old db.

In all honesty I would suggest that you move these two things one at a time, move either your database or your code but not both at the same time, your testing and debugging will be a nightmare otherwise.

Dan

Accessing multiple recordsets in MRS

Hi all,
Can anybody tell me how to acccess multiple recordsets in mrs. Please
read the following scenario.
I have written a Stored Procedure in SQL Server, this SP returns two
recordsets, suppose the sp name is my_test_sp (lets assign some alias
for those two recordsets as recordsrt1 and recordset2). I am creating a
report which is fetching data from my_test_sp, lets call this report as
my_test_report.
When I set the dataset properties of my_test_report to access
my_test_sp, the field list it generates contais fields that are from
recordset1, it dosenot display any field from recordset2.
Now here; is there any way i can access both recordset1 and recordset2
at a same time. It ll be ok if i create more than one datasets, but
then the question will be can i connect a singal data object like table
to multiple datasets at the same time? and will there be any link
between these two datasets?
I hope I am not missing anything at the design time. Your help will be
grately appriciated.
Thanks in advace. :)
Manoj SA few design issues to consider:
1. RS can only handle one result set at a time from a Stored Procedure (as
you have seen). If you want both you would need the SP to have a parameter
that tells it which to return and then call the SP twice.
2. RS does not associated datasets with one another.
3. Subreports are how you Master-detail
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Monty" <manojshirgurkar@.gmail.com> wrote in message
news:1164179273.330677.7870@.b28g2000cwb.googlegroups.com...
> Hi all,
> Can anybody tell me how to acccess multiple recordsets in mrs. Please
> read the following scenario.
> I have written a Stored Procedure in SQL Server, this SP returns two
> recordsets, suppose the sp name is my_test_sp (lets assign some alias
> for those two recordsets as recordsrt1 and recordset2). I am creating a
> report which is fetching data from my_test_sp, lets call this report as
> my_test_report.
> When I set the dataset properties of my_test_report to access
> my_test_sp, the field list it generates contais fields that are from
> recordset1, it dosenot display any field from recordset2.
> Now here; is there any way i can access both recordset1 and recordset2
> at a same time. It ll be ok if i create more than one datasets, but
> then the question will be can i connect a singal data object like table
> to multiple datasets at the same time? and will there be any link
> between these two datasets?
> I hope I am not missing anything at the design time. Your help will be
> grately appriciated.
> Thanks in advace. :)
> Manoj S
>|||you're talking about MARS right?
MARS was a scam; it doesn't work
I still can't open two datareaders on the same connection.. and that's
what it's advertised as fixing
those cocksuckers just need to go back to ADO; things have been buggy
as hell ever since they went down this ADO.net route.. I mean; what a
joke
-Aaron
Monty wrote:
> Hi all,
> Can anybody tell me how to acccess multiple recordsets in mrs. Please
> read the following scenario.
> I have written a Stored Procedure in SQL Server, this SP returns two
> recordsets, suppose the sp name is my_test_sp (lets assign some alias
> for those two recordsets as recordsrt1 and recordset2). I am creating a
> report which is fetching data from my_test_sp, lets call this report as
> my_test_report.
> When I set the dataset properties of my_test_report to access
> my_test_sp, the field list it generates contais fields that are from
> recordset1, it dosenot display any field from recordset2.
> Now here; is there any way i can access both recordset1 and recordset2
> at a same time. It ll be ok if i create more than one datasets, but
> then the question will be can i connect a singal data object like table
> to multiple datasets at the same time? and will there be any link
> between these two datasets?
> I hope I am not missing anything at the design time. Your help will be
> grately appriciated.
> Thanks in advace. :)
> Manoj S