Home > Archive > MS SQL Server > March 2005 > Lotus123 Renderer Extension of Reporting Services









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Lotus123 Renderer Extension of Reporting Services
Neale Xu via SQLMonster.com

2005-03-31, 7:01 am

Hi guys:

I want to build a export format as Lotus123 from the RS, so I build a
renderer extenstion, I meet some problems in this matter:

1. Lotus123 support us a 'l123typ.tlb' to interop into .Net, I got some
interface in the tlb file only, so I can't create the Lotus123 application
in the C# or VB.Net. How can I do? But we actually can do the export using
VB6, because we can using the 'createobject' fucntion in VB6.
2. In my extenstion, the 'RenderStream' function didn't work no matter
that there are some pictures in the report. Why?
3. Image the No. 1 question can be solved, what's about the follow
question:

public bool Render(Microsoft.ReportingServices.ReportRendering.Report
report, System.Collections.Specialized.NameValueCollection
reportServerParamete
rs, System.Collections.Specialized.NameValueCollection
deviceInfo, System.Collections.Specialized.NameValueCollection
clientCapabilities,
Microsoft.ReportingServices.ReportRendering. EvaluateHeaderFooter
Expressions
evaluateHeaderFooter
Expressions,
Microsoft.ReportingServices.Interfaces. CreateAndRegisterStr
eam
createAndRegisterStr
eam)
{
System.IO.Stream s = createAndRegisterStr
eam(report.Name, "123",
System.Text.Encoding.UTF8, "application/vnd.lotus-1-2-3", true,
Microsoft.ReportingServices.Interfaces.StreamOper.CreateAndRegister);

//Exporting data to lotus123(report.Name+".123")

//<b>How to render the lotus123 file to end user?</b>

s.Close();
return false;
}


Thanks your attentions!

Best Regards
Neale.Xu
master@cnitz.com

--
Message posted via http://www.sqlmonster.com
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com