Report Object Model?

Hi
I am looking for an object model to learn how to access report items an
conections (if available?) in code. Because the code window on report
properties is THAT programmer-friendly I have no idea where to start
accessing the items.
Thanks.
MarkusThe code window you are refering is used for writing small functions to be
used inside the report something like converting Dollar to pounds etc.
If for using connection and report items or anyother things, I suggest use
the RS web services, there are good samples available in SS online help to
start with.
Amarnath, MCTS
"MarkusPoehler" wrote:
> Hi
> I am looking for an object model to learn how to access report items an
> conections (if available?) in code. Because the code window on report
> properties is THAT programmer-friendly I have no idea where to start
> accessing the items.
> Thanks.
> Markus

Report loses all data !

Hi,
I have a reportviewer object on an asp.net page.
On this page (not in the reportviewer object) is also a button which pops up
a new window with a pdf document when clicked.
The report loads fine with all the info I want, when I refresh the page or
the report itself the information is still ok.
But as soon as I press the button for the pdf document, the document opens
fine, but it pops-up UNDER the other page, AND the reportviewer object LOSES
ALL DATA and displays this dreaded message : "To render a report, enter the
serverUrl and ReportPath."Eric,
I don't know a lot about ASP web pages, but I've got a notion that I thought
I'd share. As far as the PDF showing up under the webpage, it sounds like
the code for the PDF button doesn't have the Focus properties set properly.
You or your developer should check out that button code and make sure that
when clicked, it switches the focus from the current webpage to the new PDF
page.
As far as losing the data from the ASP page... I would say that is a code
issue with the button functionality too, rather than a Reporting Services
issue, but again, I don't know ASP, so I can't tell you exactly what the
problem is.
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Eric" wrote:
> Hi,
> I have a reportviewer object on an asp.net page.
> On this page (not in the reportviewer object) is also a button which pops up
> a new window with a pdf document when clicked.
> The report loads fine with all the info I want, when I refresh the page or
> the report itself the information is still ok.
> But as soon as I press the button for the pdf document, the document opens
> fine, but it pops-up UNDER the other page, AND the reportviewer object LOSES
> ALL DATA and displays this dreaded message : "To render a report, enter the
> serverUrl and ReportPath."|||Yeah I dont know much about ASP pages either, that is the problem :p
I tried using window.focus on my java script to put focus on the pdf page
when it opens, but that code is ignored. In the ASP newsgroup they suggest I
use window.modalDialog but that window cannot be reduced.
As for the report reloading with empty parameters, I temporarily countered
the problem by reloading the report after the button is clicked. But that is
a lame correction since the report reloads with default data and doesnt keep
its current state.
In a nutshell, im still at square one.
"Catadmin" wrote:
> Eric,
> I don't know a lot about ASP web pages, but I've got a notion that I thought
> I'd share. As far as the PDF showing up under the webpage, it sounds like
> the code for the PDF button doesn't have the Focus properties set properly.
> You or your developer should check out that button code and make sure that
> when clicked, it switches the focus from the current webpage to the new PDF
> page.
> As far as losing the data from the ASP page... I would say that is a code
> issue with the button functionality too, rather than a Reporting Services
> issue, but again, I don't know ASP, so I can't tell you exactly what the
> problem is.
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)
>
> "Eric" wrote:
> > Hi,
> >
> > I have a reportviewer object on an asp.net page.
> > On this page (not in the reportviewer object) is also a button which pops up
> > a new window with a pdf document when clicked.
> >
> > The report loads fine with all the info I want, when I refresh the page or
> > the report itself the information is still ok.
> >
> > But as soon as I press the button for the pdf document, the document opens
> > fine, but it pops-up UNDER the other page, AND the reportviewer object LOSES
> > ALL DATA and displays this dreaded message : "To render a report, enter the
> > serverUrl and ReportPath."

Report Hyperlink Opening New Window

Hi, I am trying to get a link out of a report to open another web browser
with the HTML
rs:target=_blank as part of the string parameter that is passed in...but it
still opens the link in the same window.
?How does one open a link out of a report so that it will open a new window?
THANKS!!!There is no rs:target parameter. I suppose you mean rc:LinkTarget=_blank
See also:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
> Hi, I am trying to get a link out of a report to open another web browser
> with the HTML
> rs:target=_blank as part of the string parameter that is passed in...but
> it still opens the link in the same window.
> ?How does one open a link out of a report so that it will open a new
> window?
> THANKS!!!
>|||ok, so I tried this and it didn't work...or maybe I didn't understand it...
I'm in a text box in a table under
properties>>advanced>>navigation>>Jump to URL
and I enter
="http://kingofthegreens.com&rc:LinkTarget=_blank"
results in it still opening in the same window'
"Robert Bruckner [MSFT]" wrote:
> There is no rs:target parameter. I suppose you mean rc:LinkTarget=_blank
> See also:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
> news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
> > Hi, I am trying to get a link out of a report to open another web browser
> > with the HTML
> > rs:target=_blank as part of the string parameter that is passed in...but
> > it still opens the link in the same window.
> >
> > ?How does one open a link out of a report so that it will open a new
> > window?
> >
> > THANKS!!!
> >
>
>|||I am having a similar issue, I can't find the syntax for adding
rc:LinkTarget. I am trying to add a url with one query string parameter and
open in a new window.
Thanks!
"Ben Sullins" wrote:
> ok, so I tried this and it didn't work...or maybe I didn't understand it...
> I'm in a text box in a table under
> properties>>advanced>>navigation>>Jump to URL
> and I enter
> ="http://kingofthegreens.com&rc:LinkTarget=_blank"
> results in it still opening in the same window'
>
> "Robert Bruckner [MSFT]" wrote:
> > There is no rs:target parameter. I suppose you mean rc:LinkTarget=_blank
> > See also:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
> > news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
> > > Hi, I am trying to get a link out of a report to open another web browser
> > > with the HTML
> > > rs:target=_blank as part of the string parameter that is passed in...but
> > > it still opens the link in the same window.
> > >
> > > ?How does one open a link out of a report so that it will open a new
> > > window?
> > >
> > > THANKS!!!
> > >
> >
> >
> >|||Here is a response of mine about exporting to CSV that covers your
situation. Note that you need to have SP1 or SP2 installed to be able to use
this:
>>>>>>
Depending on how you design your reports you can do the following to export
to Excel. Or, what I do sometimes is make a copy of the report and clean it
up for data export and then hide it in list view. If you export from Report
Manager it puts CSV data in unicode which Excel puts all in one column. If
you export in ASCII then Excel does just as you want. To prevent a problem
with cells (Excel will object to sorting the data) you need to remove any
textboxes you have (for instance with a title, showing the parameters run
etc) and instead add additional header rows, merge the cells and put your
text in there instead. I add a link at the top of the report that says
Export Data. With RS 2005 you will be able to configure it to use ASCII
instead of Unicode.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
Very nice and very fast.
>>>>>>>>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peter Rogers" <Peter Rogers@.discussions.microsoft.com> wrote in message
news:F4C1AC98-3B0D-443D-B18A-0E7896435958@.microsoft.com...
>I am having a similar issue, I can't find the syntax for adding
> rc:LinkTarget. I am trying to add a url with one query string parameter
> and
> open in a new window.
> Thanks!
> "Ben Sullins" wrote:
>> ok, so I tried this and it didn't work...or maybe I didn't understand
>> it...
>> I'm in a text box in a table under
>> properties>>advanced>>navigation>>Jump to URL
>> and I enter
>> ="http://kingofthegreens.com&rc:LinkTarget=_blank"
>> results in it still opening in the same window'
>>
>> "Robert Bruckner [MSFT]" wrote:
>> > There is no rs:target parameter. I suppose you mean
>> > rc:LinkTarget=_blank
>> > See also:
>> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
>> >
>> > -- Robert
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
>> > news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
>> > > Hi, I am trying to get a link out of a report to open another web
>> > > browser
>> > > with the HTML
>> > > rs:target=_blank as part of the string parameter that is passed
>> > > in...but
>> > > it still opens the link in the same window.
>> > >
>> > > ?How does one open a link out of a report so that it will open a new
>> > > window?
>> > >
>> > > THANKS!!!
>> > >
>> >
>> >
>> >