Making Groups Visible Using Parameters

Apr 25, 2007

Hi everyone,

I am new to reporting services and really need some help..
Im trying to simply my requirement using this scenario: Lets say

I want to display Sales for the current year (i.e from the start of the year january to the month we are currently at). The next requirement is to group these sales, by Area , Region , Zone...

Top leve l = Zone , then Region then Area.

I need the user to be able to control this using a parameter (i.e User can select "View Area Level" or "View Region Level" or "View Zone level")

How can this best be achieved ?

My idea was using row groupings and controling visibility using the parameter.. The problem is.. If i want to view ONLY the area level and not see anything above, can I turn visibility off of the Zone and Region and still see the inner group (area)

Area Level (default view)

Jan Feb
Area 1 100 100
Area 2 200 200

Region Level Selected

Reagion 1
Area 1 100 100
Region 2
Area 2 200 200

Zone Level Select

Zone 1
Region 1
Area 1 100 100
Region 2
Area 2 200 200


Any help would REALLY be appreciated ..

Kind Regards,
Neil

View 7 Replies


ADVERTISEMENT

Making My Containers Visible Design Time

Feb 1, 2007

Hi all,

I have run into a problem! Im developing a SSIS package programmatically using C#. But when i create and add a container (foreachloop and sequence) the container is not becommming visible in design time in my intergration services designer (when i open the .dtsx package afterwards). Does anyone have a solution to this problem? It is only a problem with containers i create myself (it is working when im adding e.g. dataflow tasks to existing containers).

Sincerely

Bryan

View 10 Replies View Related

Making Inegration Services Visible/available In SSMS 2005

Jan 28, 2007

I have installed SQL Server Management Studio 2005 and have beenfinding the equivalent of the Data Transfer Services in SQLServer2000. I think I have worked out that it is in SQL Server IntegrationServices but when I open File-New-Project I do not see the SQL ServerIntegration Services there, though Help assumes that it is availablefor selection when starting a new project..How can I make it visible in the New Project window?I have successfully used the import function so I think this meansthat Inegration Services is there somewhere.I would appreciate some advice,Best wishes, John Morgan

View 3 Replies View Related

Visible Parameters That User Cannot Change

Mar 17, 2008

I have a report that I want users to navigate to and I want them to see the parameters of the report, but I don't want them to be able to change them. Is this possible?

View 3 Replies View Related

Report Parameters Being Searched For After They Have Been Removed From All Visible Interfaces

Aug 30, 2006

I've been building and testing my reports and have found that if I decide that a report parameter should be removed, removing the parameter causes the report to fail.

If I remove a report parameter via the 'Report Parameters' menu, and I also remove the associated data dimension, filter expression and parameter check boxes, when I preview the report I get an error message. It appears the report is searching for the old parameter name even after it has been deleted.

This leaves me with the option of either restoring the parameter as it was, or rebuilding the report from scratch. I've done some investigation and the parameters seem to exist within the XML code that underlies the report despite the parameters being deleted.

Is there a way to avoid this problem?

View 3 Replies View Related

Reporting Services :: SSRS 2008 R2 Cascading Parameters - Visible Only When Certain Criteria Previously Selected

Oct 22, 2015

I am creating a report where there are 3 tables in one report which have visibility set as an expression so that when a certain criteria is selected in the "Report" parameter, a different table is shown below.  This works as expected.

When table 3 is shown, I want a new parameter to be visible to the user called "Ward" where the user will select the ward they are interested in and the table will display data below just for the ward selected.  However, I don't want the ward parameter visible when either of the other 2 options are selected. Is this possible and how to do this? 

View 3 Replies View Related

Auto Hide Parameters Toolbar Without Making It Disappear

Jun 5, 2007

Hi,



anyone has any idea how to make the parameters toolbar to be automatically hidden when the report is first being accessed and subsequently to show the parameters when clicked on the arrows ? I have some users who complained that the parameters list is too long, so they wish to hide it first when accessing the report. I know there's this called rc: Parameters=false but this will permanently hide the toolbar which i don't want.

By the way, i am using sql 2000 reporting services

View 1 Replies View Related

Problem With Matrix (in Subreport, Multiple Groups), Groups Repeating First Row Data

Jan 25, 2008

I have a new SQL 2005 (SP2) Reporting Services server to which I've just upgraded and deployed some SSRS 2000 reports.

I have a subreport that contains a matrix with two groups. The report data seems to be inexplicably repeating the data for the first row in the group for all rows in the group. Example:









ID1
ID2
DisplayData

1
1
A

1
2
B

1
3
C

2
1
A

2
2
B

2
3
C

Parent group is on ID1, child group is on ID2, report would show:








1
1
A

2
A

3
A

2
1
A

2
A

3
A


Is this a matrix bug in 2005 SP2, or do I need to do something differently? I can no longer pull a comparison version from an SSRS 2000 server to verify, but I believe it was working as expected before...

View 2 Replies View Related

SQL Executive NOT Visible...

Mar 23, 1999

Hi,

When I register an SQL Server from elsewhere on the network, some of them are not displaying SQL Executive in the Enterprise manager.

Why is this?

View 1 Replies View Related

Data Not Visible???

Jan 27, 2004

I recently imported some Access tables into SQL Server. I can go into enterprise manager and return all rows and the data is there.

I build an ASP page to edit the data. After the connection the data for the record is displayed in a form. For some reason some fields are not coming through?

Is this a problem when converting to SQL Server. It just doesn't make sense that the table in Enterprise manager says the field is populated but when I do a pull via ASP the data doesn't come through.

Does anyone know anything about this?

Any help or pointing in the right direction would be greatly appreciated.

Thanks,

JW

View 5 Replies View Related

SUM Only Visible Rows

Oct 1, 2007

I am using an expression to hide values in a row based on a date field ( if date is bewtween this date and that date show value, otherwise hide it). My problem is now I need to sum all the values, even though some are not visible the sum is still adding them. Is there an expression to check for only "visible" rows??

View 6 Replies View Related

Keep The First 2 Columns Visible

Jan 16, 2008

I got a Report with a lot of columns and if the user scrolls, I would like to keep the first 2 columns visible. Excel offers a function like this is there something like this in Reporting?

View 3 Replies View Related

Triggers Not Visible

Jun 18, 2007

i created two new instances of SQL Server and created 2 triggers on each of these instances.

I go to object explorer under the triggers plus sign and there's no triggers there. But these instances recognize that the triggers are there because when i try to recreate them, i get a trigger already exist error message.

Is there a problem with my instances or is there something i need to change or configure?

I will really appreciate any help on this

View 5 Replies View Related

SQL Server Not Visible

Feb 15, 2007

I can't seem to make the SQL Server visible to anything other then SQL Server Tools. (management Studio, etc.)

Neither Visual Studio 2005, or Administrative Tools/Data Sources can view or connect with my SQL Server.

I need help, Thank you.

View 5 Replies View Related

Drive Not Visible For Backups

Feb 21, 2008

Hi all,
I have a 1 TB network drive on a Windows 2005 sql server that is visible at the OS level.I am trying to use this for my SQL backups but this drive is not visible from SQL server. All the other drives appear fine except this drive. The OS team already checked everything and as its visible at the OS level they point to SQL server as the one having problems.
Any suggestion would help..
-Thanks all.

View 18 Replies View Related

System Tables Are Not Visible At All, Why?

Jun 16, 2006

Dear all,

When you go to Sql Management Studio->Object Explorer and select Tables and then System you don€™t see any at all.
Why are not visible system tables for each user database as previously did Sql Server 2000 ? They are hidden or there is other stuff?
Any thought or view would be very appreciated.

View 1 Replies View Related

SQL DTS Designer Components Not Visible

Aug 20, 2007

Hi,
I installed SQL 2005 Enterprise Edition and SQL DTS Designer Components. However I cannot find the icon of the SQL Designer Components.

Thanks.
Lian.

View 1 Replies View Related

Check If An Object Is Visible

May 1, 2008



Is there anyway to check if a textbox (or detail row, etc) is visible? I'm envisioning something like an 'isVisible' function. I'm trying to set a filter in the detail section based on a toggled visibility.

Thanks.

Brad

View 7 Replies View Related

CLR Stored Procedure Not Visible

Dec 20, 2005

I am trying to do some time series analysis on data that I have. I've read that the best way to do this is to use CLR to write the manipulation code in .Net and then load the assembly into SQL rather than extracting the data, manipulating it and putting it back again.

I'm using crystal reports with visual studio 2003 to do my reporting. The problem I am facing is that the CLR stored procedures I create using SQLExpress are not visible from my SQL explorer built into Visual Studio 2003. I can create stored procedures using standard transact sql and these are visible, but the CLR stored procedures are not.

I've noticed when I browse the stored procedures in my SQL Management Studio that the image of the stored procedure has a padlock shown in the icon, as if they are locked?

Do I have to explicitly enable a security attribute on CLR stored procedures to make them visible?

Any help would be greatly appreciated.

View 3 Replies View Related

Home Properties Tab NOT Visible

Apr 1, 2008



When I type my 'http://ServerName/rmMyManager/Pages/Folder.aspx' I can see only Home and NOT Properties. I can see all the folders below that I have .


Just two days back I have changed permission to allow only me for deploying and have all those settings. Please guide me accordingly.

View 7 Replies View Related

Dts Object Not Visible In My DataFlow ScriptComponent

Jan 30, 2007

I am trying to set the TaskResult in my DataFlow ScriptComponent, but the Dts object is not visible.
Dts.TaskResult = Dts.Results.Failure
The above line works fine in my EventHandler script, but the Dts object seems to be out of scope when I try to use it from my Dataflow.
One thing I have noticed is that my DataFlow ScriptComponent inherits from 'UserComponent'
I have tried adding Microsoft.SqlServer.ScriptTask reference, but can not see it in the reference list - Strange?
 Any help appreciated.
Regards,
 Paul.
 

View 1 Replies View Related

Stored Procedure Not Visible In SQL Express

Apr 7, 2006

I have SQL express installed in my server and I created a stored procedure using SQL server management studio express, but when I refresh my stored procedures the one I created does not show. Please help.
Your valuable feedback is greatly appriciated.

View 4 Replies View Related

Relationships Not Visible In The Query Designer

Jan 26, 2008

Hello

I have created some tables and relationships between them by using MS SQL Server Management Studio Express.
The relationships are between a field named OId, which is not a part of the primary key but it is typed as an unique key. And a field named ParentTableOId.

When I open the two tables that have this relationship in the "Design Query in Editor" is not the relationship there.
Anybody who knows why?

Best Regards
/Erik

View 1 Replies View Related

+/- For Toggling Visible And Invisible Groupings

Mar 17, 2007

When defaulted to Visible or Invisible, +/- displays correctly. But when using the Expression, + is always showing as the default even when a group is expanded. Is this expected? TIA.



View 5 Replies View Related

Why Is A User Variable Not Visible In Expressions?

Oct 26, 2007

I have defined a variable varFileName and when I go to the Expression Builder in my Connection Manager Properties I can't see it and even when I type the name it says the variable is not existent or in a different scope. I have set the scope to be the very same package, that's for sure. Can anybody please tell me, as I can't solve this mistery, why the Builder does not see the var???

Darek

View 3 Replies View Related

ReportItems Only Visible On Print/export

Jan 14, 2008



Is there a way to make some elements on a report appear only when printed/exported ?

I recall this is possible in MS Access forms/reports, but am unable to find it in RS.

I'm thinking of Disclaimers, Company Logo etc...




View 3 Replies View Related

Data Processing Extension Not Visible

May 3, 2007

hello,



I have written a Custom Data Processing Extension for SSRS 2005.

The Report Server is in SharePoint integrated mode, this works perfect except for the extension.

When I want to set a DataSource in SharePoint (WSS 3.0), the extension is not in the ComboBox.

This works well on another server with the same extension.

The DLL file of that extension is copied in the reportserver bin folder.

I have added the references in the rsreportserver.config and rssrvpolicy.config (see below).


Code Snippetrsreportserver.config


<Data>

<Extension Name="SPSLISTS" Type="ICom.ReportingServices.SharepointListsExtension.Connection,

ICom.ReportingServices.SharepointListsExtension" />

<Data>




Code Snippet
rssrvpolicy.config
This code is located inside the CodeGroup with Name="SharePoint_Server_Strong_Name".


<CodeGroup class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="SPSLISTS_CodeGroup"

Description="Code group for my SPS LISTS data processing extension">

<IMembershipCondition class="UrlMembershipCondition"

version="1"

Url="D:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinICom.ReportingServices.SharepointListsExtension.dll"

/>

</CodeGroup>



I already tried re-installing Reporting Services and the add-in for SharePoint but the problem remains.



Does anyone has an idea of what's wrong here?



Thanks in advance,

Tom

View 3 Replies View Related

Import Data Option Not Visible

Aug 22, 2007

Hello All,

I have created a database on my local machine using SQL Server Express 2005. I am trying to export data from an excel file into a table in this database but when i see tasks available for the database there is no option of import data like I assume there should.
Only the following options are visible.
Detach
Shrink
Back Up
Restore
Generate Scripts

Any solutions on how I can get my excel file into the table.

Kiran

View 6 Replies View Related

Relationships Not Visible In The Query Designer

Jan 26, 2008

Hello

I have created some tables and relationships between them by using MS SQL Server Management Studio Express.
The relationships are between a field named OId, which is not a part of the primary key but it is typed as an unique key. And a field named ParentTableOId.

When I open the two tables that have this relationship in the "Design Query in Editor" is not the relationship there.
Anybody who knows why?

Best Regards
/Erik

View 1 Replies View Related

How To Keep Header Remain Visible While Scrolling

May 7, 2007

Hi,



I have matrix which has many rows. Is there any way to keep header remain visible while scrolling?



I tried to set "Group header should remain visible while scrolling" in my columngroup property but got the error:

[rsFixedHeadersInInnerDataRegion] The matrix €˜matrix1€™ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.



I have matrix inside a table which I set table property FixedHeaderto False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!



Thanks in advance!

View 3 Replies View Related

Steps In The Schedule Jobs Not Visible

Apr 14, 2008



In my production server all the jobs are scheduled. but though sa user id sometimes the steps in the jobs are not visible
but it is working, sometime it is visible in the sql server management studio.
do i have to check any settings or change any settings.

View 1 Replies View Related

BIDS:Precedance Constraints Not Visible

Jul 19, 2006

In the SSIS Package we have, the precedance constraints between the executables become invisible. It is difficult to find out if there are already constraints between the executables in the designer window.

Is this a bug? What is the easiest way to get them back?

- Gaurav

View 4 Replies View Related

Permissions Not Visible - SQL 2005 Management Studio

Jun 30, 2005

I'm trying to apply some security to my database, so i've created a role, added my user to the role and then set the security rights for the role. Everything work great, the security right behave exactly as defined....However, when I go back the the Permissions pages, the values that i've already set don't appear in the lists (the all still work). In Fact they don't show up anywhere either in the permissions for the table / sp concerned or the right for the user or role.Is it just me, or is it a problem with SQL 2005 Management Studio? or can anybody suggest a way of finding the securty rights of any given database object?Microsoft SQL Server 2005 Beta 2Microsoft SQL Server Management Studio 9.00.1116.00RegardsGary T 

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved