Hiding Columns -White Space At End Of The Table*****Extremely Urgent
Mar 27, 2008
Hello everyone,
In reports ,My customer requirement is to display column based on selected criteria in UI .
The columns which are not selected by him will hide.
for that we kept an expression in Visibility --> Hide
Code Snippet
= NOT Parameters!Parameters.Value.ToString().Contains("Name")
then coming to HTML Report
It is working fine,but white space coming at end of the Table.
can't we supress the white space?
The white space width is exactly the width of the column which is hidden.
My designing in layout is wrong?
Else is that Problem with the SSRS?
Experts Please let me Know!!!!
Give me Solution!!!
Customer is strictly focusing on that requirement.
***Note: white Space is Some what Acceptable.But My Reports are very big like 45 columns around.When he selects 10 out of 45 then you can assume how much space is coming????????****
View 4 Replies
ADVERTISEMENT
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
Nov 14, 2007
Hi,
I am trying to do this:
UPDATE Users SET uniqueurl = replaceAllEmptySpacesInUniqueURL('uniqueurl')
What would be the syntax.
Any help appreciated.
Thanks
View 1 Replies
View Related
Dec 31, 2007
I have a table with 7 columns and it centers perfectly on my report. However, based on what the user selects when running this report, two of the columns can end up hiding. When I hide these two columns, which happen to be in the middle of the table, the table then appears to be left aligned because two of the columns are now gone so everything shifts.
The only reason its centered with 7 columns is because I have streteched all the columns out to certain sizes to make everything fit on the page and this is what is lost when 2 of those columns are dynamically removed.
Is there a way to keep everything centered even with these two columns gone? Is there a better way to ensure centering now matter how many columns exist in a table?
Thanks,
Flea
View 1 Replies
View Related
Oct 4, 2006
Ok, here is the problem.
Client created a database with Allocated Space of 5GB. THEY WILL ONLY EVER HOLD A MAXIMUM OF 1GB IN DATA!!! Don't ask.
In any case, they currently have a database filled with 600MB of Data and 4.4GB of White Space. From what I can see, the database is backing up that entire database nightly, based on 5GB of allocated space. It doesnt care that only 600MB is being used, it only knows that someone put aside 5GB and its gonna darn well back it up.
I need to get rid of that space. Their Backups are taking hours on end and Batch Files are timing out. Quite honestly, they dont need to back up 4.5GB of white space.
QUESTION:
How can I eliminate that white space? I have tried to run several SQL scripts to Truncate the DB and eliminate unused space, unfortunately it is not working.
Any help would be GREATLY appreciated.
Matt.
View 14 Replies
View Related
Oct 1, 2006
I think this may be a dumb question, but here goes.If there is a lot of "white space" in a field in SQL Server, does it take upserver space, or is it just ignored?Example:Name of product<br>Manufacturer's Name<br>Manufacture's Phone number<br>Instead of this:Name of product<br>Manufacturer's Name<br>Manufacture's Phonenumber<br>I think it would, but maybe not?Thanks, J~
View 1 Replies
View Related
Aug 10, 2007
Good day to you, community friend!
Just a quick one - I swear I've seen a function before that was like Len() but it counted the white spaces too. I have a feeling it was something along the lines of "data_length" but I can't for the life of me find it!
Many thanks,
George
View 7 Replies
View Related
Aug 2, 2007
I am hoping there is either a quick fix within SQL reporting services or a 3rd party tool for SQL reporting services that will fix my error. If not, we will be forced to go back to Crystal Reports.
I have a large report, that per each record prints between 3 and 5 pages of information. It is laid out like an MS Word document (as that is what is needed to send off to the client), so it is in standard letter style with the text growing down vertically.
I have about 10 large text (SQL Server Text field types) fields on this report. The report itself was built using the SQL Reporting Services table tool, so I could correclty group the information into the same record and also to keep the needed specific report formatting.
Everything looks GREAT, except for large white space in the report. The cause is that each row on the SQL Reporting Services table contains a field of data. Well, in some instances there is too much text to fit on the current page of the report (in some cases as much as 3/4 a page of paper), so instead of starting to print on the page and then continuing to print on to the next page, the data will skip the page and start at the top of the next page.
This will leave large white spaces in my report. In one instance I have a Text field that with the correct formatting is larger than a page. So the report prints on 1/4 of page 2, is blank for remander 3/4 of a page 2, and then starts printing the large text field on the following page (page 3). So 3/4 of a page in my report is left empty.
Is there a work around for this, or a 3rd party tool that can be purchased to allow for this? I have not found a setting or a way to keep the table rows together as there is in Crystal Reports.
Thank you for your help!
T.J.
View 3 Replies
View Related
Dec 24, 2007
White space
In SSRS the controls(chart and table) are hidden .Some white space occured for each full page. How to avoid such white space (blank page) for every page.
In our report there is five Controls and some of the controls are to be hidden. And that some pages having only white space. How to avoid such blank spaces.
Regards
Mugesh
View 3 Replies
View Related
Jul 20, 2015
I am trying to print only the grand total raw. The grand total is based on the information in the groups and therefore I cannot hide the groups.
Instead I am trying to minimize the size of the group raw by sizing font, shrink, etc but with no success. I still get a lot of unwanted space. How can resolve this?
View 2 Replies
View Related
May 16, 2006
Hello
I have created a report that works how I want it in the visual studio 2003 designer. I have deployed it to our test box (sql server 2k, reporting services with sp2) and when we preview the report, there is a giant white space between the graph in the report and the matrix object below it. This white space was not in the designer. It only shows when previewing the report. If you print from the report manager, it does not print the white space.
Is there a way to remove it from the report manager when the report is previewed? I am sure users will complain when they see this.
Thanks.
Ben
View 2 Replies
View Related
Sep 28, 2015
I build a tablix A in SSRS, which contains a tablix B and a textbox C. When the report is exported to word,  I found that there is white space between the tablix B and textbox C if the row of tablix B is spilled over to next page.
If I export the report to PDF, the white space issue is gone.
View 2 Replies
View Related
May 15, 2007
I have a report that (for purposes of this example) displays States and the Cities in a state.
Now the State is the first group which I want to drill down into by expanding and then show the Cities as the detail line.
What I would expect to happen (and what does happen if I use the wizard instead of creating the report manually) is that I would click on a State and then the page would expand to make room for all the cities listed below.
(That is to say if I am showing only states, not expanded, then all 50 states fit on a single page. Then if I expand California all the states below that shift onto other pages to make room for the 400+ cities in California)
However, what happens is that when I preview the report instead of being 1 page long it is many pages in length with empty white space between the States (white space that would be occupied by the cities if I were to expand the state).
Can someone tell me what setting I need to adjust to get the report to dynamically resize when I expand/collapse groups?
Thank you.
View 1 Replies
View Related
Jul 20, 2005
I am attaching a database with 3 data files.When I execute "exe sp_attache_db..." I obtain this error:database 'POINT' cannot be opened because some of the files could not beactivated.I have deleted its LDF file.Usually I detach my db, then I delete transaction log, and reattach 3 datafiles...Now it doesn'work!!!!!!!!!!Someone can help me?Thanks.
View 1 Replies
View Related
Mar 24, 2008
I have an Matrix report in which report output is completely numbers. That is fine but the problem is when i am trying to export it to Excel ,the data is exporting wih error:
Converting numbers stored as text.
i dont know why numbers are Exporting like text format.
please let me know whether it is problem with exporting in ssrs tool itself or else i need to change any properties in RDL file.
Note: This Error i am getting when i am using expression IIF(IsNothing(Fields!Parameter.value),"0",Fields!Parameter.value)
View 5 Replies
View Related
Jan 20, 2008
Hello,
Ik have a problem with the free space if I'am hiding textboxes.
I put 2 textboxes in a rectangle and when I hide the rectangle then the textboxes are gone but the space that the rectangle needed is now blank.
Can I suppress the blank space?
Mvg,
Hans
View 3 Replies
View Related
Feb 12, 2015
I have some sql below..
SELECT
t.Doctor, t.LedgerAmount, t.TransactionDate,
ISNULL(lg.LedgerGrpDesc, 'No Sales Group') AS LedgerGroup
FROM
Transactions t
LEFT OUTER JOIN LedgerGroups lg ON t.LedgerDescription = lg.dbLedgerDesc
[Code] .....
My problem is that the data in t.LedgerDescription sometimes now has either leading/trailing white space or more likely special chars so the join against lg.dbLedgerDesc doesn't always work.
I can't change the source of the data to strip out special chars/white space so am stuck on how to deal with it.
I tried using LTRIM & RTRIM in the where clause but this doesn't seem to have had any effect...
LEFT OUTER JOIN LedgerGroups lg ON LTRIM(RTRIM(t.LedgerDescription)) = lg.dbLedgerDesc
View 7 Replies
View Related
Jun 27, 2007
I have query which retrieves multiple column vary from 5 to 15 based on input parameter passed.I am using table to map all this column.If column is not retrieved in the dataset(I am not talking abt Null data but column is completely missing) then I want to hide it in my report.
Can I do that??
Any reply showing me the right way is appricited.
-Thanks,
Digs
View 3 Replies
View Related
May 26, 2008
Hi Team,
When i view the Report from SSRS Report preview Tab it's working fine, But when i deploy that and try to view in the IE
I am seeing the Body background color in between the image and page border of the page footer how to solve that?
View 1 Replies
View Related
Nov 23, 2005
Hi,On my SQL Server 2000, I have a table of data (tblAllData) containing anumber of columns, some of which are 'secret'.I have to let some users access the database using ODBC from an Excelsheet, and I would like that they do not know at all that the columns exist.I tried creating a view for them (qryAllData) that only selects thecolumns that should be visible, but when the creating theODBC-connection, both the query and the underlying table shows up.If I select the table as datasource, the query-builder in excel shows alist of all the columns, including the secret ones. If I try selectingthen, of course, an error occurs.I would like either that the columns for the table don't show or thatthe table does not show at all - and only reveals the existence of theview to the odbc-client.Is that possible?Here's what I tried so far:<pre>USE DbAllDatasp_addlogin @loginame='ODBCAccess', @passwd='ODBCAccess', @defdb='DbAllData'sp_grantdbaccess 'ODBCAccess'sp_addrolemember @rolename = db_denydatawriter, @membername = ODBCAccessREVOKE ALL FROM ODBCAccessDENY SELECT ON dbo.syscolumns TO ODBCAccessDENY SELECT ON dbo.syscomments TO ODBCAccessDENY SELECT ON dbo.sysdepends TO ODBCAccessDENY SELECT ON dbo.sysfilegroups TO ODBCAccessDENY SELECT ON dbo.sysfiles TO ODBCAccessDENY SELECT ON dbo.sysfiles1 TO ODBCAccessDENY SELECT ON dbo.sysforeignkeys TO ODBCAccessDENY SELECT ON dbo.sysfulltextcatalogs TO ODBCAccessDENY SELECT ON dbo.sysfulltextnotify TO ODBCAccessDENY SELECT ON dbo.sysindexes TO ODBCAccessDENY SELECT ON dbo.sysindexkeys TO ODBCAccessDENY SELECT ON dbo.sysmembers TO ODBCAccessDENY SELECT ON dbo.sysobjects TO ODBCAccessDENY SELECT ON dbo.syspermissions TO ODBCAccessDENY SELECT ON dbo.sysproperties TO ODBCAccessDENY SELECT ON dbo.sysprotects TO ODBCAccessDENY SELECT ON dbo.sysreferences TO ODBCAccessDENY SELECT ON dbo.systypes TO ODBCAccessDENY SELECT ON dbo.sysusers TO ODBCAccess--allow selectingGRANT SELECT (idx, col1, col2) ON tblAllData TO ODBCAccessGRANT SELECT ON qryAllData TO ODBCAccess</pre>TIA,M
View 5 Replies
View Related
Feb 26, 2002
Hi,
Could you please tell me removing table columns with null value will reduce the datafile size.
Data file size needs to be reduced to make free space on the disk, Could please suggest what data type can be choosen to be removed from the existing table so that more space can be made(Char,varhchar,int,date etc )
Thanks
John Jayaseelan
View 2 Replies
View Related
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
Aug 17, 2006
Dear all,
In my current database design, there is one table (PState) which has a Primary Key (int) and a few other fields.
During development, a pattern started to arise; for certain rows in PState, I wanted to specify an additional set of columns (over 10 of them with quite large lengths) for each row in PState. However, as these additional columns would only be required in approximately 20% of the rows of PState, there would be plenty of NULL values in PState if I would make this table wider than necessary. So, I decided to create a separate table with those optional columns (PStateWFI). In order to attach these additional columns in PStateWFI to PState in the cases they were needed, I would obviously have to create a Foreign Key constraint on the Primary Key of PStateWFI so that these optional rows would know which row in PState they would belong to.
However, the problem with this approach is that one could define multiple rows in PStateWFI referring to the same row in PState, which would not make sense. Thus, a UNIQUE index constraint added to the constrained ID column in PStateWFI would make sense to ensure that there could only be one set of optional columns added to each row in PState. But now, when adding the UNIQUE index, the FK constraint started to appear as a bidirectional key link in the Diagram; hence, new entries in PState would have to meet a FK constraint based on PStateWFI, which was not intended.
Hence, I had to create a quite awkward design to enforce the constraints:
1. The PState table has a Primary Key (PState.ParticleID, int, Identity Specification: Yes)
2. The PStateWFI table has a Primary Key (PstateWFIID, int, Identity Specification: Yes)
3. PStateWFI has field "PStateID" which has a FK constraint to PState.ParticleID (which is a one-way constraint operating in the correct way and does not constrain insertions in PState)
4. PStateWFI has an additional column ParticleIDIndex which has a UNIQUE Index attached to it.
5. There is a check constraint on PStateWFI enforcing PStateWFI.ParticleIDIndex = PStateWFI.ParticleID.
Although this structure does the job, it makes it necessary to add a redundant column in PStateWFI by duplicating the PStateWFI.ParticleID into PStateWFI.ParticleIDIndex, since I can't create a UNIQUE index on PStateWFI.ParticleID without constraining the PState table as well. So, insertions into this table would have to insert the same value into two columns. Not a big deal, but appears slightly ugly.
Basically I'd hope someone could explain why a bidirectional FK constraint has to be enforced on the primary key table in a relationship when the constrained column in the primary key table has a UNIQUE index attached on it. I have a few other cases where the above approach would benefit from a more clear structure.
Thanks in advance for any advice.
View 6 Replies
View Related
Sep 16, 2005
Hi,I have a table defined asCREATE TABLE [SH_Data] ([ID] [int] IDENTITY (1, 1) NOT NULL ,[Date] [datetime] NULL ,[Time] [datetime] NULL ,[TroubleshootId] [int] NOT NULL ,[ReasonID] [int] NULL ,[reason_desc] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_ASNULL ,[maj_reason_id] [int] NULL ,[maj_reason_desc] [nvarchar] (255) COLLATESQL_Latin1_General_CP1_CS_AS NULL ,[ActionID] [int] NULL ,[action_desc] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_ASNULL ,[WinningCaseTitle] [nvarchar] (255) COLLATESQL_Latin1_General_CP1_CS_AS NULL ,[Duration] [int] NULL ,[dm_version] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_ASNULL ,[ConnectMethod] [nvarchar] (255) COLLATESQL_Latin1_General_CP1_CS_AS NULL ,[dm_motive] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_ASNULL ,[HnWhichWlan] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_ASNULL ,[RouterUsedToConnect] [nvarchar] (255) COLLATESQL_Latin1_General_CP1_CS_AS NULL ,[OS] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,[WinXpSp2Installed] [nvarchar] (255) COLLATESQL_Latin1_General_CP1_CS_AS NULL ,[Connection] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_ASNULL ,[Login] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,[EnteredBy] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_ASNULL ,[Acct_Num] [int] NULL ,[Site] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,CONSTRAINT [PK_SH_Data] PRIMARY KEY CLUSTERED([TroubleshootId]) ON [PRIMARY]) ON [PRIMARY]GOWhich contains 5.6 Million rows and has non clustered indexes on Date,ReasonID, maj_Reason, Connection. Compared to other tables on the sameserver this one is extremely slow. A simple query such as :SELECTSD.reason_desc,SD.Duration,SD.maj_reason_desc,SD.[Connection],SD.aolEnteredByFROM dbo.[Sherlock Data] SDWhere SD.[Date] > Dateadd(Month,-2,Getdate())takes over 2 minutes to run ! I realise the table contains severallarge columns which make the table quite large but unfortunately thiscannot be changed for the moment.How can i assess what is causing the length of Query time ? And whatcould i possibly do to speed this table up ? The database itself isrunning on a dedicated server which has some other databases. None ofwhich have this performance issue.Anyone have any ideas ?
View 5 Replies
View Related
Mar 22, 2007
When I go to preview mode and select the print preview. The white background is black and the black is white. Any one know how to set this back to the original way it worked?
View 3 Replies
View Related
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
Apr 21, 2008
hi
i have table i use it for update insert
and the users use this table from a grid on the web
and i need to prevent from white space in the fields in table
so how to
create TRIGGER remove white space from a fields in table scan and fix it ?
Code Snippet
SELECT TRIM(fieldname)
, LTRIM(fieldname)
, RTRIM(fieldname)
, LTRIM(RTRIM(fieldname))
FROM tablename
Code Snippet
WHERE (LTRIM(RTRIM(fieldname)) = 'Approve')
Code Snippet
replace(@text,' ','')
create TRIGGER on update insert and not to damage the text in the all fields
TNX
View 21 Replies
View Related
Apr 11, 2002
Hi friends ,
I have a database with around 2 GB space for the data and 5.8 GB for the
transaction log .
Now the problem is i do not have any more space on the system and data files requires more space than 2 G.B to execute some stored procedures .
Is it possible to decrease some space of the transaction log , say from 5.8 GB to 2 GB and allocate it to the data files .
My data and log files are on different drives . I did not find anything related to this topic in the BOL .
Can somebody help me with this problem ? Anthing related to this issue will be of great help to me since i have no expertise in this field .
Thanks and Regards
Christine S.
View 1 Replies
View Related
Aug 28, 2001
I have a question on database size, specifically, what difference would I expect in the size of a db (the space actually used for data, not indexes) if I have one single data device vs. multiple data devices spanned across different physical drives. I have 2 customers that have identical database tables (all columns are integers), customer A has 27 million rows and customer B has 36 million rows. If I do an sp_spaceused on the table, customer A's data takes up 9.7 gig, whereas customer B only takes up 3.2 gig, even though it has 9 million more rows. Statistics have been updated, so I'm confident the sp_spaceused is accurate on both databases.
The only differences I can see between the 2 databases is that customer B has 5 separate data files (6 gig each) for the database which are part of the Primary filegroup. These files are all on the D: drive, which is a partition on a RAID 5 array. Customer A has a single large data file (24 gig), which is also on a RAID 5 array.
Any ideas?
View 4 Replies
View Related
Feb 25, 2004
Hi All,
Sql Server 7
My tempdb is eating 1.27 gb of space of my d dive, and now only 10 mb is left in d drive . for this i stoped and started sqlserver but it didnt release much of space.Pls let me know is there any other way so that i can release some space from my tempdb.
Waiting for reply
TIA
Adil
View 5 Replies
View Related
May 20, 2008
My scenario is:
I got this ReportItems.Value which is an Integer lets name it Value1.
I got this rowcount and lets name is Value2.
Can you help me generate a query wherein:
1.Value1 = Value2
2. And the Row from Value2 and its succeeding Rows be deleted or be hiden.
ic3m@n
View 6 Replies
View Related
May 23, 2000
Hi,
In sql 7.0 , i would like to create a database with the size of 10Gb, in my server couple of databases already exist.
How do i know how much free space is there in File group.
we are having only one file group i.e PRIMARY.
Could anyone pls tell me about this.
Thank u.
--kavira
View 2 Replies
View Related
Jul 5, 2007
Hi, Everyone.
i am wondering if there is some way to hide a table row depending on the page number.
I have tried to find a way to access the global page number to use it in an expression for the visibility property on the table row, but i havent found anything useful.
View 14 Replies
View Related
