Thursday, March 22, 2012
Drop-down in DTS Package cut off
when I click on the drop-down in the Table/View field the path will only
extend for the width of the field, even if the path name is too long to fit
in that field. As a result, I often can't see the full path displayed.
Thanks.JKKUS wrote:
> When working in DTS, specifically in the Transform Data Properties window,
> when I click on the drop-down in the Table/View field the path will only
> extend for the width of the field, even if the path name is too long to fi
t
> in that field. As a result, I often can't see the full path displayed.
> Thanks.
Hi,
Is it possible to place the cursor in the field and then use the 'End'
and 'Home' buttons to navigate?
James|||No, that will only scroll vertically up and down the drop-down list, but not
horizontally.
"James Wilson" wrote:
> JKKUS wrote:
> Hi,
> Is it possible to place the cursor in the field and then use the 'End'
> and 'Home' buttons to navigate?
> James
>|||This did not yet resolve my issue.
"James Wilson" wrote:
> JKKUS wrote:
> Hi,
> Is it possible to place the cursor in the field and then use the 'End'
> and 'Home' buttons to navigate?
> James
>sql
Drop-down in DTS Package cut off
when I click on the drop-down in the Table/View field the path will only
extend for the width of the field, even if the path name is too long to fit
in that field. As a result, I often can't see the full path displayed.
Thanks.JKKUS wrote:
> When working in DTS, specifically in the Transform Data Properties window,
> when I click on the drop-down in the Table/View field the path will only
> extend for the width of the field, even if the path name is too long to fit
> in that field. As a result, I often can't see the full path displayed.
> Thanks.
Hi,
Is it possible to place the cursor in the field and then use the 'End'
and 'Home' buttons to navigate?
James|||No, that will only scroll vertically up and down the drop-down list, but not
horizontally.
"James Wilson" wrote:
> JKKUS wrote:
> > When working in DTS, specifically in the Transform Data Properties window,
> > when I click on the drop-down in the Table/View field the path will only
> > extend for the width of the field, even if the path name is too long to fit
> > in that field. As a result, I often can't see the full path displayed.
> >
> > Thanks.
> Hi,
> Is it possible to place the cursor in the field and then use the 'End'
> and 'Home' buttons to navigate?
> James
>|||This did not yet resolve my issue.
"James Wilson" wrote:
> JKKUS wrote:
> > When working in DTS, specifically in the Transform Data Properties window,
> > when I click on the drop-down in the Table/View field the path will only
> > extend for the width of the field, even if the path name is too long to fit
> > in that field. As a result, I often can't see the full path displayed.
> >
> > Thanks.
> Hi,
> Is it possible to place the cursor in the field and then use the 'End'
> and 'Home' buttons to navigate?
> James
>
Drop-down in DTS Package cut off
when I click on the drop-down in the Table/View field the path will only
extend for the width of the field, even if the path name is too long to fit
in that field. As a result, I often can't see the full path displayed.
Thanks.
JKKUS wrote:
> When working in DTS, specifically in the Transform Data Properties window,
> when I click on the drop-down in the Table/View field the path will only
> extend for the width of the field, even if the path name is too long to fit
> in that field. As a result, I often can't see the full path displayed.
> Thanks.
Hi,
Is it possible to place the cursor in the field and then use the 'End'
and 'Home' buttons to navigate?
James
|||No, that will only scroll vertically up and down the drop-down list, but not
horizontally.
"James Wilson" wrote:
> JKKUS wrote:
> Hi,
> Is it possible to place the cursor in the field and then use the 'End'
> and 'Home' buttons to navigate?
> James
>
|||This did not yet resolve my issue.
"James Wilson" wrote:
> JKKUS wrote:
> Hi,
> Is it possible to place the cursor in the field and then use the 'End'
> and 'Home' buttons to navigate?
> James
>
Wednesday, March 21, 2012
DROP TABLE IF EXISTS (not working)!
thanx !if object_id('<table_name>') is not null drop table <table_name>|||Originally posted by ms_sql_dba
if object_id('<table_name>') is not null drop table <table_name>
thanx !!!!|||The M$ way...
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Company]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Company]
GO
Sunday, March 11, 2012
Drop Down Parameters Not Working
does
not populate automatically. It appears that the focus is not being made on
the frame that allows for the user to enter parameters.
Is there a way to make the focus on a certain frame of the Report parameters
form?
I found that once the page loads, as long as I don't select anything in the
primary dropdown list, I can select the frame that the drop down is in, and
then select an option and it works correctly. If I select the option first,
then select the frame, it does not work. I'm not an expert, but to me, this
means that the focus needs to be put on the drop down list frame by Reporting
Service.I had this exact same problem, took a while to figure it out. Some IE
browsers (maybe others too) do this, not really the reporting services. I
believe if you update your browser it can solve this. Otherwise you can add
"&rc:Stylesheet=fix" to the end of you link to the report and it should work.
Hope this helps.
"A.J." wrote:
> If you select an option from the dropdown list, the secondary dropdown list
> does
> not populate automatically. It appears that the focus is not being made on
> the frame that allows for the user to enter parameters.
> Is there a way to make the focus on a certain frame of the Report parameters
> form?
> I found that once the page loads, as long as I don't select anything in the
> primary dropdown list, I can select the frame that the drop down is in, and
> then select an option and it works correctly. If I select the option first,
> then select the frame, it does not work. I'm not an expert, but to me, this
> means that the focus needs to be put on the drop down list frame by Reporting
> Service.|||I tried to update my browser and that didn't work. I already have the latest
from Microsoft. As far as the &rc goes, I didn't development the report, so
I'm not sure how to do this, but I'll pass it on to the owner.
"scraejtp" wrote:
> I had this exact same problem, took a while to figure it out. Some IE
> browsers (maybe others too) do this, not really the reporting services. I
> believe if you update your browser it can solve this. Otherwise you can add
> "&rc:Stylesheet=fix" to the end of you link to the report and it should work.
> Hope this helps.
> "A.J." wrote:
> > If you select an option from the dropdown list, the secondary dropdown list
> > does
> > not populate automatically. It appears that the focus is not being made on
> > the frame that allows for the user to enter parameters.
> >
> > Is there a way to make the focus on a certain frame of the Report parameters
> > form?
> >
> > I found that once the page loads, as long as I don't select anything in the
> > primary dropdown list, I can select the frame that the drop down is in, and
> > then select an option and it works correctly. If I select the option first,
> > then select the frame, it does not work. I'm not an expert, but to me, this
> > means that the focus needs to be put on the drop down list frame by Reporting
> > Service.|||Looks like I got it to work, but I had to revert to a previous version of
I.E. browser. I went from Update Version
"SP1;Q832894;Q867801;Q871260;Q823353;" to simply "SP1", which brings us back
to our original problem occurring after we pushed out Microsoft patch 888113.
This should be a Microsoft issue, if someone knows how to report it.
"scraejtp" wrote:
> I had this exact same problem, took a while to figure it out. Some IE
> browsers (maybe others too) do this, not really the reporting services. I
> believe if you update your browser it can solve this. Otherwise you can add
> "&rc:Stylesheet=fix" to the end of you link to the report and it should work.
> Hope this helps.
> "A.J." wrote:
> > If you select an option from the dropdown list, the secondary dropdown list
> > does
> > not populate automatically. It appears that the focus is not being made on
> > the frame that allows for the user to enter parameters.
> >
> > Is there a way to make the focus on a certain frame of the Report parameters
> > form?
> >
> > I found that once the page loads, as long as I don't select anything in the
> > primary dropdown list, I can select the frame that the drop down is in, and
> > then select an option and it works correctly. If I select the option first,
> > then select the frame, it does not work. I'm not an expert, but to me, this
> > means that the focus needs to be put on the drop down list frame by Reporting
> > Service.
Friday, February 24, 2012
Drillthrough to AS2005 cube in excel
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 Security Conundrum AS 2005
Hi,
I'm looking for some inspiration on how to solve the following issue.
I'm working on a cube that contains crime data. I have a number of reports built using SSRS that show summary totals for different types of crime. In addition, there are a number of linked reports where the user can drill through to the underlying details of the crimes in the fact table fact table. These reports use the DRILLTHROUGH statement via the OLE DB provider for OLAP. So far, so good.
The client now wants to restrict drillthrough on certain types of crime.
Essentially, if a user is a member of Role1, they should be able to see the summary total for Crime A in the main report but they should NOT be able to drillthrough to the details of that summary
If the user is a member of Role2, they should be able to drill through to the detail level.
So far, I cannot see a way to do this with role permissions. My understanding and experience of the role based security thus far is as follows (please correct me if I'm wrong)
1) You can enable or disable drill through at the cube level for a particular role via the Cubes > Drillthrough Access property. This is too restrictive for my needs in this case
2) You can hide certain dimension members via Dimension Data tab but this results in the particular crime types not being displayed in the main report (i.e. you can't see the summary total for that crime)
3) You can restrict access to certain cell values via Cell Data but again this results in a value like N/A being displayed in the main report.
Has anyone faced a similar problem and come up with a way to do this?
Any feedback appreciated
NJDUNNE
The right way to approach this is through dimension security (Dimension Data tab). Drillthrough respects all the dimension security settings. You can restrict access to details, but make sure that Visual Totals=false, therefore you will see the summaries but won't be able to go to details.|||Hi ,
Do u know if we can create drill through reports in SSRS through SSAS & Sql Server 2005 as the Database . I want to know how this can be done ?
Regards
Rashmi
Drillthrough Security Conundrum AS 2005
Hi,
I'm looking for some inspiration on how to solve the following issue.
I'm working on a cube that contains crime data. I have a number of reports built using SSRS that show summary totals for different types of crime. In addition, there are a number of linked reports where the user can drill through to the underlying details of the crimes in the fact table fact table. These reports use the DRILLTHROUGH statement via the OLE DB provider for OLAP. So far, so good.
The client now wants to restrict drillthrough on certain types of crime.
Essentially, if a user is a member of Role1, they should be able to see the summary total for Crime A in the main report but they should NOT be able to drillthrough to the details of that summary
If the user is a member of Role2, they should be able to drill through to the detail level.
So far, I cannot see a way to do this with role permissions. My understanding and experience of the role based security thus far is as follows (please correct me if I'm wrong)
1) You can enable or disable drill through at the cube level for a particular role via the Cubes > Drillthrough Access property. This is too restrictive for my needs in this case
2) You can hide certain dimension members via Dimension Data tab but this results in the particular crime types not being displayed in the main report (i.e. you can't see the summary total for that crime)
3) You can restrict access to certain cell values via Cell Data but again this results in a value like N/A being displayed in the main report.
Has anyone faced a similar problem and come up with a way to do this?
Any feedback appreciated
NJDUNNE
The right way to approach this is through dimension security (Dimension Data tab). Drillthrough respects all the dimension security settings. You can restrict access to details, but make sure that Visual Totals=false, therefore you will see the summaries but won't be able to go to details.|||Hi ,
Do u know if we can create drill through reports in SSRS through SSAS & Sql Server 2005 as the Database . I want to know how this can be done ?
Regards
Rashmi
Drillthrough Reports not working in Webforms Report Viewer Control
I created a report (Report A) which links to another report (Report B). The
drillthrough works fine both in Visual Studio and via Report Manager.
I have an ASP.NET application which uses the Report Viewer Control to
display Report A. When I click the links in Report A to go to Report B, the
Report Viewer Control/IE shows the hour glass as if something is about to
happen, refreshes the page but still displays Report A.
Obviously the link is set up properly and the reports work since linking
from Report A to Report B works fine from Report Manager.
Are there any known issues with Drillthrough Reports not working in Webforms
Report Viewer Control? Are there any special considerations I should know
about? Any special set up I should be doing?
Any help with this will be greatly appreciated.
--
Chris, SSSIHello Chris,
I have tested on my side that the Drillthrough report works fine on my side.
Here are the steps:
1. Create a new Web Site in the VS 2005.
2. Drag a Report View Control to the Web Page.
3. Click the triangle in the right-up of the Report View Control.
4. Enter the Report Server name and the Report Path of the Drillthough
report.
5. Run the solution and the Drillthough report works fine.
Please try the steps on your side and let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Wei Lu,
According to your steps I am doing everything correctly, but as I mentioned
in my intial post this is not working.
Can you please answer these questions from my original post:
1) Are there any known issues with Drillthrough Reports not working in
Webforms
Report Viewer Control?
2) Are there any special considerations I should know about?
3) Any special set up I should be doing?
4) What could explain this behavior of the report links not working *ONLY*
in the Report Viewer Control?
Thanks!
-- Chris
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hello Chris,
> I have tested on my side that the Drillthrough report works fine on my side.
> Here are the steps:
> 1. Create a new Web Site in the VS 2005.
> 2. Drag a Report View Control to the Web Page.
> 3. Click the triangle in the right-up of the Report View Control.
> 4. Enter the Report Server name and the Report Path of the Drillthough
> report.
> 5. Run the solution and the Drillthough report works fine.
> Please try the steps on your side and let me know the result.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||I don't see any attachment. Is it supposed to be attached to your reply?
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hello Chris,
> So far as I know, there is not any known issue with Drillthrough Reports
> not working in Webforms Report Viewer Control.
> The only thing I do in the VS project is add the ReportViewer control:
> <rsweb:ReportViewer ID="ReportViewer1" runat="server"
> Font-Names="Verdana" Font-Size="8pt"
> Height="400px" ProcessingMode="Remote" Width="692px" >
> <ServerReport ReportPath="/ReportDemo/Drillthrough" />
> </rsweb:ReportViewer>
> The attachement is the sample aspx page.
> Please let me know does this works on your side.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support|||Hello Chris,
OK. I will post the HTML Code of the aspx Page.
============================<%@. Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs"
Inherits="_Default" %>
<%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"">http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<rsweb:ReportViewer ID="ReportViewer1" runat="server"
Font-Names="Verdana" Font-Size="8pt"
Height="400px" ProcessingMode="Remote" Width="692px"
DocumentMapCollapsed="True">
<ServerReport ReportPath="/ReportDemo/MultiParameter" />
</rsweb:ReportViewer>
</div>
</form>
</body>
</html>
=============================
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hi,
It turns out I created my own problem. Chalk it up to lack of experience
with ASP.NET apps. ;-)
The problem was I have code in my code behind page to configure the Report
Viewer control, but I was not checking for a post back condition. When the
user clicks a link to a drill through report a post back is done. As a result
my code behind page was reinitializing the Report Viewer on every user click.
Once I moved that Report Viewer set up code inside a check for "not
postback" everything worked fine.
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
>
Sunday, February 19, 2012
Drillthrough Report with Parameters - Jump to URL not working
I'm hoping to have a drillthrough report appear in a separate window but am
struggling to get it to work. I'm attempting to use the textbox navigation
property "Jump to URL", placing Javascript in the property field that should
render the child report in a separate window.
I can get this to work if the child report does not have parameters. But
when the child report does have parameters the child report is displayed in
the report manager UI, but all it shows is the parameter textboxes and I
need to enter the parameter data again and click "View Report" to get the
report to render. I would like the report to render in the new window
automatically.
I've seen many variations on how to get the "Jump to URL" to work and have
tried them with no luck, at least when the child report requires parameters.
Thanks in advance for any help that can be provided.
JackDo you have these parameters hidden in your "jump to" report?
"Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
> Hello,
> I'm hoping to have a drillthrough report appear in a separate window but
> am struggling to get it to work. I'm attempting to use the textbox
> navigation property "Jump to URL", placing Javascript in the property
> field that should render the child report in a separate window.
> I can get this to work if the child report does not have parameters. But
> when the child report does have parameters the child report is displayed
> in the report manager UI, but all it shows is the parameter textboxes and
> I need to enter the parameter data again and click "View Report" to get
> the report to render. I would like the report to render in the new
> window automatically.
> I've seen many variations on how to get the "Jump to URL" to work and have
> tried them with no luck, at least when the child report requires
> parameters.
> Thanks in advance for any help that can be provided.
> Jack
>|||Thanks Mark. I did not have the hidden property set. Setting the hidden
property on now causes an error to be displayed in the child window
indicating the parameter value wasn't provided. "The 'Param1' parameter
is missing a value"
Here's the java I'm trying to use, which works fine w/o the parameter(Parent
and Child report reside in the same folder).
="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
& Fields!MyParamField.Value & "'))"
Thanks again,
Jack
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
> Do you have these parameters hidden in your "jump to" report?
> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window but
>> am struggling to get it to work. I'm attempting to use the textbox
>> navigation property "Jump to URL", placing Javascript in the property
>> field that should render the child report in a separate window.
>> I can get this to work if the child report does not have parameters. But
>> when the child report does have parameters the child report is displayed
>> in the report manager UI, but all it shows is the parameter textboxes and
>> I need to enter the parameter data again and click "View Report" to get
>> the report to render. I would like the report to render in the new
>> window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>|||This is my JS code to run some code on the back-end.
See if helps you to find right syntax:
=("javascript:void(window.open('http://localhost/some.htm?parm1=" &
Fields!gaylordid.Value & "','price',
'status=0,toolbar=0,width=630,height=700,center=yes'))")
"Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
news:e4n7qy9nIHA.4904@.TK2MSFTNGP03.phx.gbl...
> Thanks Mark. I did not have the hidden property set. Setting the
> hidden property on now causes an error to be displayed in the child window
> indicating the parameter value wasn't provided. "The 'Param1' parameter
> is missing a value"
> Here's the java I'm trying to use, which works fine w/o the
> parameter(Parent and Child report reside in the same folder).
> ="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
> & Fields!MyParamField.Value & "'))"
> Thanks again,
> Jack
>
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
>> Do you have these parameters hidden in your "jump to" report?
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window but
>> am struggling to get it to work. I'm attempting to use the textbox
>> navigation property "Jump to URL", placing Javascript in the property
>> field that should render the child report in a separate window.
>> I can get this to work if the child report does not have parameters.
>> But when the child report does have parameters the child report is
>> displayed in the report manager UI, but all it shows is the parameter
>> textboxes and I need to enter the parameter data again and click "View
>> Report" to get the report to render. I would like the report to render
>> in the new window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>>
>|||Thanks Mark. I've tried a number of different approaches with the JS
syntax and have gotten them all to work w/o parameters so I think my syntax
up to the point of calling the page/report is OK, even though our two
versions are quite different.(but JS is new to me) Also, it appears our
code to include the parameters is set up the same for the most part so I'm
thinking that may be OK too.
I've tried so many different versions of JS syntax with the same results I'm
wondering if something else isn't in play here. I'm trying to publish and
run these reports on an RS "Report Manager" website, where it appears you
may be referencing an HTML web page. Did you ever go the Report Manager
route with success so I could be certain what I'm trying to do(and what
you've done) is "doable" in that environment?(RS is new to me too)
Thanks again for your time, it's appreciated.
Jack
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:%23W3nFG%23nIHA.420@.TK2MSFTNGP02.phx.gbl...
> This is my JS code to run some code on the back-end.
> See if helps you to find right syntax:
> =("javascript:void(window.open('http://localhost/some.htm?parm1=" &
> Fields!gaylordid.Value & "','price',
> 'status=0,toolbar=0,width=630,height=700,center=yes'))")
> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
> news:e4n7qy9nIHA.4904@.TK2MSFTNGP03.phx.gbl...
>> Thanks Mark. I did not have the hidden property set. Setting the
>> hidden property on now causes an error to be displayed in the child
>> window indicating the parameter value wasn't provided. "The 'Param1'
>> parameter is missing a value"
>> Here's the java I'm trying to use, which works fine w/o the
>> parameter(Parent and Child report reside in the same folder).
>> ="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
>> & Fields!MyParamField.Value & "'))"
>> Thanks again,
>> Jack
>>
>> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
>> news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
>> Do you have these parameters hidden in your "jump to" report?
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window
>> but am struggling to get it to work. I'm attempting to use the
>> textbox navigation property "Jump to URL", placing Javascript in the
>> property field that should render the child report in a separate
>> window.
>> I can get this to work if the child report does not have parameters.
>> But when the child report does have parameters the child report is
>> displayed in the report manager UI, but all it shows is the parameter
>> textboxes and I need to enter the parameter data again and click "View
>> Report" to get the report to render. I would like the report to
>> render in the new window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>>
>>
>|||I was able to get my problem resolved - thanks Mark for taking some time to
help.
The change that appears to resolve my problem was adding the "reportserver"
literal to the URL. I could reference the child report page in a variety of
different methods of JS syntax but the parameter processing wouldn't work
until I included the reportserver folder in the URL string I placed in the
Jump to URL property. Getting to my child report page by any other method
appeared to cause the parameter passing to fail.
Working JS string:
=("javascript:void(window.open('http://servername/Reportserver/Pages/Report.aspx?%2fMyReports%2fMyDrillThroughReport&Parm1="
& Fields!MyParm.Value
&"','Detail','resizeable=1,toolbar=0,status=0,menu=0,top=20,left=20,width=740,height=930'))"
)
Thanks again,
Jack
"Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
news:uVcqiQ$nIHA.3376@.TK2MSFTNGP05.phx.gbl...
> Thanks Mark. I've tried a number of different approaches with the JS
> syntax and have gotten them all to work w/o parameters so I think my
> syntax up to the point of calling the page/report is OK, even though our
> two versions are quite different.(but JS is new to me) Also, it appears
> our code to include the parameters is set up the same for the most part so
> I'm thinking that may be OK too.
>
> I've tried so many different versions of JS syntax with the same results
> I'm wondering if something else isn't in play here. I'm trying to
> publish and run these reports on an RS "Report Manager" website, where it
> appears you may be referencing an HTML web page. Did you ever go the
> Report Manager route with success so I could be certain what I'm trying to
> do(and what you've done) is "doable" in that environment?(RS is new to me
> too)
>
> Thanks again for your time, it's appreciated.
>
> Jack
>
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:%23W3nFG%23nIHA.420@.TK2MSFTNGP02.phx.gbl...
>> This is my JS code to run some code on the back-end.
>> See if helps you to find right syntax:
>> =("javascript:void(window.open('http://localhost/some.htm?parm1=" &
>> Fields!gaylordid.Value & "','price',
>> 'status=0,toolbar=0,width=630,height=700,center=yes'))")
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:e4n7qy9nIHA.4904@.TK2MSFTNGP03.phx.gbl...
>> Thanks Mark. I did not have the hidden property set. Setting the
>> hidden property on now causes an error to be displayed in the child
>> window indicating the parameter value wasn't provided. "The 'Param1'
>> parameter is missing a value"
>> Here's the java I'm trying to use, which works fine w/o the
>> parameter(Parent and Child report reside in the same folder).
>> ="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
>> & Fields!MyParamField.Value & "'))"
>> Thanks again,
>> Jack
>>
>> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
>> news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
>> Do you have these parameters hidden in your "jump to" report?
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window
>> but am struggling to get it to work. I'm attempting to use the
>> textbox navigation property "Jump to URL", placing Javascript in the
>> property field that should render the child report in a separate
>> window.
>> I can get this to work if the child report does not have parameters.
>> But when the child report does have parameters the child report is
>> displayed in the report manager UI, but all it shows is the parameter
>> textboxes and I need to enter the parameter data again and click "View
>> Report" to get the report to render. I would like the report to
>> render in the new window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>>
>>
>>
>
Drillthrough not working!
Hello everyone!
I am using VS 2005, with SQL 2000. My reports are displaying fine, but i am trying to have a drillthrough report. So basically display one report and once i click on a certain element within the report, it should take me to that specific report, i.e that parameter is passed.
I have rooted through the internet to find a couple of examples which do the same, but these examples use XML as the datasource but I am using a dataset (.xsd) file and cannot get my head around how to interact with this and reload the dataset onto the ReportViewer based on the DrillThrough event the user selects.
The code using the xml file is below, can someone help me to convert this to get it to read data from the xsd file. Both my dataTableAdapters are in the same Dataset. xsd file. I am fairly new at .NET but even i know that this has to be possible.
Cheers,
Munira
private DataTable LoadEmployeesData()
{
DataSet dataSet = new DataSet();
dataSet.ReadXml(@."c:\My Reports\employees.xml");
return dataSet.Tables[0];
}
private DataTable LoadDepartmentsData()
{
//This is the bit that needs to change inorder to read from an xsd file
DataSet dataSet = new DataSet();
dataSet.ReadXml(@."c:\My Reports\departments.xml");
return dataSet.Tables[0];
}
void DemoDrillthroughEventHandler(object sender, DrillthroughEventArgs e)
{
LocalReport localReport = (LocalReport)e.Report;
localReport.DataSources.Add(new ReportDataSource("Employees",
LoadEmployeesData()));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// On initial page load
ReportViewer1.LocalReport.ReportPath = @."c:\My Reports\Departments.rdlc";
// Supply a DataTable corresponding to each report data source.
ReportViewer1.LocalReport.DataSources.Add(
new ReportDataSource("Departments", LoadDepartmentsData()));
}
// Add the handler for drillthrough.
ReportViewer1.Drillthrough += new DrillthroughEventHandler(DemoDrillthroughEventHandler);
}
Hello all!
I managed to solve my problem after quite a bit of frustration...so I thought that this little check list might be helpful to someone else facing a similar problem.
Ok things to do inorder to make drill down reports work.
1. In the second report (the drillthrough report) add the parameter to the report, in the rdlc page.
2. In the main report, go to the element that you want to click on, the textbox, and make the navigation properties to jump to the second report, also remember to set the parameter in that dialogue box!
3. Add the drillthrougheventhandler in your aspx.cs page, this is the point where you want to change your data source.
4. Make sure you set the reportviewer ondrillthoughevent, in the html definition of the reportviewer, to go to the function writen in 3.
Regards,
Munira
DrillThrough Actions not working in Proclarity web standard (Vs Proclarity professional)
Hi,
I created some Drillthrough actions in Proclarity web professional. When I right click in professional and select the aciton they open a new window and display the correct corresponding values.
after publishing the graph, I tried the same in the ProClarity Web Standard. Here the actions are not displayed in the right-click menu, but are displayed in the left navigation tab.
Clicking on the same drillthrough action, for the same cell and dimension values, opens a new window, which only keeps showing "Please wait, Loading Details....." I waited for 30 minutes. and still it did not show any results.
Since there is only one row that it has to display (as seen in proclarity professional for the same data), I think that there is something else that has to be configured for the proclarity web standard.
Please help.
thanks and regards
Anybody worked on ProClarity and ssas 2005?|||On the web, there is no right click, just click on the cell and a menu will pop up for Drill to detail. You cannot drill on calculated measure cells.
Also check the permissions of the user in IIS that is running the PAS site. Try using an administrator account as anonymous and see if that works.
|||Hi,
thanks for the reply,
Yeah , there is no right click on the web standard. (only in professional).
but i am able to see the drillthrough actions!!!! in web standard also.
it appears in the right side navigation tab , under the "Actions" header.
but clicking on those actions , opens a window, but does not get results.
I will try out what you specified.
Regards
Drillthrough action not working
Hello,
I have an AS2005 cube in which I created a drillthrough action. For some reason, it won't return any rows. Even the cube browser within BIDS won't show any results. I have the same setup for another project where it works fine. Can this be security related? I have a single role which has all possible permissions.
Thnx. Jeroen
I'm assuming you have a SQL Server database backend to this. Have you run Profiler against that database to see what query is being submitted or whether errors are being raised on the backend that for some reason are not bubbling up to you?
B.
|||Hello Bryan,
I captured the drillthrough query with Profiler like you suggested, and ran the following MDX in Management Studio:
Code Snippet
DRILLTHROUGH
SELECT
( [Measures].[Number of Visits]
, [Visit Status].[Visit Status].&[Done]
) ON 0
FROM
[Visits]
RETURN
[$Visit Status].[Visit Status]
, [$Account].[Account Code]
Now, the SELECT clause contains a lot more slicers, but for some reason, when I leave out all parts which select a specific value using the "&" sign, the query returns a result. So in the query here, when I leave out
, [Visit Status].[Visit Status].&[Done]
data is returned. When I leave out only ".&Done" then a result is returned as well, with in most cases the Visit Status being "Done".
Any clue?
Thnx, Jeroen
<some time passed, did some further research>
It seems to be related with the "IgnoreUnrelatedDimensions" property of the MeasureGroup. When this property is set to
TRUE - won't give any results
FALSE - works OK
However, in some cases I need it to be TRUE... Anyone knows a good bit of explanation of this property and of using MeasureGroups and Dimension Usage in general?
Thnx, Jeroen
|||I'm not 100% what all the IgnoreUnrelatedDimensions property does, but the one thing we use if for is to ensure that when a dimension that does not have a relationship to a measure group from which a measure is derived is used with that measure in a query, no values are returned. Wow! That was a long sentence! Let me try to explain this another way....
In a cube, I may have multiple measure groups, each containing one or more measures. Each measure group has relationships defined with the dimensions and some of these dimensions will have relationships with multiple measure groups. When I browse the cube in a traditional browser, e.g. SSMS or Proclarity, I don't see those relationships. So, it is possible for me to grab a dimension, put it on an axis (so to speak), and then grab an unrelated measure. Because the two are unrelated, there is no data at the intersection of these two sets. So, SSAS has to decide what to show you.
The internal logic of how SSAS thinks about cubes should return the top level aggregated value for that measure. In other words, the measure as it exists if you selected no dimensions to dice it by. (There are variations on this, but we're keeping the concept simple. Just imagine a single dimension on rows and the measure on columns.) If you've ever seen a repeated value all the way down a column in your cell-set, you're probably looking at this.
This isn;t the most intuitive way to display the data to a user. So, the IgnoreUnrelatedDimensions property can be set to True to adjust the behavior. With this property set to True, the values of the unrelated measure are just hidden.
So, if this property is affecting whether or not you get results, do you have a relationship established between the Visit Status dimension and the measure group holding Number of Visits? Also, do you have a relationship established between the Account dimension and that same measure group?
B.
|||Hi Bryan, thanks for your explanation -verbose!
I had noticed a bit of this behaviour as well. I have a few cubes and some of them have multiple measuregroups, like Order / OrderItems. I think hiding the measures is the most decent way to do it as well. So I guess that only leaves the question why the drillthrough option doesn't work when the option is set to TRUE...
Jeroen
|||So, if this property is affecting whether or not you get results, do you have a relationship established between the Visit Status dimension and the measure group holding Number of Visits? Also, do you have a relationship established between the Account dimension and that same measure group?
|||Hi, both relationships are present, since this is a cube with just a single MeasureGroup.
Jeroen
|||Sorry, but I'm kinda out of ideas with this one. If there is a suspicion this might be security related, you may want to get rid of that role to see if this changes anything.
B.
Drillthrough action not working
Hello,
I have an AS2005 cube in which I created a drillthrough action. For some reason, it won't return any rows. Even the cube browser within BIDS won't show any results. I have the same setup for another project where it works fine. Can this be security related? I have a single role which has all possible permissions.
Thnx. Jeroen
I'm assuming you have a SQL Server database backend to this. Have you run Profiler against that database to see what query is being submitted or whether errors are being raised on the backend that for some reason are not bubbling up to you?
B.
|||Hello Bryan,
I captured the drillthrough query with Profiler like you suggested, and ran the following MDX in Management Studio:
Code Snippet
DRILLTHROUGH
SELECT
( [Measures].[Number of Visits]
, [Visit Status].[Visit Status].&[Done]
) ON 0
FROM
[Visits]
RETURN
[$Visit Status].[Visit Status]
, [$Account].[Account Code]
Now, the SELECT clause contains a lot more slicers, but for some reason, when I leave out all parts which select a specific value using the "&" sign, the query returns a result. So in the query here, when I leave out
, [Visit Status].[Visit Status].&[Done]
data is returned. When I leave out only ".&Done" then a result is returned as well, with in most cases the Visit Status being "Done".
Any clue?
Thnx, Jeroen
<some time passed, did some further research>
It seems to be related with the "IgnoreUnrelatedDimensions" property of the MeasureGroup. When this property is set to
TRUE - won't give any results
FALSE - works OK
However, in some cases I need it to be TRUE... Anyone knows a good bit of explanation of this property and of using MeasureGroups and Dimension Usage in general?
Thnx, Jeroen
|||I'm not 100% what all the IgnoreUnrelatedDimensions property does, but the one thing we use if for is to ensure that when a dimension that does not have a relationship to a measure group from which a measure is derived is used with that measure in a query, no values are returned. Wow! That was a long sentence! Let me try to explain this another way....
In a cube, I may have multiple measure groups, each containing one or more measures. Each measure group has relationships defined with the dimensions and some of these dimensions will have relationships with multiple measure groups. When I browse the cube in a traditional browser, e.g. SSMS or Proclarity, I don't see those relationships. So, it is possible for me to grab a dimension, put it on an axis (so to speak), and then grab an unrelated measure. Because the two are unrelated, there is no data at the intersection of these two sets. So, SSAS has to decide what to show you.
The internal logic of how SSAS thinks about cubes should return the top level aggregated value for that measure. In other words, the measure as it exists if you selected no dimensions to dice it by. (There are variations on this, but we're keeping the concept simple. Just imagine a single dimension on rows and the measure on columns.) If you've ever seen a repeated value all the way down a column in your cell-set, you're probably looking at this.
This isn;t the most intuitive way to display the data to a user. So, the IgnoreUnrelatedDimensions property can be set to True to adjust the behavior. With this property set to True, the values of the unrelated measure are just hidden.
So, if this property is affecting whether or not you get results, do you have a relationship established between the Visit Status dimension and the measure group holding Number of Visits? Also, do you have a relationship established between the Account dimension and that same measure group?
B.
|||Hi Bryan, thanks for your explanation -verbose!
I had noticed a bit of this behaviour as well. I have a few cubes and some of them have multiple measuregroups, like Order / OrderItems. I think hiding the measures is the most decent way to do it as well. So I guess that only leaves the question why the drillthrough option doesn't work when the option is set to TRUE...
Jeroen
|||So, if this property is affecting whether or not you get results, do you have a relationship established between the Visit Status dimension and the measure group holding Number of Visits? Also, do you have a relationship established between the Account dimension and that same measure group?
|||Hi, both relationships are present, since this is a cube with just a single MeasureGroup.
Jeroen
|||Sorry, but I'm kinda out of ideas with this one. If there is a suspicion this might be security related, you may want to get rid of that role to see if this changes anything.
B.
Drillthrough action not working
Hello,
I have an AS2005 cube in which I created a drillthrough action. For some reason, it won't return any rows. Even the cube browser within BIDS won't show any results. I have the same setup for another project where it works fine. Can this be security related? I have a single role which has all possible permissions.
Thnx. Jeroen
I'm assuming you have a SQL Server database backend to this. Have you run Profiler against that database to see what query is being submitted or whether errors are being raised on the backend that for some reason are not bubbling up to you?
B.
|||Hello Bryan,
I captured the drillthrough query with Profiler like you suggested, and ran the following MDX in Management Studio:
Code Snippet
DRILLTHROUGH
SELECT
( [Measures].[Number of Visits]
, [Visit Status].[Visit Status].&[Done]
) ON 0
FROM
[Visits]
RETURN
[$Visit Status].[Visit Status]
, [$Account].[Account Code]
Now, the SELECT clause contains a lot more slicers, but for some reason, when I leave out all parts which select a specific value using the "&" sign, the query returns a result. So in the query here, when I leave out
, [Visit Status].[Visit Status].&[Done]
data is returned. When I leave out only ".&Done" then a result is returned as well, with in most cases the Visit Status being "Done".
Any clue?
Thnx, Jeroen
<some time passed, did some further research>
It seems to be related with the "IgnoreUnrelatedDimensions" property of the MeasureGroup. When this property is set to
TRUE - won't give any results
FALSE - works OK
However, in some cases I need it to be TRUE... Anyone knows a good bit of explanation of this property and of using MeasureGroups and Dimension Usage in general?
Thnx, Jeroen
|||I'm not 100% what all the IgnoreUnrelatedDimensions property does, but the one thing we use if for is to ensure that when a dimension that does not have a relationship to a measure group from which a measure is derived is used with that measure in a query, no values are returned. Wow! That was a long sentence! Let me try to explain this another way....
In a cube, I may have multiple measure groups, each containing one or more measures. Each measure group has relationships defined with the dimensions and some of these dimensions will have relationships with multiple measure groups. When I browse the cube in a traditional browser, e.g. SSMS or Proclarity, I don't see those relationships. So, it is possible for me to grab a dimension, put it on an axis (so to speak), and then grab an unrelated measure. Because the two are unrelated, there is no data at the intersection of these two sets. So, SSAS has to decide what to show you.
The internal logic of how SSAS thinks about cubes should return the top level aggregated value for that measure. In other words, the measure as it exists if you selected no dimensions to dice it by. (There are variations on this, but we're keeping the concept simple. Just imagine a single dimension on rows and the measure on columns.) If you've ever seen a repeated value all the way down a column in your cell-set, you're probably looking at this.
This isn;t the most intuitive way to display the data to a user. So, the IgnoreUnrelatedDimensions property can be set to True to adjust the behavior. With this property set to True, the values of the unrelated measure are just hidden.
So, if this property is affecting whether or not you get results, do you have a relationship established between the Visit Status dimension and the measure group holding Number of Visits? Also, do you have a relationship established between the Account dimension and that same measure group?
B.
|||Hi Bryan, thanks for your explanation -verbose!
I had noticed a bit of this behaviour as well. I have a few cubes and some of them have multiple measuregroups, like Order / OrderItems. I think hiding the measures is the most decent way to do it as well. So I guess that only leaves the question why the drillthrough option doesn't work when the option is set to TRUE...
Jeroen
|||So, if this property is affecting whether or not you get results, do you have a relationship established between the Visit Status dimension and the measure group holding Number of Visits? Also, do you have a relationship established between the Account dimension and that same measure group?
|||Hi, both relationships are present, since this is a cube with just a single MeasureGroup.
Jeroen
|||Sorry, but I'm kinda out of ideas with this one. If there is a suspicion this might be security related, you may want to get rid of that role to see if this changes anything.
B.
Friday, February 17, 2012
DrillThrough action is broken and returns no data
I have a simple DrillThrough action which has been working for sometime. However, it has now stopped working and will not return any data... even if I invoke it from the highest level. I have re-deployed and processed the whole database from scratch. There is no conditional statement to this so I cannot see why it would not run.
What could possibly been happening? Has anyone had this problem before? Any suggestions about finding the source of this problem?
Ta
Dirc
Hello Dirc/Dorc,
Have you ever been able to solve this? I seem to be experiencing the same thing.
Regards, Jeroen
DrillThrough action is broken and returns no data
I have a simple DrillThrough action which has been working for sometime. However, it has now stopped working and will not return any data... even if I invoke it from the highest level. I have re-deployed and processed the whole database from scratch. There is no conditional statement to this so I cannot see why it would not run.
What could possibly been happening? Has anyone had this problem before? Any suggestions about finding the source of this problem?
Ta
Dirc
Hello Dirc/Dorc,
Have you ever been able to solve this? I seem to be experiencing the same thing.
Regards, Jeroen
Drilldowns with SOAP rendering or SSRS 2005?
ASP.NET application that would use SOAP web access to render the reports.
However, I was wondering how this works with linked or drill down reports,
which we are thinking will be an important part of our design.
Has anyone done this successfully? How does it work? Normally, the
reportingservice.render method is called, but I read about an issue that
occurs when a drill down report is encountered. Apparently the user is
redirected to the Report Manager, as there is no way to tell the Report
Server that the drill down destination should be mapped to the calling
application. I also read that there may be something better for this in SQL
Server 2005, but I wonder when we should expect that?
Can anyone shed some light on this issue?
Thanks,
nickpupwell i ve been using SSRS 200 with SQL Server 2000 n ASP.Net for my
reports n i had the same problem of handling linked n toggle reports
as far as linked reports r concerned those were settled by changing the
path of the linked report to my application's webpage that shows the
specified linked report with parameters in URL through JUMP TO URL
PROPERTY however i couldnt resolve the toggled report problem i tried
but couldnt succeed if u get the idea plz let me know as well|||I will - thanks.
"** Spirits **" wrote:
> well i ve been using SSRS 200 with SQL Server 2000 n ASP.Net for my
> reports n i had the same problem of handling linked n toggle reports
> as far as linked reports r concerned those were settled by changing the
> path of the linked report to my application's webpage that shows the
> specified linked report with parameters in URL through JUMP TO URL
> PROPERTY however i couldnt resolve the toggled report problem i tried
> but couldnt succeed if u get the idea plz let me know as well
>
Drill-down is not working on browser : Please help
Please help.. this is an annoying problem ......
I am running sample reports in the browser and found that none of the
reports drilldown
when I click on teh + sign.
In VS.NET environment the reports drilldown fine.
Is there a particular setting in the Internet Explorer options I have to set
?
I am using Evaluation edition with SP1.
Cheers
PawanDo you have an underscore in the server machine name?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pawan" <pawan_kr_sharma@.hotmail.com> wrote in message
news:%23jkX%23ssZEHA.1448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Please help.. this is an annoying problem ......
> I am running sample reports in the browser and found that none of the
> reports drilldown
> when I click on teh + sign.
> In VS.NET environment the reports drilldown fine.
> Is there a particular setting in the Internet Explorer options I have to
> set
> ?
> I am using Evaluation edition with SP1.
> Cheers
> Pawan
>|||Yes !
Pawan
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:eGmWsbtZEHA.1164@.TK2MSFTNGP12.phx.gbl...
> Do you have an underscore in the server machine name?
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Pawan" <pawan_kr_sharma@.hotmail.com> wrote in message
> news:%23jkX%23ssZEHA.1448@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > Please help.. this is an annoying problem ......
> >
> > I am running sample reports in the browser and found that none of the
> > reports drilldown
> > when I click on teh + sign.
> > In VS.NET environment the reports drilldown fine.
> >
> > Is there a particular setting in the Internet Explorer options I have to
> > set
> > ?
> >
> > I am using Evaluation edition with SP1.
> >
> > Cheers
> > Pawan
> >
> >
>|||http://groups.google.com/groups?selm=%23HoAMdjBEHA.3284%40TK2MSFTNGP09.phx.gbl
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pawan" <pawan_kr_sharma@.hotmail.com> wrote in message
news:uj5JMTyZEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Yes !
> Pawan
>
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> news:eGmWsbtZEHA.1164@.TK2MSFTNGP12.phx.gbl...
>> Do you have an underscore in the server machine name?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Pawan" <pawan_kr_sharma@.hotmail.com> wrote in message
>> news:%23jkX%23ssZEHA.1448@.TK2MSFTNGP12.phx.gbl...
>> > Hi,
>> >
>> > Please help.. this is an annoying problem ......
>> >
>> > I am running sample reports in the browser and found that none of the
>> > reports drilldown
>> > when I click on teh + sign.
>> > In VS.NET environment the reports drilldown fine.
>> >
>> > Is there a particular setting in the Internet Explorer options I have
>> > to
>> > set
>> > ?
>> >
>> > I am using Evaluation edition with SP1.
>> >
>> > Cheers
>> > Pawan
>> >
>> >
>>
>|||Hi Lev,
I changed my computer name to remove the underscore from name.
After that I used rsconfig.exe utility to change the connection settings of
report server.
Now, my reports show the images and drill down in the browser.
Many thanks for your help.
Pawan
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:eJbVDc8ZEHA.3512@.TK2MSFTNGP12.phx.gbl...
>
http://groups.google.com/groups?selm=%23HoAMdjBEHA.3284%40TK2MSFTNGP09.phx.gbl
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Pawan" <pawan_kr_sharma@.hotmail.com> wrote in message
> news:uj5JMTyZEHA.1764@.TK2MSFTNGP10.phx.gbl...
> > Yes !
> >
> > Pawan
> >
> >
> > "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> > news:eGmWsbtZEHA.1164@.TK2MSFTNGP12.phx.gbl...
> >> Do you have an underscore in the server machine name?
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >>
> >> "Pawan" <pawan_kr_sharma@.hotmail.com> wrote in message
> >> news:%23jkX%23ssZEHA.1448@.TK2MSFTNGP12.phx.gbl...
> >> > Hi,
> >> >
> >> > Please help.. this is an annoying problem ......
> >> >
> >> > I am running sample reports in the browser and found that none of the
> >> > reports drilldown
> >> > when I click on teh + sign.
> >> > In VS.NET environment the reports drilldown fine.
> >> >
> >> > Is there a particular setting in the Internet Explorer options I have
> >> > to
> >> > set
> >> > ?
> >> >
> >> > I am using Evaluation edition with SP1.
> >> >
> >> > Cheers
> >> > Pawan
> >> >
> >> >
> >>
> >>
> >
> >
>
Tuesday, February 14, 2012
drill through on chart working on some IE browsers and not on other browsers
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.
Hi,
The drillthrough functionality uses JavaScript. You need to check what the permissions are. Check if the security zone is the same for the working and not working pc's.
Greetz,
Geert
Geert Verhoeven
Consultant @. Ausy Belgium
My Personal Blog