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.

dropdown menu in sql reporting

Is it possible in SQL Reporting 2005 to have dropdown menu(eg..on mouseover list of static menu appears from which i can navigate to other rdl files while passing all parameters) ..

Do you mean in the parameter pane or within the report ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I mean within the report..
As for now on i made one horizontal table and below it vertical menutable..now on form load and other event of the form i pass in navigation parqameter VerticaltableDisplay="N" and only in one event when Cell of horizontal table on top I pass parmeter =IIF(VerticaltableDisplay="Y","N","Y")

and in visiblity property of vertical table gave a condition =IIF(VerticaltableDisplay="Y",Display,Hide)*

It is working for click event ok but how can i do for mouseover event...

as if once clicked on report its visible and if there is no other even and we export to different format the verticaltable is visible

|||Javascript is very restricted in Reporting Services, I guess you cannot use the mouseover events here.

HTH, Jens K. Suessmeyer.

-
http://www.sqlserver2005.de
-

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

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

Drilldown question

Hi,

I've been playing around with SSRS 2005 to see if it might be the solution for some reporting requirements I have been given, but I still haven't found a way to do exactly what I need. Basically I've been asked to provide a report which allows drilling down multiple levels of a client hierarchy to show some sales figures, sounds pretty simple right? The report will look like this (not showing sales figues here just client hierarchy)...

+ Client A
- Client B
- Client C
- Client D
+ Client E
- Client F
- Client G
- Client H
- Client I
- Client J
+ Client K
+ Client L

As you can see they want to be able to expand & collapse rows to drill down through their client hierarchy. The hierarchy will be 3 or 4 levels deep.

I have seen that RS2005 supports a simple way to drill-down via grouping, but I don't want to do it this way because it means that I will have to have a query which retrieves all of the data right away which would take several minutes.

What I'd really like to do is to lazily load the hierarchy so that the data is loaded as the tree is expanded so that it won't take too long to render the report initially. I.e. when they click on "Client B" I'll hot the DB and get the sales figures for all children of Client B, in the case above thats Clients C & D.

Can this be achieved using sub reports or report linking? If anyone knows of some tutorials or examples that might be able to help me with this I would really appreciate it.

Thanks.

Lachlan

Hi

I am facing the same problem what you have stated. If you have got or found a solution please share it. It is quite urgent.

Thanking you in advance

regards

Sai

|||well, you could use several single reports i think
1. report all collapsed but root-rows and a link to another report (2. report) on each row
Query: WHERE hierachie level=1
2. report with the root rows and the rows below the row you clicked on 1.report
Query: WHERE hierachie level=1 or parent=<clicked row>
and so on ...

and all reports with the grouping you would usually have

but its very complex and wont be easy to implement i think

i also have to say that i've never tried it, its just an idea

greets
gerhard
|||

Hello Gerhard,

Can you please explain in detail. I have just started working on sql reporting services 2005 and I need a solution for a similar issue.

I need a drilldown report in the model given below.. Main values will be clientname, clientcode and total number of products purchased. When I expand details for each client I should see the SalesOrder #, Date, ProductPurchased , Qty and Price

I'm able to get this output:

ClientCode (MainGrouping)

SalesOrder# Date ProductPurchased Qty Price (DrilldownDetails )

But I'm not able to get this as output:

ClientCode ClientName Total# Purchased (MainGrouping)

SalesOrder# Date ProductPurchased Qty Price (DrilldownDetails )

I need it to really group by ClientCode. But the grouping line should display other fields related to that client..

How do I do this ?

Note : I have another question : I have tried the same with a Drill through report. The problem I'm facing here is, the drill thro detail report for each client opens in the same window, which I don't like. I want it to open in a new window. Is there a way to open a drill thro report in a new window ?

Thanks for your help in advance,

vidash

Drilldown question

Hi,

I've been playing around with SSRS 2005 to see if it might be the solution for some reporting requirements I have been given, but I still haven't found a way to do exactly what I need. Basically I've been asked to provide a report which allows drilling down multiple levels of a client hierarchy to show some sales figures, sounds pretty simple right? The report will look like this (not showing sales figues here just client hierarchy)...

+ Client A
- Client B
- Client C
- Client D
+ Client E
- Client F
- Client G
- Client H
- Client I
- Client J
+ Client K
+ Client L

As you can see they want to be able to expand & collapse rows to drill down through their client hierarchy. The hierarchy will be 3 or 4 levels deep.

I have seen that RS2005 supports a simple way to drill-down via grouping, but I don't want to do it this way because it means that I will have to have a query which retrieves all of the data right away which would take several minutes.

What I'd really like to do is to lazily load the hierarchy so that the data is loaded as the tree is expanded so that it won't take too long to render the report initially. I.e. when they click on "Client B" I'll hot the DB and get the sales figures for all children of Client B, in the case above thats Clients C & D.

Can this be achieved using sub reports or report linking? If anyone knows of some tutorials or examples that might be able to help me with this I would really appreciate it.

Thanks.

Lachlan

Hi

I am facing the same problem what you have stated. If you have got or found a solution please share it. It is quite urgent.

Thanking you in advance

regards

Sai

|||well, you could use several single reports i think
1. report all collapsed but root-rows and a link to another report (2. report) on each row
Query: WHERE hierachie level=1
2. report with the root rows and the rows below the row you clicked on 1.report
Query: WHERE hierachie level=1 or parent=<clicked row>
and so on ...

and all reports with the grouping you would usually have

but its very complex and wont be easy to implement i think

i also have to say that i've never tried it, its just an idea

greets
gerhard|||

Hello Gerhard,

Can you please explain in detail. I have just started working on sql reporting services 2005 and I need a solution for a similar issue.

I need a drilldown report in the model given below.. Main values will be clientname, clientcode and total number of products purchased. When I expand details for each client I should see the SalesOrder #, Date, ProductPurchased , Qty and Price

I'm able to get this output:

ClientCode (MainGrouping)

SalesOrder# Date ProductPurchased Qty Price (DrilldownDetails )

But I'm not able to get this as output:

ClientCode ClientName Total# Purchased (MainGrouping)

SalesOrder# Date ProductPurchased Qty Price (DrilldownDetails )

I need it to really group by ClientCode. But the grouping line should display other fields related to that client..

How do I do this ?

Note : I have another question : I have tried the same with a Drill through report. The problem I'm facing here is, the drill thro detail report for each client opens in the same window, which I don't like. I want it to open in a new window. Is there a way to open a drill thro report in a new window ?

Thanks for your help in advance,

vidash

Drilldown question

Hi,

I've been playing around with SSRS 2005 to see if it might be the solution for some reporting requirements I have been given, but I still haven't found a way to do exactly what I need. Basically I've been asked to provide a report which allows drilling down multiple levels of a client hierarchy to show some sales figures, sounds pretty simple right? The report will look like this (not showing sales figues here just client hierarchy)...

+ Client A
- Client B
- Client C
- Client D
+ Client E
- Client F
- Client G
- Client H
- Client I
- Client J
+ Client K
+ Client L

As you can see they want to be able to expand & collapse rows to drill down through their client hierarchy. The hierarchy will be 3 or 4 levels deep.

I have seen that RS2005 supports a simple way to drill-down via grouping, but I don't want to do it this way because it means that I will have to have a query which retrieves all of the data right away which would take several minutes.

What I'd really like to do is to lazily load the hierarchy so that the data is loaded as the tree is expanded so that it won't take too long to render the report initially. I.e. when they click on "Client B" I'll hot the DB and get the sales figures for all children of Client B, in the case above thats Clients C & D.

Can this be achieved using sub reports or report linking? If anyone knows of some tutorials or examples that might be able to help me with this I would really appreciate it.

Thanks.

Lachlan

Hi

I am facing the same problem what you have stated. If you have got or found a solution please share it. It is quite urgent.

Thanking you in advance

regards

Sai

|||well, you could use several single reports i think
1. report all collapsed but root-rows and a link to another report (2. report) on each row
Query: WHERE hierachie level=1
2. report with the root rows and the rows below the row you clicked on 1.report
Query: WHERE hierachie level=1 or parent=<clicked row>
and so on ...

and all reports with the grouping you would usually have

but its very complex and wont be easy to implement i think

i also have to say that i've never tried it, its just an idea

greets
gerhard|||

Hello Gerhard,

Can you please explain in detail. I have just started working on sql reporting services 2005 and I need a solution for a similar issue.

I need a drilldown report in the model given below.. Main values will be clientname, clientcode and total number of products purchased. When I expand details for each client I should see the SalesOrder #, Date, ProductPurchased , Qty and Price

I'm able to get this output:

ClientCode (MainGrouping)

SalesOrder# Date ProductPurchased Qty Price (DrilldownDetails )

But I'm not able to get this as output:

ClientCode ClientName Total# Purchased (MainGrouping)

SalesOrder# Date ProductPurchased Qty Price (DrilldownDetails )

I need it to really group by ClientCode. But the grouping line should display other fields related to that client..

How do I do this ?

Note : I have another question : I have tried the same with a Drill through report. The problem I'm facing here is, the drill thro detail report for each client opens in the same window, which I don't like. I want it to open in a new window. Is there a way to open a drill thro report in a new window ?

Thanks for your help in advance,

vidash

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.

Drilldown in SQl Reporting Service

Hi,

I'm new to SQL Reporting Service. Now only I've started studying that. My question is,

I wanna list out my product sales for each month for each keywords. For example, I have 4 products, some 15 keywords (its an ecommerce site. Visitor coming from a particluar keyword and buying some products. Wanna list out sales for each keywords and product for Every month. To know the quarter sales wanna see the sales and product name for particular keyword). I'm having reports for each month sales. like,

Keywords

Product A

Product B

Product C

Product D

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

For quarter sales, I want to see the sales and keywords list for each month and for each products in the same report. I don't want to create one another report for each and every product and month. If I want to see the sales and keywords for a particular product I want a report like,

For Product 1

Keywords

Month1

Month2

Month3

Month4

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

and

For Month 1

Keywords

Product A

Product B

Product C

Product D

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

Just by using drilldown I want this report. If any other method is possible, please tell me. It's very urgent. Please Help me. I'm very new to SQL Reporting Service. Started studying before 2 days. Thanks.............

This is possible,

What U have to do, just right click on perticular textbox from which U want drill down, and go to properties.

There u find Navigatioin Tab, In this tab there is one option Jump to report, select it and give name of detail report u want in drilldown.

If drilldown wants parameters from parent report, give parameters by click on Button Parameters besides.

Try this it works fine, i have design many report like this and Be Cool.

|||

Hi,

Can you please explain me fully? I want same report wiht drilldown. I want to see quarter sales for particular product and a month sales for all products for the same set of keywords. Can you please tell me how to give input and all? Thanks...

|||

Hi!

I'm experiencing whit a strange behaviour in reporting services and drill down: I’ve a report with a graphic and nothing else. If I publish the report through a windows server 2003 R2 I can click on a element in the graph and a new report is shown. But if I publish the report by a windows XP Pro I see the report correctly but if I click on a element in the graph nothing happens.

Does it depend on the SSRS configuration or is the behaviour OS related?

Thanks in advance.

Alx

Drilldown in SQl Reporting Service

Hi,

I'm new to SQL Reporting Service. Now only I've started studying that. My question is,

I wanna list out my product sales for each month for each keywords. For example, I have 4 products, some 15 keywords (its an ecommerce site. Visitor coming from a particluar keyword and buying some products. Wanna list out sales for each keywords and product for Every month. To know the quarter sales wanna see the sales and product name for particular keyword). I'm having reports for each month sales. like,

KeywordsProduct AProduct BProduct CProduct DKeyword 11252427512Keyword 2456245671223

For quarter sales, I want to see the sales and keywords list for each month and for each products in the same report. I don't want to create one another report for each and every product and month. If I want to see the sales and keywords for a particular product I want a report like,

For Product 1

KeywordsMonth1Month2Month3Month4Keyword 11252427512Keyword 2456245671223

and

For Month 1

KeywordsProduct AProduct BProduct CProduct DKeyword 11252427512Keyword 2456245671223

Just by using drilldown I want this report. If any other method is possible, please tell me. It's very urgent. Please Help me. I'm very new to SQL Reporting Service. Started studying before 2 days. Thanks.............

This is possible,

What U have to do, just right click on perticular textbox from which U want drill down, and go to properties.

There u find Navigatioin Tab, In this tab there is one option Jump to report, select it and give name of detail report u want in drilldown.

If drilldown wants parameters from parent report, give parameters by click on Button Parameters besides.

Try this it works fine, i have design many report like this and Be Cool.

|||

Hi,

Can you please explain me fully? I want same report wiht drilldown. I want to see quarter sales for particular product and a month sales for all products for the same set of keywords. Can you please tell me how to give input and all? Thanks...

|||

Hi!

I'm experiencing whit a strange behaviour in reporting services and drill down: I’ve a report with a graphic and nothing else. If I publish the report through a windows server 2003 R2 I can click on a element in the graph and a new report is shown. But if I publish the report by a windows XP Pro I see the report correctly but if I click on a element in the graph nothing happens.

Does it depend on the SSRS configuration or is the behaviour OS related?

Thanks in advance.

Alx

Drilldown in SQl Reporting Service

Hi,

I'm new to SQL Reporting Service. Now only I've started studying that. My question is,

I wanna list out my product sales for each month for each keywords. For example, I have 4 products, some 15 keywords (its an ecommerce site. Visitor coming from a particluar keyword and buying some products. Wanna list out sales for each keywords and product for Every month. To know the quarter sales wanna see the sales and product name for particular keyword). I'm having reports for each month sales. like,

Keywords

Product A

Product B

Product C

Product D

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

For quarter sales, I want to see the sales and keywords list for each month and for each products in the same report. I don't want to create one another report for each and every product and month. If I want to see the sales and keywords for a particular product I want a report like,

For Product 1

Keywords

Month1

Month2

Month3

Month4

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

and

For Month 1

Keywords

Product A

Product B

Product C

Product D

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

Just by using drilldown I want this report. If any other method is possible, please tell me. It's very urgent. Please Help me. I'm very new to SQL Reporting Service. Started studying before 2 days. Thanks.............

This is possible,

What U have to do, just right click on perticular textbox from which U want drill down, and go to properties.

There u find Navigatioin Tab, In this tab there is one option Jump to report, select it and give name of detail report u want in drilldown.

If drilldown wants parameters from parent report, give parameters by click on Button Parameters besides.

Try this it works fine, i have design many report like this and Be Cool.

|||

Hi,

Can you please explain me fully? I want same report wiht drilldown. I want to see quarter sales for particular product and a month sales for all products for the same set of keywords. Can you please tell me how to give input and all? Thanks...

|||

Hi!

I'm experiencing whit a strange behaviour in reporting services and drill down: I’ve a report with a graphic and nothing else. If I publish the report through a windows server 2003 R2 I can click on a element in the graph and a new report is shown. But if I publish the report by a windows XP Pro I see the report correctly but if I click on a element in the graph nothing happens.

Does it depend on the SSRS configuration or is the behaviour OS related?

Thanks in advance.

Alx

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