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.
> > >
> > >
> > >

ActiveX and RDL

Is there any element that is supported by RDL that will allow an ActiveX control to be embedded into a Reporting Services report?

The ActiveX control doesn't need to be scripted, but only listed as an object tag with some parameter tags within it. I'm looking for something like this:

<ActiveXControl Name="Control1">
<ClassID>...</ClassID>
<Parameters>
<Parameter>
<Name>Param1</Name>
<Value>Value1</Value>
</Parameter>
</Parameters>
</ActiveXControl>

I understand that an ActiveX control doesn't really make sense in any context outside of HTML, but the ability to do this would be very valuable to a lot of consumers I think. I am already aware of CustomReportItem, but I've been told the functionality of that element is limited to outputting an image.

Does such a construct exist?

Thanks.

For a while, we actually had this in RDL but we cut it because you could not do data binding for the control. We were also concerned about security and the cross-platform issues. We might bring it back in the future but no workaround for SQL 2005.

Accessing the underlying sql query from the rdl file

Our client uses the report builder to generate reports for collection of employees. We would like to use the employee records in this report to perform some additional processing (such as the list of employees gets assigned to a particular group).

Programmatically, I can retrieve a byte stream from rs.GetReportDefinition( "\myClientEmpReport") and deserialize the stream into Report object (as define by ReportDefinition.xsd).

I can then manually drill down and retrieve the SematicQuery xml from the commandText field.

The problem is how to convert the SemanticQuery format into a T-Sql query that I can run against the view that the report model is based off of.

Is this possible?

Thanks,

Arjay

P.S. Running SQL 2005 Reporting Services, VC# 2005, ASP.Net 2.0.

After attempting to autogenerate serialization classes on the SemanticQuery xml with Xsd and XsdObjectGen, I ended up hand coding some classes that handled recursion. From there, I was able to regenerate the sql query by walking through the filter and grouping sections. While this isn't a generic solution, it works well for my needs because the model I need this for is a single datasource derived from a view.

As a feature request, it sure would be nice to be able get the query string from the reporting engine directly.

Accessing the ReportService.asmx via an ASP.NET page

Hi all, I have an ASP.NET page which I want to use to be able to upload
*.rdl documents to the report server "on the fly".
When I call the webservice via some code in my ASP.NET webpage I receive the
following error
"The request failed with HTTP status 401: Unauthorized."
Any ideas more than welcome..
TIA MarkHi all, a bit of research produced the following:
http://support.microsoft.com/default.aspx?scid=kb;en-us;811318
All fixed and working now :)
Cheers
Mark
"Mark" <dont@.spam.me> wrote in message
news:ud3zhsenFHA.3408@.tk2msftngp13.phx.gbl...
> Hi all, I have an ASP.NET page which I want to use to be able to upload
> *.rdl documents to the report server "on the fly".
> When I call the webservice via some code in my ASP.NET webpage I receive
the
> following error
> "The request failed with HTTP status 401: Unauthorized."
> Any ideas more than welcome..
> TIA Mark
>

Accessing RDL Reports from Visual Basic 6.0 Application

Hai! I don't know is this a silly question. Is it possible to execute and display the rdl (Sql server 2005 reporting services) report from visual basic 6.0 application.

I have a full fledged Visual basic windows application and using crystal reports. I want to create the reports using SQL server 2005 reporting services and access it from my Visual Basic 6.0 Windows application.

Thanks in advance

I'm afraid VB6 support has ended, and so VB6 questions are off topic here. Try www.vbcity.com instead.