Drill-through report passing credentials

Is it possible to drill through to a report that does not have embeded credentials? Every time I link from a report that requires a sql username and password to run to another report that requires the same permissions, I recieve an error message stating: "One

or more data sources is missing credentials" Is there a way to make RS prompt the end user to re-enter credentials after drilling through to the next report, or to make the credentials entered to access the first report pass through to the second report? The drilling through works perfectally from within visual studio, but fails to work when the report is viewed in IE.Did you ever fix this problem? I am having the same problem. It works fine when run in Visual Studio but then on the server it does not prompt again for the credentials when drilling through to the next report. My email is scriptjunk3@.hotmail.com. If you did fix this or get an answer, please let me know here or at my email. Thank you.

Drill-through report passing credentials

Is it possible to drill through to a report that does not have embeded credentials? Every time I link from a report that requires a sql username and password to run to another report that requires the same permissions, I recieve an error message stating: "One or more data sources is missing credentials" Is there a way to make RS prompt the end user to re-enter credentials after drilling through to the next report, or to make the credentials entered to access the first report pass through to the second report? The drilling through works perfectally from within visual studio, but fails to work when the report is viewed in IE.
Did you ever fix this problem? I am having the same problem. It works fine when run in Visual Studio but then on the server it does not prompt again for the credentials when drilling through to the next report. My email is scriptjunk3@.hotmail.com. If you did fix this or get an answer, please let me know here or at my email. Thank you.

Drillthrough question - how to return to same report page where drillthrough occurred?

Hello,

I have a master report that uses the "Jump to report" property to drill through to a detail report when the user clicks a report column value. This all works great and the users love it. However, when I click the brower's "Back" button to return to the master report, the master report is rerun and I am returned to page 1. If I drilled through on page 25 of the master report then I have lost my original position and I must navigate back to page 25. The users don't love this "feature"!

Is there a way I can return from the drill through detail report to the master report without using the browser's back button and losing my original position in the master report?

Thanks,

BCB

I forgot to mention that I am using Report Manager and not the .NET report viewer control. Also, I don't see any navigational control on the drillthrough report that allows me to "back up" to the master - that is why I have used the browser's "Back" button.

Thanks,

BCB

Drillthrough question - how to return to same page?

Hello,

I have a master report that uses the "Jump to report" property to drill through to a detail report when the user clicks a report column value. This all works great and the users love it. However, when I click the brower's "Back" button to return to the master report, the master report is rerun and I am returned to page 1. If I drilled through on page 25 of the master report then I have lost my original position and I must navigate back to page 25. The users sure don't love this "feature"!

I am using Report Manager and not the .NET report viewer control. Also, I don't see any navigational control on the drillthrough report that allows me to "back up" to the master - that is why I have used the browser's "Back" button.

Is there a way I can return from the drill through detail report to the master report without using the browser's back button and losing my original position in the master report?

Thanks,

BCB

Hi BCB,
sorry I haven't the answer, but can you just explain me how you do to drill through to a detail report with the option "jump to report"... I have a post here : http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1455055&SiteID=1

Thank you to take few minutes...
please
|||

Hi Alineo,

You open the properties window for the report field that you want to turn into a drillthrough link. On the "Navigation" tab you select the drillthrough report. Finally, you click the "Parameters" button to add all parameters that the drillthrough report requires. That's all it takes.

BCB

|||

I've had the opportunity to investigate this a little more and I believe it has something to do with report parameters that do not have default values. I'm convinced that a report with no parameters will return to the same page when you click the brower's Back button. In other words, the report won't be run again before you see it.

Reports that have parameters without defaults always seem to be rerun when the user clicks the Back button even though the previously entered values are used when the report is generated.

My results with reports that have parameters with default values have varied. Some reports seem to return to the last-viewed page when the Back button is clicked and other reports are rerun.

I'm still looking for an answer to this so if anyone has a theory I'd appreciate hearing it.

Thanks.

BCB

|||

After spending several hours decomposing a report that suffers from this problem, it appears that a report with a parameter of multi-value type will be always run when the user returns to it by using the browser's Back button. This causes the original report to display page #1 again. Not very nice if you happened to viewing page #39 when you clicked the drillthrough link! I can't be sure there is no other way to cause this problem but the multi-value property is guaranteed to do the trick. I'm assuming this is a bug.

We are running SP2 on our servers.

If anyone has experience working around this problem I'd appreciate hearing your solution. Multi-value parms are a requirement for us.

Thanks,

BCB

Drillthrough Filters

Hi,
Can anyone explain me how to work with the filter tab on Cube drill through
options?
I added an extra table and specified the joining clause in this tab. It
works fine for the first time; but after saving the cube it gives invalid
alias or alias cannot be located. I tried putting the same alias name for the
table but it doesn’t work.
Thanks in advance.
Regards,
Yash
Run SQL Profiler to see what the exact SQL statement being generated looks
like.
My guess is that you have an edit issue in your filter statement.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Yash" <Yash@.discussions.microsoft.com> wrote in message
news:F34694EB-D644-4671-AF0D-2C1896CDDDEE@.microsoft.com...
> Hi,
> Can anyone explain me how to work with the filter tab on Cube drill
through
> options?
> I added an extra table and specified the joining clause in this tab. It
> works fine for the first time; but after saving the cube it gives invalid
> alias or alias cannot be located. I tried putting the same alias name for
the
> table but it doesn't work.
> Thanks in advance.
> --
> Regards,
> Yash
>

Drillthrough Filters

Hi,
Can anyone explain me how to work with the filter tab on Cube drill through
options?
I added an extra table and specified the joining clause in this tab. It
works fine for the first time; but after saving the cube it gives invalid
alias or alias cannot be located. I tried putting the same alias name for th
e
table but it doesn’t work.
Thanks in advance.
--
Regards,
YashRun SQL Profiler to see what the exact SQL statement being generated looks
like.
My guess is that you have an edit issue in your filter statement.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Yash" <Yash@.discussions.microsoft.com> wrote in message
news:F34694EB-D644-4671-AF0D-2C1896CDDDEE@.microsoft.com...
> Hi,
> Can anyone explain me how to work with the filter tab on Cube drill
through
> options?
> I added an extra table and specified the joining clause in this tab. It
> works fine for the first time; but after saving the cube it gives invalid
> alias or alias cannot be located. I tried putting the same alias name for
the
> table but it doesn't work.
> Thanks in advance.
> --
> Regards,
> Yash
>

Drilling Cross Tabs

Hi There,
Is there a way to drill down into Cross Tabs. If so could you please help me out with it.
Thanks
PrashI dont think this is possible. Anyway check here
http://support.businessobjects.com/

drilldown values

When you use the action property of a text box for drill down, how do you
pass the selected value to the report? or is sql reporting smart enough to
know?
--
Thanks,
CGWNever mind... found the button for parameters.
"CGW" wrote:
> When you use the action property of a text box for drill down, how do you
> pass the selected value to the report? or is sql reporting smart enough to
> know?
> --
> Thanks,
> CGW

Drill-down in ASP.NET with iframes

Hello all I pretty new to SRS. I've got an asp.net application that uses
iframes to display reports. I'm trying to get the reports to drill down.
I've tried using the 'Jump to report' option but it opens the report on top
of my application so I loose my iframe (and app header and navigation). I
can't work out how to change this behaviour. I also tried the 'Jump to URL'
but ran into some issues with this too. I had to hardcode my server name in
the link. I also have to put code in my page to handle the parameters. Is
there a better way?What about using the _self target rather than the _top target, which is
default. ?
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Patrick P via SQLMonster.com" <forum@.nospam.SQLMonster.com> schrieb im
Newsbeitrag news:53526a45e0544eb1a51ed6169737ca1a@.SQLMonster.com...
> Hello all I pretty new to SRS. I've got an asp.net application that uses
> iframes to display reports. I'm trying to get the reports to drill down.
> I've tried using the 'Jump to report' option but it opens the report on
> top
> of my application so I loose my iframe (and app header and navigation). I
> can't work out how to change this behaviour. I also tried the 'Jump to
> URL'
> but ran into some issues with this too. I had to hardcode my server name
> in
> the link. I also have to put code in my page to handle the parameters. Is
> there a better way?|||I couldn't find where this property is stored. The Link is generated as
follows:
<a style="color:Blue" href="http://links.10026.com/?link=http://localhost/myreport/Reports/Summary.aspx?
ReportName=rptNoRevisions&BeginDate10/10/2003" TARGET="_top">Day
Shift</a>
So even if I set the target at a page level the element level will override
it. Is there a way to change the default target for report links?|||http://groups.google.de/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/54a5075b1e3f48e7/55e040db2460e6b1?q=iframe+open+target&rnum=3&hl=de#55e040db2460e6b1
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Patrick P via SQLMonster.com" <forum@.SQLMonster.com> schrieb im Newsbeitrag
news:a5299fd9cb314afbbb5d64a4a7493296@.SQLMonster.com...
>I couldn't find where this property is stored. The Link is generated as
> follows:
> <a style="color:Blue"
> href="http://links.10026.com/?link=http://localhost/myreport/Reports/Summary.aspx?
> ReportName=rptNoRevisions&BeginDate10/10/2003" TARGET="_top">Day
> Shift</a>
> So even if I set the target at a page level the element level will
> override
> it. Is there a way to change the default target for report links?|||Thanks for the link but unfortunately google groups is blocked by our
firewall, which makes it really hard to get technical research done (very
annoying). Could you please cut and paste relevant bits for me. Thanks
again!
--
Message posted via http://www.sqlmonster.com|||Let me be your proxy :-)
Bryan Keller [MSFT] 19 Mär. 2004 19:39 Optionen anzeigen
Newsgroups: microsoft.public.sqlserver.reportingsvcs
Von: "Bryan Keller [MSFT]" <brya...@.online.microsoft.com> -
Nachrichten von diesem Autor suchen
Datum: Fri, 19 Mar 2004 10:37:32 -0800
Lokal: Fr 19 Mär. 2004 19:37
Betreff: Re: href TARGET property defaults to "_top"
Antwort an Autor | Weiterleiten | Drucken | Einzelne Nachricht |
Original anzeigen | Missbrauch melden
What action are you using to generate the URL? Jump to Report will not
work
with LinkTarget. Jump to URL will. So in your example below, when a
user
clicks on the link, any URL's in the Consolidated report will have
target = _self. But unless the parent report of Consolidated has
rc:LinkTarget=_self,
your link below will open in _top. Where are you running into a
problem?
Please be more specific about parent reports, child reports and the
expected
navigation of users. This will help me to better answer your question.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Patrick P via SQLMonster.com" <forum@.SQLMonster.com> schrieb im Newsbeitrag
news:4f06f19c226447c0bc25587933cc43c3@.SQLMonster.com...
> Thanks for the link but unfortunately google groups is blocked by our
> firewall, which makes it really hard to get technical research done (very
> annoying). Could you please cut and paste relevant bits for me. Thanks
> again!
> --
> Message posted via http://www.sqlmonster.com
begin 666 dot_clear.gif
K1TE&.#EA`0`!`( ``/___P```"'Y! $`````+ `````!``$```("1 $`.P``
`
end|||Thanks for the help. I worked out the solution. For anyone struggling with
the same issue here is what I did.
1. Use 'Jump to URL' instead of the other options.
2. Open Report Viewer project and add the following code:
Private _linktarget As String = "_self"
<Category("HTMLViewer Commands"), Description("Sets rc:linktarget to change
iFrame target")> _
Public Property LinkTarget() As String
Get
Return Me._linktarget
End Get
Set(ByVal Value As String)
Me._linktarget = Value
Me.SetParameter("rc:LinkTarget", Value)
End Set
End Property
3. Recompile and place dll in project bin.
Now the default is _self and you have the option to change the target from
your code.
This solution isn't ideal because you have to use the jump to url which
means more work in creating the url with params, and you may have to hard
code your servername.
If anyone comes up with a better solution please post it.
--
Message posted via http://www.sqlmonster.com

Drill-down Cross tab reports

Hallo all,
I have to create drill down cross tab reports.
How can I create drill-down cross tab reports using Sql server reporting
services 2005? I am very much in need of help. Can any one help me how i can
create ?
Please kindly some links if any drill down cross tab reports examples
available online?
I am very much thankful to all,if any of you provide me some input to step
further as soon as possible.
regards
miikaOn Mar 12, 6:01 am, aka <a...@.discussions.microsoft.com> wrote:
> Hallo all,
> I have to create drill down cross tab reports.
> How can I create drill-down cross tab reports using Sql server reporting
> services 2005? I am very much in need of help. Can any one help me how i can
> create ?
> Please kindly some links if any drill down cross tab reports examples
> available online?
> I am very much thankful to all,if any of you provide me some input to step
> further as soon as possible.
> regards
> miika
In SQL Server Reporting Services (SSRS), cross-tab reports are called
matrix reports. You should be able to get started on a basic matrix
report via the report creation wizard. As far as drill-down reports,
here is a link that might help.
http://msdn2.microsoft.com/en-us/library/aa964132.aspx
Also, I am offering a Practical SQL Server 2005 Reporting Services
class in the Nashville, TN area available starting April 23rd, if you
are available at that time. You can email me at:
emartinez.pr1@.gmail.com for specifics (incl pricing, course outline,
etc).
Regards,
Enrique Martinez
Sr. SQL Server Developer

Drilldown

Is there a way to disable a level drill down? I want to keep the level set to All and not have the user to drill down via the report.

One possibility is to try custom dimension security:

http://msdn2.microsoft.com/en-us/library/ms175366.aspx

>>

SQL Server 2005 Books Online

Granting Custom Access to Dimension Data

After a Microsoft SQL Server 2005 Analysis Services (SSAS) database role has read or read/write permission to a dimension, you can define security on each dimension member (also called dimension security). By default, a database role is not allowed access to any members of any dimension. You have to grant permission to allow access to specific attributes and attribute members within the dimension. The properties that are available for viewing attributes and attribute members are: IsAllowed, AllowedSet, DeniedSet, ApplyDenied, VisualTotals, and DefaultMember. The type of access that members of a dimension role have is based on the dimension access granted, either read or read/write.

>>

|||

I'm following the BOL, but I don't see the "Dimension Custom Data Access" option in the "Select a page pane" when editing the Analysis Service database role. Is this only available in a specific version/edition of SSAS? I'm running Developers edition w/ SP1 installed.

Thanks.

Drilldown

Is there a way to disable a level drill down? I want to keep the level set to All and not have the user to drill down via the report.

One possibility is to try custom dimension security:

http://msdn2.microsoft.com/en-us/library/ms175366.aspx

>>

SQL Server 2005 Books Online

Granting Custom Access to Dimension Data

After a Microsoft SQL Server 2005 Analysis Services (SSAS) database role has read or read/write permission to a dimension, you can define security on each dimension member (also called dimension security). By default, a database role is not allowed access to any members of any dimension. You have to grant permission to allow access to specific attributes and attribute members within the dimension. The properties that are available for viewing attributes and attribute members are: IsAllowed, AllowedSet, DeniedSet, ApplyDenied, VisualTotals, and DefaultMember. The type of access that members of a dimension role have is based on the dimension access granted, either read or read/write.

>>

|||

I'm following the BOL, but I don't see the "Dimension Custom Data Access" option in the "Select a page pane" when editing the Analysis Service database role. Is this only available in a specific version/edition of SSAS? I'm running Developers edition w/ SP1 installed.

Thanks.

Drill to detail in ProClarity

Hi,

This is from a previous post I had put,

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

ProClarity gives a "Drill-To-Detail" by default. When you click on that it shows the key columns for the fact tables. It uses Drillthrough for this.

I tried defining drillthrough actions in ssas 2005, but they come up seperately as actions in proclarity. The "Drill-To-Detail" is still displayed on right-click at proclarity.

The actions are working in ssas 2005, but according to the definition, if a drillthrough is executed, if no return columns are specified, then it picks the return columns from the action that resembles similar query target. This does not seem to work for me!

if nothing can I at least remove the "Drill-To-detail" from ProClarity? please help.

Regards

Hi Vijay,

Could you explain this in more detail, because it doesn't sound identical to the Drillthrough whitepaper verbiage:

"then it picks the return columns from the action that resembles similar query target."

http://msdn2.microsoft.com/en-us/library/ms345125.aspx

>>

...

When a client sends a DRILLTHROUGH statement that does not contain the RETURN clause, the server looks for a default drillthrough action whose target subspace contains the cell coordinate for which drillthrough is being executed.

>>

In what way does it not work for you - what results do you get? Also, have you tried accessing the "xxxDetails" Drillthrough actions in the Adventure Works cube from Proclarity - do they work as expected?

|||

Hi Deepak,

Thanks for the reply.

Apologies, this is what I meant by my statement :

"When a client sends a DRILLTHROUGH statement that does not contain the RETURN clause, the server looks for a default drillthrough action whose target subspace contains the cell coordinate for which drillthrough is being executed."

Here is the query that ProClarity sends out when you right-click on any cell and click on the "DrillThrough"

DRILLTHROUGH MAXROWS 1000 SELECT { ( [Measures].[ABC] ) } ON COLUMNS ,

{ ( [DATE].[NAME].&[1.001734E6] ) } ON ROWS

FROM [ZZZCUBE]

WHERE ( [DATE].[DAY OF MONTH].[All], [DATE].[DIM MONTH NAME].[All], [DATE].[DIM YEAR NAME].[All], [LL_USER_TYPE].[DIM_LL_USER_TYPE_KEY].[All], [LL_USER_TYPE].[DIM_LL_USER_TYPE_NAME].[All], [LL_USER_TYPE].[DIM_LL_USER_TYPE_SHORT_NAME].[All], [SLICE_LOCATION].[KEY].[All], [SLICE_LOCATION].[NAME].[All], [SLICE_LOCATION].[SHORT NAME].[All], [LOCATION].[KEY].[All], [LOCATION].[NAME].[All], [LOCATION].[SHORT NAME].[All], [APPLICATION].[DIM_APPLICATION_KEY].[All], [APPLICATION].[DIM_APPLICATION_NAME].[All], [APPLICATION].[DIM_APPLICATION_SHORT_NAME].[All], [DATACENTER].[DIM_DATACENTER_KEY].[All], [DATACENTER].[DIM_DATACENTER_NAME].[All], [DATACENTER].[DIM_DATACENTER_SHORT_NAME].[All], [MONTH].[DIM_MONTH_NAME].[All], [MONTH].[DIM_MONTH_SHORT_NAME].[All], [MONTH].[KEY].[All], [ALL_COUNTRIES].[KEY].[All], [ALL_COUNTRIES].[NAME].[All], [ALL_COUNTRIES].[SHORT NAME].[All] )

<PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>CON4QA</Catalog><Timeout>0</Timeout><Format>Native</Format><DbpropMsmdFlattened2>false</DbpropMsmdFlattened2><Dialect>MDX</Dialect><MdxMissingMemberMode>Error</MdxMissingMemberMode><LocaleIdentifier>1033</LocaleIdentifier><DbpropMsmdMDXCompatibility>2</DbpropMsmdMDXCompatibility></PropertyList>

Notice, it contains no return columns. but it contains a <PropertyList>.

This cube's measureGroups contains 2 measures, out of which one is selected for the graph. The cube's measureGroup uses 3 dimensions, two are used in the graph. that would be, let us say, Measure M1 (background) , Dim Date (rows) , Dim Type(columns).

So I created a drill through action for the same MeasureGroup. Then in return columns, I selected only one measure (the one used in graph- M1). Then I selected the dimensions which I have used in the graphs (Dim Date.Name, Dim Type.Name).

After saving everything, I browse the same Proclarity graph , right click on a cell and click on Drill-To-Detail. I get the following columns in the drillthrough window that gets opened.

Date.Name (because Date dimension has Name as its key attribute)
Type.Key
location.key (not in graph)

M1 (measure)
M2 (measure) (not in graph)

My problem is , why are dimensions and measures that are not used in the graph coming? (although they are used by the measuregroup as displayed in the dimension usage tab of BI studio)

In any case, I do not want the "Key" attribute of dimension to be displayed in the drill-to-detail. If I get the "Name" attribute instead of the key attribute, then it would be okay with me. that is what I am trying to do.

note. In the BI studio browser, we do not have a default drillthrough in the UI. If we define a drillthrough action on the measureGroup, then it gets rendered in the BI studio browser. Also this action is visible in Proclarity, under 'actions'. but the drill-to-detail still exsits. The actions that I have created are working fine by themselves.

Please tell me if you need any other information?

How can I solve this,

Regards

|||

Hi Deepak,

I forgot to ask this,

what does "target subspace contains the cell coordinate......" mean?

How can I create a default drillthrough, which will be used whenever the user does a drillthrough on any of the cells of the a particular cube/measuregroup/dimension combination?

regardig the 'xxxDetails' drillthrough in Adventure Works, I will check it.

Thanks!

Regards

|||

The TargetType for Drillthrough Actions is "Cells" - for example, the definition of the "Reseller Details" action in Adventure Works includes:

<TargetType>Cells</TargetType>
<Target>MeasureGroupMeasures("Reseller Sales")</Target>

So it applies only to cells in the "Reseller Sales" Measure Group - but you can select <All> as the Target for a Drillthrough which applies across all Measure Groups. You should test your Drillthrough Action directly, using an MDX query in Management Studio, to ensure that it is returning the correct columns. For example:

>>

Drillthrough

select {[Measures].[Reseller Order Quantity]} on 0,

[Date].[Calendar].[Month].&[2001]&[7] on 1

from [Adventure Works]

where [Product].[Product Categories].[Product Name].&[300]

-

[Reseller Sales].[Reseller Sales Amount] [Reseller Sales].[Reseller Order Quantity] [Reseller Sales].[Reseller Extended Amount] [Reseller Sales].[Reseller Tax Amount] [Reseller Sales].[Reseller Freight Cost] [Reseller Sales].[Discount Amount] [Reseller Sales].[Reseller Unit Price] [Reseller Sales].[Unit Price Discount Percent] [Reseller Sales].[Reseller Total Product Cost] [Reseller Sales].[Reseller Standard Product Cost] [$Reseller].[Reseller] [$Promotion].[Promotion] [$Employee].[Employee] [$Delivery Date].[Date] [$Sales Territory].[Sales Territory Region] [$Reseller Sales Order Details].[Carrier Tracking Number] [$Reseller Sales Order Details].[Customer PO Number] [$Reseller Sales Order Details].[Sales Order Number] [$Reseller Sales Order Details].[Sales Order Line] [$Product].[Product] [$Ship Date].[Date] [$Source Currency].[Source Currency Code] [$Date].[Date] [$Geography].[City] [$Geography].[State-Province] [$Geography].[Country] [$Destination Currency].[Destination Currency Code]
809.76 1 809.76 64.7808 20.244 0 809.76 0 699.0928 699.0928 Original Bicycle Supply Company No Discount Jos Edvaldo. Saraiva July 13, 2001 Canada 4E0A-4F89-AE PO18473189620 SO43661 1 HL Mountain Frame - Black, 48 July 8, 2001 CAD July 1, 2001 Toronto Ontario Canada USD

>>

The list of columns corresponds to those specified in the definition of the "Reseller Details" action.

Drill through works eradically

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

This ended up being a bug. The report viewer control works as expected in Visual Studio 2005, but when linking back to the same report under Visual Studio 2005 SP1, this bug may appear.

Drill through works eradically

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

This ended up being a bug. The report viewer control works as expected in Visual Studio 2005, but when linking back to the same report under Visual Studio 2005 SP1, this bug may appear.

Drill Through to report from Matrix Subtotal

Hi,
I have the following result from a matrix:
| Week 1 | Week 2 | Week 3 |
DSM 1 | Salesrep 1| Sales | $100 | $200 | $300 |
|New cust | 3 | 2 |
5 |
Salesrep 2| Sales | $200 | $300 | $100 |
|New cust | 2 | 1 |
3 |
---
DSM 1 Totals | $300 | $500 | $400 |
|New cust | 5 | 3 |
8 |
What I'm trying to accomplish is to have the user click on the field "New
Cust" and open a report that shows the new customers (detail) for the entire
row. The marix report has to and from date parameters that I am passing to
the second report, but the second report also has the DSM and Salesrep
parameters (each set up as a multi parameter). I want the user to be able to
click on the indevidual Salesrep line, the DSM subtotal Line, and the Grand
total line. I know this requires the InScope function, but I can't seem to
get the statment right.
Any help is greatly appreciated.
Thanks!
--
JohnWell either this was too hard or it is not possible. Either way, can someone
give me some insight?
--
John
"John" wrote:
> Hi,
> I have the following result from a matrix:
> | Week 1 | Week 2 | Week 3 |
> DSM 1 | Salesrep 1| Sales | $100 | $200 | $300 |
> |New cust | 3 | 2 |
> 5 |
> Salesrep 2| Sales | $200 | $300 | $100 |
> |New cust | 2 | 1 |
> 3 |
> ---
> DSM 1 Totals | $300 | $500 | $400 |
> |New cust | 5 | 3 |
> 8 |
> What I'm trying to accomplish is to have the user click on the field "New
> Cust" and open a report that shows the new customers (detail) for the entire
> row. The marix report has to and from date parameters that I am passing to
> the second report, but the second report also has the DSM and Salesrep
> parameters (each set up as a multi parameter). I want the user to be able to
> click on the indevidual Salesrep line, the DSM subtotal Line, and the Grand
> total line. I know this requires the InScope function, but I can't seem to
> get the statment right.
> Any help is greatly appreciated.
> Thanks!
> --
> John

drill through timeout

In Analysis Manager I have received the message:
Unable to drill through
The operation requested failed due to timeout
This happens when the query takes 30 secons or more to return the result set.
How can I resolve this issue ?
(Analysis Services 8.0 SP2)SP3 for AS fixes quite a few problems, I would reccomend applying sp3 before you try anything else.

HTH|||Originally posted by rhigdon
SP3 for AS fixes quite a few problems, I would reccomend applying sp3 before you try anything else.

HTH
Hi, thans a lot !!! I have tried applying SP3a but the timeout problem were not corrected.
Any other suggestions ?

Drill through reports in RS2005

How do I drill through to a report from a report that's in a different directory? In the designer I can only drill through to reports that are in that project. I'm sure that there is a simple solution (hopefully!).

Hi.

You can use the action property and then "jump to url" or try to use string under the option "jump to report", that refer to the report something like "..\anotherfolder\anotherreport"

I think that should work. Try it.

Greentings.

Drill through reports in report container

I am integrating the Sql reporting services (Sql 2000) for my web
application. The reports are displayed in a report container "ReportViewer"
in a web page. All the reports are working fine except those drill through
reports, the first level of the drill through reports is showing in the
report container, however when click on the link to drill through to the
second level it opens up with a new browser rather than displaying at the
report container. Please how to make those drill through reports stay with
the report container in a web page. Many thanks.I also have the same problem.
Did you manage to resolve it? If so how?
Thanks
"Paul" wrote:
> I am integrating the Sql reporting services (Sql 2000) for my web
> application. The reports are displayed in a report container "ReportViewer"
> in a web page. All the reports are working fine except those drill through
> reports, the first level of the drill through reports is showing in the
> report container, however when click on the link to drill through to the
> second level it opens up with a new browser rather than displaying at the
> report container. Please how to make those drill through reports stay with
> the report container in a web page. Many thanks.
>
>

Drill Through Reports

Any way to have the drill through report open in a new window on the web?

with a hyperlink:

=void(window.open('http://yoururl?parameter1=value'))"

|||

im using an expression not a hyperlink.

Any way in VS2005 to set it in the navigation properties or something?

|||I'm saying, that's the only way.