Showing posts with label render. Show all posts
Showing posts with label render. Show all posts

Wednesday, March 21, 2012

displaying xml using reporting service web service

I'm using VS2005 web developer. I can't display XML results when using the
render method, although it renders fine.
I'm using the SQL Server 2000 reporting services web service render method
to get a byte array like this:
result = rs.Render(reportPath, format, historyID, devInfo,
parameters, _
credentials, showHideToggle, encoding, mimeType,
reportHistoryParameters, warnings, streamIDs)
This is from the sample at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_lz_6x0z.asp
It works great if I assign HTML4.0 and EXCEL to the "format" variable.
Then I put
response.binarywrite(result)
and it is just fine.
When I try this with the XML format, it creates a file perfectly if I put
Dim stream As FileStream = File.Create("report.xml", result.Length)
but I don't know how to display the xml in a browser.
Response.binarywrite(result) and Response.writefile("report.xml") gives me
an error
The XML page cannot be displayed.
...
Cannot have a DOCTYPE declaration outside of a prolog
I guess because the XML is written inside the html.
I would appreciate any suggestions.
Thanks
BillCorrection - response.writefile(filename) works, but I don't want to have to
create files on the server and clean them up all the time.
Thanks
Bill
"bill" <belgie@.datamti.com> wrote in message
news:ubuEOCnMGHA.2124@.TK2MSFTNGP14.phx.gbl...
> I'm using VS2005 web developer. I can't display XML results when using
> the render method, although it renders fine.
> I'm using the SQL Server 2000 reporting services web service render method
> to get a byte array like this:
> result = rs.Render(reportPath, format, historyID, devInfo,
> parameters, _
> credentials, showHideToggle, encoding, mimeType,
> reportHistoryParameters, warnings, streamIDs)
> This is from the sample at
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_lz_6x0z.asp
> It works great if I assign HTML4.0 and EXCEL to the "format" variable.
> Then I put
> response.binarywrite(result)
> and it is just fine.
> When I try this with the XML format, it creates a file perfectly if I put
> Dim stream As FileStream = File.Create("report.xml", result.Length)
> but I don't know how to display the xml in a browser.
> Response.binarywrite(result) and Response.writefile("report.xml") gives
> me an error
> The XML page cannot be displayed.
> ...
> Cannot have a DOCTYPE declaration outside of a prolog
> I guess because the XML is written inside the html.
> I would appreciate any suggestions.
> Thanks
> Bill
>

Monday, March 19, 2012

Displaying RTF Content in Report

Hi
I am having rtf stuff in database.
I need to display it in the Report.
Is ther any way to render rtf text in the report
or Is there any way to remove rtf stuff and just display plain text.
I Tried to use RichTextBox object of System.Windows.Forms.dll.
It worked well in design time preview tab.
But giving error at field where I used to display when I published to
Report Server and run the reportPlease tell me what solution you did for below mentioned problem
"Rama Prasad" wrote:
> Hi
> I am having rtf stuff in database.
> I need to display it in the Report.
> Is ther any way to render rtf text in the report
> or Is there any way to remove rtf stuff and just display plain text.
> I Tried to use RichTextBox object of System.Windows.Forms.dll.
> It worked well in design time preview tab.
> But giving error at field where I used to display when I published to
> Report Server and run the report

Saturday, February 25, 2012

Displaying a report on the browser when using SOAP

I was wondering if theres a way to correctly display reports on the browser
if you use SOAP to render them.Yes you can.
In this case when you try to render a report( You can use the Render method
to do so) the reporting services HTML Report in a byte array.
You can use this byte array to display reports on the browser.
"Rodrigo Sánchez" wrote:
> I was wondering if theres a way to correctly display reports on the browser
> if you use SOAP to render them.
>
>|||ive done that and used the response.write to send the report to screen but
images break, yo dont have the toolbar and paging doesnt seem to work, any
suggestions?
"Sangfroid" <Sangfroid@.discussions.microsoft.com> escribió en el mensaje
news:198F4602-729C-43AE-A7F7-CF4D76D600DE@.microsoft.com...
> Yes you can.
> In this case when you try to render a report( You can use the Render
method
> to do so) the reporting services HTML Report in a byte array.
> You can use this byte array to display reports on the browser.
> "Rodrigo Sánchez" wrote:
> > I was wondering if theres a way to correctly display reports on the
browser
> > if you use SOAP to render them.
> >
> >
> >

Friday, February 24, 2012

Display Reporting Services in Blackberry

Attempting to render a report in mobile blackberry. The report viewer
displays, and the report generates, but eventually freezes and no data
appears.
Blackberry 5 OS
SQL Reporting Services 2005 (SP2)
Blackberry browser with IE emulation and javascripts enabled on
client.
Any other blackberry users attempting to view reporting services?
Thanks.
RobThough I have not yet discovered the procedure for successfully
displaying a dynamic report within a reportviewer, it did discover a
work around that might be the next best thing. For a little
background, I do have reporting services integrated with sharepoint
services 3.0. A user can go to his/her web site or workspace shared
documents and build a report or subscribe to an existing report in
their list.
So, for example: Customers.rdl and it's datasource actually exist as
documents in the shared document list. This is accomplished by adding
these content types to the shared documents list.
1) I subscribed to the report using the sharepoint web form.
2) Select the report from the dropdown list in the shared documents
list.
3) Select "Manage subscriptions"
4) Set up a subscription to run "hourly" and select "web page" as the
format type.
5) Give your subscription document a name. i.e. myreport.html
5) Have the subscription sent to //<yoursharepointserverpath>/shared
documents/
Now from your blackberry browser, navigate to the name
(myreport.html).
Rob

Sunday, February 19, 2012

Display of MICR font.

I have a check printing functionality which is implemented as an rdl. The
check number needs to render in MICR . When the report is rendered in pdf,
the MICR font is not getting displayed. I have installed the MICR font on the
machine containing the RS and restarted it. Where else may I be going wrong
in ?
Any help will be appreciated. Thanks.Do you have the MICR font installed on the client machine too?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"satwikb" <satwikb@.discussions.microsoft.com> wrote in message
news:CA908E24-5FB3-4C20-99C8-DE445A8DFF83@.microsoft.com...
>I have a check printing functionality which is implemented as an rdl. The
> check number needs to render in MICR . When the report is rendered in pdf,
> the MICR font is not getting displayed. I have installed the MICR font on
> the
> machine containing the RS and restarted it. Where else may I be going
> wrong
> in ?
> Any help will be appreciated. Thanks.