Print

How to incoporate with vs application using soap method please guide me
advance thanks
RajaI'm not exactly sure what you are asking. You want to use the print control
object via SOAP? This can't be done, it is an activeX control and it uses
URL access to render reports.
You can create your own printing logic and call SOAP to render each page in
the format you wish to use for printing. The control uses EMF and then uses
GDI to print to the printer.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raja Mohamed" <Raja@.photoninfotech.com> wrote in message
news:Opv2c$hSFHA.720@.TK2MSFTNGP10.phx.gbl...
> How to incoporate with vs application using soap method please guide me
> advance thanks
> Raja
>|||Actually, in the ReadME it talks about the RSClientPrint object in the API.
I guess this isn't a web service, but it's how to Print the report other
than the URL Access method.
- Joel
"Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
news:ekO0Bp1SFHA.3308@.TK2MSFTNGP14.phx.gbl...
> I'm not exactly sure what you are asking. You want to use the print
> control object via SOAP? This can't be done, it is an activeX control and
> it uses URL access to render reports.
> You can create your own printing logic and call SOAP to render each page
> in the format you wish to use for printing. The control uses EMF and then
> uses GDI to print to the printer.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Raja Mohamed" <Raja@.photoninfotech.com> wrote in message
> news:Opv2c$hSFHA.720@.TK2MSFTNGP10.phx.gbl...
>> How to incoporate with vs application using soap method please guide me
>> advance thanks
>> Raja
>|||Yes, the RSClientPrint object can be used in your own html. You just need
to set the object tag and call the method correctly.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
news:uNCV8x2SFHA.3228@.TK2MSFTNGP10.phx.gbl...
> Actually, in the ReadME it talks about the RSClientPrint object in the
> API. I guess this isn't a web service, but it's how to Print the report
> other than the URL Access method.
> - Joel
>
> "Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
> news:ekO0Bp1SFHA.3308@.TK2MSFTNGP14.phx.gbl...
>> I'm not exactly sure what you are asking. You want to use the print
>> control object via SOAP? This can't be done, it is an activeX control
>> and it uses URL access to render reports.
>> You can create your own printing logic and call SOAP to render each page
>> in the format you wish to use for printing. The control uses EMF and
>> then uses GDI to print to the printer.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Raja Mohamed" <Raja@.photoninfotech.com> wrote in message
>> news:Opv2c$hSFHA.720@.TK2MSFTNGP10.phx.gbl...
>> How to incoporate with vs application using soap method please guide me
>> advance thanks
>> Raja
>>
>|||daniel can u plz post a simple example of html that uses rsclientprint
activex control and its print method i ll b greatful
moreover plz let me know that either i need anyother file to use that
control than rsclientprint.dll
thanx in advance
--
Message posted via http://www.sqlmonster.com|||There is sample code in the readme for using the print control in html. You
need all of the assemblies in the .cab file for the print control to work.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Muhammad Hammad via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:a9250f7bbde844ebb135df6dc0b9d738@.SQLMonster.com...
> daniel can u plz post a simple example of html that uses rsclientprint
> activex control and its print method i ll b greatful
> moreover plz let me know that either i need anyother file to use that
> control than rsclientprint.dll
> thanx in advance
> --
> Message posted via http://www.sqlmonster.com

PrimeOutput : difference between 'Output' and 'output buffer'

When overriding the PrimeOutput method in a custom component, you get as parameters the outputIDs and the output buffers (of type PipelineBuffer). using the outputIDs you can get IDTSOutput90 outputs.

As I interpret things, each output is associated with one output buffer. When you want to output rows, you add rows to the buffer. But what do you use the output (IDTSOutput90) for?

Regards,
HenkGood question. I'm keen to know the answer to this too.

-Jamie|||If you have more than one output on your component then you can use the order of the IDs and buffers (they are in the same order) to determine which buffer goes with which output. Obviously, there are other ways to do this but this makes it simple.

HTH,
Matt|||That was clear to me Matt, but what do you need an output for?|||Henk,

Maybe you have already come up with a answer, since there was no proper answer in the Thread, I will mention what I think.

IDTSOutput90 is used to Specify the MetaData of that particular output, using that Interface its possible to give the output columns' {Field}Name , Description, DataType, Length , etc..... which are the metadata of that Output.

The metadata will have to be specified if you are adding new columns to the Output, or else the metadata will be retrived by the earlier component.

When adding to the output buffer, the values will have to adhere to the metadata in the IDTSOutput90.

Hope this is the answer to your Question

Nilushan,sql

PrimeOutput : difference between 'Output' and 'output buffer'

When overriding the PrimeOutput method in a custom component, you get as parameters the outputIDs and the output buffers (of type PipelineBuffer). using the outputIDs you can get IDTSOutput90 outputs.

As I interpret things, each output is associated with one output buffer. When you want to output rows, you add rows to the buffer. But what do you use the output (IDTSOutput90) for?

Regards,
HenkGood question. I'm keen to know the answer to this too.

-Jamie|||If you have more than one output on your component then you can use the order of the IDs and buffers (they are in the same order) to determine which buffer goes with which output. Obviously, there are other ways to do this but this makes it simple.

HTH,
Matt|||That was clear to me Matt, but what do you need an output for?|||Henk,

Maybe you have already come up with a answer, since there was no proper answer in the Thread, I will mention what I think.

IDTSOutput90 is used to Specify the MetaData of that particular output, using that Interface its possible to give the output columns' {Field}Name , Description, DataType, Length , etc..... which are the metadata of that Output.

The metadata will have to be specified if you are adding new columns to the Output, or else the metadata will be retrived by the earlier component.

When adding to the output buffer, the values will have to adhere to the metadata in the IDTSOutput90.

Hope this is the answer to your Question

Nilushan,

Previous value best method

I'm not really strong in SQL. My goal is to compare the beginning mileage of a vehicle record with it's previous ending mileage reading. I have something that works, but it feels clunky. I wonder if there is a better method, ie a join. Here's what I have:

SELECT A.Trolley_num, A.Date, A.Speedo_start, A.Speedo_end,
(SELECT B.Speedo_end FROM Daily_Trolley AS B
WHERE B.Trolley_num = A.Trolley_num
AND B.Date =
(SELECT Max(Date) FROM Daily_Trolley AS C WHERE C.Trolley_num = A.Trolley_num
And C.Date < '1/23/2005')) AS PrevSpeedoEnd
FROM Daily_Trolley AS A
WHERE A.Date='1/23/2005'

ps: I inherited this db; I'm aware that "Date" should not have been used as a field name.Unfortunately, this is just a clunky thing to do in SQL. You can try this and see if it is any faster. One lest nested subquery...

select Current.Trolley_num,
Current.Date,
Current.Speedo_start,
Current.Speedo_end,
Previous.Speedo_end
from Daily_Trolley Current
inner join --PriorReadings
(select DTA.Trolley_num,
DTA.Date,
Max(DTB.Date) as PreviousDate
from Daily_Trolley DTA
left outer join Daily_Trolley DTB
on DTA.Trolley_num = DTB.Trolley_num
and DTA.Date > DTB.Date
group by DTA.Trolley_num,
DTA.Date) PriorReadings
on Current.Trolley_num = PriorReadings.Trolley_num
and Current.Date = PriorReadings.Date
left outer join Daily_Trolley Previous
on PriorReadings.Trolley_num = Previous.Trolley_num
and PriorReadings.PreviousDate = Previous.Date|||Forgive me if this is a duplicate; I got an error posting a reply and it's not showing up. This is the third try.

Thanks blindman. QA didn't like "Current" as an alias, but it worked fine when I changed that. Both our versions return records so quickly that no time is registered in the execution time window in QA. There are only 10k records in this table though. However, your version lets me calculate the difference; mine wouldn't (not directly anyway).

I may modify both to work against another table with several hundred thousand records, and see how they compare. I suspect yours will be faster due to the join instead of subquery.

Thanks again.

Previewing reports - MissingMethodException

Hi, after installing RS SP1, when I want to preview a report in VS.NET 2003,
I get an error- MissingMethodException: Method not found: System.String
Microsoft.ReportingServices.Diagnostics.Globals.GetCurrentWindowsUserName().
I guess its because Microsoft.ReportingServices.Diagnostics.dll is somehow
wrongly registered, I tried to register it with regsvr32.exe (both copies,
one in Documents and Setting and one under RS home directory) but I didnt
succeed.
The report renders allright in Report Manager, but I really miss the
Preview, because it slows down the developing so much.
Any help would be appreciated.I even tried to unisnstall Reporting Services and did a clean install again,
but it didnt help. I really dont feel like reinstalling Windows now...
"Nikola Tepper" wrote:
> Hi, after installing RS SP1, when I want to preview a report in VS.NET 2003,
> I get an error- MissingMethodException: Method not found: System.String
> Microsoft.ReportingServices.Diagnostics.Globals.GetCurrentWindowsUserName().
> I guess its because Microsoft.ReportingServices.Diagnostics.dll is somehow
> wrongly registered, I tried to register it with regsvr32.exe (both copies,
> one in Documents and Setting and one under RS home directory) but I didnt
> succeed.
> The report renders allright in Report Manager, but I really miss the
> Preview, because it slows down the developing so much.
> Any help would be appreciated.|||--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nikola Tepper" <Nikola Tepper@.discussions.microsoft.com> wrote in message
news:8766C01C-9FA8-4C21-BC00-71627266FDA9@.microsoft.com...
> I even tried to unisnstall Reporting Services and did a clean install
again,
> but it didnt help. I really dont feel like reinstalling Windows now...
> "Nikola Tepper" wrote:
> > Hi, after installing RS SP1, when I want to preview a report in VS.NET
2003,
> > I get an error- MissingMethodException: Method not found: System.String
> >
Microsoft.ReportingServices.Diagnostics.Globals.GetCurrentWindowsUserName().
> > I guess its because Microsoft.ReportingServices.Diagnostics.dll is
somehow
> > wrongly registered, I tried to register it with regsvr32.exe (both
copies,
> > one in Documents and Setting and one under RS home directory) but I
didnt
> > succeed.
> > The report renders allright in Report Manager, but I really miss the
> > Preview, because it slows down the developing so much.
> > Any help would be appreciated.|||Sorry, hit "Send" too soon. Did you try reinstalling the .NET framework?
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:ODFBI7IjEHA.3632@.TK2MSFTNGP09.phx.gbl...
>
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Nikola Tepper" <Nikola Tepper@.discussions.microsoft.com> wrote in message
> news:8766C01C-9FA8-4C21-BC00-71627266FDA9@.microsoft.com...
> > I even tried to unisnstall Reporting Services and did a clean install
> again,
> > but it didnt help. I really dont feel like reinstalling Windows now...
> >
> > "Nikola Tepper" wrote:
> >
> > > Hi, after installing RS SP1, when I want to preview a report in VS.NET
> 2003,
> > > I get an error- MissingMethodException: Method not found:
System.String
> > >
>
Microsoft.ReportingServices.Diagnostics.Globals.GetCurrentWindowsUserName().
> > > I guess its because Microsoft.ReportingServices.Diagnostics.dll is
> somehow
> > > wrongly registered, I tried to register it with regsvr32.exe (both
> copies,
> > > one in Documents and Setting and one under RS home directory) but I
> didnt
> > > succeed.
> > > The report renders allright in Report Manager, but I really miss the
> > > Preview, because it slows down the developing so much.
> > > Any help would be appreciated.
>