How Can I Drillthrough To Reports In Another Project

May 2, 2007

I'm trying to use the drill-through feature to link to a report in the same solution, on the same server, but in a different project. Local help files say:

"The list of report names includes all reports in the current report server project. If the drillthrough report is on the report server but is not in the project, type the name of the report. The report name can contain a relative or absolute path to the report."

Can someone give an example of a relative or absolute path? Nothing I've tried has worked.

Thanks,

JL

View 5 Replies

Problem In Displaying Drillthrough Reports(15th Mar)

Mar 15, 2008

Hi all
I have created two reports.
And check the jump to option button and gave the second report name.and passed the parameter in first report.
Problem is when i click on preview button on the main report,First time i am able to see the main report and when i click on the linked text box i am able to view the second report.
But when i click on the preview button second time i am directly getting the second report preview.
How can i view first report every time i click on preview button.From there i need to go to second report by clicking on the specified text box.
How can i Achieve it.

Any body pls help me.

View 11 Replies View Related

Drillthrough Question - How To Return To Same Report Page Where Drillthrough Occurred?

Apr 10, 2007

Hello,

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

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

Thanks,

BCB

View 1 Replies View Related

Drillthrough In Calculated Fields Enable When Drillthrough Option Is Disable In Original Fields, Is This A BUG?

Jan 21, 2008

Hi people
My users are having troubles with link to default drillthrough report when reports are exported to excel (they REALLY don't like this behavior ), so I decided set all of them disabled in report model, this work fine, but calculated field in reports has this drillthrough link.

Let me show you the situation. Entity Product has an UnitaryCost field, I set the EnableDrillthrough Property in False so when I export a report with this field, no link is shown.

But if I create in the report a calculated field Round(UnitaryCost) this field has a Drillthrough Link

Is this the standard and expected behavior? or its simply a BUG?

Have I done something wrong in my model? and in this case, How I can correct this?

regards.
Julio Diaz.

View 1 Replies View Related

Project Reports

Jul 17, 2001

What is a good piece of software that can interact with SQL Server 2000 and handle Project Reports (Engineering/Construction/Architecture)?

View 1 Replies View Related

Deployment Of Reports Outside Reporting Project

Feb 27, 2008

We had some problems in deploying the reports to the client. Previously we used to deploy the reports in our development environment through reporting project but now we need to physically deploy the reports to the client on 14 different servers. We don't have access to the reporting project on site. Is there any way to deploy the reports outside reporting project?

Thanks,

View 4 Replies View Related

Deploying Reports From SSRS Project

May 19, 2008

I have created some reports in BIDS and saved them to a folder in my m/c (without deploying them) . i want to deploy that to the report server through C# code.

i can deploy that onto any Report Server. For that I will have to change the datasource connection string.

Is there a way to achieve this. Please let me know if it is there.

Regards...
Girija Shankar

View 5 Replies View Related

How To Create Subfolders In A Reports Project

Feb 8, 2008

I seem to be missing something rather obvious... I cannot find a way to create subfolder in my reports project in Visual Studio (2005).

Can someone help me out here?

View 11 Replies View Related

Vb2005 Express - Design Reports And Add To Project

Jan 16, 2008

Ok, I'm using vb2005 express and I know that the reportviewer control has to be added and reports can't be designed from the IDE. So, I downloaded the business intelligence studio and I can design a report that looks like just what I want. What I can't seem to do is add that report to the application I'm developing. I don't want to use a report server - I want to use the report with client side processsing. I'm wondering if this is possible and if so how? When I try to add that .rdl file or rename it to a .rdcl file to my project I'm not allowed to do so. Any thoughts?

View 4 Replies View Related

Team Project In TFS - SSIS Project Sets Itself As The Startup Project

May 29, 2008

For some reason in a Team Foundation Team Project that has multiple project types (SSRS, SSIS, WebSite, C# Business DLL...), the SSIS project makes itself the startup project to the team project. If I explicitly set another project as the startup project to the team project and then select an SSIS package in the SSIS project in the team project, the SSIS project becomes the startup project automatically.

I am using Visual Studio 2005 SP1.

View 3 Replies View Related

Problem In Opening The Project..Make Sure The Application For The Project Type (.dtproj) Is Installed.

Jun 24, 2007

Hi,

I have been working on some SSIS packages for a while now and today while i was working i was trying to create a new connection and in the process there was an error and it said the BIDS has to be closed and i closed it but later when i open BIDS and try to open my project(.sln) from the file menu to work on the half done package it pops up an error which shows the path to my project location on the first line and next statement on the pop up error box says:

"Make Sure the application for the project type (.dtproj) is installed."

I tried to check some forums in which some suggested to try installing SP1 which i tried but ..i dont know why but the SP1 fails to install (i dont know if its causing problem becoz i already installed SP2 as i had some other problem before for which the cure was to install SP2).

Did anyone here face such a problem before ?

I'd really appreciate if the experts here can tell a cure for this problem.

thanks,

Ravi

View 4 Replies View Related

Visual Studio 2005 Automatically Sets SSIS Project As Startup Project

Feb 23, 2007

I have a Visual Studio 2005 solution which contains a Sql Server Integration Services (SSIS) project.

In this solution I have explicitly set a Web application project as startup project, but whenever I edit a DTS package within the SSIS project, VS automatically sets the SSIS project as startup project and the package I edit as startup object.

Needless to say, this may cause some really unwanted incidents when running the solution - thinking that you're about to run the Web application project (that was explicitly set as startup project), but instead, you run the edited package in the SSIS project.

Is there any way to avoid having the SSIS project automatically setting itself as startup project, any workaround here at all? :)

Thanks.

View 4 Replies View Related

Integration Services :: Importing Deployed Project From Catalog Into New SSIS Project

Jun 16, 2015

in order to maintain a deployed project into an Integration Services Catalog I'd like to know if it is possible to import it into a new project inside SSDT.

View 5 Replies View Related

PSI: How To Update Custom Field Value For A Perticular Project Using PSI(Project Server 2007)

May 6, 2007

Hi,

I want to update value of a custom field for a perticular project in Project Server 2007 using PSI.

I have created 5 enterprise custom fields(A,B,C,D,E) through PWA/Server Settings.

I want to search all Projects on Server. If any project is having value for custom field A then I want to update rest of the custom fields(B,C,D,E) for that perticular project.

I dont know how to do it please help.

Thanks in Advance

Madhukar

View 5 Replies View Related

Can't Create A Setup Project For Project Referencing Microsoft.SqlServer.ManagedDTS

Feb 3, 2007

I have a very small project written in VB.Net 2005 using the SQL Server 2005 SSiS DTSx package.

I took a SQL Server 2000 dts package and using the SQL Server 3005 legacy tools migrated it so I could still use the package withing SQL 2005 until I can build one using BI/SSIS.

Anyway,I added the reference Microsoft.SqlServer.ManagedDTS so I could then use the Microsoft.SqlServer.Dts.Runtime so I can execute the commands:

Dim oApp As New Application
Dim oPkg As New Package
oPkg = oApp.LoadPackage(g_DTSx_Directory & "AOC copy Generic1 CSV to AOC_verify_file_1.dtsx", Nothing)
Dim oResults As DTSExecResult
oResults = oPkg.Execute

Ok. That works fine. Executes without a hitch. So now I try and create a setup project for this and I use the setup wizard.

During the creation of the setup project I get a message that states:
The following files may have dependencies that cannot be determined automatically. Please confirm that all dependencies have been added to the project.
C:windowssystem32msxml6.dll

OK. The dll is part of the reference I mentioned above and I have no idea what other dependencies it may have.

How do I find this out?

Has anyone else created a project like this and experenced the same?

I am on a clean build running WinXP Pro with SP2 - VS2005 with SP1 and the SQL Server 2005 tools.

View 1 Replies View Related

Integration Services :: Automate Process Of Creating A Project On SSISDB Based On SSIS Project Name?

Apr 20, 2015

I've got an SSIS solution file with project deployment model in VS 2013 and would like to deploy that to SSISDB on different environments.All these days I followed the regular way to create a project in SSISDB and deploy it to that. Now want to find out if i can automate this process and so got some questions

1. Can we automate the process of creating a project on SSISDB based on our SSIS project name? This will be like when we do a deployment it should check if the project exists or not on SSISDB based on our SSIS project name, if the project exists we just deploy the packages in the project and if the project does not exists in SSISDB it will create that project and deploy the packages.

2. Can we also automate the process of creating environments? In traditional way we manually create the environment variables under environment tab of SSISDB, but can we make that also as part of deployment? Like when we are releasing to Dev server we look if that particular Dev variable exists on that server, if it exists we just update the existing stuff and if it does not exists we just create it.

View 2 Replies View Related

Business Intelligence Project/Integration Services Project Not Showing Up In Visual Studio 2008

Mar 31, 2008

I have visual studio 2005 and sql server 2005 with integration service installed on my machine. Couple of days ago, I installed visual studio 2008 professional. When I go to create SSIS project I dont see it in visual studio 2008. What do I have to do to make it appear in visual studio 2008 so that I can create SSIS projects.

Thanks.

View 7 Replies View Related

Unable To Use Project Professional To Establish Connection To Project Server

Jul 23, 2007

I fail to use project professional 2003 to access to the project server 2003 using MSDE 2000 in local area network, following message was shown,

Connection failed:

SQLState: '01000' SQL Server Error 1326 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
Connection failed:
SQLState '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

I have seen these pages with similiar cases but can't help.

http://support.microsoft.com/kb/818047/

http://support.microsoft.com/kb/837653/en-us

Can anyone help me?? Thanks a lot!

View 1 Replies View Related

Drillthrough

Mar 27, 2007

I am a confused newbie, grateful for some help. I need to select 10 rows from total profit of married people. How would I do that?

DRILLTHROUGH MAXROWS 10 SELECT
{[Measures].[Total Profit]} on 0, [customer].[Name]ON 1 ON columns
FROM from [Electronics] WHERE [Demo].[civilstatus-salary].[civilstatus].&[married]}
RETURN [Measures].[Total profit](as rows)

View 2 Replies View Related

Drillthrough (beginner)

Jan 5, 2007

I have created two reports. One links to the other with a drillthrough. The linking works fine, but no values show up in the fields besides the group titles and column titles. Why is this happening?

The user is given a list of Counties with values. The Counties(in a matrix) are clickable for a drillthrough of Ages and Genders in the Counties. Looks something like this:

Years

Counties Total Crashes Fatalities

Cook 85 98

Manchester 2850 258

Sagamon 987 526

So when a user clicks a county, such as "Cook", this is displayed

Years

Age Gender Total Crashes Fatalities

0-8 Female 25 8

Male 55 15

9-15 Female 850 258

Male 185 35

16-22 Female 87 526

Male 10 35

But I am getting this in :

Years

Age Gender Total Crashes Fatalities

0-8 Female

Male

9-15 Female

Male

16-22 Female

Male

Whats going on? Can anyone make any suggestions? Just to let you know its based off of an Analysis Services Cube and not relational tables.

View 2 Replies View Related

Can You Have A Drillthrough If Your Using An AS Cube

Jan 11, 2007

Trying to drillthrough one report to another. But im not getting the correct values. I dont know why its not working. I created the parameters and linked them in the properties of the clickable field. What am i missing? or is it more complex in a cube to drillthrough then relational tables?

View 3 Replies View Related

Create SQL Server Project In VB.NET 2.0 (Database Project)

Mar 13, 2008

Hi all How can create trigger in sql server project in VB.NET 2.0 ?thanks in advance

View 1 Replies View Related

Want The Parameters To Appear ON The Drillthrough Report

Nov 29, 2007

Hello again,

We have a drillthrough report that our users will see as part of an ASP.net page. I would like to nicely show the parameters that were sent through from the main report, maybe in a text box of some kind. However, when I set a text box value to =Fields!FieldName.value, I get the tuple: [Dimension].[Hierarchy].&[Member]. I just want the Member.

I know I can parse out the value, but is there any easier way that I'm missing. We aren't using the parameter bar that comes with RS, we want the report itself, above the matrix with the data, to show the parameters.

Any ideas, resources, references, links or good clean jokes would be appreciated.

Thanks,
Kathryn

View 2 Replies View Related

Permission Error On Drillthrough

Jun 27, 2007

I've published a matrix type report through report builder to my report server, based on the model I created. When I click the subtotals to drillthrough, I receive the following error:

"The permissions granted to user 'Domainuserid' are insufficient for performing this operation. (rsAccessDenied)"

If I explicitly specify another report to tie to the drillthrough property on the entity via the model property page in SSMS, the drillthrough stuff works fine. But if I just rely on Reporting services to auto generate ( see "Autogenerated" here ) the clickthrough report I get the error above. Can anyone help?

View 1 Replies View Related

Drillthrough Help In Report Builder

Jan 8, 2007

Hi,

I've looked at all of the published materials related to this subject that I could find but cannot find a good answer.

I'm trying to find out if there is a way to directly influence what details are shown when a figure is clicked on in a report.

I know it shows related data but it does not seem to show it all, infact it seems to pick pretty arbitrary things.

I've tried messing around with the attribute properties (in particular the EnableDrillthrough one) but to no avail.

Is there anything I am missing?

Thanks in advance.

View 4 Replies View Related

DRILLTHROUGH In Report Server

May 21, 2007

Dear all,

Please help to create DRILLTHROUGH in a report server project. I am a beginner . I want the DRILLTHROUGH featrure in Report server like same as that of analysis server project

Please help

regards

Polachan

View 3 Replies View Related

Drillthrough Missing Rows (AS 2005)

Jun 27, 2007

I have enabled drillthrough on a cube (AS 2005) and selected the columns required. This worked. When I use the drillthrough option in Excel, drillthrough queries return less rows than expected. For example, for a cells combinations (pivot table) I saw 21198 rows, but after access to detail, query return just 21106 rows. Less rows than expected.

Any ideas what causes this?

Thanks!

:)

View 1 Replies View Related

OLAP Drillthrough For Null Data

Mar 31, 2004

Hi:

The drillthrough in my cube is working fine except for the cases where the dimension member is null. For example I have the dimension
PRODUCT (dim)
- PROD_TYPE_CD (name = PROD_TYPE_CD || '-' || PROD_TYPE_NM)
- PROD_CD
-PROD_NM

So for if the data is like the following where the PROD_TYPE_CD is null :
- (name = -FOOD)
- 123
- bread

The drillthough is not displaying any data no matter I select the PROD_TYPE_CD, PROD_CD or PROD_NM in the dimension drop down altough if query the DB directly I found data to display in the drillthrough
Any ideas why this is happening and how to solve it.

Thanks
J

View 1 Replies View Related

Drillthrough Report Link Not Working

Oct 25, 2007

Good morning all!

I am working on a Actuals vs Budget report which needs drillthrough capability. Right now the reports are not deployed, I am working on them in Visual Studio 2005.

My main report has a text box with the Navigation tab set to Jump to report: DrillThrough1025. I have set all the parameters to pass through to the drill through report.

When I preview my main report and click on the drillthrough textbox, the DrillThrough1025 Report opens, but it opens with the parameter bar at the top, waiting for the parameters to be filled in.

Am I making a basic newbie error somewhere?

Any ideas, references, or resources would be greatly appreciated.

Thanks,
Kathryn

View 1 Replies View Related

Drillthrough Shows Other Data Than SQL Server

Oct 25, 2007

Hello!

I'm working with the SQL Server 2005 Developer Edition. When i created a mining structure for association rules and go into the rule by drillthrough there's something i don't understand.

In the SQL Server the data set is:

ID: MM: MF:
47 463 200

And drillthrough shows me:

ID: MM: MF:
47 476 227

Why is the result of drillthrough another than in the table of the SQL Server???

View 1 Replies View Related

Drillthrough Question - How To Return To Same Page?

Apr 11, 2007

Hello,

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

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

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

Thanks,

BCB

View 4 Replies View Related

Analysis :: Drillthrough With Measures From Two Measure Groups

Nov 4, 2014

I'm trying to show measures from 2 measures groups in a drillthrough. Obviously, it's not possible with a standard drillthrough action, but I still hope that I can somehow achieve this with the ASSP GetCustomDrillthroughMDX function.

Speaking in AdventureWorks2008R2 terms: Imagine I have a pivot table with Product Categories in filter (say, filtered on Gloves) and "Internet Sales Amount" as measure. From context menu in Excel I can call the drillthrough action which shows me the individual sales records. I would like to show in drillthrough additionally "End of Day Rate" measure from "Exchange Rates" measure group.

One option would be to join FactInternetSales with FactCurrencyRate and make EndOfDayRate a physical measure in the "Internet Sales" measure group. This is a pretty huge overhead for my scenario and I'd like to avoid this.

Another one would be to call something completely external for a drillthrough (for example, a SRRS Report).

View 3 Replies View Related

Problems With Filters/Drillthrough/calculated Measures

May 20, 2008

Wondering if anyone has any work arounds.

We have a cube that has financial data in it. There are report actions on cells. I want them to be able to drill through the the supporting data stored in the fact table and all the measures I am showing are calculated measures.

Users connect to this cube from Excel 2007. If they use a "Filter" in Excel and do not select "All" or "One" of the members of the filter hierarchy, then the action dissapears. Microsoft explained this is because that cell then has a calculated cordinate and they can't determine the action to perform.

Has anyone experienced a need to do this? Can you provide me alternatives?

Thanks

[Edit]

The functionality I am looking for is not available in the BIDS either (Well it is to a point--if you select the first 2, 3, 4...members in the filter, the action will still appear. It only reads the first one however. If you select the members starting with any but the first, the action disappears).

Chris

View 5 Replies View Related