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