Drop-down in DTS Package cut off

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

drill-through does not work ?

Hi friends
I have a simple report that lists summary of transactions made by each customer.
when i click on no of transactions ,as you know, it would display invidual transactions automatically.
It all working fine with VS2005 RC1 but recently we bought VS2005 standard edition (Nov release).

with this licensed version i cant drill thru report !! i mean i can run my report ok but if i click on no of transactions it would not display any details !!
is it limitation of standard edition ? is it not default in released version ?
Thank you very much for your help.I suppose you are asking about "infinite clickthrough" (i.e. automatically generated drillthrough links based on the semantic model) in report builder reports, correct?
This feature is only available in the Enterprise Edition (or Developer Edition) of Reporting Services 2005, but not in Standard Edition. Please check: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

-- Robert|||Thanks Robert.
Thats what i just found !! damn ,thats a nice feature to loose :(
http://msdn2.microsoft.com/en-us/library/ms345252(en-US,SQL.90).aspx

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

Drilling Down - Toggling All Rows

Does anyone know if it's possible to expand and collapse all rows when drilling down? The way it is now, the user has to click the plus sign on each row to drill down. I would like to provide functionality to expand or collapse all rows at once while the report is being viewed. Thanks.

There may be a way - but I have not found one!

I also did not like after I expanded a group then expanded a group within a group how you have to <return> a coule of times to begin where you first started.

So, I just <jump to a URL> and then display the detail within a "frame".

Seems easier for the user to navigate in that they have the primary "expand" item still available - if you get my drift!

Hope this helps!

Drilldown and graphs

Is it possible to somehow create charts that support drilldown? E.g. a
pie-chart where you can click any area in the chart which will redirect you
to another report?
Thank you for any help.
Regards, Jakob.
--
http://www.dotninjas.dkYes you can do that. In the chart properties dialog on the Data tab, select
a Value and edit its properties. The Action tab contains what you're looking
for.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jakob Christensen" <jch@.REMOVEpension.dk> wrote in message
news:77AB990F-9281-403B-9514-019D7DF86382@.microsoft.com...
> Is it possible to somehow create charts that support drilldown? E.g. a
> pie-chart where you can click any area in the chart which will redirect
> you
> to another report?
> Thank you for any help.
> Regards, Jakob.
> --
> http://www.dotninjas.dk|||Thank you :-)
"Robert Bruckner [MSFT]" wrote:
> Yes you can do that. In the chart properties dialog on the Data tab, select
> a Value and edit its properties. The Action tab contains what you're looking
> for.
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jakob Christensen" <jch@.REMOVEpension.dk> wrote in message
> news:77AB990F-9281-403B-9514-019D7DF86382@.microsoft.com...
> > Is it possible to somehow create charts that support drilldown? E.g. a
> > pie-chart where you can click any area in the chart which will redirect
> > you
> > to another report?
> >
> > Thank you for any help.
> >
> > Regards, Jakob.
> >
> > --
> > http://www.dotninjas.dk
>
>

Drill downs not working in RM

Hi,
We have many reports that have been uploaded to Report Manager (RM) that
contain drill downs. When you click on a drill down, it doesn't work. It
makes a click but doesn't drill down. When previewing in Report Designer, all
the reports work just fine. Any ideas?
Thanks in advance for any help.1. Have you upgraded to RS SP1?
2. Try allowing cookies on your browser.
3. Add the site at the top level into your allowed sites in IE.
Ive only seen this problem on XP and or Windows 2003.
Immy
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:940D40D7-573C-4838-A6FB-2CABF0D1CD59@.microsoft.com...
> Hi,
> We have many reports that have been uploaded to Report Manager (RM) that
> contain drill downs. When you click on a drill down, it doesn't work. It
> makes a click but doesn't drill down. When previewing in Report Designer,
> all
> the reports work just fine. Any ideas?
> Thanks in advance for any help.|||Thanks for the suggestion, however that didn't work.
To answer your questions, yes, we ungraded to RS SP1. The IE settings are
correct. We are running Windows 2002 (Adv Srvr).
"Imtiaz Ullah" wrote:
> 1. Have you upgraded to RS SP1?
> 2. Try allowing cookies on your browser.
> 3. Add the site at the top level into your allowed sites in IE.
> Ive only seen this problem on XP and or Windows 2003.
> Immy
>
> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> news:940D40D7-573C-4838-A6FB-2CABF0D1CD59@.microsoft.com...
> > Hi,
> >
> > We have many reports that have been uploaded to Report Manager (RM) that
> > contain drill downs. When you click on a drill down, it doesn't work. It
> > makes a click but doesn't drill down. When previewing in Report Designer,
> > all
> > the reports work just fine. Any ideas?
> >
> > Thanks in advance for any help.
>
>|||To clarify further, everything works on the production server. This is only
occurring on the development server. We use the same IE browser both
prodution and development servers. The only difference between the servers is
the OS they run. The Production server runs on Windows Server 2003 and the
Development servers runs on Windows 2000 Advance Server.
"Imtiaz Ullah" wrote:
> 1. Have you upgraded to RS SP1?
> 2. Try allowing cookies on your browser.
> 3. Add the site at the top level into your allowed sites in IE.
> Ive only seen this problem on XP and or Windows 2003.
> Immy
>
> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> news:940D40D7-573C-4838-A6FB-2CABF0D1CD59@.microsoft.com...
> > Hi,
> >
> > We have many reports that have been uploaded to Report Manager (RM) that
> > contain drill downs. When you click on a drill down, it doesn't work. It
> > makes a click but doesn't drill down. When previewing in Report Designer,
> > all
> > the reports work just fine. Any ideas?
> >
> > Thanks in advance for any help.
>
>

Drill down problem, report jumps to top of table!

Hi
I have a report with a table which has two groups. Each group is collapsed
by default when the report loads. When I click on the first group expand
icon (+) the group expands but also the report jumps up the screen so that
the top of my first data row in my table is alligned to the top of the IE
window. This is really annoying and I do not understand why it is happening.
Is this a known bug in RS or has anyone else had this problem and been able
to solve it? It also happens when I expand/collapse the second group.
I think it only started happening after I added a few images to my report. I
have tried removing the images from the report but this does not get rid of
the problem.
Any help/ideas would be greatly appreciated.
Kind Regards
Lewis Holmes
eNateHi
Problem solved!
In Visual Studio I had the page setup so that the body of the report was
larger than the area visible on the screen and so my footer was off the
screen. I have now changed this so that the body of the report is just large
enough for the contents of the body. Now the report does not jump around
when I expand/collapse groups.
Hope this may help anyone else with the same problem.
Regards
Lewis Holmes
eNate
"l.holmes" <enate@.newsgroups.nospam> wrote in message
news:u1ST$9g3FHA.2552@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have a report with a table which has two groups. Each group is collapsed
> by default when the report loads. When I click on the first group expand
> icon (+) the group expands but also the report jumps up the screen so that
> the top of my first data row in my table is alligned to the top of the IE
> window. This is really annoying and I do not understand why it is
> happening. Is this a known bug in RS or has anyone else had this problem
> and been able to solve it? It also happens when I expand/collapse the
> second group.
> I think it only started happening after I added a few images to my report.
> I have tried removing the images from the report but this does not get rid
> of the problem.
> Any help/ideas would be greatly appreciated.
> Kind Regards
> Lewis Holmes
> eNate
>|||Hi Lewis,
It's great to hear you have resolved it and thanks so much for sharing your
experience with us.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Drill Down Performance

I was wondering if when you click on the + in a drill down report, does the report requery the database, or is the report just re-rendered without having to query again?

depending on the answer, performance considerations would be different.

The only requery is on the ReportServer db which has cached the results of the dataset. Your original query is not rerun.