(URGENT) Getting The Number Of Rows From List Control
Oct 16, 2007
Ok here is what I have
Department:A
Line 1 Name: George
Addresss date raise
125254 Test 10
125254 Test 10
125254 Test 10
125254 Test 10
Total: 80% 40
Name: Mik
Addresss date raise
125254 Test 10
125254 Test 10
125254 Test 10
Total: 70% 30
Name: Jonathan
Addresss date raise
125254 Test 10
125254 Test 10
125254 Test 10
Total: 70% 30
Line 10
Line 15 Total for this division: 33% ((100 )/3) 100
Department:B
¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦..
Here is what I did I have a list control that is grouped by department. this will get me the info from Line 1 to Line 10 then this list control is actually under another list control that is grouped by department to get the info from Line 15. I used this example for simplicity and what I am doing is fairly similar to this situation. My problem is, I need to find away to know how many totals I have to count the total for the entire department. In other words : from the example above how can I know I have to divide by 3 to get 33%. I can get the 100 without any problem but I cant tell what number I need to divided by. I tried to use Count(Name.Field) I was hoping this will give me 3 which indicates the divided number. But I was getting 7 for some reason.
How can I get the number of times the list control was implemented for one department which is in this case 3?
thanks
View 2 Replies
ADVERTISEMENT
Sep 10, 2015
i want to break 2 by 2 rows in reportceiling(rownumber(nothing)/2).i used this expression in row group.Β URL....but i want to use this expression in matrix and that matirx is with in list . so i Β am getting error .Β how to use rownumber in list.here i used list to break the page wise id
View 3 Replies
View Related
Apr 9, 2008
I know I can do a JOIN(parameter, "some seperator") and it will build me a list/string of all the values in the multiselect parameter.
However, I want to do the same thing with all the occurances of a field in my result set (each row being an occurance).
For example say I have a form that is being printed which will pull in all the medications a patient is currently listed as having perscriptions for. I want to return all those values (say 8) and display them on a single line (or wrap onto additional lines as needed).
Something like:
List of current perscriptions: Allegra, Allegra-D, Clariton, Nasalcort, Sudafed, Zantac
How can I accomplish this?
I was playing with the list box, but that only lets me repeat on a new line, I couldn't find any way to get it to repeate side by side (repeat left to right instead of top to bottom). I played with the orientation options, but that really just lets me adjust how multiple columns are displayed as best I can tell.
Could a custom function of some sort be written to take all the values and spit them out one by one into a comma seperated string?
View 21 Replies
View Related
Oct 2, 2007
I know it is possible to make a list inside another list control.My question is,what happens to tha data of the list which overlapped the main list.
For example,i have "mainList" which is the dominant list,it contains field1.Then i put "List2" inside "mainList".List2 have fieldNew.And next,i put a textbox inside "List2".But what could be the reason,why fieldNew can't be seen and only field1 appears when i typed in my expression =Fields!fieldNew. it doesn't seem to be present to the fact that both list are assigned to different dataset..
mainList -> dataSet1
List2 -> dataSet2
As for what i have observed,and correct me if im wrong,list can only be embed into a list if its function would be for grouping,but not for getting different values from different dataset..
Hope to hear from anyone..Thanks..
View 4 Replies
View Related
Nov 22, 2005
Hi!
I have a strored proc which adds up fields separated by semicolon into a new one and I'd like to use it as a combo box's control source field as a Value list. But it's just insert the whole field into one line like value1;value2;value3 .
Is there any way to get these values selectable in the combo box?
Thanks in advance for any help.
Vill
View 1 Replies
View Related
Oct 28, 2007
Hi,
I am new to SSRS.
I have created simple report using reporting services, In which i am using one List element and inside that 8 text boxes and a table, in which 4 texboxes is used as lable and remain 4 textbos is value from dataset and table displays details as below for each unquie call number with table header marked in red color. When i click preview i get below report(Report 1) for call number 4 and 10 records in table which is under list. But for call number 4 still 6 records as to be display in next page with text boxe element which marked in Green color in Report 1. Now i am getting report with out List element i.e (Report 2 given below )
Report generated for Call numnber 4 (on click of preview ) (Report 1)
Generated Report
Call No
4
CallDate
2/2/2007
Customer Name
ZINDAL STEEL P . LTD
Address
Chennai
SL Number
PartNumber
PartName
Qty
Rate
Amount
1
12345
SCREWS
100
10
1000
2
47555
BOLTS
200
25
5000
3
125453
RIVETS
300
40
12000
4
15786
RATCHETS
500
23
11500
5
15566
TORQUE WRENCH
600
45
27000
10
5456
HARMONIZATION TOOL
700
45
31500
(Report 2)
Report generated for Same Call number 4 in next page with out List element, In this page i want display the same textboes and values which are marked in green color.(This 6 records alos belongs to same call Number 4 )
SL Number
PartNumber
PartName
Qty
Rate
Amount
11
12345
SCREWS 6"
100
10
1000
12
47555
BOLTS 5"
200
25
5000
13
125453
RIVETS 5"
300
40
12000
14
15786
RATCHETS Big
500
23
11500
15
15566
TORQUE WRENCH Small
600
45
27000
16
5456
HARMONIZATION TOOL
700
45
31500
Can any one please guide me how to do this kind of desing.
Thanks and regards
Manju
View 2 Replies
View Related
Apr 4, 2007
I have created a report that contained a subreport that was databound inside a table but I was getting errors when I export to excel - "Subreports within table/matrix cells are ignored".
So I changed my report to bind the subreport to a list control instead of a table and it exports to excel fine but I now have new issues:
1) When I export to pdf it seems to ignore width and height properties, creating a blank page every other page (because it thinks the list control is wider than the page), and it also overlaps other elements below the list control.
2) I also seems to have lost the paging in the viewer control that is handled by setting the interactive height property.
Are these known limitations of the list control and pdf or do I have something wrong in the way I have set-up the report. I can provide .rdlc file samples if necessary.
Thank you
Lee Whitney
View 2 Replies
View Related
Sep 24, 2007
Hi
I want to enter rows into a table having more number of columns
For example : I have one employee table having columns (name ,address,salary etc )
then, how can i enter 100 employees data at a time ?
Suppose i am having my data in .txt file (or ) in .xls
( SQL Server 2005)
View 1 Replies
View Related
Sep 6, 2000
Tempdb has grown to over 17 GB. It had no max growth limit set and actually took up all the disk space on the drive. I tried to run DBCC SHRINKDATABASE and received a bunch of errors about table corruptions. So, I found Brian Knight's post about stopping and restarting tempdb in minimal mode. I did that. It came back up and tempdb was correctly only 2 MB. It freed up 17 GB on the disk. Then, I stopped and restarted the service again, not in minimal mode, and it won't come back up. It has taken back that 17 GB of disk space. From the error log, I can see that it is stuck on rebuilding tempdb. Why is it trying to rebuild tempdb to 17 GB???
While in minimal mode, we did set the maximum growth limits to 1 GB for both data and log for tempdb, but that seemed to have no effect.
Any suggestions????
View 3 Replies
View Related
Nov 6, 2007
i have another problem with my library...
i create a library with a datagridview, that i polute manually from several database querys...
thats just fine.... works excelent..
but if i browse the aspx page from another computer on the network, when the code tries to read the data set give me an error
Cannot find the table 0
seems like a problemwith the connection or the query, but if i browse the page from the localmachine i works just fine
please help
Public MM_CONEXION_STRING As String = "server=HP001SQL2000;uid=xxx;pwd=xxxxx;database=GSSDOTNET;"Dim myConnection As New SqlConnection(MM_CONEXION_STRING)Dim myCommand As New SqlCommand(SQL, myConnection)
myConnection.Open()Dim objDS As New System.Data.DataSet()
objDS=myCommand.ExecuteReader()For Each FILA As System.Data.DataRow In objDS.Tables(0).Rows .......
Next
View 2 Replies
View Related
Apr 28, 2008
What are the options to create a table of contents based on the report items in a List Control? Document Mapping works for online viewing. A table of content would make the report easier to read when it's printed.
Any help is much appreciated. Thanks.
View 1 Replies
View Related
Sep 26, 2005
Hi,I've just installed SQL server and then IIS and SQLCE tools.I created a virtual directory and was trying to update the NTFSpermissions from SQLServer Connectivity management when i got thefollowing error - Access Control List (structure) invalid.Has anyone come across this and if so, what did u do to fix it.ThanksLyn
View 2 Replies
View Related
May 17, 2007
Hi,
I'm using SqlDataSource control.
Is there a way to know how many records a query has returned?
View 3 Replies
View Related
Jul 30, 1998
Hi everyone!
Is it possible to control the number of simultaneous connections one login id can have?
I`d like to avoid my users to share their login ids and passwords to help them enter data into the system.
Thanks,
Mauricio
View 5 Replies
View Related
Feb 13, 2007
Hi All
I have a report which has a multi-value parameter. Problem is, it can contain up to 100 options.Is there a way to limit the number of options that is passed to the SQL statement?. EG list has 100 options, user selects 10 but only the first 4 selected options are passed to the SQL statement.
Many Thanks
Delli
View 4 Replies
View Related
Oct 29, 2007
hii
Everybody
In my report i have a matrix,but i want to show only 10 columns in one page and rest of the data should come in next page?
so is there anyway to control the number of columns in a matrix to be shown in the priview?
please help me with some suggestions.
its orgent
thanks in advance
Mahasweta
View 1 Replies
View Related
Sep 12, 2015
@BoxesNeeded will change every time it runs. This method works.
declare @i as int,
@BoxesNeeded as int
select @i = 0,
@BoxesNeeded = 15
--drop table #temp
select @i as DDL
into #temp where 1=2
while @BoxesNeeded > @i begin
set @i = @i + 1
insert into #temp
select @i
end
select DDL
from #temp
View 3 Replies
View Related
Jul 3, 2007
Hello,
I have a matrix inside a list box that groups by "question id" to display matrices with summaries for each question. I have checked the box "Insert page break after this list".
I want to be able to place the list box number next to the question, so that I will see something like:
1. Name
2. Category
3. Age
Is there a way to do this? Can I access the current number within the list? If I try the Globals!PageNumber variable, I get an error saying that the variable can only be used in a header or footer.
Thanks,
Michael
View 3 Replies
View Related
Mar 22, 2007
I accidently deleted the file that I was working on in notepad that had the tables and views that I created. Is there a way to retrieve a list and the code that I put in for the tables and views?
View 1 Replies
View Related
Nov 13, 2001
Hi,
this is my second attempt to get an answer to this question.
We want to strip our firstName column and lastname column of any punctuation that might be present.
What's the best of doing that?
Is my only choice to write a nested REPLACE for each character we want replaced (which will end up being very very long) or is there another way.
thanks
Zoey
View 2 Replies
View Related
Aug 13, 2007
I have a custom list(say a list for account numbers, account numbers starting with 13 form a group, then starting with 14 form a group and like that)
and then there are tables inside this list. the report will be displayed based on the values of this custom list.
i also have a drill through report for this. now when i pass fields!accountnumber.uniquename for this list only the first of the group values say 130001 is selected..
what shud i do to select the whole grp??
thanks!
View 4 Replies
View Related
Apr 10, 2001
Hey folks,
Please give me the correct function name, otherwise please ignore in sending reply. I had used all the functions like identity, ident and so on. I need while selecting a querry, i need to generate serial numbers. I dont have identity column in my table. But, i need to generate serial numbers..
In Sybase SQL Any where, we have a function called Number (*) which will in turn generate serial numbers like ex..
Select Number (*) from x
The output will be
Number(*)
1
2
3
4
5
6
and so on..
I need a equivalent function in SQL Server 7.0 in which if i do select on that particular function with a table i should return above values..
Can any one solve this issue...
Please help me in this....
Urs
VJ
View 1 Replies
View Related
Oct 10, 2007
Here is what I have
CDec(Sum(Val(Fields!Test1.Value))/(Val(CountRows("Group1"))*SomeNumber)*100%)
This works fine
but the problem is the number can be 25.325641. I only want to get 25 so I did this
Int(Sum(Val(Fields!Test1.Value))/(Val(CountRows("Group1"))*SomeNumber)*100%)
This did the trick but if the number is .255667 it will display 0.
here is what i want:
1-if the number is bigger than 0 i don't want to display the decimals for example:
25.01245 = 25
2-if the number is less than 0. I only want to display 2 decimal places
.256415 = .25
Thanks
View 4 Replies
View Related
Apr 14, 2007
I am creating printed questionnaires based on data in a table. Portions of the layout must be exact and not be moved on the page.
I have some textboxes and rectangles on the left of a report and a table on the right. The table forces all the controls on the left to appear AFTER the last row and I can find no workaround. Basically, no controls can appear to the left of a table. The texboxes on the left give instructions to the user on how to fill out the items in the table on the right and I need them to remain where I place them. I have many other reports that require fixed positions.
Other report writers have texbox and label options to work around this . For example Visual Foxpro has an "Object Position" property with options for "Float", "Fix position relative to top of band", "Fix position relative to bottom of band". This allows the position to be forced if necessary.
This is very much needed and wanted in the Report Writer and I request it for the next release or service pack.
View 1 Replies
View Related
Jan 28, 2008
Hi,
i hv made a rdl having 2 tables.My requirement is to display the tables on different sheets of excel, so i hv inserted "Page Break At End" in table1.
As a result im getting tables in different sheets but second table (in sheet2) is starting from 2nd row of the sheet i.e. 1st row is coming as hidden, and i want to remove this row as client feed's this excel file in some other application.
If anyone is aware of the solution pl. reply ASAP.
Thank u.
View 3 Replies
View Related
May 3, 2007
This is stupid, I used to be able to do this all the time by mistake now I can't do it on purpose
I want to be able to return a full list of matching records when only one is true
LikeRow 1, ID_1, falseRow 2, ID_1, falseRow 3, ID_1, trueRow 4, ID_2, falseRow 5, ID_2, trueRow 6, ID_2, false
I currently getRow 3, ID_1, trueRow 5, ID_2, true
View 3 Replies
View Related
Apr 7, 2004
Hello!
Got a problem I hope some clever people can help me out with..
I have a web form that displays a set of records in a grid. The grid is "paged" according to a PageNum column, with a dropdown box to change pages and buttons allowing the items to be moved up or down a list within a page or moved between pages. So the backend table (simplified) looks something like this
PageNum ItemNum ItemDescription
----------- ----------- -------------------
1 1 aaaaaaa
1 2 bbbbbbb
1 3 cccccccc
2 1 ddddddd
2 2 eeeeeee
2 3 ffffffffffff
3 1 ggggggg
3 2 hhhhhhh
3 3 iiiiiiiiiiiiiiii
The problem is when I want to delete a page - I need the page numbers to automatically resequence themselves, so for example, If I delete "Page 2" (i.e. delete rows where PageNum = 2), all items on "Page 3" become "Page 2" (and any items on "Page 4" become "Page 3" etc).
This has proved straightforward to when deleting an item from a particular page, and can resequence ItemNum thanks to a clever bit of code found on SQLteam.com:
DECLARE @intCounter int
SET @intCounter = 0
UPDATE <Item Table>
@intCounter = ItemNum = @intCounter + 1
WHERE Pagenumber = <Currently Selected Page>
However I haven't been able to adapt this to resequence the Page number, as this involves resequencing blocks of numbers. The closest I can get is:
DECLARE @intCounter int
SET @intCounter = 1
UPDATE <Itemtable>
SET @intCounter = PageNum = CASE
WHEN @intCounter = PageNum - 1 THEN @intCounter + 1
WHEN @intCounter = PageNum - 2 THEN @intCounter + 1
ELSE @intCounter
END
But this doesn't quite work.
Anyone got any other ideas??
Thanks
Greg
View 3 Replies
View Related
Apr 28, 2015
I am getting error [[Msg 16924, Level 16, State 1, Line 13
Cursorfetch: The number of variables declared in the INTO list must match that of selected columns.]] when i execute below script.
Declare @mSql1 Nvarchar(MAX)
declare @dropuser int
declare @dbname Nvarchar(max)
declare @username Nvarchar(max)
DECLARE Dropuser_Cursor CURSOR FOR
[Code] ....
View 9 Replies
View Related
Apr 10, 2001
Hey folks,
In Sybase SQL Any where, we have a function called Number (*) which will in turn generate serial numbers like ex..
Select Number (*) from x
The output will be
Number(*)
1
2
3
4
5
6
and so on..
I need a equivalent function in SQL Server 7.0 in which if i do select on that particular function with a table i should return above values..
Can any one solve this issue...
Please help me in this....
Urs
VJ
View 1 Replies
View Related
Aug 2, 2006
I am in need of help to develop a query
I have two tables Exams and Exams_lab, that are joined by a field id_exame. I want to return The Exams that has all the dependent rows in Exames_lab with the same value in the status_int field of Exames_lab. Can anyone Help Me?
Lets see an example
tb_exame
id_exame
date_exame
1
07/01/2006
2
08/01/2006
3
09/01/2006
tb_exame_lab
id_exame_lab
id_exame
desc_exame
status_exame
1
1
NORMAL
1
2
1
0
3
2
NORMAL
1
4
2
PROBLEMS
1
5
2
OK
1
6
3
OK
0
in this exemple my query must return only id_exame 2 and 3 because id_exame 1 has two different values on id_status on tb_exame_lab
can anyone help me?
View 5 Replies
View Related
Jun 6, 2014
I have the following query:
Code:
SELECT DISTINCT [WL].[Id]
,[WL].[UserId]
,[WL].[DIF]
,[WL].[MW]
,[WL].[Notes]
,[WL].[WDate]
[Code] ....
And the error i get is:
> Column 'Wsite.dbo.WLog.Id' is invalid in the select
> list because it is not contained in either an aggregate function or
> the GROUP BY clause.
What I am wanting to do is just conbine the data if there are more than one **UserID** in the list.
As an example:
Code:
Id | UserId | .... | Id | UserName | SLength | ....
5843| 99304 | .... | 99304| Bob Barker | 14 | ....
5844| 06300 | .... | 06300| Dean Martin | 104 | ....
5845| 99304 | .... | 99304| Bob Barker | 8 | ....
5846| 99304 | .... | 99304| Bob Barker | 11 | ....
5847| 7699 | .... | 7699 | John Doe | 0 | ....
So it should look like this:
Code:
Id | UserId | .... | Id | UserName | SLength | ....
5843| 99304 | .... | 99304| Bob Barker | 33 | ....
5844| 06300 | .... | 06300| Dean Martin | 104 | ....
5847| 7699 | .... | 7699 | John Doe | 0 | ....
Notice that Bob Barker's SLength was combined (14+8+11=33).
View 1 Replies
View Related
Oct 17, 2013
I'm using this to find duplicates where a person has the same email but varying firstname and lastnames:
select distinct t1.booking_id, t1.first_name, t1.last_name, t1.email_add, t1.booking_status_id
from [aren1002].[BOOKING]
as t1 inner join [aren1002].[BOOKING]
as t2
on t1.last_name=t2.last_name and t1.booking_id<>t2.booking_id
where t1.booking_status_id = 330
order by last_name asc
Sample data:
3927 Greg Smith greg@emailno1.com 303
5012 John Smith greg@emailno1.com 303
6233 John Smith greg@emailno1.com 303
4880 Dulcie Abuud dulcie@theiremail.com 303
However it is listing the non duplicate rows, For example: The record with Abuud as the last name, doesn't have any duplicates in the table, so I don't want it listed.
The data should be like this:
3927 Greg Smith greg@emailno1.com 303
5012 John Smith greg@emailno1.com 303
6233 John Smith greg@emailno1.com 303
View 4 Replies
View Related
Nov 3, 2014
select pr.birthdate, pr.operationdate from patientrecord pr
Total no.of rows = 24420
select distinct pr.birthdate, pr.operationdate from patientrecord pr
Total no.of rows = 23528
It seems there are some rows with same birthdate and operationdate.
I want to get the list of rows(with all columns) that has got same birthdate and operationdate
View 1 Replies
View Related
