DropDownList instead of Textbox in Reporting Services

Hello,
I have a report that uses a stored procedure. The parameter from the stored procedure is a name field defined nvarchar(50). But I have a list of values for this field in another table; is there anyway to use the values from the other table to populate a dropdownlist of these values, instead of prompting the user for a textbox?
Thanks.Hi ,
for populating drop down list instead of default text box, you have to create another dataset which will fetch fields from another table.
while in layout, go to Report --> Report Parameters..
click on the parameter on left and on right side, select radio btn From query and specify dataset and select fields.
you can also select default value also. i think this is what u want right?
Thanks
Rohit
|||

Hey,

Yes, that is exactly what I was looking to do. Thanks a lot.

|||That's good for designing reports on the server (RDL). I'm using Visual Web Developer Express and cliking on Report-Report Parameters it seems there's no option for configuring parameters to come from a dataset. Is there a way around this?|||No takers so far. So let me re-phrase the question. Is there any way by which I can move parametrized reports from the server (RDL) to the client (RDLC)?|||Sure you can. You need to use the parameter objects to pass parameters to the report.

drop down parameter question.

We have a bunch of reports that take a parameter from outside the normal
reporting services parameter window.
I understand that for security reason we cannot pass that parameter on the
querystring unless a reportparameter is defined. I therefore had to display a
drop down box with all the possible values.
Question is can I hide that box and its label?
I have managed to hide it from reportingservices manager, but not in a
browser whn just passing a url.
e.g.
http://dsdev2/Reports/Pages/Report.aspx?ItemPath= Works
but http://dsdev2/reportserver?...&rs:Command=Render&SurveyId=1
does not.
The way I got this to work is by changing ReportingService.css and adding a
behaviour.
e.g:
table.msrs-contentFrame IFRAME {
behavior: url(../js/CustomParameters.htc);
}
Any Idea anyone.Remove the Prompt for the parameter.
--
| Thread-Topic: drop down parameter question.
| thread-index: AcUgvQSDe1jZy1lbQDy/S6JkRqOmEw==| X-WBNR-Posting-Host: 62.188.58.81
| From: "=?Utf-8?B?RnJlZA==?=" <Fred@.discussions.microsoft.com>
| Subject: drop down parameter question.
| Date: Fri, 4 Mar 2005 05:21:04 -0800
| Lines: 28
| Message-ID: <84E65958-73A2-4F98-88B3-17B1E4D920B4@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA
03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:44592
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| We have a bunch of reports that take a parameter from outside the normal
| reporting services parameter window.
|
| I understand that for security reason we cannot pass that parameter on
the
| querystring unless a reportparameter is defined. I therefore had to
display a
| drop down box with all the possible values.
|
| Question is can I hide that box and its label?
|
| I have managed to hide it from reportingservices manager, but not in a
| browser whn just passing a url.
| e.g.
| http://dsdev2/Reports/Pages/Report.aspx?ItemPath=
| Works
| but http://dsdev2/reportserver?...&rs:Command=Render&SurveyId=1
| does not.
|
| The way I got this to work is by changing ReportingService.css and adding
a
| behaviour.
| e.g:
| table.msrs-contentFrame IFRAME {
| behavior: url(../js/CustomParameters.htc);
| }
|
| Any Idea anyone.
|
|
|
|

Driver questions running with DB2 as datasource

I need some help and feedbacks from other users that are currently running Reporting Services using DB2 as a database. I have been testing OLE DB and ODBC from Microsoft and IBM, and recently DB2 .Net Data provider from IBM.

We are currently running DB2 on z/os v 7, gateway v.8 fixpack 10. We will mainly be calling Stored Procedures on the DB2 and passing recordsets back to the client.

First I installed IBM DB2 ODBC DRIVER v. 7.01.00.88, but I did not get this too work with reporting Services calling Stored Procedures, so I had too upgrade the driver to v8.01.10.812 to get it to work.

I have been in contact with Microsoft and they recommend using Microsoft OLE DB Provider for DB2 (30.sept 2005). I have tried too get this driver too work but I have problems configuring it. I think that it has something too do with some packages that the driver tries too create on DB2. I get error messages both on the DB2 and in the Data access Tool that runs a wizard setting up the driver. '—The package creation process has failed on resource "mytest", Data description mismatch SQLSTATE:HY000, SQLCODE: -292'

IBM have also developed a IBM DB2 Data provider for .Net Framework 2.0. This is the only driver that I can use too browse the database in the Server Explorer in VS. If you edit the RSReportDesigner.config file you can also use this driver in Report Server projects. Just add <Extension Name="DB2" Type="IBM.Data.DB2.DB2Connection,IBM.Data.DB2, Version=9.0.0.2, Culture=neutral, PublicKeyToken=7c307b91aa13d208" /> too the data section of the xml file.

So too wrap it all up. Which provider should I use? Are there any recommendations out there?

Thanks

B

well i've a question.

how to get IBM DB2 Data Provider for .Net Framework 2.0

Driver questions running with DB2 as datasource

I need some help and feedbacks from other users that are currently running Reporting Services using DB2 as a database. I have been testing OLE DB and ODBC from Microsoft and IBM, and recently DB2 .Net Data provider from IBM.

We are currently running DB2 on z/os v 7, gateway v.8 fixpack 10. We will mainly be calling Stored Procedures on the DB2 and passing recordsets back to the client.

First I installed IBM DB2 ODBC DRIVER v. 7.01.00.88, but I did not get this too work with reporting Services calling Stored Procedures, so I had too upgrade the driver to v8.01.10.812 to get it to work.

I have been in contact with Microsoft and they recommend using Microsoft OLE DB Provider for DB2 (30.sept 2005). I have tried too get this driver too work but I have problems configuring it. I think that it has something too do with some packages that the driver tries too create on DB2. I get error messages both on the DB2 and in the Data access Tool that runs a wizard setting up the driver. '—The package creation process has failed on resource "mytest", Data description mismatch SQLSTATE:HY000, SQLCODE: -292'

IBM have also developed a IBM DB2 Data provider for .Net Framework 2.0. This is the only driver that I can use too browse the database in the Server Explorer in VS. If you edit the RSReportDesigner.config file you can also use this driver in Report Server projects. Just add <Extension Name="DB2" Type="IBM.Data.DB2.DB2Connection,IBM.Data.DB2, Version=9.0.0.2, Culture=neutral, PublicKeyToken=7c307b91aa13d208" /> too the data section of the xml file.

So too wrap it all up. Which provider should I use? Are there any recommendations out there?

Thanks

B

well i've a question.

how to get IBM DB2 Data Provider for .Net Framework 2.0

Drillthroughs and report viewers

I'm fairly new to the Reporting Services world and I'm having some
difficulties with getting my drillthrough reports to open within the
same report viewer as its parent report.
Currently, I'm using the "Jump to URL:" navigation feature with the
URL:
http://localhost/Telecomm/WirelessAcctReports.aspx?ReportName=MinutesDrillDown.rdl&YearMonth=200408&rs:ClearSession=true&rc:parameters=false
This will bring up the page WirelessAcctReports with the viewer on it,
but not the report. I've also tried putting brackets around the report
name
http://localhost/Telecomm/WirelessAcctReports.aspx?ReportName=<MinutesDrillDown.rdl&YearMonth=200408&rs:ClearSession=true&rc:parameters=false>
but this gives me the error:
A potentially dangerous Request.QueryString value was detected from
the client (ReportName="<MinutesDrillDown.rd...").
What to I need to do to get this to work.
Also, eventually I will need to pass a parm for YearMonth. Will the
URL accept the Parameters!YearMonth.Value or will I have to pass it a
different way? thanks in advance.
JonathanJonathan,
Try using the "jump to report" as the action. You mentioned that you
will have a detail report that you will pass a parameter to. For example: I
have a report that shows a graph of number customers by geography in a pie
chart. When you select a pie slice (ie United States) then the action it
takes is to drill thru to the detail report displaying the customers for the
United States (parameter passed from the pie chart). I think this is what
you ultimately want to do based upon your posting. Once you define the
detail report (in my case the customer detail - which takes a parameter of
geography) ... then you can select that report to jump to and you can select
what field to pass from the first report as the parameter value for the
detail report. I hope this helps.
"Jonathan" wrote:
> I'm fairly new to the Reporting Services world and I'm having some
> difficulties with getting my drillthrough reports to open within the
> same report viewer as its parent report.
> Currently, I'm using the "Jump to URL:" navigation feature with the
> URL:
> http://localhost/Telecomm/WirelessAcctReports.aspx?ReportName=MinutesDrillDown.rdl&YearMonth=200408&rs:ClearSession=true&rc:parameters=false
> This will bring up the page WirelessAcctReports with the viewer on it,
> but not the report. I've also tried putting brackets around the report
> name
> http://localhost/Telecomm/WirelessAcctReports.aspx?ReportName=<MinutesDrillDown.rdl&YearMonth=200408&rs:ClearSession=true&rc:parameters=false>
> but this gives me the error:
> A potentially dangerous Request.QueryString value was detected from
> the client (ReportName="<MinutesDrillDown.rd...").
> What to I need to do to get this to work.
> Also, eventually I will need to pass a parm for YearMonth. Will the
> URL accept the Parameters!YearMonth.Value or will I have to pass it a
> different way? thanks in advance.
> Jonathan
>

Drillthrough problems with Reporting services in Integrated Mode

We have started to use reporting services in integrated mode with windows sharepoint. Since this installation the drillthrough reports have stopped working. We get the following error when a hyperlink is cllicked:-

The item 'http://vtrends/reports/IslandRegionCountryState' cannot be found. (rsItemNotFound)

In the textbox properties we have set the 'Jump to Report' hyperlink option to use a condition. Based on the link clicked, one of two reports will be displayed. If i remove this condition and manually select the report to run then there are no problems. This however is not the functionality that is needed.

Any help will be appreciated.

In WSS mode, the report path is completely different. It must reference the report location in the WSS library wherethe report is deployed. See this blog for more details.

Drillthrough Problem

I have a problem with the drillthrough feature in reporting services.
When I drillthrough from report A to report B it works fine and all
parameters where processed. But if i drilltrhough from report B to report A
now the parameters where ignored and i get an cached version of report A. How
can I run report A with the new parameters of report B after the first
drillthrough?this problem only occurs in the Microsoft CRM report viewer.
"Mike" wrote:
> I have a problem with the drillthrough feature in reporting services.
> When I drillthrough from report A to report B it works fine and all
> parameters where processed. But if i drilltrhough from report B to report A
> now the parameters where ignored and i get an cached version of report A. How
> can I run report A with the new parameters of report B after the first
> drillthrough?

Drillthrough Functionality via Excel Add-in

Hi,

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

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

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

"Unable to Drillthrough on this Cell"

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

Many Thanks

Jonathan Derbyshire

Jonathan_Derbyshire@.Hotmail.com

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

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

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

Thanks

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

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

Its a Medium to large cube.

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

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

Drillthrough Event not getting fired

Hi,
I am using VS2005 and SQL Server 2005 reporting Services. I have created a server report (rdl file) and wish to implement drillthrough functionality. On my web page, I added a reportviewer control and added an "OnDrillThrough" Event to the reportviewer.
However, when I click on the element that should raise the drillthrough event, the page gets posted back but the drillthrough event does not get called at all?? Am i missing something?

Thanks
Dabi

Hi Dabi,

I have the same problem as you posted with the drillthrough and I didn't find yet a solution. Can you help me please with it if you found a solution to it?

thanks,

Hanin

Drilldown Problem Using Parent Hierarchy

Does anyone know how to create a parent-child hierarchy that can be expanded (ie drilldown capabilities) in reporting services as well as analysis services?

Currently, I have a dimension with three attributes: parent, child, and key. Everything works fine in Analysis Services. When I click browse for the cube and I add the parent-child hierarchy, Analysis Services autogenerates a drilldown from the top level to the bottom level. However, reporting services doesn't seem to recognize the parent hierarchy as being a true hierarchy. After I add the parent-child hierarchy to a table or matrix, it will only add the very first level. There doesn't seem to be any way for reporting services to autogenerate the drilldown like in Analysis Services.

I really need this to work on a report. Any ideas would be much appreciated? Thank you.

You need to set the parent property on the grouping, check out this page on Recursive Hierarchies for details http://msdn2.microsoft.com/en-us/library/ms155903.aspx|||That link applies to Report Designer but what about Report Builder? When I generate a SMDL from an Analysis Services cube, the model contains all my dimensions but if I drag them over to the report, it returns all the available members.

Drilldown Problem Using Parent Hierarchy

Does anyone know how to create a parent-child hierarchy that can be expanded (ie drilldown capabilities) in reporting services as well as analysis services?

Currently, I have a dimension with three attributes: parent, child, and key. Everything works fine in Analysis Services. When I click browse for the cube and I add the parent-child hierarchy, Analysis Services autogenerates a drilldown from the top level to the bottom level. However, reporting services doesn't seem to recognize the parent hierarchy as being a true hierarchy. After I add the parent-child hierarchy to a table or matrix, it will only add the very first level. There doesn't seem to be any way for reporting services to autogenerate the drilldown like in Analysis Services.

I really need this to work on a report. Any ideas would be much appreciated? Thank you.

You need to set the parent property on the grouping, check out this page on Recursive Hierarchies for details http://msdn2.microsoft.com/en-us/library/ms155903.aspx|||That link applies to Report Designer but what about Report Builder? When I generate a SMDL from an Analysis Services cube, the model contains all my dimensions but if I drag them over to the report, it returns all the available members.

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

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 report in reporting services

hi,
could any one tell me how to drill through a report in
reportingservices . is there any samples ? or could any
one give me a walk through ..
Actually when i double click on analysis manager data it
shd open the report in the report manager...could any one
know how to do this .. plz help meThe sample reports that ship with the product, specifically [Territory Sales
Drilldown.rdl], [Sales Order Detail.rdl], and [Employee Sales Summary.rdl]
demonstrate this functionality. Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_samplereports_v1_9pmb.asp
for description of sample reports.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"john" <anonymous@.discussions.microsoft.com> wrote in message
news:388c01c47252$5a21b620$a601280a@.phx.gbl...
> hi,
> could any one tell me how to drill through a report in
> reportingservices . is there any samples ? or could any
> one give me a walk through ..
> Actually when i double click on analysis manager data it
> shd open the report in the report manager...could any one
> know how to do this .. plz help me

Drill through in migrated cubes ?

We have some migrated cubes that implemented drillthrough in Analysis Services 2000 and appear to have drill through in the migrated version if viewed through Proclarity. But when I look at the cube in the 2005 BI studio, I see no structure to implement this drill through. Nor am I able to drill through from the Management Suite--just Proclarity.

What's going on ?

Dan,

Drillthrough has gone through significant changes in AS2005. The following is a link to a good whitepaper on the topic:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5_anservdrill.asp

What you are seeing in ProClarity is "backward compatibility" support that was built into our 6.1 release. If you build a "Drillthrough Action" in AS 2005 it will show up in the cube browser used by the BI Studio.

HTH,

- Steve

|||

Steve:

I appreciate the help, but am a little confused.

First, my group has implemented drill through in 2005 using the concept of a degernate dimension on new (i.e., NOT migrated) cubes.

Our confusion occurs becauses migrated cubes exhibit drill through when viewed in Proclarity, but do not have a degernate dimension when examined in the BI 2005 Development Suite.

So, where is Proclarity getting the drill through data from ?

The answer apparently must be that SQL Server Analysis Services 2005 implements an "alternate drill through capability" that cannot be built using the 2005 BI Suite at all, but can only be created by first building a cube in 2000, and then migrating it.

Is this true ?

So, why is this all relevant to us ? Because we wish to add a field to the drill thru in the migrated cube.

|||

Dan,

If you can email me a phone number at spontello@.proclarity.com we can discuss the specifics.

- Steve

|||

Steve,

Is there a way to turn off this "Drill to detail" feature at the PAS server level?

Or to map the "Drill to detail" action to a Drillthrough action that was specifically created by the cube designer?

Thanks,

JGP

|||

JGP,

This could be done by customizing the PAS code. If you want more details send me an email at spontello@.proclarity.com.

- Steve

Drill down slow

Hello everyone

For starters i'm using Microsoft analysis services, integration services and reporting services.

All goes well when creating some general overview reports.

Once i get to making drill down reports with only 2000 rows of data is already starts to work very slow (sometimes takes hours). It seems a data cube is only fast for calculations like SUM, PARALLELPERIOD, ... but if it comes to amount of data it is extreemly weak! 2000 rows is not even alot, i've seen reporting tools beeing able to handle a million rows with drill down function.

I'm thinking that this microsoft tool is just not able to handle reports bigger than 100 rows in it combined with drill down. Please proof me wrong because we already paid for the microsoft tools and it would be a shame if we were not able to use them because of bad functionality...

The machine we work on is quite strong (dual core 2.4 ghz, 4 gig ram, ...)

And yes i know you can make reports clickable so they take the value with them to a next report as a parameters but thats not what we are looking for, we need this drill down to work properly with larger amounts of data.

Hmm, I don't think it's the tool in this case - I have drill down reports with far more data than that and I've never run into 'hours' of execution time. Do you have more detail?

Drill down slow

Hello everyone

For starters i'm using Microsoft analysis services, integration services and reporting services.

All goes well when creating some general overview reports.

Once i get to making drill down reports with only 2000 rows of data is already starts to work very slow (sometimes takes hours). It seems a data cube is only fast for calculations like SUM, PARALLELPERIOD, ... but if it comes to amount of data it is extreemly weak! 2000 rows is not even alot, i've seen reporting tools beeing able to handle a million rows with drill down function.

I'm thinking that this microsoft tool is just not able to handle reports bigger than 100 rows in it combined with drill down. Please proof me wrong because we already paid for the microsoft tools and it would be a shame if we were not able to use them because of bad functionality...

The machine we work on is quite strong (dual core 2.4 ghz, 4 gig ram, ...)

And yes i know you can make reports clickable so they take the value with them to a next report as a parameters but thats not what we are looking for, we need this drill down to work properly with larger amounts of data.

Hmm, I don't think it's the tool in this case - I have drill down reports with far more data than that and I've never run into 'hours' of execution time. Do you have more detail?

drill down report with report viewer

Hi
I am using the new report viewer control that comes with Reporting services
2005. However, my reports were created in using Visual Studio 2003 and are
.rdl files. Previously I used jump to url to drill down in a report and
passed the report url along with the report parameters in the query string.
I tried my report using the new report viewer control but when I click on a
drill down link, the report opens in the report viewer but it takes over the
whole IE window. My report viewer is within a page which is within one of
many frames that make up my webb application.
How can I get the drill down to work without losing my other frames?
If this is not possible, what do I need to do to convert my .rdl files to
.rdlc. I understand if I do this that I will need to take the sql query out
of my .rdl report and load up a dataset in code using this query and then
set this as the datasource for the report. Is this correct?
Thanks
Lewis Holmes
eNateHi eNate,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: When you use the
jump to url to view a report in the report viewer control ( SQL Reporting
Services 2005 ), all the frames gones away. If I misundertstood your
concern, please feel free to point it out.
I have tested on my SPS site. But it works fine.
1. I create a Web Page Part, configurate the Report Viewer Control to view
the report. In the report I use jump to url to redirect to another report.
2. I access the Web Page, the report shows fine.
3. I click the link in the report, and it redirected, and the Report Viewer
is fine.
Have you install SPS Service Pack 2? If not , please install and try to
check the issue again.
You can download SP2 from the following site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=171DC9A7-B4BA-4759-
BD64-6B7D851A97EF&displaylang=en
As for the convert from .rdl file to .rdlc file, you may follow this
article:
Converting RDL and RDLC Files
http://msdn2.microsoft.com/en-us/library/ms252109.aspx
Hope this will be helpful
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hi
Basically when I click on the link in a report, the report opens in the same
window but the other frames I had are lost.
I have tried using
javascript:void(window.open('reportURLandParameters','_self'));
but this does not work. The closest I have got is to replace '_self' with
the name of the iframe that the report viewer control uses. This works but i
get the report along with the report toolbar are displayed again within the
original report viewer frame. I tried adding &rc:toolbar=false to remove the
toolbar and this works but then the refresh button on the toolbar crashes
with javascript error and print preview thinks the original report page is
still being displayed.
Has anybody got a jump to report URL drill down to open in the report viewer
correctly when using the report viewer within a frame?
I really do not want to have to change the reports at this stage of
development.
I am using .rdl reports and Visual Studio 2005 with ASP.net 2.0.
Thanks
Lewis Holmes
eNate
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:kVKTqgxUGHA.4716@.TK2MSFTNGXA01.phx.gbl...
> Hi eNate,
> Welcome to use MSDN Managed Newsgroup Support.
> From your description, my understanding of this issue is: When you use the
> jump to url to view a report in the report viewer control ( SQL Reporting
> Services 2005 ), all the frames gones away. If I misundertstood your
> concern, please feel free to point it out.
> I have tested on my SPS site. But it works fine.
> 1. I create a Web Page Part, configurate the Report Viewer Control to
> view
> the report. In the report I use jump to url to redirect to another report.
> 2. I access the Web Page, the report shows fine.
> 3. I click the link in the report, and it redirected, and the Report
> Viewer
> is fine.
> Have you install SPS Service Pack 2? If not , please install and try to
> check the issue again.
> You can download SP2 from the following site:
> http://www.microsoft.com/downloads/details.aspx?FamilyId=171DC9A7-B4BA-4759-
> BD64-6B7D851A97EF&displaylang=en
> As for the convert from .rdl file to .rdlc file, you may follow this
> article:
> Converting RDL and RDLC Files
> http://msdn2.microsoft.com/en-us/library/ms252109.aspx
> Hope this will be helpful
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.
>|||What happens if you use jump to report instead?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"l.holmes" <enate@.newsgroups.nospam> wrote in message
news:OczKizyUGHA.4976@.TK2MSFTNGP11.phx.gbl...
> Hi
> Basically when I click on the link in a report, the report opens in the
> same window but the other frames I had are lost.
> I have tried using
> javascript:void(window.open('reportURLandParameters','_self'));
> but this does not work. The closest I have got is to replace '_self' with
> the name of the iframe that the report viewer control uses. This works but
> i get the report along with the report toolbar are displayed again within
> the original report viewer frame. I tried adding &rc:toolbar=false to
> remove the toolbar and this works but then the refresh button on the
> toolbar crashes with javascript error and print preview thinks the
> original report page is still being displayed.
> Has anybody got a jump to report URL drill down to open in the report
> viewer correctly when using the report viewer within a frame?
> I really do not want to have to change the reports at this stage of
> development.
> I am using .rdl reports and Visual Studio 2005 with ASP.net 2.0.
> Thanks
> Lewis Holmes
> eNate
>
> "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
> news:kVKTqgxUGHA.4716@.TK2MSFTNGXA01.phx.gbl...
>> Hi eNate,
>> Welcome to use MSDN Managed Newsgroup Support.
>> From your description, my understanding of this issue is: When you use
>> the
>> jump to url to view a report in the report viewer control ( SQL Reporting
>> Services 2005 ), all the frames gones away. If I misundertstood your
>> concern, please feel free to point it out.
>> I have tested on my SPS site. But it works fine.
>> 1. I create a Web Page Part, configurate the Report Viewer Control to
>> view
>> the report. In the report I use jump to url to redirect to another
>> report.
>> 2. I access the Web Page, the report shows fine.
>> 3. I click the link in the report, and it redirected, and the Report
>> Viewer
>> is fine.
>> Have you install SPS Service Pack 2? If not , please install and try to
>> check the issue again.
>> You can download SP2 from the following site:
>> http://www.microsoft.com/downloads/details.aspx?FamilyId=171DC9A7-B4BA-4759-
>> BD64-6B7D851A97EF&displaylang=en
>> As for the convert from .rdl file to .rdlc file, you may follow this
>> article:
>> Converting RDL and RDLC Files
>> http://msdn2.microsoft.com/en-us/library/ms252109.aspx
>> Hope this will be helpful
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community 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 report using Report sevices help me to get a solution

Hi all

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

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

For Example

Measures

Quarter1 Quarter2 Quarter3#

Profit Profit Profit

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

Dimension

Product1 200.50 1500.75 -200.40

Product2 5000.00 4000.00 6000.00

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

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

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

With regards

Polachan

In your sample report, I assume these are aggregated values that are summed by some sales? You will want to use a table that holds the sales. That table can be collapsed by the quarters to show the sum of the product for that quarter and the expanded to show the details of the sales.

I know that this reply does not go into detail on how this is done, but it might be a start.

|||

Dear guyinkalamazoo3

Thank u for ur reply to my quries

is it possible to drill down the measure object. ?...

For example in quarer 3 for product1 shows -200.40 loss.

So I want to drill down

Profit

-200.400
--> Customer Product Date Invoice Amt
- -
x Product1 01/10/2007 001 -100
y Product1 01/10/2007 001 -100.40

Can I give this type of drill down is possible in Measure attributes Profit. So I can find in which transaction occure loss to my organisation

Please help me to get a solution for this...

|||

Unfortunately, I hope somebody else might be able to help you with this problem as I am not that familiar with using cubes and OLAP in reporting. This is something that I am just learning myself. I am sure that the technical aspects for drilling down into the actual data in the reports is the same, but I am unfamiliar with data from OLAP.

Sorry I could not be of any further help.

|||

I am just starting on Reporting Services myself, and just finished my first drill down report. What you describe sounds like you should be able to do it.

There is a series of tutorials for Reporting services. The link below is to part of one. This section has 6 lessons that build up to lesson 6 - a drill down report.

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

Hope this helps point you in the right direction.

Shirley

drill down report using Report sevices

Hi all

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

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

For Example

Measures

Quarter1 Quarter2 Quarter3#

Profit Profit Profit

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

Dimension

Product1 200.50 1500.75 -200.40

Product2 5000.00 4000.00 6000.00

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

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

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

With regards

Polachan

In your sample report, I assume these are aggregated values that are summed by some sales? You will want to use a table that holds the sales. That table can be collapsed by the quarters to show the sum of the product for that quarter and the expanded to show the details of the sales.

I know that this reply does not go into detail on how this is done, but it might be a start.

|||

Dear guyinkalamazoo3

Thank u for ur reply to my quries

is it possible to drill down the measure object. ?...

For example in quarer 3 for product1 shows -200.40 loss.

So I want to drill down

Profit

-200.400
--> Customer Product Date Invoice Amt
- -
x Product1 01/10/2007 001 -100
y Product1 01/10/2007 001 -100.40

Can I give this type of drill down is possible in Measure attributes Profit. So I can find in which transaction occure loss to my organisation

Please help me to get a solution for this...

|||

Unfortunately, I hope somebody else might be able to help you with this problem as I am not that familiar with using cubes and OLAP in reporting. This is something that I am just learning myself. I am sure that the technical aspects for drilling down into the actual data in the reports is the same, but I am unfamiliar with data from OLAP.

Sorry I could not be of any further help.

|||

I am just starting on Reporting Services myself, and just finished my first drill down report. What you describe sounds like you should be able to do it.

There is a series of tutorials for Reporting services. The link below is to part of one. This section has 6 lessons that build up to lesson 6 - a drill down report.

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

Hope this helps point you in the right direction.

Shirley