Hi
I am having a peculiar problem. Drill through on Charts is not working on certain users machines. Drill through on tables is however working on all the user machines.
I checked IE security setting on users machines. But could not figure out what is causing the problem. Some one please help.
Regards
Bobba.
I've seen many posts about lack of non-IE browser compatibility, but still no solution (MyIEtab ISN'T a solution). The CSS fix solves it partially, but not completely, and the fix of putting a rectangle in the top is just a joke.
Currently my reports can't be browsed by Firefox and other Mac browsers, and that's going to be a stopper for further using of SSRS in the future in my company. I was expecting SP2 to do something about this, but it hasn't solved anything. I'm sure it's a very easy patch for MS, but by maintaining this (artificial?) limitation they're going to make us move from SSRS and even the full SQL Server stack for future projects.
Any other *real* solution, other than CSS and big rectangle in the top of the report?
Hi All,
I've looked around but can't seem to find an answer for this.
I have a cube that has a fairly large time dimension (going back to 1949) as the data demands this.
When a user is browsing the cube and applies a filter or adds the a time heirarchy as a value it's always sorted from oldest to newest. Whilst the need is there to look at data from 1949 most people want to look at the last few years. The problem is they have to scroll right down the list to get to this. Is there a way of having the most recent years of the time dimension appear first in these lists to make them more accessable?
I hope that makes sense!
Any help would be appreciated.
Thanks
yayomayn
Hi all
I'm working on a project where we've developed a number of reports using SQL Reporting Services. Everything works fine on the developer PCs and when they cannect to the reporting services URL they can see all the reports listed and everything works fine. When the testers connect, they can see the basic reporting services homepage with the contents and properties tabs. But when they click on the contents tab nothing is displayed.
The tester pcs are locked down and the user profiles wouldnt have the same access rights as the developers who are all local admins on their PCs.
My question is what would prevent the reports from being listed? Is there an activex control that is possibly being blocked by the local security policy for the tester profiles? If this is the case is there anything that can be pre installed on the client pcs to get around this problem?
Any thoughts or assistance that anyone could provide would be grately approeciated
Thanks
Mark
Hi,
we have a requirement that, when we click on the multiple series bars in a SSRS chart, it should drill through that chart and the detail report should filter based on these x axis and y axis of the bars selected.
As far as my knowledge, we can drill through the chart by selecting single series bar at a time in SSRS. Is there any way to acheive this multiple drill through of a chart.
Thanks
Raghava
I am able to drill down a pivot graph in sharepoint's power pivot gallery using left mouse then magnefying glass (quick explore) but how on earth do i drill up again??? Using ie back brings the original report not the last drill i was at...
View 6 Replies View RelatedHi 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
Hi everyone,
I am currently using SSRS 2000. I have a chart that shows everything that we have shipped by specific part number. The Y axis displays the quantity and X axis shows the date. Well, the X axis I grouped it by year then by month, so it can display Jan 04, Dec 05, Mar 07, etc. but all I get is the year. How can I format it, or do so it can display that format????
Thanks ahead of time,
Abner
We developed some of the chart reports. It is working fine when we preview the reports in the solution itself. After deployment to reportserver, when we access the same report, It is showing empty rectangle box (border of chart body). We have already checked data source/ Dataset mapping for the report.
View 3 Replies View Related
Hello All,
I have a reporting services report in the form of a chart. I have two datafields on the chart.
I need to be able to dynamically hide one datafield and view the chart for the other one and vice versa.
How do I do this ?
Any help would be appreciated..
Thanks!
When I export the report in excel format the chart is displayed as picture. I want it to be displayed as editable chart.Does Office Writer work in this situation and did anyone use Office Writer to accomplish same type of problem.Is there any other method or product we can use instead of the office writer.
View 2 Replies View RelatedI have a report designed in SSRS 2008 R2.My issue is that the data labels do not stay outside the bars for high values.
View 4 Replies View RelatedI need to create a chart with the following features
1) Bar chart that has data for 3 years (3 series)
2) Line chart that has the same data as per the above points on the bar chart but this is a running total. (3 series)
3) These data points are for the 12 months
4) there should be a secondary axis for the cumulative one
Can I create this using the same data set?
Can 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 Guys..
i don't know weather is it possible or not..but Can any One tell's me How can i refresh the Chart Values.. acutally what's happening..
i have two Chart in a reprot .. One is Main Category and other one is SubCategory... acutally what i want.. in Main Category chart sum of Quantities of Subcategory values comes in bar or any other format.. and when i click on Main chart any bar it's refresh the other chart and return the result of subcategory under that main category in details...
i don't know is this possible .. acutally i m very new in reproting.. infact that's my first report.. so i want to do this.. if any article or any help anyone can provide me..
Thanks
Hi,
I am not getting Mining Accuracy Chart and Min ing Model Prediction
Plz tel me how to do.And how to use the filter input data used to generate the lift chart and
select predictable mining model columns to show in the lift chart
hi
I had a view in which I did something like this
isnull(fld,val) as 'alias'
when I assign a value to this in the client (vb 6.0) it works ok in sql2000 but fails in 2005.
When I change the query to fld as 'alias' then it works ok in sql 2005 .
why ?? I still have sql 2000 (8.0) compatability.
Also some queries which are pretty badly written run on sql 2000 but dont run at all in sql 2005 ???
any clues or answers ?? it is some configuration issue ?
Thanks in advance.
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