Interactive Data And Clickthrough Reports

Jul 13, 2007

My reports are not allowing me to "Clickthrough" to more detailed reports.



I want my report to automatically show a detail record when they select some "interactive data" in my reports.



I have read a page on this stuff ( http://msdn2.microsoft.com/en-us/library/ms345252.aspx ) which states:



In Report Builder, a clickthrough report is a report that provides detailed information about the data contained within the main report. A clickthrough report is displayed when the Report Builder user clicks the interactive data that appears in the main report. These reports are automatically generated by the report server. You, as the model designer, determine what is displayed in clickthrough reports by setting the DefaultDetailAttribute and DefaultAggregateAttribute properties that you assign to an entity in the report model.



Hence, within my report model i have created an entity with a number of DefaultDetailAttributes.

I have not created a specific "click through" report as i would be happy to view the automatically generated report that should contain the attributes defined in the "DefaultDetailAttributes" list.



However, when i view the report, no data items are links (or "interactive data" as the msdn article describe them).



Has anyone got any ideas on how to make the report data interactive?



Thanks,

pete

View 1 Replies


ADVERTISEMENT

Enabling Automatic ClickThrough/ Drill Into For Report Builder Reports Against A Model

Apr 4, 2007

Hello - I am having difficulty enabling the automatic click-through functionality for my model. I have two entities - Customer & Incident. Incident is a role/FK/OptionalMany relationship to customer.



I've read through earlier postings on this subject (below) and have verified that the #Incidents attribute in my incident entity has the EnableDrillThrough=true.



My test report is simple - Customer Name (from customer) and #Incidents (from incident). When I run it, the click-through option is not available (the cursor stays as an arrow and doesn't change to a finger).



Are there other properties or settings that I need to be working with? I have SP2 (9.0.3042) installed on our Standard edition of SQL 2005. I know Infinite Click-Through is not in Std edition, but a few levels should be, correct?



Thanks in Advance,

Toni



Other related postings -

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1260819&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=657279&SiteID=1

View 4 Replies View Related

FEATURE REQUEST: Ability To Disable Clickthrough Reports (Live Links) At The Report And Export Function Level

Jul 19, 2007

Please consider enhancing SQL 2005 Reporting Services to provide the ability to disable Clickthrough Reports (Live Links) at the Report and Export Function level. Today you can only enable or disable Clickthrough Reports at the View/Model Level for all Report Builder reports.

View 1 Replies View Related

Interactive Sort Not Working On Snapshot Reports

Jan 17, 2006

Interactive sorting works just fine on my report until I set the
execution property to render from snapshot. When viewing a snapshot,
clicking on the column sort arrows will not sort the data I'm viewing. If I turn the snapshot feature off, then I get the interactive sort functionality back.

Is this by design or am I missing something fundamental here?

Using SQL 2005, RS 2005, VS 2005.

Thanks.

View 2 Replies View Related

Adding Interactive Sort In Drill Down Reports.

Dec 20, 2007



Hello,

I have a drill down report and would like to add interactive sort on two columns:- column 1 & column 2. These two columns should be in descending order. By adding this, when user's click on column 1 they will see the data based on the sorted order.
Does anyone help me on this issue.

Thanks,
BL

View 5 Replies View Related

Reports Containing Drill Through Interactive Bar Charts Not Working Properly When Deployed

Feb 9, 2006

Hi all,

Drill through bar charts work great in the report designer preview, but as soon as I deploy the report, and view the report in a webpage, drill through does not work smoothly.

I have to move the mouse around to be able to find a place on the bar to click through to the next report. Sometimes, I am able to click on the bar to go to next report, but then sometimes I have to click on the label, and other times somewhere in the vicinity of the label.

Any help will be much appreciated.

Thanks,

Kanwal

View 1 Replies View Related

Reporting Services :: Interactive Sorting With Drill Down Reports In Report Builder 3.0

Aug 20, 2015

I am using Report Builder 3.0 and i have report which has a drill down group. The report opens in a collapsed form.This report has interactive sorting on a column. But,when we drill down and sort the column, the group collapses and the details disappear.

In some posts, i have seen that instead of interactive sorting, people recommended a parameter. But i have to do interactive sorting only.

View 3 Replies View Related

What Exactly Is Infinite Clickthrough?

Nov 1, 2007

Another thread (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2347749&SiteID=1) got me wondering: what exactly is this "infinite clickthrough" feature that SSRS Enterprise Edition has? Searching for "infinite clickthrough" yields little but frustration - nearly all of the hits are merely pages explaining that Enterprise Edition has it and the other editions don't, without ever describing what exactly it is.

Near as I can tell, "infinite clickthrough" refers to a feature of ReportBuilder when used in conjunction with Report Models on SSRS Enterprise whereby ReportBuilder will synthesize a clickthrough report on the fly, and has nothing to do with the ability to build "clickthrough" reports using links (the "Navigation" tab on the Properties of most any reporting services object).

View 1 Replies View Related

Interactive Data Access Through Firewall

Sep 7, 2007



Hi there!

I am facing this problem:

I have server A (SQL Server 2005) in LAN and server B (IIS 6) in DMZ.

Due to security policies, server A can initiate communications to B through a firewall; server B cannot initiate any communication to server A.

A web application on server B needs to interactively read/write data stored on server A.

I was reading something about repication, sql everywhere, service broker and something else.

Is there some integrated functionality in SQL Server 2005 that can help in this scenario, or should I develop some sort of sync application?



Thank you.
Bye!

View 3 Replies View Related

Remove All Reports ( Not Data Sources) From Reports Server

Jan 23, 2007

Hi does anyone know how to do the above with out going through reportserver url?

Preferably by using a cmd tool ? such rs.exe

or through the backend in the reportserver DB?

Thanks

Dave

View 2 Replies View Related

How To: Link A Report To A Model As A Clickthrough Report

Jul 14, 2006

I'm having some difficulty linking a custome drilldown or clickthroug report to another report that I have already created in report builder. I followed a MSDN article found at http://msdn2.microsoft.com/en-us/library/ms345226.aspx but I cannot find the " Select a page area, select Drill-through reports" option in report manager. Does anyone have a better explanation on how to do this? I'm assuming that when you create the clickthrough report there has to some sore of filter on it that relates to the item of the clickthrough. I guess I'm I little confused, any help would be great. Thanks.

View 5 Replies View Related

Data Caching In Reports?

Jul 18, 2006

I wrote an invoice report that gets its data from an Oracle database.  This is working fine except when users change something on the server (like adding a new charge to the invoice) then when they re-run the SSRS report the new line doesn't show up.  They wait 15 minutes and re-run the SSRS report and then it appears.

It is like the SSRS report is caching the old data of the report.

Points to note though...

To execute the report I am using the SSRS 2005 webservice.  I understand that there is 2 cachings, 1 server and 1 IIS side.  I have not cached the server and don't know how to clear the IIS side.  I see there is a rs:ClearSession=true parameter that you can pass in but by using the SSRS 2005 webservice this is not an option (I don't see how you can pass query strings in to the call).

Does SSRS cache the Oracle DataSet at all?

Thanks heaps for any help,

Craig

View 1 Replies View Related

Interactive Prompting

Sep 22, 2004

Hi,

I am migrating few my oracle codes to T-SQL. Currently am using & (ampersand) interactive prompt of SQLPlus. Is there any equivalent for the above said in SQL Server.

-Cheeku

View 1 Replies View Related

Interactive Reporting

May 17, 2007

Software packages like Microsoft Small Business Accounting and Quickbooks offer a very powerful reporting module that lets end users change grouping, filtering, sorting, etc at run time (having it change the report dynamically infront of them). More importantly, their reporting tools let users click on details on the reports which opens the data in the form based portion of their software.



For example: If the end user pulls up a financial report, lets say "All Bills for February 07", the user get a report of all the bills that have gone out in that time frame. The end user can then click on the actual details in the report, and the Bill will come up in the Windows Forms portion of their software so they edit the bill, or create a new bill.



I have done a very limited amount of reporting in SQL Server, so I am not sure of how they were able to achieve this. If someone could give me some key words or ideas that I can bring up more information from in google, or even on here, I'd appreciate it.



Thanks in advance!

View 3 Replies View Related

Interactive Sort

Mar 25, 2008


The Items Display is like this.

Project Name Acronym ID


7ked
SedRich Sed 123

Diercrom Dife 256
Fireup Fip 563

8IOP
Hiluke Hik 478

Jikerty Jer 125
Kilert Kre 458

The Report idea, u Got Right, now I want to implement Interactive sorting to Name ,Acronym,ID
Please help me

View 6 Replies View Related

Interactive Sorting

Jun 14, 2007

I know this is not available now, but is it plan in the near future:



I want to be able to set the initial sort order on the interactive sort.

for example, I have a report sorted Asc by Rank. If I click on the interactive sort button on the Rank column, it resorts ascending... totally pointless, and my customers point this out on a weekly basis...



Any plans to add this feature? If not, I will go to connect and suggest it.



Also, does anyone else find this annoying?



Thanks!



BobP

View 5 Replies View Related

Interactive Subreport

Jan 19, 2008

I have a report that lists customers. Is it possible to create an interactive mechanism so that a user can somehow select a customer and have a subreport update to show that customer's data, without jumping away from the parent report?

Thanks.

J

View 3 Replies View Related

Interactive Sort Bug?

Nov 20, 2007

We have an issue with interactive sorting. Interactive sorting works in our Dev and test environments but does not work on our production server. We have deployed exactly the same report to each server. All servers are sp2 (9.00.3042.00). When the interactive sort buttons are clicked on production nothing happens. Has anyone seen this?

View 1 Replies View Related

Data Level Security In Reports

Aug 30, 2007

Hi Experts,

Hi experts,

I have a BI Reporting scenario, wherein i have to fetch Reports from analysis Services.
when the user tries to access a report, he should be validated uisng the Windows Authentication ID, and only data specific to that user should be display.
I am not sure if this user authentication is to be done on analysis Services/reporting services.

Any suggestions/pointers would be highly appreciated.

Thanks


Alicia Rose

View 1 Replies View Related

Linked Reports And Data Sources

May 31, 2007

Is it possible to tie a linked report to a different data source that the base report?



I have a set of base reports that point to Data Source A.

I have a set of linked reports that I want to point to Data Source B. These linked reports live in a different folder altogether.



Is there a simple way to accomplish this?



Thanks In Advance...

View 1 Replies View Related

Reports Using A Lot Of Data --- Errors Exporting

Aug 29, 2007

We have a customer that has a large report that they want to export to Excel. If I try to export the entire report, it just hangs. If I run the report in 2 batches, it exports fine.

Can you tell me if there is a patch for SSRS that is going to address this or if there is a work around that I can put in my report to handle it?

The customer is quite upset at the work around so I'd love to find a solution soon.

Thanks in advance for any help!
Sherry

View 2 Replies View Related

Dynamic Data Sets In Reports

Sep 3, 2007



Hi,

I'm using a matrix report where in i want to use two datasets in the same report. How can i make the dataset dynamic for a single report.

Regards

View 1 Replies View Related

Interactive Sorting In A Matrix

Oct 16, 2006

Bill,

You say, "we enjoy the option of specifying sorting for
multiple columns within the matrix, table or list within which we
are working." But, when I add interactive sorting to the headers of a matrix, the up and down toggles appear in the preview, but the rows are not sorted after clicking.

This works perfectly fine on tables, as you say, but I have yet to see it on a matrix.

Thanks,

Tom

View 7 Replies View Related

Interactive Sort Doesn't Do Anything

Apr 16, 2008



I can't get interactive sort to work on Report Server reports (but it works on reports I've done in Report Builder using one table per report).
I tried it on a different database in a Report Server report and it did work.

There was another post that talked about the collation, which is Latin1_General_CI_AS_KS_WS for the ReportServer and ReportServerTempDB, and SQL_Latin1_General_CP1_CI_AS for the two databases I reported on. But it seems like I'm not doing something correctly since it works in RB but not RS (though the one database report did work).

Any ideas?

View 2 Replies View Related

Interactive Dashboard With Subreports

Sep 14, 2007

I am trying to create a dashboard that is split into the five main focus areas of Customer, Finance, Management, People and Innovation. Each focus area has a main report and a series of subreports (within a panel). I use the €˜Jump to report:€™ property at the domain level €“ which works well.

My problems arise when dealing with the subreports. For example, in the €˜People€™ focus area €“ the panel contains 4 subreports covering; contractor vs. fte trends, gender balance trends, compliance trends and investment trends.

Ideally I would like to have four €˜tabs€™ which when clicked would show the relevant subreport. I know this can be done via a full report refresh, but it looks clumsy and is more complex and costly to maintain.

I am happy for any method that might change the €˜Subreport€™ property dynamically or set the visibility of the objects. I want to avoid using the toggle capability as this could result in two or more subreports conflicting and being visible at the same time.

View 2 Replies View Related

SP2 Breaks Interactive Sort

May 2, 2007

We have run into a really bizzare problem after upgrading to SQL Server 2005 SP2. We have a bunch of matrix reports that have interactive sort in the upper left hand corner, the sort based on Numeric and Text fields. For Example

=Fields!City.Value

=Sum(Fields!Pax.Value)

Now for whatever reason after upgrading to SP2 and making NO CHANGES to the reports or under data sources, interactive sorts that use the =Sum(....) no longer work but interactive sorts on text values still work.



Any ideas???

View 1 Replies View Related

Drill Down Interactive MDX Query

Sep 17, 2007

Hi,

I am new to reporting services. We are creating a report with drill-down capability. We have a Date dimension hierarchy defined as Year - Month - Day.

On the report, we expect reporting services send MDX query to SSAS to get the total sales just for the the year, say 2007, when we click the year 2007. Then it send query just to aggregate sales for that month when we click a month.

But when we build the reports, it looks like it always aggregate for all levels. So the performance is bad to first open the report.

How do I resolve this issue? Please help.

Thanks,
Jia

View 3 Replies View Related

Interactive Sort Has Probs

Jun 11, 2007

Hi All,



I've designed a simple sales report , first grouped by Transport type and then by item.

Example

Category Item Sales



DHL A 2000

DHL C 1500

DHL E -1700



AmEx A 200

Amex E 20



-------------------------------

when click on sales under group DHL it shouild sort -say descending-

so result should be

DHL A 2000

DHL C 1500

DHL E -1700



instead I get results



DHL A 2000

DHL E -1700

DHL C 1500



this is just an example but this is the sort of results I get when I try to use interactive sorting.

Any Ideas?



thanks



Sonny

View 5 Replies View Related

Interactive Sorting Icon

May 14, 2008

Is there any way to change the interactive sorting icon or even adjust it? When I add the functionality to a column, it skews the column heading to make room for it. This means that reports that previously displayed properly no longer look correct. If I adjust the width of the report to allow room for the icon, then the report overflows its boundary in terms of printing.

Also, the icon does not display evenly all the time. Sometimes, it displays directly next to the text and sometimes it is off to the right more.

View 6 Replies View Related

TextAlign Ignored When Using Interactive Sort

Aug 8, 2007

I have a table with WritingMode for the column labels set to tb-rl (vertical writing).
I want the text in each label to be right-aligned (i.e. aligned along the actual bottom of the cells), so I set TextAlign = Right.
This works fine for all columns until I enable Interactive Sort. When Interactive Sort is activated TextAlign ignores the value and always behaves as if General (or Center) was selected.
Is there a solution to this?


By the way: Is it possible to have the vertical text written upwards (bt-lr) instead of downwards?

View 1 Replies View Related

Interactive Column Sort

Mar 9, 2007



Hi All

I'm Climbing the walls here, does anyone know how to do an interactive sort but keep one of the returned rows pinned at the end of the result set?

i've tried this

=iif(Fields!Item.Value <> "c", 1 ,2) & Fields!Item.Value

Doesn't work to well

Results to Sort

d

e

a

b

c

Sort should return

which works fine on the ascending sort

a

b

d

e

c

with c remaining at the bottom

But i get this on the descending sort

c

a

b

d

e

Thanks in advance

Dave

View 1 Replies View Related

Toggled &&amp; Interactive Sort

Sep 23, 2006

Hello,



I have a table with interactive sort and toggled to hide and unhide details (table group is the toggled)

when user click on the interactive sort the collapse back to default.

e.g.

in the report all the details on the table group are hide and the group have toggled.

user open one of the group. after that click on the sort all the collapses are close also the group user click to unhide.

any workaround ?

View 1 Replies View Related

How To Use Web Services And Interactive Features

Dec 26, 2006

I've been having trouble getting my RS2005 reports with interactive features (drilldowns) to work in an Iframe and rendered with SOAP.

The main problem now is that the toggle buttons (+ / -) point to the reporting services server and do a URL Access call. I've tried the <ReplacementRoot> element in the DeviceInfo parameter but it doesn't appear to do anything.

I keep on reading about how everything is possible through the web services but it looks as if these interactive features are only available using the URL Access. Is this true?

Kwan

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved