Dynamic Layout && Whitespace
Dec 19, 2006
Hi,
I have a report that, among other things, contains 3 tables laid out side-by-side horizontally. The first table is conditionally visible and when it is hidden the report contains whitespace instead of the table. The problem is that this causes an unappealing visual look because the other 2 tables look shifted too much to the right.
What is the recommended way for dealing with situations like this? There doesn't seem to be support for specifying the location (i.e. top, left) of elements based on expressions. Am I "stuck" with having to create multiple flavors of the report?
Thanks,
Vitaly
View 2 Replies
ADVERTISEMENT
Nov 21, 2007
I designed a report in reporting services 2005. When i look at the view layout for the report everything is aligned correctly but if i go to print preview one matrix is shifted up or down. I have tried to put the matrix inside a rectangle but the issue is still present. Does anyone know why this is happening or any suggestions on what to do to fix it.
Thanks
Scott
View 3 Replies
View Related
Mar 28, 2008
I am currently working on a rather simple report, it cosists of a table with two columns
The first column contains Employee Names, and the second column contials details of what the have worked on
I have made the second column invisible, and can be made visible when the eployee name column is expanded.
The problem that i am having is that when the second column is collapesed, it still leaves whitespace, in the first column, of how ever many rows that are contained in the second column, is there a way, I can get rid of that whitespace?
Thanks
Chris
View 4 Replies
View Related
Jan 16, 2007
Hello All,
I am having a problem with whitespace showing up within a table. I have a grouping by date that toggles the fields correctly but when the fields are not expanded, the space where the data would be is showing as whitespace instead of collapsing up. Can anyone shed some light on how to make the whitespace go away?
Thanks
Clint
View 4 Replies
View Related
Oct 8, 2007
I am hoping there is an easy way to fix this. I have a report defined 8.5" x 11.0" with .5" Margin's all around. I am using the WinForms Report Viewer Control (doing Server side reports). It looks like the viewer is taking the left margin and adding it to the right margin. So you get large amounts of white space on the right of the viewer. This requires me to make the viewer way larger than it needs to be to get rid of the ugly Horizontal Scroll bar.
What I want is either don't show the margins until you print (removing the margins from the RDLC file does nothing), or have the left margin white space belong on the left side.
Why is this happening? And how can I fix it? Thanks!
View 1 Replies
View Related
Apr 26, 2007
I have a OLE DB Source going to a flat file destination. My source is a sql variable with "select * from tablename" which have varchar datatypes. Yet I'm getting trailing spaces at the end of some of my columns (for instance, my address column).
I've checked the data by doing a "select Max(Len(address)) from tablename" and the max is only like 34 chars, yet each of them have 100 chars total.
Taking a look at my flat file connection, the outputColumnWidth is 100, and datatype is string [DT_STR]. Am I crazy? What's the problem here? Is the DT_STR datatype the equivalent of char, and not varchar?
Any help, of course, will be appreciated.
View 8 Replies
View Related
Feb 6, 2007
So...I'm trying to insert a tab (or just a few spaces) at the beginning of a line in a textbox. Is this possible? If so, what do i have to do?
View 1 Replies
View Related
Jul 23, 2005
I'm trying to figure out how to find the last whitespace character in avarchar string. To complicate things, it's not just spaces that I'mlooking for, but certain ascii characters (otherwise, obviously, justuse LEN). My initial thought was to REVERSE it, find the location(using CHARINDEX) looking for each of those characters (so, multiplequeries), then subtract that from the LEN of the string.The problem I'm running into is that there are about a dozen differentcharacters we're looking for. Any suggestions? My thought was to(this sounds silly, so there's gotta be a better way) dump the resultsfrom each CHARINDEX into a table, then find the MAX of the table anduse that. But, like I said, it sounds silly. I don't think I can do a[^0-9A-Z] either, since there are non-Alphanumeric characters we'relooking for.Many thanks.
View 10 Replies
View Related
Oct 2, 2006
I have a column that I do not want any whitespace in whatsoever. I'mwondering how do enforce this a DDL level instead of in 40 millionseat-of-the-pants after-the-fact computer programs accessing thedatabase.Regards,Terrence
View 5 Replies
View Related
Jul 20, 2005
Hi,I am trying to concoct a query that will join rows on the basis of awhitespace insensitive comparison. For instance if one row has the value'a<space>b' and another has the value 'a<space><space>b' I want them to beconsidered equal (but not the same as 'ab')I am happy to do some T-SQL if that helps. Also I have a full-text index onthe column in question, but note that I am comparing rows against eachother, not to a fixed string.This is for a one-off job, so if there is no obvious way to do it on thedatabase, I will just bcp out the data and knock up some perl or somethingto do it. All other things being equal I would rather do it on the databasethough.Many thanksAndy
View 11 Replies
View Related
Jan 11, 2008
I am having an problem with using full-text search and phrases in ASP.NET 2.0 when populating a treeview.
I have a stored procedure that searches a full text index and brings back the results in a datareader. It fails when I try to search for more than one word with a space in between.
I get the error SQLException was unhandled by usercode "Syntax error near 'up'' in the full-text search condition ''item up''."
The stored proc is as follows:
CREATE PROCEDURE [dbo].[SearchResults] @criteria as varchar(50)
AS
BEGIN
SELECT *
FROM PMGNT_PROJECTS PRJCT INNER JOINCONTAINSTABLE(PMGNT_PROJECTS,*,@criteria) K
ON PRJCT.PRJCT_REFNO = K.[KEY]
END
The stored procedure works fine though query analyser it's only when I try to use it in ASP.NET and use more than one word that it fails e.g. "item up". Search for single words also works fine in ASP.NET
Code is as follows:
1 if (SearchField.Text != "")
2
3 {
4
5 string searchString = "";
6
7 searchString = "'" + SearchField.Text + "'";
8
9
10
11 SqlConnection SqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString);
12
13 SqlCon.Open();
14
15 SqlCommand SqlCmd = new SqlCommand("SearchResults", SqlCon);
16
17
18 SqlCmd.CommandType = CommandType.StoredProcedure;
19
20 SqlCmd.Parameters.Add("@criteria", SqlDbType.VarChar);
21
22 SqlCmd.Parameters["@criteria"].Value = searchString;
23
24
25
26 SqlDataReader Sdr = SqlCmd.ExecuteReader();
27
28 SqlCmd.Dispose();
29
30 string[,] ParentNode = new string[200, 2];
31
32 int count = 0;
33
34 while (Sdr.Read())
35
36 {
37
38 ParentNode[count, 0] = Sdr.GetValue(Sdr.GetOrdinal("PRJCT_REFNO")).ToString();
39
40 ParentNode[count++, 1] = Sdr.GetValue(Sdr.GetOrdinal("PRJCT_CODE")).ToString();
41
42 }
43
44 Sdr.Close();
45
46 for (int loop = 0; loop < count; loop++)
47
48 {
49
50 TreeNode root = new TreeNode();
51
52 root.Text = ParentNode[loop, 1];
53
54 root.Value = ParentNode[loop, 0];
55
56 root.SelectAction = TreeNodeSelectAction.Select;
57
58 SqlCommand Module_SqlCmd = new SqlCommand("SELECT * FROM PMGNT_MILESTONES MILST where MILST_PRJCT_REFNO =" + ParentNode[loop, 0], SqlCon);
59
60 SqlDataReader Module_Sdr = Module_SqlCmd.ExecuteReader();
61
62 string[,] ChildNode = new string[200, 2];
63
64 int countChild = 0;
65
66
67
68 while (Module_Sdr.Read())
69
70 {
71
72 ChildNode[countChild, 0] = Module_Sdr.GetValue(Module_Sdr.GetOrdinal("MILST_REFNO")).ToString();
73
74 ChildNode[countChild++, 1] = Module_Sdr.GetValue(Module_Sdr.GetOrdinal("MILST_TITLE")).ToString();
75
76 }
77
78 Module_Sdr.Close();
79
80 for (int cloop = 0; cloop < countChild; cloop++)
81
82 {
83
84 TreeNode child = new TreeNode();
85
86 child.Text = ChildNode[cloop, 1];
87
88
89
90 root.ChildNodes.Add(child);
91
92 }
93
94
95
96 // Add root node to TreeView
97
98 SearchResultTree.Nodes.Add(root);
99
100 }
101
102 SearchResultTree.CollapseAll();
103
104 SqlCon.Close();
105
106
107 }
108
109
Can anyone Help ?
View 9 Replies
View Related
Mar 31, 2008
Hi,
I have a need to create a report that has a graph at the top and a table at the bottom. The graph at the top can optionally be made hidden because they cause problems when exported to Excel as images. However, when I set the Hidden property of the graph to true, positions of all items on the report remain absolute. Meaning of course that the table that is located half-way down the page remains half-way down the page and there is a lot of nothing on the first half where the graph used to be.
It would be desirable to have the ability to have the table move up when the graph is not visible, however it obviously doesn't do it automatically and also refuses me the ability to change the position with an expression.
Any advice is appreciated, thank you!
View 3 Replies
View Related
Feb 3, 2006
I know that this almost never happens... but Im dealing with an AIX flatfile-database conversion that brings 80 tables into SQL. Im not allowed to touch this stuff or to massage how its brought over to SQL, as it deals with medical records...
What I need to do though, is on creating my own table imports, for my "account" fields to match with the existing SQL conversion table "account" fields, I have to match requirements...
Existing account numbers are a total of 6 charaters. Account numbers with less than six characters contain leading whitespace character equivalents to total the six character spaces for "account number"
When I import records, I need to force the same requirement and have a min and max length of characters for "account number" = 6 characters and any account number less than 6 characters must also have the necessary whitespace character equivalent added to it.
How would I do this? It needs to be automated, as this is a process that will run nightly and cannot have a human sitting on it every day, 7 days a week... I cannot accurately join unless I can meet this requirement and my hands are tied because I can't change the way the formatting is done on the imported tables =(
Any help would be greatly appreciated... I'm quite stuck
View 5 Replies
View Related
May 2, 2007
Hi there.
I'd like to call dtexec with something like this:
dtexec /f myPackage.dtsx /Set package.variables[User::connStr].Value;Source=localhost;Provider=blah;Integrated Security=SSPI;
I get an error along the lines of
Option "Source=localhost;Provider=blah;Integrated" is not valid".
How do I pass in a property containing spaces? I've tried all of the usual quote-encasing patterns I can think of.
Thanks,
Jon
View 5 Replies
View Related
Oct 14, 2015
I am facing whitespace issue in my SSRS report. I have simple tablix report with 10 columns. I am trying to toggle column 5 to 8 using on column 4. The problem I am facing is the whitespace. Now column 5 to 8 are only visible when we expand column 4. When the report is rendered on the screen, there is a huge gap between column 4 and 9.
View 4 Replies
View Related
Jan 30, 2008
I'm trying to suppress whitespace in a drilldown for textboxes that have suppress duplicates applied.
I have a matrix report that is showing whitespace in a drilldown because I am supressing duplicates. Based on what I read in other forums, if I set the ToggleItem to Len(FieldName)=0 that should supress the whitespace, right?
I can see that I have a field in the toggleitem called: Firstname. If I put the value Len(Firstname)=0 in the toggleitem property, then I get the error: The textbox 'textbox21' has Len(Firstname)=0' as a toggle item. Toggle items must be text boxes that share the same scope as the hidden item. I think the code 'Len' is throwing it off.
If I put the value "Firstname" in the toggleitem property, then it doesn't return the error, so I know that firstname is a valid value for toggleitem, but setting the value to firstname doesn't suppress anything.
If someone can tell me how to supress a textbox based on a value, then this may get rid of the whitespace I'm trying to suppress. Any ideas? Thanks...
View 3 Replies
View Related
Mar 18, 2008
I am working on a report that has 3 bars per series. I would like to add some gapping or whitespace between each bar in each series. Also how do you deal with overlapping. I know it can be done in Excel, I can't find the property of how to do it in SSRS. Any assistance would be appreciated.
View 1 Replies
View Related
May 15, 2008
I have a form that I created that groups make and model and it totals all the fields to make 1 entry on the Layout. I then am trying to get the layout to SUM those values but it does not. For example we have 2
Make, Model, Totals
CV, P2100, 50,000
CV, P2100, 52,000
CV, P2100, 48,000
CM, R3200, 50,000
CM, R3200, 53,000
CM, R3400, 20,000
CM, R3400, 22,000
As you can see above we have 2 Makes CV and CM, with Diff models.
The code i used totals the make, model, and totals for the parts.
Results look like this.
Make, Model, Total
CV, P2100, 150,000
CM, R3200, 103,000
CM, R3400, 42,0000
I tried to use the SUM function and it takes all older totals and places that at the bottom creating a Larger value than what should be posted.
the CM total should be 145,000 and the CV would be 150,000.
Here is the code I am using for this and this parts right I am just having issues with the layout not posting the correct numbers.
SELECT equip.eqpphybr, equip.kequipnum, equip.kmfg, equip.kmodel, equip.kserialnum, equipdet.glsrc, equipdet.glamt, equipdet.gldate, equipdet.action,
CASE WHEN action = 'b' THEN glamt ELSE 0000000.00 END AS RentalBilling,
CASE WHEN action = '6' THEN glamt ELSE 0000000.00 END AS Depreciation,
CASE WHEN action = 'a' THEN glamt ELSE 0000000.00 END AS Repairs, equip.eqprecdt, equipdaily.cnvf001, equipdaily.cnvf00109, equip.eqpstatus
FROM equipdet INNER JOIN equip ON equipdet.kequipnum = equip.kequipnum INNER JOIN equipdaily ON equip.kequipnum = equipdaily.kequipnum
WHERE (equipdet.gldate BETWEEN @fromdate AND @thrudate) AND (equip.eqpstatus <> 'SO')
ORDER BY equip.kmfg, equip.kmodel
__________________________________________________________________-
For the layout its looks like this with 2 groupings.
Below is the headers in same order as the =Fields
Br,EQ#, MFG, Model, S/N, ACQ Date, ACQ Cost, Book Value, Rental Billing, Depreciation, Repairs
---------------------------------------------------------------------
(This is row 1 inserted as a group with expression =Fields!kmfg.Value)
=Fields!eqpphybr.Value, =Fields!kequipnum.Value, =Fields!kmfg.Value, =Fields!kmodel.Value, =Fields!kserialnum.Value, =Fields!eqprecdt.Value, =Fields!cnvf001.Value, =Fields!cnvf00109.Value, =SUM(Fields!RentalBilling.Value), =SUM(Fields!Depreciation.Value), =SUM(Fields!Repairs.Value)
---------------------------------------------------------------------
(This row is set as a group by =Fields!Kmodel.Value)
ACQ Cost, Book Value, Rental Billing, Depreciation, Repairs
---------------------------------------------------------------------
Totals: =SUM(Fields!cnvf001.Value), =SUM(Fields!cnvf00109.Value), =SUM(Fields!RentalBilling.Value),=SUM(Fields!Depreciation.Value) / -1, =SUM(Fields!Repairs.Value)
---------------------------------------------------------------------
(I added a row from the =Fields!Kmodel.Value to get percents.)
Depreciation, Repairs
---------------------------------------------------------------------
=IIF(Sum(Fields!RentalBilling.Value)<>0,Sum(Fields!Depreciation.Value)/Sum(Fields!RentalBilling.Value),0)/-1, =IIF(Sum(Fields!RentalBilling.Value)<>0,Sum(Fields!Repairs.Value)/Sum(Fields!RentalBilling.Value),0)
View 20 Replies
View Related
Jun 1, 2007
We have a report that is printed landscape and contains a main table with values. Inside this table we also want to create a "sub-report" table based on two other criteria (charges and credits), but this data is still grouped with the main table. Here is a simple schematic of the report
XXXXXXX XXXXXXXX XXXXXXXXXX XXXXXXXXX Charges
XXXXXXXXX
XXXXXXXXX
Credits
XXXXXXXXX
XXXXXXXXX
XXXXXXX
We have placed a rectangle in the last column of the main table to accomodate two other "sub-tables": one for Charges and the other for Credits. We need to keep the heighth of each row in the main table the same (without extra white space) so we cannot move the second table for Credits below the table for charges.
I hope this makes sense and anybody with any suggestions, it is appreciated.
View 3 Replies
View Related
Jun 15, 2007
I'm developing a system in .NET to record and manage marks for classroom attendance. To enable staff to print-out the registers, I need to output the data in a printable format. My first thought on this was to use Reporting Servcices, however there are a number of caveats.
I'm using the matrix control to handle the displaying of the students with the class dates and attendance marks. After 25 columns are output this should wrap to a new page, is this possible?
When wrapping to a new page, the first 3 columns should remain the same with the other 18 being the next lot of class dates.
There needs to be 25 rows shown, regardless of whether or not there are actually 25 rows returned from the dataset.
Essentially the layout for this is strictly controlled. Is RS the correct tool for this or is there something else I can/should use?
Example register layout
NO. STUDENT ID 01/01 08/01 15/01 22/01 29/01
1 ADAM SMITH 123456 X X X X X
2 JANE WILSON 748386 X O O X X
View 25 Replies
View Related
Oct 10, 2007
Hey, guys
I have got problem of designing a report table. The table is created based on 5 field dataset output, student name, semester, unit name, unit code and exam mark. e.g.
StudentID Semeter UnitName UnitCode Mark
------------------------------------------------------------------------------------------------------------------------------------
123456 1, 2006 Database IT001 85
123456 1, 2006 XML IT002 82
123456 2, 2006 Web Development IT003 76
123456 2, 2006 ............
etc
and there is supposed to one table for one semester and the student ID and Semester must be in the first 2 rows and all the other data is column based as normal, which is like
StudentID 123456
Semester 1, 2006
------------------------------------------------------------------------
UnitName UnitCode Mark
Database ITN001 85
XML ITN002 82
StudentID 123456
Semester 2, 2006
------------------------------------------------------------------------
UnitName UnitCode Mark
Web Development ITN003 76
I only can create the table using grouping but the layout is column based.
Does anybody know how can I design the table to achieve the above table layout.
Thanks in advance.
Regards,
Jeff
View 3 Replies
View Related
Mar 14, 2008
I started the project with the goal of using 2005 Reporting Services as the reporting mechanism. Our graphic designer has created a layout that has been approved by the company and I am attempting to translate that layout to a report design that gives similar output.
I have discovered during the course of working with reports that true free from data layout is not possible. What I was expecting was the ability to design a layout for data in the body section of the report, and that layout being repeated for each row of data in the database.
I understand that tables and lists exists that allow repeated data to be displayed, but is it possible to repeat data in a custom freeform layout with 2005 Reporting Services.
Imagine if you were creating a report that looked like an ID card for each record. Would such a layout be possible with this reporting service?
If not, could someone direct me to a reporting application that does? Does Crystal Reports satisfy this requirement? I liked Reporting Services because it allowed one to design once and output into several popular formats, but the design portion doesn't appear to be as freeform as I was lead to believe.
Thanks
View 8 Replies
View Related
Sep 12, 2007
Hi,
When I preview my Reporting Services Report in VS2005 the report uses 2 separate pages. Even when there is very little data on Page 1 it will display something on Page 2.
How do I get all data on the one page?
Thanks.
View 10 Replies
View Related
Aug 16, 2007
I'm having a problem with my deployed reports. Once they have been deployed to a server then the layout changes and some parts of the report move around to line up with the edge of a matrix or the bottom of a table even through they do not actually overlap. The layout also changes depending on whether report items are visible or hidden, with tables moving away from hidden items but lining up witht hem when they are visible.
This also sometimes happens when moving between the layout and preview tabs in reporting services although this is not so much of a problem.
Has anyone else experienced the same problems and if so did you find a solution?
View 1 Replies
View Related
Sep 11, 2007
I have had a lood through the forum but although folks seem to be having a lot of issues with layout I can't see a problem quite like this one.
We have a number of customer reports which need to be exported to PDF and to look quite smart. They are single page reports with things like address and customer info at the top, followed by the main report, all of which can have a variable number of rows. Then at the bottom is some supplementary information which can also vary quite substantially in size. All I want is for the main report to hug the top of the page and the supplementary one to hug the bottom of the page - and I only really care what it looks like in PDF format. The problem is that I can't seem to achieve this. As the area at the top expands the bottom section moves up and down the page. I'd be quite happy to set aside a fixed area at the bottom of the page for the supplementary report, but I can't even work out how to acheive that! You would think that the obvious answer would be to put it in to a footer, but for some reason you can't put data elements in to headers or footers (why?). Any help would be greatly appreciated.
View 5 Replies
View Related
May 14, 2008
I have a report that i have totaled and working correctly and I am able to get the 2 columns to sum up but I need to get those 2 sumed columns to be divided to get the gross prof %.
The columns that I have summed are
=Sum(Fields!eqpsldamt.Value)
=Sum(Fields!grosspro.Value)
I need to take those summed values and divide them but I do not know the propper syntax to do this. I thought it would have been
=SUM(Fields!grosspro.Value) / SUM(eqpsldamt.Value)
But this did not work any help would be great thanks!
View 13 Replies
View Related
May 14, 2008
I have a report that i have totaled and working correctly and I am able to get the 2 columns to sum up but I need to get those 2 sumed columns to be divided to get the gross prof %.
The columns that I have summed are
=Sum(Fields!eqpsldamt.Value)
=Sum(Fields!grosspro.Value)
I need to take those summed values and divide them but I do not know the propper syntax to do this. I thought it would have been
=SUM(Fields!grosspro.Value) / SUM(eqpsldamt.Value)
But this did not work any help would be great thanks!
View 1 Replies
View Related
May 19, 2008
I have some old code that was used in cristal reports and thought it might help with my problem. I need this to calcuate intrest for every piece of equipment.
IF ({equipdet.ACQUIRED_DATE} < Date(2007,01,01)) THEN ({equipdet.Book Value}*(CurrentDate - Date(2007,01,01)) * .07/365) ELSE IF ({equipdet.ACQUIRED_DATE} > Date(2007,01,01)) THEN {equipdet.Book Value}*(CurrentDate - {equipdet.ACQUIRED_DATE})*
.07/365
I am just not sure how to write this in the layout view.
View 3 Replies
View Related
Sep 28, 2007
Hi
Is there anyway of copying an entire database (table layout, stored procs etc) without the data that the tables contain please?
I have a SQL7 DB (production) that I need to replicate on a SQL200 Server (development) but the DB is very large and all I need is the table structure and the stored procs on the development Server...
Cheers
View 7 Replies
View Related
Dec 2, 2007
Hi Guys,
Can I hear your views on this type of DB layout? I have a DB that contains tables which are not linked by FK's etc but rely on one another through SP's. I've never came across this layout before so was hoping you could shed some light on it with your experiences etc.
Also what if many of the tables didn't have PK's this would lead to duplicate data being allowed to be entered into the database. Are there any other issues here?
Regards Butterfly
View 9 Replies
View Related
Jul 20, 2005
Hello to everyoneI am using SQL Server Enterprise Manager and I would like to print thestructure of each table of a database, with the purpose to see the wholerecord layout. (In Access there is Analyzer which does that) butapparently I acnnot find anything similar in EM.Who Could help me?Thank you to everyone!RegardsFabio*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 2 Replies
View Related
Mar 25, 2008
I'm trying to create a report like following format. Any idea how can I design it?
'ID', 'Title', 'Answer' and 'Comment' have to span multiple rows which will list 'Response'.
----------------------------------------------------------------------------------------------------------------------------
ID Title Answer Response Comment
------------------------------------------------------------------------------------------------------------------------------
1 | Q1 | B | A | aaaaaaaaaaaaaaaaa
| | | B | aaaaaaaaaaaaaaaaaaaaaaaaa
| | | C | aaaaaaaaaaaaaaaaaaaaaaaaa
| | | D |
---------------------------------------------------------------------------------------------------------------------------------------
2 | Q2 | C | A | bbbbbbbbbbbbbbbbbbbbbbbbbb
| | | B | bbbbbbbbbbbbbbbbbbbbbbb
| | | C | bbbbbbbbbbbbbbbbbbbbbbb
| | | D |
---------------------------------------------------------------------------------------------------------------------------------------
View 12 Replies
View Related
Jan 10, 2007
I have a report that needs to show postal addresses. The address is broken down into several fields. The problem I have is some of the address parts are optional. If they are empty, I'm left with nasty gaps in the address. I'd really like next label to reclaim the space of any empty labels.
a quick example
A full address would look like this..
customer name
address line 1
address line 2
town
county
post code
if address line 2 isnt given, I get:
customer name
address line 1
town
county
post code
but I want:
customer name
address line 1
town
county
post code
Can anyone help?
Many thanks,
Paul
View 4 Replies
View Related
