December 28, 2008 at 10:49 pm
Hi friends,
Am Working with Sql Server Reporting services 2005. i created a dll file for calculating total_stock using vb.net and i used the following in expression,
=DPD.Class1.Total_Stock(Parameters!BRANCHSTATE.Label,Parameters!BRANCHBRANCH.Label,Fields!STATE.Value,Fields!BRANCH.Value,Fields!PERIOD.Value,Fields!ASSET_CLASS.Value).
i used drill down for state. if i drill down the statename, branch field will be shown.. the total_stock function works correctly for all branches. but the summing up value is not correct.
it shows the first branch value in the total value.
i want to sum all total stock for all branches.
Thanks in advance for all valuable suggestions.
Regards,
Gayathri
December 29, 2008 at 12:45 pm
Any chance you could give us a little more to work with, perhaps the code from your DLL? also perhaps some sample data, and what results you currently get and what results you are expecting? I understand this is a bit more difficult given that it's SSRS but we'll need just a bit more so that we can help you.
thanks.
-Luke.
December 29, 2008 at 3:46 pm
It sounds like this could be something you do natively within SSRS or in T-SQL (assuming that SQL Server is the data source). If you provide the DDL for the tables involved in the query there may be a way to do this without a custom dll, as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply