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!
Am currently implementing this as nested list controls with textboxes due to the fact that the headers for the parent and child differ. (By header I mean the column labels)
1. is there a better way of doing this as I much prefer working with tables/matrix controls? 2. how can I stop the header from scrolling - this is possible with tab/mtx controls. The alternative is to repeat the headers all down the page which wastes space and looks messy 3. How can I apply 'interactive sorting' to the parent columns?
Could someone describe to me how to have headers remain visible while scrolling in a matrix? I can do this in a table without a problem but can't seem to find this option for a matrix.
I have generated a report that requires the user to scroll down the page since it is fairly long. I want to be able to show the column headings as the report is being scrolled. Much like excel locking the column headings as you would scroll down the spreadsheet so you know what values correspond to what heading. How do I configure this report to do this? Any suggestion is greatly appreciated. Thanks!
Would be very pleased if anyone knows a solution to my prob.
I connect via ODBC (ADO) within Active Server Pages with an SQL Server 6.5 database. The connection is opened at the top of the pages that need the database, and closed at the end of each individual page. Thing is, the connections for one single user are max. around 3 connections (checked that in Performance Monitor), no matter how many times the user opens his browser with the application. However, when say 20 users log on, the max. number of user connections as configured is reached within no time! The connections are not being closed (even with connection pooling on, they increase like hell!). The only way to close them seems to be stopping the MSSQLServer service, but that's something ya don't want, of course.
It's jut plain crazy to increase the number of user connections to around 250 for about max. 80 user connections at one time...
I have set the option 'Headers should remain Visible while scrolling', in order to freeze the headers. However, on some reports, when I scroll down the report , the headers overlap each other .
Pretty unorthodox query. We would like to use SSIS for doing the ETL but the source and target (staging & Reporting) area will remain to be SQL server 2000.
I have installed SQL Server 2005 Standard Edition for our Team Foundation Server install. I have verified the installation and all seems well, except that the Analysis Services service does not remain started. I get a message like "Some services stop if there is nothing to do." The Analysis service needs to be running in order for the TFS install to succeed. How can I get the Analysis Services service to remain started?
Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this?
I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending? Then i cld swop the 1 and the 2 around.
I have a very wide report that uses a table control. I would like to "freeze" the two leftmost columns so that they remain visible when the user is scrolling horizontally (sideways). Is this possibe?
I have an issue with fragmentation SQl server 2012 .I monitored indexes using sys.dm_db_index_physical_stats. fragmented % is still remain after re-organized the index.
I need some help. I am writing a report in SSRS 2005 that I then need to export to Excel. When I put a report header I would expect the header to not display in the Excel spreadsheet until the Print Preview or the Print. The report footer works just fine I put some text in the footer, and it shows up in the footer. The header though, shows up as a row in the Excel spreadsheet that then causes columns to merge. How do I get the report header to act like a page header?
I am making a book-like report, I am using a report that has a header and calling a sub-report that has it's own header. However the sub-report header is not showing on the parent report. Parent report header is prevailing over the sub-report. Is it possible to have both headers displaying?
I have a wide report. The leftmost two columns have the FixedHeader property set true so they remain visible when I do horizontal scrolling. My problem is that the height of the 1st two rows in the fixed header section increases as soon as I scroll the report to the right. The height of the 1st two rows in the fixed header section roughly doubles while the height of the scrollable section remains the same. The upshot is that the fixed part of the report is misaligned with the scrollable part (because the rows in the two sections don't have the same height). Only the 1st two rows in the fixed header grow taller - the other rows in the fixed header retain their original height.
Has anyone seen this problem or have an idea what is happening?
Thanks, BCB
This is the style that is generated for one of the fixed header columns:
My understanding is that at installation of all but the Express edition, there is no choice but to have VS2005 installed as well. If this is true, can VS 2005 at least be uninstalled after a different debugger is enlisted?
I have a report that I created and the report was working until I added some fields to a group footer row in a table.
My table has 5 group levels. I had information displaying in the 5th level header group and detail. It was working fine. Then I added some fields to the 4th level group footer. Now it displays only the Page header, Table header, and the 4th level group footer data.
What happened to the rest of the data?
All the cells and rows I want to display have the Visibility Hidden set to false. I tried removing the objects I added (to the 4th level group footer) and it still does not work. Is this a bug or did I set something that is hiding the data.
There is a one header in the report, when I publish and hit the report in IE(internet explor) the header appears fine on first page when I go to next page this header does not appear.
But in mozilla the header is visible on every page of the report. so it is working fine in mozilla.
I have a table with the following columns employeeSessionID, OpDate, OpHour, sessionStartTime, sessionCloseTime. I need to see how many users remain active per hour. I can calculate how many logged in per hour, but I am stumped on how to count how many are active per hour. I have a single table that stores login data. I have created a query that pulls out the only the data needed from the table into a temp table using this query. Also note it is possible that the sessionCloseTime is null if the device has not been logged out this would need to be counted a active.
TABLE NAME #empSessionLog Contains the time stamp data OpDate, sessionStartTime and sessionCloseTime. OpDatesessionStartTimesessionCloseTime 2015-01-202015-01-20 14:32:59.1302015-01-20 14:33:14.6299166 2015-01-202015-01-20 06:58:33.7302015-01-20 15:27:16.9133442 2015-01-202015-01-20 09:56:22.8402015-01-20 17:56:29.7555853 2015-01-202015-01-20 05:59:18.6132015-01-20 14:05:19.0426707
[code]....
can see how many sessions logged in per hour with the following statement:
SELECT opDate, FORMAT(DATEPART(HOUR, sessionStartTime), '00') AS opHour, Count(*) AS Total FROM #empSessionLog Group BY opDate, FORMAT(DATEPART(HOUR, sessionStartTime), '00') Order BY opDate, FORMAT(DATEPART(HOUR, sessionStartTime), '00') ASCResults: opDateopHourTotal 2015-01-20041
[code]....
Where I am stuck is how do I count the sessions that remain active per hour until the session is closed with the sessionCloseTime.
i just clicked on Advanced mode in Column Group, and then in Row Group Side i set Fixed Data=true for first top static. I'm using local report not server report and i'm displaying that local report in Reportviewer. Now also its not working....
hi need help to solved date calculation for next month i explain i have table employee and the employee insert into table the holidays the date start >>>> to date end now i need to create a view only for next moth , in this view i need to see only the relative dates for the next month if the dates is not for the next month i don't need to see it
like this example 09/07/2008 > 09/08/2008 (is not for next month) like this example 10/09/2008 > 12/09/2008 (is not for next month)
555 EEE
09/07/2008 09/08/2008
4
666 fff 10/09/2008 12/09/2008
1
in this example i need to see only the relative dates for next month only in the view
333 cccc
01/05/2008 15/05/2008
4
4
333 cccc
01/05/2008 31/05/2008
1
30
tb_all_holiday before
id
fname
Start_Date
EndDate
val_holiday
111 aaaa
15/03/2008 10/05/2008
1
222 bbbb
02/05/2008 31/05/2008
3
333 cccc
03/04/2008 15/05/2008
4
333 cccc
29/04/2008 07/07/2008
1
444 dddd
01/05/2008 02/05/2008
1
444 dddd
09/05/2008 19/08/2008
1
555 EEE
09/07/2008 09/08/2008
4
666 fff 10/09/2008 12/09/2008
1 VIEW_all_holiday after -next month only
id
fname
Start_Date
EndDate
val_holiday sum_day_next_month
111 aaaa
01/05/2008 10/05/2008
1
4
222 bbbb
02/05/2008 31/05/2008
3
29
333 cccc
01/05/2008 15/05/2008
4
4
333 cccc
01/05/2008 31/05/2008
1
30
444 dddd
01/05/2008 02/05/2008
1
1
444 dddd
09/05/2008 31/05/2008
1
22
all the time i need to see only the relative dates for the next month only
create table temp ( Â Â date1 datetime, Â Â category varchar(3), Â Â amount money
[code]....
In above format:15-10 means Oct 15, 15-09 means Sept 15I am getting issues while formatting this in SSRS.I need SSRS table headers to be dynamic. I need that it should be according to the sql table header...The table header should change according to the sql query
I have two separate reports, and they work fine. But I noticed that in one report, regardless of length, it will show up in the Report Manager as one page that you just scroll down through. The second report always shows up as more than one page, and you have to click through the pages to see everything. Is this some setting that I am unaware of? I have tried finding a difference between the two reports, but can't see why one would show up as a long continuous report and the other is divided into pages. Any ideas?
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.
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??
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?
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?
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.
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.
