Hiding/Collapsing Report Sections

May 16, 2007

I have lot of information to display on one report. I am trying to come up with a reasonable layout, that could include all the information on one page without over whelming the user. Essentially I would like to divide the report in three sections, ideally with a collapse/expand functionality. Is it possible with Reporting services. How?



- Section1 Heading....(Expanded/Visible)

<Table, text boxes, lists go here>

<data region>

<data region>

<...>

<...>



+ Section2 Heading (Collapsed/Hidden)

<Table and other data regions are hidden>



+ Section3 Heading (Collapsed/Hidden)

<Table and other data regions are hidden>



Any help will be appreciated.



Thanks.



DNG

View 3 Replies


ADVERTISEMENT

Hiding Sections Of Text

Feb 15, 2008

I'm new at Reporting Services. I need to know if the Reporting Services will meet my needs.

I need to create a report that looks much like a Word document with large sections of text. Is it possible to hide some sections of text based on boolean fields in a SQL table/query?

Alternatively.. will it handle rich text? I could then select the appropreate section to display by query.


Thanks in advance

View 1 Replies View Related

Creating Sections And Subsections In Report

Feb 26, 2008



Hi,
I am new to Microsoft SQL Server Reporting Services.
Please tell how to create sections and subsections in the report.
Pls provide if any document is there ..


Thanks
Rajiv Gupta

View 9 Replies View Related

Hiding Sub Report

Jan 9, 2008

I have main reports and also sub reports in the same project [folder]. I don't want to show sub reports in the reports drop down list. Can you please let me know how to do it?

View 1 Replies View Related

Hiding Tables In A Report

May 6, 2007

Hi,



Can anyone help me with the expression I need to use in order to hide a table with no rows? I have put my table inside a rectangle with the idea that I would just hide the rectangle if there weren't any rows but I can't find any examples of what expression I can use to specify the no rows condition.



Thanks!

Debi

View 5 Replies View Related

Hiding Sub Report - Auto Deployment

Jan 9, 2008

I just asked you about how to hide the sub report from showing it in the drop down list. I have done it with the report manager [Report properties--> general --> Hide in Listview]. I am using RSBuild tool to automatically deploy the reports.I don't know what modification I have to make in the RSBuild code to incorporate this new functionality[Hiding sub report]. Can you please let me know how to do it?


I am using the following code, The description property is working correctly. But the Hide in List view property is not working.
Property[] properties = new Property[2];

Property Prop1 = new Property();
Property Prop2 = new Property();

Prop1.Name = "HideInListView";
Prop1.Value = "True";

properties.SetValue(Prop1, 0);
Prop2.Name = "Description";Prop2.Value = "Muni deployed sub report";

properties.SetValue(Prop2, 1);


But I don't know the proprty name and value for Hide in List view.


Can you please give me the suggestion?

View 4 Replies View Related

Report Hiding Duplicates, Not Wanted

Apr 16, 2007

I created a report which has duplicates on one field. I want the report to display the duplicates, but cannot figure out how. Anywhere I have found where there is a "Hide Duplicates" option I have it turned off (in matrix properties), but the report matrix still hides the duplicates. I don't understand why this would happen since the other fields on the same record are not duplicates. I tried grouping but that was no help.

The query in the dataset DOES return the duplicates as expected.



Anyone know how to fix this, or if it is a bug?



Thanks,

Chris

View 1 Replies View Related

Group By / Hiding Report Items (Newbie)

Apr 3, 2008

Hi. First, I am VERY new to SQL Queries and Reporting. A co-worker is "mentoring" me, but I am trying not to fill his day with questions.

I HAVE read the help files, searched the forums, looked at books, and done general web searches, but any answers I have found have either no addressed my issue, or the answers are way over my head.

Furthermore, the (SQL 2000) DB is built into proprietary software (ISS Proventia Intrusion Prevention System), and the database may NOT be modified outside of the software.

With that said, I am querying multiple tables within the DB. I am using Business Intelligence Dev Studio, and placing my queries on a reporting server maintained by my co-worker. My goal is not only to get a solution, but also to UNDERSTAND it so I can continue to learn. Of course, the solution takes precedence over my understanding!

My Primary key is dbo.SensorData1.SensorDataID. dbo.SensorDataAVP.AttributeText returns a different number of rows, containing different data depending upon the value of dbo.SensorData1.AlertName. I need to return all rows, hence the Left Joins.

Depending upon my query, I might have 1000 events, and due to the many rows of data from dbo.SensorData1.AlertName I might return 20,000 rows (or more.)

I would like to return a report that "groups" events by dbo.SensorData1.SensorDataID., BUT, rather than simply providing these in groups, provides me single rows with a plus sign next to each even, that can be expanded for the additional data.

My co-worker has discussed sub-tables, but since I cannot modify the DB, it will be difficult / complex to do so, AND, for me to understand.

One of my queries follows. I have thirteen queries, total, that use various groupings of attributes. I have chosen one of the more complex combinations so I can generally apply the concept to the queries with fewer parameters more easily.

Note, I'll be asking the same question on www.sqlservercentral.com in the hopes of getting an answer I can understand one of these two places - If you answer here, there's obviously no need answering there answering there.

Thank you in advance.



SELECT
convert(nvarchar(20), AlertDateTime,120)
AlertDateTime,
AlertName,
AlertPriority,
AlertCount,
convert(varchar,(convert(bigint,SrcAddressInt) / 256 / 65536)) + '.' +
convert(varchar,((convert(bigint,SrcAddressInt) /65536) % 256)) + '.' +
convert(varchar,(convert(bigint,SrcAddressInt) /256) % 256) + '.' +
convert(varchar,((convert(bigint,SrcAddressInt) % 256)))
SrcAddressInt,
SourcePort,
SourcePortName,
convert(varchar,(convert(bigint,DestAddressInt) / 256 / 65536)) + '.' +
convert(varchar,((convert(bigint,DestAddressInt) /65536) % 256)) + '.' +
convert(varchar,(convert(bigint,DestAddressInt) /256) % 256) + '.' +
convert(varchar,((convert(bigint,DestAddressInt) % 256)))
DestAddressInt,
DestPortName,
dbo.SensorData1.ObjectName,
SensorName,
SensorInterfaceName,
AlertTypeID,
convert(varchar,(convert(bigint,SensorAddressInt) / 256 / 65536)) + '.' +
convert(varchar,((convert(bigint,SensorAddressInt) /65536) % 256)) + '.' +
convert(varchar,(convert(bigint,SensorAddressInt) /256) % 256) + '.' +
convert(varchar,((convert(bigint,SensorAddressInt) % 256)))
SensorAddressInt,
ProtocolID,
Cleared,
VulnStatus,
dbo.SensorDataAVP.SensorDataID,
dbo.SensorDataAVP.AttributeName,
dbo.SensorDataAVP.AttributeDataType,
dbo.SensorDataAVP.AttributeText,
dbo.SensorDataAVP.AttributeValue,
dbo.SensorDataAVP.AttributeBlob,
ResponseTypeName,
ResponseName

from
dbo.SensorData

LEFT JOIN

dbo.SensorDataAVP
ON dbo.SensorDataAVP.SensorDataID =
dbo.SensorData1.SensorDataID

LEFT JOIN
dbo.SensorDataResponse
ON dbo.SensorDataResponse.SensorDataID =
dbo.SensorData1.SensorDataID

LEFT JOIN
dbo.ObjectView
ON dbo.ObjectView.ObjectName=
dbo.SensorData1.ObjectName


WHERE
convert(nvarchar(20), AlertDateTime,120) between @StartDate and @EndDate

AND
convert(varchar,(convert(bigint,SrcAddressInt) / 256 / 65536)) + '.' +
convert(varchar,((convert(bigint,SrcAddressInt) /65536) % 256)) + '.' +
convert(varchar,(convert(bigint,SrcAddressInt) /256) % 256) + '.' +
convert(varchar,((convert(bigint,SrcAddressInt) % 256)))

between @LowerIP and @UpperIP

AND
AlertName = @EventName

View 2 Replies View Related

Dynamically Hiding Columns In A Matrix Report

Mar 5, 2008

Hi,


I am wondering if someone has some experience with hiding columns in a Matrix report. I have got two details columns: "Yr to Yr Credits Growth€? and "Yr to Yr Credits Growth %" and those two columns return only one value "N/A" for the earliest year since there is nothing to compare to. Thus, I don't really need them for the earliest year. On top of detail columns, I have got three matrix groups: matrix1-Year, matrix1-Quarter and matrix-Date. Once those two detail columns are hidden, I would like obviously resize (shrink) those three matrix groups columns to reflect the fact that the detail columns were hidden.

Thanks!

View 3 Replies View Related

Reporting Services :: Hiding Sub-report Based On WeekDayName Value?

Jun 30, 2015

I'm working on a scheduling report to display work to be completed on each day. I have each day iteration as separate subreports by adding day values to "Today()" I'm trying to hide subreports that return as Sat or Sun.

Here's what I'm using to define my WeekDayName=WeekDayName(Weekday(DateAdd("d",1,Today())),True,0)

What I would like to do is =WeekDayName(Weekday(DateAdd("d",1,Today())),True,0) = 'Sat' OR WeekDayName(Weekday(DateAdd("d",1,Today())),True,0) = 'Sun' but I get an error when I attempt that.

I'm entering this under Sub-Report Properties - Show/Hide based on Expression using Report Builder 3.0.

how I can achieve this?

Using Report Builder 3.0 on SQL 2008 R2

View 3 Replies View Related

Hiding/unhiding A Report Field By Mouse Click

Jun 6, 2007

How would you go about making one of your fields hidden until you click on it?

View 4 Replies View Related

Hiding Main Report White Space If Subreport Is Empty

Jul 27, 2007

I have a main report and a subreport. If the subreport doesn't have any data then I hide it, but the main report still shows the white space of where the subreport would show up if it had data. So how can I get rid of the extra white space in the main report?

Thanks,

Han

View 3 Replies View Related

Collapsing Data

Nov 27, 2007

I want to collapse the incoming data based on the Plus4 High and low values. Here is the format





Code Block

create table #rangetbl (zip varchar(5), zipl varchar(4), ziph varchar(4), zipid varchar(4))

insert into #rangetbl values('90112','0000','0100','SET1')
insert into #rangetbl values('90112','0101','0210','SET1')
insert into #rangetbl values('90112','0211','0320','SET1')
insert into #rangetbl values('90112','0400','0500','SET2')
insert into #rangetbl values('90112','0503','0600','SET2')

Expected Output

ZIP low high identifier
90112 0000 0320 SET1
90112 0400 0500 SET2
90112 0503 0600 SET2


In this case a "set" is when the values immediately follows the high values. 0101 is the next number to 0100, 0211 is after 0210 so on and so forth and they all belong to the same set. If the sets are different we should not collapse the data.

Current code uses cursors to do the collapsing of data I was wondering if a TSQL can do the job.

Thanks

View 1 Replies View Related

Reporting Services :: Hiding Subreport If Parent Report Row Containing Subreport Is A Certain Value

Jul 14, 2015

Using SSRS 2014 and VS2013 rc5.

How do I hide a subreport if the parent report row containing the subreport is a certain value? I am attempting to create a statement with ageing buckets. In the main body of the report I have to display payments and invoices. If the invoice row is blank, I need to hide the row containing the subreport.

First, Is this even possible?
Second, How?

View 10 Replies View Related

Underlay Following Sections

Mar 5, 2008

Hello there.

With my team we have to convert all our CrystalReports-Reports to ReportingServices-Reports.
Now i have a problem with on functionality in CR.

I just have a table. One group, two columns. like this:


Column1 Column2
-----------------------------------------------------------
GroupTextBox1 empty
-----------------------------------------------------------
empty DetailTextBox1
-----------------------------------------------------------

Now i want to underlay the following DetailRows to the Group.
There can be many DetailRows and the GroupTextBox1 is bigger than one line.
If its possible i dont want to use subreports

Can somebody help me?

Thanks in advance, Tobi

View 1 Replies View Related

General SQL - Need Same Inner Select In FROM And WHERE Sections...

Feb 29, 2008

Hi, I've got the query below which works as needed, but it performs the same inner select twice at present. What is the best way of eliminating the second evaluation of the inner select statement?
SELECT TOP 1 condition FROM
  (SELECT condition, COUNT(condition) AS total FROM [JCM].[dbo].[jcmresults] GROUP BY condition)
WHERE total = (SELECT MIN(total) FROM
  (SELECT condition, COUNT(condition) AS total FROM [JCM].[dbo].[jcmresults] GROUP BY condition))
 
Thanks,
Andrew

View 5 Replies View Related

Cleaning Up Hardcode Sections

Jan 5, 2005

Hey,

Does anyone know of a neat and easy way to modify this section of hardcode:

SELECT CASE dbo.requestsbyyeartemp.themonth when '1' then 'January' when '2' then 'Febuary' when '3' then 'March'
when '4' then 'April' when '5' then 'May' when '6' then 'June' when '7' then 'July' when '8' then 'August'
when '9' then 'September' when '10' then 'October' when '11' then 'November' when '12' then 'December' end as 'themonth', etc...

Requestsbyyeartemp is a table where the numbers corresponding to the months are stored. This statement is used to make a new table where the months are stored with the proper names and not numbers.

I would sooner not have any hardcode at all if there is a simple way to do it.

Thanks

View 4 Replies View Related

SQL XML :: How To Parse Different Sections XML With OPENXML

Aug 26, 2015

I am learning how to parse XML data into SQL table.  Below partial XML data contains multiple sections.  I used OPENXML to parse one section but need to parse the remaining sections into a table.  For example, below openxml code can only retrieve elements under "NewHires/Newhire/EmployeeInfo/PersonName" section.  I also need to parse elements under "NewHires/Newhire/EmployeeInfo/ContactMethod" sections.  Notice that there are three subsections underneath the ContactMethod section ("/Telephone", "/InternatEmailAddress", and "/PostalAddress") sections.  Not to mention there are EmergencyContact section follow behind. 

OpenXML can only extract one section at a time.  Does it mean I have to write multiple OpenXML, store them into multiple temp tables then merge them into a single table?  If that is the case, how to save all these data into a single table? 

parse all the elements in lieu of OpenXML?

Here is the partial XML data:

<?xml version="1.0" encoding="UTF-8"?>

View 11 Replies View Related

Integration Services :: SSIS Package Configuration Option Resets When Collapsing / Expanding Options Tree

Oct 22, 2014

On Visual Studio 2013 with SSDT for SQL Server 2014

I noticed something very strange.

I am viewing the package configuration selected option for a package:

Now, i just click on the - sign and then on the plus sign on the "Properties" branch. And the option is cleared:

The ONLY way i found not to mess everything is just to have ALL the options FULL expanded and THEN to select what i want.

View 4 Replies View Related

Multiple Sections In SQL Server Reports..

Nov 15, 2007

Hi,
Am using SQL Server Reporting service to generate reports.Actually i want is a reports containng two sections,How can i achieve that?
Cheers
Jan

View 7 Replies View Related

Retrieving Random Sections From A Data File

Jun 2, 2007

On my company's website, we have a quote of the day. I would like to be able to type a hundred or so quotes into a mdf file. Then, I would like to have code that randomly selects one of the quotes every day and posts it.
 
....What I want is very similar to the "Image Of the Day" section on many websites.
 
Any ideas?

View 3 Replies View Related

Collapsing/Expanding Group Data In Table And Matrix Data Regions

May 30, 2007

Hi,



Is it possible to create Expand/Collapse functionality for the grouped data in Table and Matrix data regions? Essentially, the idea is for the user to be able to see the group/subgroup data if she wishes to by clicking on (+/-) symbols, as is usually the case in Tree View style data grid control in web apps. Any ideas how to accomplish the same in reporting services?



Thanks.

View 1 Replies View Related

Hiding A Zero Value

Jan 11, 2007

How can I hide or suppress the 0-values (zero) in a report?

View 8 Replies View Related

Hiding Particular Objects

Aug 1, 2000

Hey guys,
Is there any way to hide a particular object(table,sp,tr etc) from
a particular user?

we are developing softwares for the clients..and Once we install our product we dont want the clients site guys to go and delibrately view the data from sql server but through the front end. Is there anyway that i can do that...?

For Eg..the front end codes are capsulated as DLLs so that no can view the code.. Like that for SQL Server..can we do that kinda stuffs to prevent them?

View 5 Replies View Related

MS SQL Hiding Behind Access

Dec 7, 2005

Hi guys

We have a helpdesk application which is based on an MS SQL database, and which runs with a rather large and complicated C# based interface. We don't have the code for this, so we can't customise it. Long story short, what we want is to create an interface in Access (or similar) which accesses the same database as the helpdesk suite, and allows reading AND writing, and some rather complex operations (which SHOULD be fairly simple to do in SQL).

Unfortunately, I have been given this project, and I know about as much about Access and SQL as I do about Ghengis Khan's fashion sense.

I will follow with more information as required, but I'm going to need a lot of help with this one. First things first, is Access the way to do this? Is it going to be easier to create a new Access DB and synchronise it with the SQL, instead of both applications using the same database?

The only way I can get Access to interrogate the SQL database is to create a Data Access Page - is this the correct starting point? The only problem is that this seems to only offer HTML, and is far from being a friendly interface, at least not to me.

I know that I currently have no grounding in physics and I'm trying to build a space station, but any advice that you could give me would be much appreciated.

Thanks guys!

View 4 Replies View Related

Hiding The DB Design.

Feb 3, 2004

Hi all,

I am going to install my application at my Client's place.

I do not want them to know about my DB design and also i have a lot of master information that I dont want the Client to view.

The Client insists that he would have the Super Administrator user ids and passwords (ie. "sa" - user).

Is there any way i can encrypt my DB design and the data in the DB.

Or is there any other way of restricting the Client from viewing my DB design and data???

Thanks

Vishal

View 5 Replies View Related

Hiding NULL

Mar 29, 2006

In SQL 2000 Query Analyzer, you can set up the text output pane toleave null values blank.That could give you this (assuming it's set to comma-delimited) --CREATE TABLE #Test (A int, B int)INSERT #Test SELECT 1,2INSERT #Test SELECT NULL,4INSERT #Test SELECT 5,NULLINSERT #Test SELECT NULL,NULLSELECT * FROM #TestA,B1,2,45,,I can't figure out how to set up 2005 Management Studio the same way.I can only manage to get outputs like this, with "NULL" instead ofempty fields --A,B1,2NULL,45,NULLNULL,NULLHow can I get rid of the NULLs?Thanks,Jim

View 2 Replies View Related

Hiding Data

Jul 20, 2005

Hi,I am intetrested to know if there is a way to hide the information in aspecific column in my table. SQLServer 200. Something like a passwordprotection were you only see *****. I have a DBA but want to hide salaryinformation from him that is stored in the database.Any suggestionsThanksElmo

View 3 Replies View Related

Hiding A Table

Feb 28, 2008

Hi,

I am designing a report with a few tables in it which i selectively want to hide if there is no data to display in them.
The tables hide themselves but leave behind a big void without compressing the fields beneath them.

Is there anyway to make sure that the tables are hidden and it compresses the space which it would have otherwise occupied?

The two methods i have tried are:

1. Put an expression in the visibility property and set it to true if the row count is zero
2. set the expression in the NoRows property to =""

(both without luck)

Any suggestions would be greatly appreciated.

Regards,

Ash

View 4 Replies View Related

Hiding Parameters

Jan 11, 2008



Hi There,

I am fairly new at RS, and have a question about showing/hiding parameters :

What i would like to do is have one report, with the parameters :

Report By : (Date/Week)
Buisiness Stream : (Spares/OEM)
Start Date : (Date)
End Date : (Date)
Start Week : (Start Week Num)

End Week : (End Week Num)

What I would like to do is show the 'Start Date' and 'End Date' when the Report By value = Date

OR

Show the 'Start Week' and 'End Week' parameter when Report By value = Week.

Can someone help me with this?

Thanks

Jamie

P.S. If its not possible to hide the fields, could i grey them out??

View 3 Replies View Related

Hiding Reports

Jul 23, 2007

Is there a way to hide reports before publishing and then hiding reports via the Report Manager? We have some subreports that before we publish, we would like to set a flag to hidden so the Report Manager will know after the deploy that this report is to be hidden.



Thanks for the information.

View 4 Replies View Related

Hiding A Subreport

Jul 24, 2007

We have a parameter that takes the values of "Yes" or "No" (non-queried). If the user chooses "Yes", we want the subreport to display, but remain hidden on "No".



In the expression for visibility, we have the following:
=IIf(cstr(Parameters!Heading.Value = "Yes"),False,True)



When the report runs we get the following error: "The input string was not in the correct format."



Has anybody seen this before?



Thanks for the information.

View 1 Replies View Related

Hiding Groups

May 1, 2008

I know how to hide groups using Expressions that use parameters that can be passed in, but can you hide groups that are inside other groups. Here is my situation. Our company has different organization levels. On reports the users want to select which organization levels they want to see the #s for. So I set up groups for each org level like so....

Org Level 1
Org Level 2
Org Level 3

The data results are like so

Org Level 1 Org Level 2 Org Level 3 Category $ Amount
USA Midwest Kansas 1 500.00
USA Northeast Maine 1 200.00

And I sum the $ Amount Per Category for each Org Level using grouping in the report.

Then based on the selections they make it hides the org levels they don't need to see. The issue is that the report will not show org level 2 or org level 3 if org level 1 is not visible, and org level 3 can't be visible if org level 2 isn't visible, etc.....Anyone know a solution to this situation, I know this has had to have come up.

Thanks,
Adam

View 1 Replies View Related







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