Turn Report Auto-scroll Feature Off When Toggling Drill-down

Aug 9, 2007

Is there a way to turn IE7's auto scroll off so that every time you drill down by clicking on one of the "+" toggle buttons the report doesn't recenter itself. We find this window jumping/scrolling highly annoying to watch.

This problem does NOT occur in FFox, just Microsoft's browsers.

We are displaying this report running on another server running Visual Studio 2005's ReportViewer control in an aspx (ASP.NET) page.

We are using SSRS 2005, std edition.
FFox 2.0.0.6, IE7.

Will be glad to post more info if requested.

View 30 Replies


ADVERTISEMENT

How To Enable Auto-scroll By Middle Clicking

Oct 8, 2015

In SQL Server 2008 when I click the middle button I could scroll up and down(scroll wheel) by just flicking the mouse. We just upgraded to 2012 and I can't do that on my Lenovo ThinkPad. I am using an external wired usb mouse(Intelli Mouse) to scroll.

I have SQL server 2008 and 2012 installed on the same machine scrolling works in 2008 but not in 2012.

View 5 Replies View Related

Scroll Bar In Report Viewer

Oct 16, 2007



How can i show scroll bar in winform report viewer.?
I have set Auscroll = true..
But that didnt effect

View 1 Replies View Related

BIDS - How To Turn-off Auto Naming Of Fields

Mar 2, 2007

Hi:

When I create a report, the wizard auto-renames fields.

E.g. if Table_COLUMN_Name=CustomerName, the list column header in the report will change to Customer Name. The wizard figures out Friendly names based on capitalization, and underscores and so on.

Similar behavior occurs even in SSAS projects Dimensions Wizard.

Is there a way to turn of this extra cuteness?

TIA

Kar

 

View 1 Replies View Related

This Feature Remote Access To Report Data Sources And/or The Report Server Database Is Not Supported In This Edition Of Report

Jun 16, 2006

SQL server 2005 express reporting problem.

error message:

This feature "remote access to report data sources and/or the report server database" is not supported in this edition of reporting service

I got this error message when I try to connect to database hosted in another PC running SQL server 2000.

Is it true that SQlL server Express can only use Local Database Engine to host the database?



View 5 Replies View Related

Auto-expand Drill-downs On Print

Feb 6, 2008



Yet another newbie question here in my quest to learn reporting services.

Is there a property I can set to automatically expand all drill-downs when a user goes to print a report? As it is now all the drill-downs remain collapsed when the user goes to print, which is problematic on large reports where there may be many records between groupings (users may expand one group containing 1000's of records, and then decide to simply print everything -- but they'll only get the expanded data -- I'd like to expand everything automatically and have it all print.)

Thanks,

View 3 Replies View Related

Reporting Services :: Row Group Totals On A Drill Down Report Builder Report

Oct 28, 2015

I have a report builder drill down report. I have row groups with totals.    It looks like the attached.   The problem is when the report is not expanded the Grand Totals column is not accurate... it is displaying the totals of one of the rows when expanded.The expression in the Total Show text box is

= Switch (                                                                      
MID(Fields!protocol_id.Value,1,7)="THERAPY",                    
                                         Sum(IIF(Fields!status.Value = "CO", CDbl(Fields!TX_CO.Value),           Nothing)),
  MID(Fields!protocol_id.Value,1,7) = "GENERAL" and                                                  MID(Fields!program_id.Value,1,6)
= "INTAKE",                                                        Sum(IIF(Fields!status.Value = "CO",

[code]...

Is there any way to not display the expression in the Total columns unless the report is expanded?

View 2 Replies View Related

Reporting Services :: Passing Cascaded Parameters From Main Report To Drill Through Report In SSRS?

Sep 16, 2015

I am trying to develop a report from cube,and it has one drill through report.when i click on sales amount field on main report,then it open the drill through report with details.Here i passed the **(category,subcat,product)parameters(Cascaded)** to drill through report in action part of main report.In my main report i have two columns .

columns are **Level**  and              **Salesamount**.  

Values are like  

**[-]category**              **100**
    **[-]subcat**             **50**
         **product**          **30**

when i click on 100, parameters are passed & it open the detail report correctly, but when i click on 50,the values for subcat parameter is not getting values in detail report and same as the product also.

Here i used the expressions in parameter values

**pCategory**----iif(inscope(category),!fields.category.value,split(join(Parameters!category.value,","),","))

**psubcat**----iif(inscope(subcat),!fields.subcat.value,split(join(Parameters!subcat.value,","),","))

**pproduct**----iif(inscope(product),!fields.product.value,split(join(Parameters!product.value,","),","))

View 3 Replies View Related

Reporting Services :: TFS Ssrs Report For WorkItemType Drill Down Report

Oct 2, 2015

I need to create a SSRS report using the Warehouse tfs_warehouse DB Report need to be drill down on WorkItemType Parents and child values. So, If we click on Product Back Log Item will get all the tasks inside it and so on....

------->Product BackLog items
                          ----------> Bugs Or Tasks
                                                -----------> Tasks

I have done research and found out how to do it in OLAP cube ..but still can't figure out the TSQL query to be used.Found one of the query on forum:

SELECT * FROM DimWorkItem DWI
INNER JOIN FactWorkItemLinkHistory FWILH ON DWI.System_Id = FWILH.TargetWorkItemID
WHERE FWILH.WorkItemLinkTypeSK IN (SELECT DWILT.WorkItemLinkTypeSK FROM DimWorkItemLinkType DWILT WHERE DWILT.LinkName = N'Child')
AND DWI.System_WorkItemType = N'Task'
AND DWI.System_Rev = (SELECT MAX(DWI1.System_Rev) FROM DimWorkItem DWI1 WHERE DWI1.System_Id = DWI.System_Id)
AND FWILH.SourceWorkItemID IN (SELECT DWI2.System_Id FROM DimWorkItem DWI2 WHERE DWI2.System_WorkItemType = N'Bug');

View 5 Replies View Related

Report Model: Drill On Calculated Field In Report Builder

Feb 11, 2007

Hi,

I've created dsv that contain all fields from table database. in the smdl I've remove some fileds due to security. All fields in the smdl do not contain drill.

Issue: When I created calculated field in the report builder the field has a link. When I clicked the drill I saw all the record data including field that not in the smdl.

Questions:

1) Can I remove the link from the calculated fields?

2) Can I prevent from users drill to fields that not in the smdl?

Thanks,

Assaf

View 1 Replies View Related

Cannot Drill Down On Drillable Column From Report Builder Report

Mar 12, 2008

I deployed the same report model to 2 different SSRS servers. The report only has 1 field with count of records from 1 table. I can drill down on this column on 1 server, but not on the other server. This column is set to drillabe on the report model.

Is there any SSRS configuration that is stopping me drilling down on it?

View 1 Replies View Related

How To Turn On Report Builder

Dec 11, 2007

Hi.
I setup a group on report service and give this group "Brower, My reports, report builder" permision, but I can't found report builder on client. does anybody can help?

Thanks

View 3 Replies View Related

My Report Feature

Jun 22, 2007

Currently - our Reporting Services site is setup so that all Domain Users can access it. We are starting to use Report Builder now. I have enabled the My Reports folder feature that that creates a user folder for anyone that logs onto the site. Is there a way to just create the user folders for certain people?



View 1 Replies View Related

Need Help With Report Feature

Nov 15, 2007

Hi!
I am having a terrible time with the report feature. First of all, my queries through it do not match my queries thru SQL server 2005 Express Management. When I enter my fields, through the auto query function, it moves them. When I try to put them where I think they belong (by editing the SQL code, my queries get all messed up).

Is there a way to import my SQL query and run it through the report feature?

I am using windows XP Pro
Microsoft Visual Studio 2005 version 8.0.50727.42
Microsoft SQL Server Reporting Services Designers version 9.00.2047.00

Thank You so much......









View 1 Replies View Related

Drill Through Report

Jun 5, 2007

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

View 1 Replies View Related

When Exporting To Excel Unable To Turn Of The Hyperlink Report Export

Sep 20, 2007

Hello, I have a report that enables drilldown to another report through the hyperlink jump to report option in the navigation properties of the cell. The thing is I need the report to only export what the users see on the screen, which means that if the report's cell is not expanded to another report then only the current report needs to be exported. The export option will currently export all data down to last drilldown. Any suggestions?

View 2 Replies View Related

Drill Down Report Using Report Sevices

May 8, 2007



Hi all



I am new in Sql Server reporting services ..So please help me to clarify my doubt



Please help me to know whether it is possible to generate a drill down report using Report sevices. If it possible please let me know how it can be generated



For Example



Measures

Quarter1 Quarter2 Quarter3#

Profit Profit Profit

====================================================================================

Dimension

Product1 200.50 1500.75 -200.40

Product2 5000.00 4000.00 6000.00

==================================================================================





In the above example Quarter 3 for product 1 shows los in such cases I want to drill down the transaction to get the detailed inormation and to find out the reason how the loss came..



Please help me to get such type of drill down is possible in measures to get the detailed report



With regards



Polachan

View 4 Replies View Related

MAtrix Report With Drill-through

Mar 13, 2007

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

View 1 Replies View Related

Problem In Drill Through Report ....

Nov 7, 2007



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...

View 3 Replies View Related

Drill Down In A Matrix Report

Jan 8, 2007

is it possible to have drill down feature in matrix report?

A B C
x 1 0 1
y 2 2 2
z 4 0 7


What would be nice is if the user clicked on "7" and a report opened showing the detail for that value.

View 1 Replies View Related

Creating A Drill-through Report

Sep 21, 2007



I'm building my report using the Report Designer in the SQL Server Business Intelligence Development Studio. At the moment I've got a single report which consists of 2 tables. The top table shows some summary data and the bottom table shows more detail.


What I'd like to do is design the report so that when the summary data (in the top table) appears, the user can click on a row in the table and this takes them to a new screen which shows more detail about that item, extracted from the bottom table.

Is this possible? I know it's possible to create a drill-through report if you have the high-level summary data in one report and the low-level detailed data in a separate report, but is it possible to create a drill-through report if all the data is in one single report (albeit in 2 separate tables)?

View 6 Replies View Related

Drill-through To A Report In Another Project

May 14, 2007

Hello All,



I am sure many people faced this problem before. I want to drill-through to a report in another project. I want to use "Jump to report" in the navigation tab.



I am able to use Jump to URL. But I cound not specify "method="post" target="_self" in the "Jump to URL" box.



Can some one help me on how to use:

1. "Jump to Report" for reports in another project.

2. Or. Help me specify method="post" target="_self"



Regards

Bobba

View 1 Replies View Related

Nested Drill Down Report.

Mar 21, 2008

Hi,

I want to create the report with following requirements.

I want to have the following fields in the drill down

India
Sales report
Expense report
Analysis report
USA
Sales report
Expense report
Analysis Report

UK
....
If I am clicking any country, it should show the sub report. If I click the sub report, it should show the appropriate report. please help me. thanks in advance

View 3 Replies View Related

Does RS Allow Any Kind Of Hover Over Feature In A Rendered Report And/or Param Prompt?

Dec 6, 2007

does RS allow a report to be built such that after user runs it, hovering over a particular piece of info could display some variable piece of info similar to tooltips, intellisense etc?

How about a tip to the user if he/she hovers over a parameter prompt?

View 4 Replies View Related

Drill Down Report For SSRS 2000

Feb 26, 2008

Does anyone have a link to a good tutorial on how to create a drill down report in SSRS 2000. I found one for SSRS 2005
http://www.c-sharpcorner.com/UploadFile/MohanKumar.R/DrillDownReport02212008083910AM/DrillDownReport.aspx
If I had the AdventureWorks Db I may be able to figure it out.

I know how to create a hyperlink but I need the toggle (+/-) for my latest endeavor.

My book "Hitchhikers Guide..." didn't help me out.

Thanks.

View 3 Replies View Related

Cannot Pass 'All' As A Parameter To A Drill-through Report

Jun 7, 2007

Hello,



I have a main report that drills-through to a secondary report. The main report has parameters which can be selected (Dairy, Frozen, Fruits, etc.). If I make a selection (let's say Fruits) the second report displays just Fruits information (as would be expected).



However, when I select 'All' from the parameter, on the Main report, and then click to drill-through, the passed parameter is the first selection below 'All.' I cannot seem to pass 'All' to the second report.



What am I doing wrong?



Thank you for the help.



-Gumbatman



p.s. The datasets are based on an Analysis Services cube.

View 1 Replies View Related

Is There A Way To Have A Hide All/Show All In Drill-down Report ?

Apr 10, 2007

Hi all,



I was wondering whether there was a way to implement a "Hide all/show all" option in the report. are there any examples that I could refer to ?



Thanks !

Bernard

View 8 Replies View Related

Drill Down Leads To Jump In Report

Oct 24, 2007

Hi all,


We are developing some reports in Reporting Services 2005 (deployed in Sharepoint). We are having a bit of a problem with the drill down functionality:

When drilling, the report page "jumps", repositioning itself so that the item I drilled is at the top of the page. Not what I wanted, I want it to expand the item without repositioning it.

So, any ideas on what my problem is? I am in kind of a hurry to fix this problem (as always ...).


Regards,
Daniel

View 7 Replies View Related

Drill Through Report Problem - Too Many Parameters?

May 13, 2008

I am having an issue with a drill through report. I have a parent report with 12 parameters that drills through to a report with a single parameter. The parent reports runs fine and the drill through works fine.

The problem occurs when I hit the browser back button to return to the parent report. The parent report will start to refresh (I see activity in the status bar) but then I just get an endless 'Report is being generated' message. If the report refresh button is hit then the report will come up (I would expect this to happen). I can't expect the users to have to continually
hit the report refresh button when returning to the parent report.

The report and drill through works fine in Visual Studio and this probelm is only apparent when testing through IE7.

Anyone have any ideas about this? Out of curiosity is there a limit to how many parameters can be used in a report? I can't find any reference to this in any SSRS literature.

Thanks
Ray

View 1 Replies View Related

Why Does A Drill-through Report Cause An Out Of Memory Error

Apr 11, 2008



I have a report with a matrix object within which I can "drill-down" through several row and column groups. The report runs, and I can successfully "drill-down" within the matrix object.

However, when I create a drill-through action that executes another report when users click on the summed number of the matrix object, the main report fails with an out of memory error. When I remove the drill-through action, the report runs successfully again. This report is important because the users need to use it to get the detailed records from the main report.

Why is this happening? Does adding the drill-through links really use up that much memory?

Is there anything I can do to correct this problem, besides play with server memory settings and/or upgrade to 64 bit? I have already passed as much of the aggregation as I can to the database; in fact, the query for the main report only pulls 1000 records!

I refuse to create an intermediary drill-through report, since the whole reason I created the first drill-through report was because the main report can't handle the detail in the first place.


Thanks.

View 4 Replies View Related

Drill Down Report Spacing Issue

Apr 16, 2007

I have created a drill down report, using text boxes. When the report is not drilled down, all root nodes are collapsed, the spacing is really weird between them. For
example.


+ Node A
+ Node B


<a bunch of white space>


+ NodeC.


I want all the nodes to be one after each other. Thanks for any help you can provide.

View 1 Replies View Related

Passing A Report Group In Drill Through Parameter

Mar 24, 2008

Hi all;

Could any body tell me as to how I would be able to pass report grouping in drill through report.

Please review the diagram below to better understand my problem


Report 1 (Summary) Columns1 Column 2

Row-1:Grouped by attribute X Calculation based of dates Calculation based of dates
Row-2: Grouped by attribute Y Calculation based of dates Calculation based of dates

The Drill thru option should be present in all of the columns; so that, when any of the numbers in the column are clicked it should drill through to another report which should show all the records pertaining to all the values in X1



Report 2 (Details) Report 3 ((Details)
X1 Y1
X2 Y2
X3 -
X4 -
X5 -
- Yn
-
-
-
Xn
What I did so far was to pass the report parmeter in report 1 as "Fields! attribute X ,Value" and same for Y
The problem with is that only the first value of the group that satisfies condition gets passed on to the detail reports. Kindly let me know were I am going wrong and what should I be doing.
Awaiting your opinions
Thanks and Regards
GM

View 4 Replies View Related

Two Independent Drill Downs In Matrix Report

Jan 16, 2007

I have defined the following to generate a matrix report

1. Row data: Country,region,state,Race,gender

(Red colored columns - Group1;

Blue colored columns - Group 2)

2. Column Data: Statistics as of (Date)

3. Value: household income

I'd like to be able to have a seperate drilldowns on group1 and group2. i.e drilling down on country, region, state shouldn't automatically expand/minimize race and gender. I played with the attributes of individual columns and edit groups of the same. But couldn't achive an independent drill down.

Income as of '05 Income as of '06

Country Region State Race Gender 100k 105k



Having independent drilldown on the group1 and 2 enables us to find out, for example, how many hispanics live in the region west coast. (in a typical tree like drill down, you need to expand country, region and state to get to Race)

How can create an independent drilldown on group1 and group2?

View 5 Replies View Related







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