Is there a way to get the Drill through to work with model viewer controls? Any workaround?
Also, where would I find more complex data mining models for review? SQLServerDataMining site, Microsoft data mining tutorial site, and Data Mining with SQL 2005 book, all checked. Anything else?
-Young K
HI,
i would like to know whether you can control access to a drill down in a report in ssrs.
thanks for your help in advance.
thank you
Kanthi
Hello,
I'm working on a distributed application which requires data from a central database to be shown to various users. In particular users should be able to open "views" on the database, specifying the data they are interested in, and being shown the result.
This can be easily accomplished modeling the view specifications as SQL select queries, sending those queries to the server, and visualizing the result. This approach is very flexible, supported, fast and definitely the way we would like to implement it.
The problem is that we have an additional requirement.
In general the data the users might be interested in is not static, and when that data changes, those changes should be propagated to the client views.
There are lots of solutions and technologies aimed to solve very similar problems, but no one seems to support this scenario well.
1. You can re-run the queries every x time (polling)... but this is hardly an option when you have hundreds of client-views that require data to be updated in real-time (so "x time" should be, say, 1 second).
2. You can use query notification... but the documentation explicitily says it doesn't scale well and shouldn't be used with a large number of clients (which is exactly what is needed in this case).
3. You can use replication services... but this technology doesn't really seem to be created to support this scenario.
4. You can use notification services... but even this technology seems to be focused on different scenarios. I haven't looked at it extensively anyway.
5. You can use DML triggers to track data changes... but you still don't have the publish-subscribe mechanism to register client views and the mechanism to know which client views are affected by the changes.
6. You can implement a business logic tier that relates modification requests to client views... and basically do everything from scratch without using existing services.
What are your opinions?
Thank you,
Lorenzo Castelli
Hi
How can I visualize Microsoft Time Series prediction chart for web users? (for Internet Explorer browser)
Is there a way to do it using Reporting Services or special web controls?
I hoped Data Mining Web Controls helped me but they didn't support Microsoft Time Series.
-------------------------
Supported Algorithms
At this time, Data Mining Web Controls include the following:
- DMClusterViewer €“ For the Microsoft_Clustering algorithm.
- DMDecisionTreeViewer €“ For the Microsoft_Decision_Trees algorithm.
- DMNaiveBayesViewer €“ For the Microsoft_Naive_Bayes algorithm.
Models using other algorithms cannot be displayed with the Web controls.
-------------------------
Is there a way to visualize Microsoft Time Series in browser ?
When will there be such facility?
Andriy Zhornyk
Hey gang,
Do any of you know if it is possible to do a heat map chart with reporting services or with the new dundas capability coming in SQL Server 2008?
Thanks in advance.
Letni out
I am looking for some Simple/Best Data Visualization tools for Desktop which accept data from SSAS Cubes.
View 5 Replies View RelatedCan anyone help me with this?
This is my problem:
I have a cube that I created in AS2005, I have a hierarchy and drillthrough action defined. When I create a pivot table in Excel based on that cube and I try to drill down on the cell in the pivot table I can not drill down to the next level. I get an error message: Cannot show or hide detail for
this selection. My hierarchy is based on Dimension Facility. Facility State is root level, facility zip is next level. When I'm in AS2005 and browse the cube, I'm able to drill down and drill through and see the hierarchy just fine. (Also, I find interesting that when I create a cube in excel, based on a two relational tables, I'm able to drill down. ) I have the Analsysis Services Add-on installed on my machine, so I have the Cube Analysis Menu item. But I can't seem to even drill-through. So, for now all I want to know is why can't I drill-down (i.e. double clicking on a cell and having the data related "explode" in the spread sheet) like it shows in the article written by William Pearson, titled September 12, 2005
Introduction to MSSQL Server Analysis Services: Reporting Options for Analysis Services Cubes: MS Excel 2003 and More. Any help is greatly appreciated!!
Queen
View 8 Replies View Related
Hi All,
I am placing a Matrix inside the table control for grouping requirements,but when we export the report to the Excel, the contents inside the table cell are ignored. Is there any way to get the full report exported, as per the Requirement.Please help me with this issue.
With Thanks
M.Mahendra
does any one have and example of how to embedd a flash swf file onto a report.??? Is it possable? any examples would be helpful.
View 1 Replies View RelatedUPDATE #2: When it said "Do you want to install Microsoft SQL Server" I said "yes" and that caused it to work. I exited and re-ran and now the print runs w/o the "install SQL Server" (If the prompt had said "Do you want to install the print dialog" we wouldn't be having this discussion...)
UPDATE: After posting this i discovered that the same thing occurs when attempting to print the report direct from IE6: First a dialog pops up "Do you want to install this software?" Name: Microsoft SQL Server. When I click "Don't Install" I get the dialog "unable to load client print control." Since this happens direct from IE6 I suspect it's browser settings. I'll resume tomorrow and post a followup.
My WinForm C# app integrates Reporting Services by calling them from WebBrowser controls. The problem is attempts to print cause a dialog: "unable to load client print control."
I've read prior posts that say "enable Active-X in your browser" - I don't know how to do that from a WebBrowser control.
Any ideas how to support Reporting Services "Print" from within a WebBrowser control?
RELATED THREADS
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=332145&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=264478&SiteID=1
hi Guys
I want to allow users to have the ability to drilldown. But it doesn't seem possible outside AS ? am I wrong ? As I have built a cube with drilldown enabled and have tested and is working within AS. However after I've opened it up in excel I and tried to drill down it wasn't actually possible. I could only increase / decrease the report's hierachy and that was all.
Anyone know how I can allow my clients to view drill down values ?
any help is appreciated :)
Tom
Does anyone know if it's possible to use drill-through function, liked it's used in cubes in Analysis Manager, in a webreport in Reporting Services? With drill-through i mean the functionality to see individual rows from the database for a single cell in the web-interface.
Anders from Sweden
Hi !
I use a OLAP data Source (Analysis Services)
I have a problem, I have a bar chart, where I put an action on the data Properties to move to another report B if there is a clik on.
My report B need a parameter to execute it self.
So In my report A, I add an action which pass the good parameter to the report B.
In my report B, I add a parameter (via report menu, reportParameter item), but I don't how link the two (grid and parameter)...
because, in my report display, I display a grid, and a text area, in the text area I display the parameter which is pass by the drill through, and when I preview it, the value is ok, but not in my table (grid),
I try to add a dimension with ... but I have always an error, and if I put a dimension who is a parameter it is not ok...
I don't understand,
could you help me !?
Thank you
Hi All ,
I am new to Sql Server and Reporting services ..
I was trying to make a drill down report
I have created Grooup on detail row and set the Visibility with one of the group rows just above ..
But when preview the report I cannot see any data ..
How ever If I Delete the Groups I can see the data ..
Is there anything that I am missing Please help
I have a problem on creating a report using Microsoft SQL Server Business Intelligence Development Studio. I am new to this environment, anybody here can help me on how to enable the "DrillDown" on the table?
When I am using the wizard, the option to enable the drill down will appear, but when I am using "Report Server Project", I really don't know how to enable it, and theres was no table properties on how to enabled it.
Could you help me please
Thanks
Hi All,
I have one dotnet applciation in that i am viewing the report in report viewer. In the same report if the user clicks on one field another report will open. I got a problem with this second report. the image placed on the second report is not coming and if the user clicks on the print button which is on the report viewer the first report is only getting printed. How can I print the second report.
Thanks In Advance
Hello everybody,
I have a small challenge for you.
I'm developing an application using SQL Integration Services and SQL Reporting Services. I need to have the ability to drill down from a graph created with Reporting Services.
Let me explain: If I have a pie chart, I want to be able to click in one of the slides and see the information details that could be in another graph or in a table.
Somebody know how to do this?
Thanks for your help
Hi all,What is Drill Down Reports in Reporting Servies.How can i design Drill Down Reports.
Give me any example to desing Drill Down Reports.
Regards.
Does anyone know what code I'd use in an expression to conditionally format based on if the drill down is expanded or collapsed?
Thanks.
in an
in-an
inane
Inna
Ian
Edit...
Revert to "inan"conditionally
conditional
conditionals
conditionality
Edit...
Revert to "conditionaly"
I was wondering if when you click on the + in a drill down report, does the report requery the database, or is the report just re-rendered without having to query again?
depending on the answer, performance considerations would be different.
Hi,
I have created a drill down using a table. The drill down has 13 levels in it which causes a big vacant space between the top level and the mesures on the right hand side. I would like to hide the columns so that when i drill down the measure columns should dynamically move towards the right (as i keep on going to the next level) . I have tried using inscope for hiding that particular column by refering to the previous level group in it but it doesn't seem to be working.
Kindly suggest if anyone has done this before.
Regards,
Vikram
Any way to have the drill through report open in a new window on the web?
View 4 Replies View Related
Hi all
is it possible make drill down reports in crystal
my requirement is like
i have n rows in my report
if am clicking the first column in first row it will list details of that row in between first and second row
Same for all the rows
Quick reply is appreciated
Regards
Rameez
Hello everyone
For starters i'm using Microsoft analysis services, integration services and reporting services.
All goes well when creating some general overview reports.
Once i get to making drill down reports with only 2000 rows of data is already starts to work very slow (sometimes takes hours). It seems a data cube is only fast for calculations like SUM, PARALLELPERIOD, ... but if it comes to amount of data it is extreemly weak! 2000 rows is not even alot, i've seen reporting tools beeing able to handle a million rows with drill down function.
I'm thinking that this microsoft tool is just not able to handle reports bigger than 100 rows in it combined with drill down. Please proof me wrong because we already paid for the microsoft tools and it would be a shame if we were not able to use them because of bad functionality...
The machine we work on is quite strong (dual core 2.4 ghz, 4 gig ram, ...)
And yes i know you can make reports clickable so they take the value with them to a next report as a parameters but thats not what we are looking for, we need this drill down to work properly with larger amounts of data.
Hi All,
I have a table which has a country, division, category, product, Valuetype, value
data looks like this:
Country division, category, product, Valuetype, value
---------------------------------------------------------------------
UK Division1 Food Pizza Volume 10000
UK Division1 Food Pizza Revenue 2000
UK Division1 Food Pizza ROI 4.5
UK Division2 Food Pizza Volume 14000
UK Division2 Food Pizza Revenue 2400
UK Division2 Food Pizza ROI 4.1
UK Division2 Drinks Cola Volume 14000
UK Division2 Drinks Cola Revenue 2400
UK Division2 Drinks Cola ROI 4.1
I want to build a drill-through report to be grouped on country, division, category and product.
Can someone help me with some suggestions?
Cheers
Josh
I've got a report that drills through to itself, passing different parameters when drilling through. The report work flawlessly in development, flawlessly when you call the report server directly via url, but doesn't always drill through correctly when the report is called using the report viewer on web site. I've gone as far as to create a single aspx page web site that only has this report on it and it still doesn't work.
The drill through works about 1/2 of the time when viewing through the report viewer. But the other half of the time it takes you back to a previously visited parameter, instead of the parameter you clicked on.
So a series of clicks might work like this:
Parameter Clicked - Resultant page
A - Correct "A" page
B - Correct "B" page
C - Correct "C" page
D - Incorrectly taken to "B" page.
It seems to be worse if you throw in any click of the back button.
We thought at first it might be a parameter caching issue, but we turned off all caching and even created a time-stamp parameter to force no caching.
Any thoughts are appreciated.
Craig
Hello - I am using report builder against models.
Which attributes or properties determine what is shown when you do click/drill into the details? I'm using the adventure works database as my guide and expected the (default,Identifying or Aggregate ) attributes to control it, can you summarize how the drill details are determined? My test from adventure works sample:
Pull Territory Name and #customers into the report
Run it and drill into the details on one of the #customers
It returns Acct#, CustType, CustName, #SalesOrders, Sum of a bunch of sales order fields and # customer addresses.
The first three are the default attributes for a customer and the last sets look to be the default aggregates for the other relations to customer - Sales Order & Address.
Is it safe to say that it pulls in the default attributes of the immediate child and then aggregates of it's children? Does it go recursively?
Thanks in advance,
Toni
So here goes the explnation. The problem is specifying an all parameter in a drill through on the value cell of a matrix for the columns in the matrix that are not expanded.
Here goes the example
Matrix for sales.
Region | Shop | Number of sales. And then financial period would be at the top. Everything is collapsed on load so it looks something like this.
Region1 | | 50
Region2 | | 75
Then you expand Region.
Region1 | Shop1 | 30
Region1 | Shop2 | 20
Region2| | 75
At this point if you click on the 30 for shop 1 is drills through into another report passing parameter Region1, shop1 and financial period. This is perfect. The problem comes in that if you haven't expanded region1 and you click on the 50 it drills into the other report but passes through Shop1 as the shop parameter. How can I get this to pass though an all option for the unexpanded columns in the matrix. This is ofcourse just an example and my matrix has quite a few more column and stuff.
Please guys, any help would be appreciated.
This is Reporting services 2005 linking to SSAS2005 cube.
Thanks in advance
Hi,
can anybody tell me if it is possible in RS2005 to create a multi-value parameter in wich it is possibility to drill down? Say i want to use a multi-value parameter to show data for one or more specific years or months. Then the multivalue parameter would contain a list of years, with a + sign next to them, making it possible to drill down to the specific months.
Any help greatly appreciated.
Christopher
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
I've created a report with drill downs that are hidden initially. While viewing the report in preview, I'll expand the drill down to see the data.
If I go and print the report, the report is printed as collapsed (which is the initial setting) rather than expanded (which i expanded in the preview).
Is there a way to print in the "what-you-see-is-what-you-get" kinda way expanding and collapsing drill downs?
Thanks in advance!
1)i have drill through report..
a is the parent report..
b is the child/subreport ..
after i click link at parent report -(a), it will go to the child/sub report -(b),
but when i want back to parent report,dont have button back...
for your infromation,it will hapened when i deploy to server and use report viewer control from data tab in visual studio..
2)when i click the button print at child report(b) , but it will print the parent report, not the child report..
any setting for this problem?
thanks for reply..
thanks in advance...