May 5, 2008 at 9:43 am
hi
i've developed a report and having problem to display results correctly, i.e i have records with different CustomerID which belong to a BatchNo, when i select the BatchNo i want it to display records on each page ie. BatchNo 174895 has 5 different CustomerID, when i select BatchNo i should be able to display all 5 customer details in 5 separate pages but only the first customer details are being displayed.
If i run my query in the SQL Server it displays correct values but the report only displays the first one
May 9, 2008 at 2:07 am
There could be quite a large number of reasons for this, in order to help you out on this I would need more information on how you have put your report together.
My immediate answer would be that you are probably using a List Box as a Placeholder and inside the list box you are using a number of text boxes to display the results (customers). This won't work, you will no doubt notice that inside the text box is something like First(Fields!CustomerId.Value) which will do exactly what it says, it will display the first and only the first.
What you need if this is the case is to place a Table inside the list box, not text boxes.
Anyway, this was just a guess, so if I'm wrong then you need to provide more information on exactly what you have inside the report.
Nigel West
UK
May 12, 2008 at 6:59 am
thank you sooooooo much nigel.c.west, the listbox did exactly what i wanted, it really helped and now i'm able to run my report the way i want.
thanks again
May 12, 2008 at 7:02 am
Pleased to be able to help, glad it worked for you.
Nigel West
UK
June 19, 2008 at 5:58 am
hi
i need a favour i'm struggling to get a correct value out of my table:
AssetID AssetCodePcodeDepIDStaValue
6370IT_INFR 1006102421953.43
6370IT_INFR 10061024 21953.43
6370IT_INFR 10061024 21953.43
637106361 10061012 2452.00
637106361 10061012 2452.00
i need to sum StaValue this value 21953.43 + 2452.00 to get 53829810.36 leave out the duplicates
June 19, 2008 at 7:33 am
AssetID AssetCode Pcode DepID StaValue
6370 IT_INFR 1006 1024 21953.43
6370 IT_INFR 1006 1024 21953.43
6370 IT_INFR 1006 1024 21953.43
6371 06361 1006 1012 2452.00
6371 06361 1006 1012 2452.00
The idea here would be to create a table that has a group, probably based on the Asset ID (let's assume the group name is table1_AssetId). The details section would show all of the information above.
In the Footer of the Group you should place an expression in a cell to hold the value you want, the expression should read
=SUM(Fields!StaValue.Value,"table1_AssestId")
The above expression should provide you with a sum only of the value held against the group level, not the details level.
Good luck,
Nigel West
UK
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply