Interactive sort not working with snapshot

I'm using SSRS 2005. I have a pretty simple report: it's a table with an
optional date parameter. I have one column designated to allow interactive
sort. When testing the report everything works fine. When I change the report
execution to snapshot, the interactive sort no longer works. The icon will
sometimes change to make it appear as if it is sorted, but the data doesn't
actually get sorted.
Is there some config or option I've missed?
TIAThe interactive sort also does not appear to work when the report is cached.
I know this feature was new for 2005. I'm just wondering if this behavior is
by design, a bug, or a config setting that I'm missing.
Any info appreciated...
"Denise" wrote:
> I'm using SSRS 2005. I have a pretty simple report: it's a table with an
> optional date parameter. I have one column designated to allow interactive
> sort. When testing the report everything works fine. When I change the report
> execution to snapshot, the interactive sort no longer works. The icon will
> sometimes change to make it appear as if it is sorted, but the data doesn't
> actually get sorted.
> Is there some config or option I've missed?
> TIA|||SP1 appears to have fixed this bug. After applying the service pack, all
interactive sorting works, even when the report is executed as a snapshot.
"Denise" wrote:
> The interactive sort also does not appear to work when the report is cached.
> I know this feature was new for 2005. I'm just wondering if this behavior is
> by design, a bug, or a config setting that I'm missing.
> Any info appreciated...
> "Denise" wrote:
> > I'm using SSRS 2005. I have a pretty simple report: it's a table with an
> > optional date parameter. I have one column designated to allow interactive
> > sort. When testing the report everything works fine. When I change the report
> > execution to snapshot, the interactive sort no longer works. The icon will
> > sometimes change to make it appear as if it is sorted, but the data doesn't
> > actually get sorted.
> >
> > Is there some config or option I've missed?
> >
> > TIA

Interactive charts, etc.

Hi everyone,

Two questions about charts in reports.

1) They seem pretty static. I have a report with vertical column chart, and I would like to enable hyperlinks through chart columns, so, say, a height of column shows a number of experiments done by a person. I want a user to be able to click on the column or something that would be associated with that column and go either to another report or external URL that would show info about those experiments (similarly as it is done for any field in a regular report). Is it possible to do something like that? (Help files unfortunately were of no use )

2) Is there any way to show a numeric value for the column height in vertical column chart like this:

40
_
| | 20
| | _
| | | |
| | | |
--

Thanks, I appreciate your help!

Anton Bagayev
TransForm Pharmaceuticals
29 Hartwell Avenue
Lexington, MA1) Open the Chart Properties dialog. Go to the Data tab. Select the data point that you want the action on. Select Edit. Click on Action tab. Choose an action.

2) Open the Chart Properties dialog. Go to the Data tab. Select the data point that you want the label on. Select Edit. Click on Point Labels tab. Enable point labels checkbox and enter expression to display.|||

Brian,

What kind of technology does Reporting Services use to display Interactive Charts? Is it Office Web Components?

If it is Office Web Components, then will I need to license it for every web user who uses the Sql Reporting Server to view the reports?

Thanks,

Kanwal

|||

No, it does not use OWC. Your web users are covered by the RS license.

-- Robert

Interactive charts, etc.

Hi everyone,

Two questions about charts in reports.

1) They seem pretty static. I have a report with vertical column chart, and I would like to enable hyperlinks through chart columns, so, say, a height of column shows a number of experiments done by a person. I want a user to be able to click on the column or something that would be associated with that column and go either to another report or external URL that would show info about those experiments (similarly as it is done for any field in a regular report). Is it possible to do something like that? (Help files unfortunately were of no use )

2) Is there any way to show a numeric value for the column height in vertical column chart like this:

40
_
| | 20
| | _
| | | |
| | | |
--

Thanks, I appreciate your help!

Anton Bagayev
TransForm Pharmaceuticals
29 Hartwell Avenue
Lexington, MA1) Open the Chart Properties dialog. Go to the Data tab. Select the data point that you want the action on. Select Edit. Click on Action tab. Choose an action.

2) Open the Chart Properties dialog. Go to the Data tab. Select the data point that you want the label on. Select Edit. Click on Point Labels tab. Enable point labels checkbox and enter expression to display.|||

Brian,

What kind of technology does Reporting Services use to display Interactive Charts? Is it Office Web Components?

If it is Office Web Components, then will I need to license it for every web user who uses the Sql Reporting Server to view the reports?

Thanks,

Kanwal

|||

No, it does not use OWC. Your web users are covered by the RS license.

-- Robert

Interactive charts, etc.

Hi everyone,

Two questions about charts in reports.

1) They seem pretty static. I have a report with vertical column chart, and I would like to enable hyperlinks through chart columns, so, say, a height of column shows a number of experiments done by a person. I want a user to be able to click on the column or something that would be associated with that column and go either to another report or external URL that would show info about those experiments (similarly as it is done for any field in a regular report). Is it possible to do something like that? (Help files unfortunately were of no use )

2) Is there any way to show a numeric value for the column height in vertical column chart like this:

40
_
| | 20
| | _
| | | |
| | | |
--

Thanks, I appreciate your help!

Anton Bagayev
TransForm Pharmaceuticals
29 Hartwell Avenue
Lexington, MA1) Open the Chart Properties dialog. Go to the Data tab. Select the data point that you want the action on. Select Edit. Click on Action tab. Choose an action.

2) Open the Chart Properties dialog. Go to the Data tab. Select the data point that you want the label on. Select Edit. Click on Point Labels tab. Enable point labels checkbox and enter expression to display.|||

Brian,

What kind of technology does Reporting Services use to display Interactive Charts? Is it Office Web Components?

If it is Office Web Components, then will I need to license it for every web user who uses the Sql Reporting Server to view the reports?

Thanks,

Kanwal

|||

No, it does not use OWC. Your web users are covered by the RS license.

-- Robert

Integrating asp.net application and reporting services

Hi,
I have just started using Reporting Services and found it pretty simpleto use. I, however, could not figure out how i can achieve thefollowing and will appreciate suggestions on this. I intend to generatethe reports on the fly depending upon the parameters the userenters.The reports are generated through a link on ASP.NET applicationpage. The user fills in the input and accordingly different reports aregenerated. So I want to ask how I can integrate the asp.net applicationand the reporting services.
Thanks
Ankur
You can use the renderbyurl method of Reporting Services. Check out books on line for RS about the various rendering extensions.|||

What should the approach for the problem described herehttp://forums.asp.net/973015/ShowPost.aspx...
try login in as testuser (pwd: dnntest) at this URLhttp://ser.senape.gov.bo/Testing/tabid/61/Default.aspx
Any help is appreciated.

|||I was never able to successfully use the URL approach without using the extensions only available in the expensive Enterprise edition. I used the SOAP approach instead as described quite thoroughly in Teo lachev's book "Microsoft Reporting Services In Action".|||Hi, thanks for your reply. I am using the render method to call thereport server through my application. But i am still facing one problemwhen I call the render method. I am not able to figure out what shouldbe the path of my report that I want to run, since the report is on aremote machine. what should my reportpath variable contain? Can yousuggest how i shld go about it?
thanks
Ankur
|||U have to create an rdl file (using XMLWriter Class) and then upload this file to the report server through code. And then u can view the reports. But a new report gets generated each time.|||reportPath is the folder path to the report (e.g. /My Reports/My Test Report). No URL information is included since that is derived from your web.config file when you instantiate your ReportServer.ReportingService Web method. Check the web.confg file and set the correct URL to the ReportingService key. Make sure that your application has the "URL Behavior" property set to "Dynamic" as well.|||Hi,
Thanks a lot for ur reply. It was a big help.
Ankur