Dropdownlist in Textfield like Excel 'autofilter'

I'd like to build a dropdownlist in the texfield which describes the columns. This dropdownlist should show all distinct values of the column like the 'autofilter' in excel. This sholuld be done directly in the report not as a parameter in the head. Any ideas ?
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=fb75b6199de248a2988f407b48fc9791
*****************************************Hi
This really interests me 2. Have you already received feedback on this issue?
Koen
"Psycho Dad via SQLMonster.com" wrote:
> I'd like to build a dropdownlist in the texfield which describes the columns. This dropdownlist should show all distinct values of the column like the 'autofilter' in excel. This sholuld be done directly in the report not as a parameter in the head. Any ideas ?
> *****************************************
> * This message was posted via http://www.sqlmonster.com
> *
> * Report spam or abuse by clicking the following URL:
> * http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=fb75b6199de248a2988f407b48fc9791
> *****************************************
>sql

Drop and Recreate Excel table

I'm having a heck of a time trying to upload data to an excel spreadsheet. This works perfectly in sql 2000 but I've been having problems with 2005

SSIS package "Package1.dtsx" starting.
Error: 0xC002F210 at Drop table(s) SQL Task, Execute SQL Task: Executing the query "drop table `GRE`
" failed with the following error: "Table 'xxx' does not exist.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Drop table(s) SQL Task
Error: 0xC002F210 at Preparation SQL Task, Execute SQL Task: Executing the query "CREATE TABLE `xxx` (
`TEST_REC_NBR` Decimal(29,0),
`PROCESS_DT_GRE` LongText
)
" failed with the following error: "Invalid precision for decimal data type.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Preparation SQL Task
SSIS package "Package1.dtsx" finished: Failure.

It looks like the problem is Decimal (29,0) - seems it is not a valid precision for excel. I tried a create table statement with Decimal (28,0) and it succeeded while Decimal(29,0) gave the same error. I think the maximum precision Excel supports for Decimal is 28.|||This is the output when I choose create and drop the table AND when I try to delete the rows. I've changed the field to decimal(28,0) also.
I can get around the problem by using a file system task and removing the file. This will work for what I'm doing but what if I need to delete only certain rows?
- Validating (Error)
Messages
Error 0xc001000e: {5143E747-D851-4E0F-9335-CCBF5E66371E}: The connection "DestinationConnectionOLEDB" is not found. This error is thrown by Connections collection when the specific connection element is not found.
(SQL Server Import and Export Wizard)
Error 0xc001000e: {5143E747-D851-4E0F-9335-CCBF5E66371E}: The connection "DestinationConnectionOLEDB" is not found. This error is thrown by Connections collection when the specific connection element is not found.
(SQL Server Import and Export Wizard)
Error 0xc00291eb: Drop table(s) SQL Task: Connection manager "DestinationConnectionOLEDB" does not exist.
(SQL Server Import and Export Wizard)
Error 0xc0024107: Drop table(s) SQL Task: There were errors during task validation.
(SQL Server Import and Export Wizard)

|||

I think you have hit a bug in Import Export Wizard, where the connection for the Execute SQL Task which drops the table is set incorrectly. I will investigate further.

|||

Ranjeeta wrote:

I think you have hit a bug in Import Export Wizard, where the connection for the Execute SQL Task which drops the table is set incorrectly. I will investigate further.

I am having trouble deleting Excel 2007 sheets programmatically. In the earlier versions of Excel, I used to open an ADO connection and executed some code like below

strSQL = "DROP TABLE NameOfExcelSheet;"

objCommand = New OleDb.OleDbCommand(strSQL, cnn)

objCommand.ExecuteNonQuery()

By executing the above code I could delete the sheet I wanted from an Excel workbook. But this method does NOT work with Excel 2007.

How can I programmatically delete sheets from an Excel 2007 workbook?

|||

Sorry... please ignore my previous comments and question.

strSQL = "DROP TABLE NameOfExcelSheet;" only clears the contects of an Excel sheet and does not delete the sheet itself on all versions of Excel.

Drop and Recreate Excel table

I'm having a heck of a time trying to upload data to an excel spreadsheet. This works perfectly in sql 2000 but I've been having problems with 2005

SSIS package "Package1.dtsx" starting.
Error: 0xC002F210 at Drop table(s) SQL Task, Execute SQL Task: Executing the query "drop table `GRE`
" failed with the following error: "Table 'xxx' does not exist.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Drop table(s) SQL Task
Error: 0xC002F210 at Preparation SQL Task, Execute SQL Task: Executing the query "CREATE TABLE `xxx` (
`TEST_REC_NBR` Decimal(29,0),
`PROCESS_DT_GRE` LongText
)
" failed with the following error: "Invalid precision for decimal data type.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Preparation SQL Task
SSIS package "Package1.dtsx" finished: Failure.

It looks like the problem is Decimal (29,0) - seems it is not a valid precision for excel. I tried a create table statement with Decimal (28,0) and it succeeded while Decimal(29,0) gave the same error. I think the maximum precision Excel supports for Decimal is 28.|||This is the output when I choose create and drop the table AND when I

try to delete the rows. I've changed the field to decimal(28,0)

also.

I can get around the problem by using a file system task

and removing the file. This will work for what I'm doing

but what if I need to delete only certain rows?

- Validating (Error)

Messages

Error 0xc001000e: {5143E747-D851-4E0F-9335-CCBF5E66371E}: The

connection "DestinationConnectionOLEDB" is not found. This error is

thrown by Connections collection when the specific connection element

is not found.

(SQL Server Import and Export Wizard)
Error 0xc001000e: {5143E747-D851-4E0F-9335-CCBF5E66371E}: The

connection "DestinationConnectionOLEDB" is not found. This error is

thrown by Connections collection when the specific connection element

is not found.

(SQL Server Import and Export Wizard)
Error 0xc00291eb: Drop table(s) SQL Task: Connection manager "DestinationConnectionOLEDB" does not exist.

(SQL Server Import and Export Wizard)
Error 0xc0024107: Drop table(s) SQL Task: There were errors during task validation.

(SQL Server Import and Export Wizard)|||

I think you have hit a bug in Import Export Wizard, where the connection for the Execute SQL Task which drops the table is set incorrectly. I will investigate further.

|||

Ranjeeta wrote:

I think you have hit a bug in Import Export Wizard, where the connection for the Execute SQL Task which drops the table is set incorrectly. I will investigate further.

I am having trouble deleting Excel 2007 sheets programmatically. In the earlier versions of Excel, I used to open an ADO connection and executed some code like below

strSQL = "DROP TABLE NameOfExcelSheet;"

objCommand = New OleDb.OleDbCommand(strSQL, cnn)

objCommand.ExecuteNonQuery()

By executing the above code I could delete the sheet I wanted from an Excel workbook. But this method does NOT work with Excel 2007.

How can I programmatically delete sheets from an Excel 2007 workbook?

|||

Sorry... please ignore my previous comments and question.

strSQL = "DROP TABLE NameOfExcelSheet;" only clears the contects of an Excel sheet and does not delete the sheet itself on all versions of Excel.

Drillthrough to AS2005 cube in excel

Hi,
I am trying to get the 'Drillthrough' feature working in excel 2003 (I
have an action set against my 2005 cube for drillthrough).
I can drillthrough fine in the cube browser but cannot get it to work
in excel.
If I double-click the cell I get an error and have read that I may need
to use the excel addin to do this. However, when I have installed the
addin and the 'required components' I can setup a connection to the
cube but when I try to connect get an error saying I do not have
permissions or my cube does not exist - both of which are false.
Anyone come across this and have a solution?
Thanks,
DarrenHi Darren,
Just write an DRILLTHROUGH MDX Query in Managamnet studio and see your
getting the data.
Let me know if your still having any issue.
Balaji
darrenmr2@.gmail.com wrote:
>Hi,
>I am trying to get the 'Drillthrough' feature working in excel 2003 (I
>have an action set against my 2005 cube for drillthrough).
>I can drillthrough fine in the cube browser but cannot get it to work
>in excel.
>If I double-click the cell I get an error and have read that I may need
>to use the excel addin to do this. However, when I have installed the
>addin and the 'required components' I can setup a connection to the
>cube but when I try to connect get an error saying I do not have
>permissions or my cube does not exist - both of which are false.
>Anyone come across this and have a solution?
>Thanks,
>Darren
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200602/1

drillthrough on a L30 Days Calculation in Excel - somehow?

I understand that calculated measures can't be coupled with drillthrough, but maybe there's another way.

I define a calculated measure with a L30 days flag that starts on the last day with order data. Now if I use this flag in conjunction with the Order Sales measure, then I can do a drillthrough. Problem is, with excel (2000 version), how could I get last 30 days w/o using the calculated measure?

Is there a way to define a measure with a combination of attribute filters that would allow drillthrough and also be accessible from excel and last but not entirely needed: have the definition housed in the AS project so that it's logic is centralized and reusable?

What version of the Analysis Services do you have?

What calculation do you use to determinate current date and last 30 days?

|||

I'm using ssas 2005 sp2

The calculation is: SUM([L30 Days].&[Yes], [Sales])

|||You could try setting up a many to many relationship although this might require having two date dimensions, one that is linked to the actual date and one that is linked via an intermediate measure group to itself and the previous 29 days. Marco Russo's whitepaper on many to many relationships at www.sqlbi.eu shows how drilltrhough works with many to many relationships.

Drillthrough in Excel 2003

Hi,
I set up drillthrough action in my cube in MS SQL 2000 AS and it's working
fine when I explore the cube with the cube browser in AS, but when I try to
invoke the drillthrough action in MS Excel 2003 I get an message the there
are no details to be displayed - it failes.
Does anyone know why? Maybe Excel doesn't support drillthroughs?
Thanks,
Marcin
Marcin Pksa wrote:
> Hi,
> I set up drillthrough action in my cube in MS SQL 2000 AS and it's working
> fine when I explore the cube with the cube browser in AS, but when I try to
> invoke the drillthrough action in MS Excel 2003 I get an message the there
> are no details to be displayed - it failes.
> Does anyone know why? Maybe Excel doesn't support drillthroughs?
> Thanks,
> Marcin
>
Right, not supported out-of-the-box. But there's some sample VBA code
you can get from the microsoft web site somewhere that shows how to
implement drill through as a right-click context menu.

Drillthrough in Excel 2003

Hi,
I set up drillthrough action in my cube in MS SQL 2000 AS and it's working
fine when I explore the cube with the cube browser in AS, but when I try to
invoke the drillthrough action in MS Excel 2003 I get an message the there
are no details to be displayed - it failes.
Does anyone know why? Maybe Excel doesn't support drillthroughs?
Thanks,
MarcinMarcin Pksa wrote:
> Hi,
> I set up drillthrough action in my cube in MS SQL 2000 AS and it's working
> fine when I explore the cube with the cube browser in AS, but when I try t
o
> invoke the drillthrough action in MS Excel 2003 I get an message the there
> are no details to be displayed - it failes.
> Does anyone know why? Maybe Excel doesn't support drillthroughs?
> Thanks,
> Marcin
>
Right, not supported out-of-the-box. But there's some sample VBA code
you can get from the microsoft web site somewhere that shows how to
implement drill through as a right-click context menu.

DrillThrough in Excel 2000

Hi all
I needed to provide OLAP drillthough for users with Excel 2000. There
are numerous threads on this topic - but no-one seems to have produced
the definitive work around.
So I made one myself and here it is. I based it on the extending OLAP
solution originally published on MSDN. It works most of the time, and
assumes that dimension members are not duplicated across levels.
Use this as a standalone workbook, an add-in or in a report workbook.
Paste this code into the code area of ThisWorkbook.
Add references to ADO and ADOMD.
I hope someone finds it useful.
Ian Bamforth
-- the code --
' This VBA macro is a modified version of an MSDN sample. The sample
was contained
' in an article titled "Extending Excel OLAP Functionality"
'
' Russ Whitney
' ProClarity Corporation
' August 15, 2003
'
'Minor Tweak IPB Sept 04 to work as standalone
'
'Rewite for Excel 2000 ipb March 20 2005 (removed PivotCell and
ADOconnection objects)
' Runs when the workbook is opened
Private Sub Workbook_Open()
Dim oPTCmdBar As CommandBar
Dim oPTCmdBarCntrl As CommandBarControl
Dim oPTDrillCmd As CommandBarControl
' Get a reference to the PivotTable's context menu
Set oPTCmdBar = Application.CommandBars("PivotTable context menu")
Set oPTDrillCmd = Nothing
' Check all the items in the context menu to see if we already
added our item
For Each oPTCmdBarCntrl In oPTCmdBar.Controls
If oPTCmdBarCntrl.Caption = "Drill to details2k" Then
Set oPTDrillCmd = oPTCmdBarCntrl
Exit For
End If
Next oPTCmdBarCntrl
' If our drill menu option was not already in the context menu then
add it
If oPTDrillCmd Is Nothing Then
Set oPTDrillCmd =
oPTCmdBar.Controls.Add(Type:=msoControlButton, temporary:=True)
oPTDrillCmd.Caption = "Drill to details2k"
End If
' Regardless of whether the item was on the menu or not, make sure
it runs the
' Drillthrough routine when it is selected
oPTDrillCmd.OnAction = "ThisWorkbook.Drillthrough2k"
End Sub
Private Function CreateDrillMdx2k(oCell As Range) As String
Dim sDrillMdx As String
Dim i As Integer
Dim iAxisNum As Integer
Dim iRowCol As Integer
Dim Mrow As Range, Mcol As Range
Dim McolLabel As String, MrowLabel As String
' The start of the query
sDrillMdx = "DRILLTHROUGH MAXROWS 1000 SELECT "
' Determine the dimension members on the row and column headers
matching this cell
'...take the row label adjacent to the data area
Set Mrow = Cells(oCell.Row, oCell.PivotTable.DataBodyRange.Column -
1)
'... and pick from the previous column if it is empty (ie the item
was drilled down) - allow up to 4 levels
For i = 0 To 3
McolLabel = Mrow.Offset(0, -i)
If McolLabel <> "" Then Exit For
Next
'...remove the word Total from the end of the label
If Right(McolLabel, 6) = " Total" Then McolLabel = Left(McolLabel,
Len(McolLabel) - 6)
'...repeat for the column label
Set Mcol = Cells(oCell.PivotTable.DataBodyRange.Row - 1,
oCell.Column)
For i = 0 To 3
MrowLabel = Mcol.Offset(-i, 0)
If MrowLabel <> "" Then Exit For
Next
If Right(MrowLabel, 6) = " Total" Then MrowLabel = Left(MrowLabel,
Len(MrowLabel) - 6)
'assume that the row and column labels are unique members of
dimensions
sDrillMdx = sDrillMdx & "{[" & MrowLabel & "]} ON " & 0 & ", "
sDrillMdx = sDrillMdx & "{[" & McolLabel & "]} ON " & 1 & ", "
iAxisNum = 2
Dim oPT As PivotTable
Dim pf As PivotField
Set oPT = oCell.PivotTable
'Set oPageFields = oPT.PageFields
' Add the member names for any paged dimensions
For Each pf In oPT.PageFields
sDrillMdx = sDrillMdx & "{" & pf.CurrentPageName & "} ON " &
iAxisNum & ", "
iAxisNum = iAxisNum + 1
Next
' Trim off the extra comma left by the last item appended to the
query
sDrillMdx = Left$(sDrillMdx, Len(sDrillMdx) - 2)
' Now add the cube name in the FROM clause
sDrillMdx = sDrillMdx & " FROM [" & oPT.PivotCache.CommandText &
"]"
' Return the MDX statement
CreateDrillMdx2k = sDrillMdx
End Function
Public Sub Drillthrough2k()
On Error GoTo errh
Dim oCell As Range
Dim opTItem As PivotItem
Dim oPT As PivotTable
Dim oOlapConn As New ADODB.Connection
Dim sDrillMdx As String
Dim oRecordSet As New ADODB.Recordset
Dim oSheet As Worksheet
Dim oQueryTable As QueryTable
Dim Mdrill As Boolean
Set oCell = ActiveCell
If WorksheetFunction.IsText(oCell) Then MsgBox "You should choose a
number that you wish to drillThrough": Exit Sub
Set oPT = oCell.PivotTable
'Set oOlapConn = oPT.PivotCache.ADOConnection
'NOT available in Excel 2K so we create new
'resolve ADO connection string by removing "OLAP;" from pivot cache
connection
oOlapConn.ConnectionString = Mid(oPT.PivotCache.Connection, 7, 150)
' Create the MDX Drillthrough statement
sDrillMdx = CreateDrillMdx2k(oCell)
oOlapConn.Open
' Execute the Drillthrough statement to get a recordset
oRecordSet.Source = sDrillMdx
oRecordSet.ActiveConnection = oOlapConn
oRecordSet.Open
' Create a new worksheet and add the drillthrough results
For Each oSheet In ActiveWorkbook.Sheets
If oSheet.Name = "DrillThrough" Then
Mdrill = True
oSheet.Activate
Cells(ActiveCell.SpecialCells(xlLastCell).Row + 2, 1).Activate
Exit For
End If
Next
If Not (Mdrill) Then
Set oSheet = ActiveWorkbook.Sheets.Add
oSheet.Name = "DrillThrough"
End If
ActiveCell = sDrillMdx
Set oQueryTable = oSheet.QueryTables.Add(oRecordSet,
ActiveCell.Cells(2, 1))
oQueryTable.Refresh
Exit Sub
errh:
MsgBox Error, vbInformation
End SubIan,
Thanks! Works well.
I have a question that will show my ignorance of cubes. Does doing a
"drillthrough" take you to the details stored in the cube, or does it
take you all the way back to the data warehouse?
TIA
JOHolloway
bammers99 wrote:
> Hi all
> I needed to provide OLAP drillthough for users with Excel 2000.
There
> are numerous threads on this topic - but no-one seems to have
produced
> the definitive work around.
> So I made one myself and here it is. I based it on the extending
OLAP
> solution originally published on MSDN. It works most of the time,
and
> assumes that dimension members are not duplicated across levels.
> Use this as a standalone workbook, an add-in or in a report workbook.
> Paste this code into the code area of ThisWorkbook.
> Add references to ADO and ADOMD.
> I hope someone finds it useful.
> Ian Bamforth|||Hi John
All the way back to the warehouse ...
- without needing to grant users logon rights to the SQL database
- In the Analysis Manager dialog, you can see all the columns in the
tables participating in the cube - and add others! You are not simply
resticted to fields assigned to measures and dimensions
misterholloway@.yahoo.com wrote:[vbcol=seagreen]
> Ian,
> Thanks! Works well.
> I have a question that will show my ignorance of cubes. Does doing a
> "drillthrough" take you to the details stored in the cube, or does it
> take you all the way back to the data warehouse?
> TIA
>
> JOHolloway
>
> bammers99 wrote:
> There
> produced
> OLAP
> and
workbook.[vbcol=seagreen]|||Ok John:
But you need to define the drill-throught query and options in the Analysis
Services... no?
Thanks
Rodrigo
"bammers99" wrote:

> Hi John
> All the way back to the warehouse ...
> - without needing to grant users logon rights to the SQL database
> - In the Analysis Manager dialog, you can see all the columns in the
> tables participating in the cube - and add others! You are not simply
> resticted to fields assigned to measures and dimensions
>
> misterholloway@.yahoo.com wrote:
> workbook.
>

Drillthrough Functionality via Excel Add-in

Hi,

I'm using the Analysis Services Excel Add-In to query a Cube built with partitions.

When using the drilldown functionality for my current\default partition the function seems to work fine.

However, when I try to drilldown on data in the other partitions, the following error message appears:

"Unable to Drillthrough on this Cell"

Would someone please be able to shed some light on this?

Many Thanks

Jonathan Derbyshire

Jonathan_Derbyshire@.Hotmail.com

We have the same problem (also using OWC controls). do you have the solution?
if yes, please, let me know.
Thanks

Carlos
tfcarlos@.hotmail.com
|||No I'm still stuck.

If anyone can help I would be very grateful...

Thanks

Jon Derbyshire|||I think Excell can't drillthrough over partitiones.
I'm not sure but if you have more than 1 partition you can't drillthrough. Did you try to execute the drillthrough query against an ado connection?
It's a large cube?
Do you have to show many columns in drillthrough?
Because you can make some calculated measures to solve this (be carefull with the result).|||Why do you think that Excel cant drillthrough over partitions? Have you read this somewehere or are you just speculating?

I can drillthrough - but only on the current/default partition...

Its a Medium to large cube.

Drillthrough shows about 20 columns, but I've tried limiting it to 5 and still the same error.|||I'm speculating.
But I found the solution:
In addition to enabling drillthrough at the cube level, you can also modify the options on each individual partition in cubes that contain more than one partition. You can access a dialog box analogous to the one in Figure B through the Partition Wizard—to access the Partition Wizard, right-click the partition and select Edit from the context menu—by clicking the Advanced Settings button and Drillthrough Options. The resulting Partition Drillthrough Options dialog box lets you change the columns and filter to use when creating drillthrough data from that partition. The ability to set drillthrough options on individual partitions means that if you execute a drillthrough operation on a cell that aggregates data from more than one partition, each partition returns its own result set and the columns in those result sets can differ from one another. Application developers need to be aware of this behavior so that they can display the results accordingly. The administrator's next task, configuring drillthrough security, requires that you use the Cube Role Manager dialog box and click the Drillthrough setting for the role you want to grant access to. Each role has a security setting, called Allow Drillthrough, that you can select to let that role execute the queries that perform a drillthrough operation. After you enable drillthrough and configure security, you can implement drillthrough for applications.
Text From Implementing Drillthrough for Developers in http://www.windowsitpro.com/Articles/Print.cfm?ArticleID=41679|||Thanks - I've been through and it appears that drillthrough was already definitely enabled...

It still doesnt enable me to drillthrough as I wish. I've posted my question on the site you provided in an attempt for more help.|||I want to ask you.
Are you using sql 2000 or sql 2005?
If you are using sql 2005, are you connecting from excel in the server or in a remote computer?
If you are connecting from a remote computer, what have you installed in the computer to making it works?
I can't connect from a remote computer with excel to AS 2005.
Thanks in advance|||2000 version

drill-down in excel format

dear all,

anyone know how to make a report using RS to create a drill-down with chart in excel format?

meaning i need a report showing in chat format in excel. and then i also able to drill-down the report. and the chat figure will change follow the drill.

Hello,

The Excel renderer generates charts as static images, not as Excel charts. If you want live Excel charts that update when you change the source data, you should use SoftArtisans OfficeWriter (http://officewriter.softartisans.com).

-Chris

|||

tat is a tools to generate report right?

i not looking for a tools, but i looking a way to settle it. because i got the reporting service at my company already. management will not spend other fund to buy other software.

so any walkaround?

|||

There is no workaround without a third-party tool. The native Excel renderer always exports charts as static images. Even if the Excel renderer did export real Excel charts, Excel itself doesn't support the notion of hyperlink actions when clicking on parts of a chart.

-Chris

|||

so this mean only can use the third-party tool to read data from the database directly?

so in this case the microsoft RS is not able to use. am i right?

|||

Now I'm confused about what your goal is. What exactly is your requirement? Can you please explain it again?

I thought you were trying to export charts to Excel that you can click on and be drilled through to different targets depending on where in the chart you clicked.

What do you mean "read data from the database directly"?

-Chris

drilldown in excel and PDF

I have a report that has the drilldown function in it with the +/-
sign. When I export the report to excel or PDF, the drilldown
functionality is lost and I am not able to view the info at the lower
level's.
If I expand all the drilldown's and export it, then all the info shows
but the +/- still doesn't show up in excel or PDF.
I am currently running RS SP2.
does anyone know the reason why it's doing this?That is the way those types are rendered. They do not have the drill down
capability.
"bevarg" <benovarghese@.gmail.com> wrote in message
news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
>I have a report that has the drilldown function in it with the +/-
> sign. When I export the report to excel or PDF, the drilldown
> functionality is lost and I am not able to view the info at the lower
> level's.
> If I expand all the drilldown's and export it, then all the info shows
> but the +/- still doesn't show up in excel or PDF.
> I am currently running RS SP2.
> does anyone know the reason why it's doing this?
>|||Something has to be wrong...
For starters:
PDF files will ONLY show the report exactly how it looks - i.e. if some
components are collapsed, and others expanded, then that is EXACTLY what you
get when you export to PDF.
EXCEL on the other hand WILL show drill-downs and carry that
functionality into the excel workbook itself. I.e. You can after exporting
into Excel drill-down into your data or collapsed as if you were on the
report server web page viewing this report.
One of the issues with Excel drill downs is when people use a SubReport.
Subreports do not render into Excel at all. (Pisses me off of course) :) Are
you using a subreport?
=-Chris
"bevarg" <benovarghese@.gmail.com> wrote in message
news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
>I have a report that has the drilldown function in it with the +/-
> sign. When I export the report to excel or PDF, the drilldown
> functionality is lost and I am not able to view the info at the lower
> level's.
> If I expand all the drilldown's and export it, then all the info shows
> but the +/- still doesn't show up in excel or PDF.
> I am currently running RS SP2.
> does anyone know the reason why it's doing this?
>|||no, all the data is part of the same report.
basically, the root level shows a customer's name and their financial
info and when the user clicks on the drilldown +/- it's supposed to
show the customer's address info. All of the info come from the same
dataset or query.
I wonder if it has anything to do with SP2.
Chris Conner wrote:
> Something has to be wrong...
> For starters:
> PDF files will ONLY show the report exactly how it looks - i.e. if some
> components are collapsed, and others expanded, then that is EXACTLY what you
> get when you export to PDF.
> EXCEL on the other hand WILL show drill-downs and carry that
> functionality into the excel workbook itself. I.e. You can after exporting
> into Excel drill-down into your data or collapsed as if you were on the
> report server web page viewing this report.
> One of the issues with Excel drill downs is when people use a SubReport.
> Subreports do not render into Excel at all. (Pisses me off of course) :) Are
> you using a subreport?
> =-Chris
> "bevarg" <benovarghese@.gmail.com> wrote in message
> news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
> >I have a report that has the drilldown function in it with the +/-
> > sign. When I export the report to excel or PDF, the drilldown
> > functionality is lost and I am not able to view the info at the lower
> > level's.
> > If I expand all the drilldown's and export it, then all the info shows
> > but the +/- still doesn't show up in excel or PDF.
> > I am currently running RS SP2.
> >
> > does anyone know the reason why it's doing this?
> >|||Has chris said it works fine with excel. Sometimes we miss out simple things,
Just in case , in excel the + sign ie grouping happens and it is extreme left
side of the sheet or the screen itself. hope you noticed this. If it is still
not there.
Amarnath
"bevarg" wrote:
> no, all the data is part of the same report.
> basically, the root level shows a customer's name and their financial
> info and when the user clicks on the drilldown +/- it's supposed to
> show the customer's address info. All of the info come from the same
> dataset or query.
> I wonder if it has anything to do with SP2.
>
> Chris Conner wrote:
> > Something has to be wrong...
> >
> > For starters:
> > PDF files will ONLY show the report exactly how it looks - i.e. if some
> > components are collapsed, and others expanded, then that is EXACTLY what you
> > get when you export to PDF.
> >
> > EXCEL on the other hand WILL show drill-downs and carry that
> > functionality into the excel workbook itself. I.e. You can after exporting
> > into Excel drill-down into your data or collapsed as if you were on the
> > report server web page viewing this report.
> >
> > One of the issues with Excel drill downs is when people use a SubReport.
> > Subreports do not render into Excel at all. (Pisses me off of course) :) Are
> > you using a subreport?
> >
> > =-Chris
> >
> > "bevarg" <benovarghese@.gmail.com> wrote in message
> > news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
> > >I have a report that has the drilldown function in it with the +/-
> > > sign. When I export the report to excel or PDF, the drilldown
> > > functionality is lost and I am not able to view the info at the lower
> > > level's.
> > > If I expand all the drilldown's and export it, then all the info shows
> > > but the +/- still doesn't show up in excel or PDF.
> > > I am currently running RS SP2.
> > >
> > > does anyone know the reason why it's doing this?
> > >
>