SQL Reporting :: Tune This Custom Code?

Jul 8, 2010

I have developed this code .It is giving sumpoistive ,sumnegative correct .But count of positives and count of negatives it is not showing value...It is not showing error but not giving result..it is giving 0 as count for the coun_positive n for negative aslo..

Please tune my logic...

Public pos_sum AS INTEGER =0
Public neg_sum AS INTEGER=0
Public pos_coun AS INTEGER
Public neg_coun AS INTEGER
FUNCTION SUMFUNCTION(ByVal Field AS INTEGER) AS INTEGER
if Field>0 then
pos_sum=pos_sum+Field
return Field
End IF
IF Field<0 then
neg_sum=neg_sum+Field
return Field
End IF
End FUNCTION
FUNCTION COUNTFUNTION(ByVal Field AS INTEGER) AS INTEGER
if Field>0 then
pos_coun=pos_coun+1
return pos_coun
END IF
IF Field<0 then
neg_coun=neg_coun+1
return neg_coun
End IF
END FUNCTION
Function SumPositive() AS INTEGER
return pos_sum
End FUNCTION
Function SumNegative() AS INTEGER
return (-neg_sum)
End FUNCTION
Function couPositive() AS INTEGER
return pos_coun
End FUNCTION
Function couNegitive() AS INTEGER
return neg_coun
End FUNCTION

View 1 Replies


Similar Messages:

SQL Reporting :: Custom Code In Rdlc Is Not Working

Mar 30, 2010

I am maintaing binay data in sql table field-'StImage' . Actually i don't know how to show image from database field.

After lots of googling i tried to make it a reality .

I have dragged and droped a 'Image' control into my table in MyReport.rdlc[Design]

I set the following properties to the 'Image' control

name=ImgSt
MIME Type= image/jpeg
Source=Database
Value==Code.ByteToImage(Fields!StImage.Value)

Then i have added the following code to the 'Code' tab of Report Properties window

[Code]....

[Code]....

[Code]....

View 4 Replies

SQL Reporting :: Custom Code For Rdlc Report?

Feb 4, 2011

In my report I want to display the dollar amoumt in textboxs.

So I set the textbox property Format as currency.

My question is that I want to reports show brackets for negative dollar values. Ex : ($100) but

i want to report only display the negative values -$100

View 3 Replies

SQL Reporting :: Error In Custom Code Of Rdlc Report

Mar 30, 2010

I am having the binary data in sql table field 'ImgSt' .

I want to show the binay data as a jpg image. Therefore i used the for converting the binay data to image

[Code]....

[Code]....

I have also set in 'DataOutput' Tab

the the ElementName='imgSt' which is my Image's name
DataTranform==Code.ByteToImage(Fields!StImage.value)
For the value field of my 'Image' in report i have set
value==Code.ByteToImage(Fields!StImage.value)

But i am getting the error as the following

' MemoryStream' is not defined

View 3 Replies

.net - Fine Tune A Membership Provider?

Apr 30, 2010

After all the answers to my last question about fine-tuning turned out to be more useful than I expected, I thought that I would ask another similar Question about the MembershipProviders as well.

Okay, so firstly, to clarify: I know what a Membership, Role, and Profile provider is, how to implement my own, and how to configure them, and most of the things about them. Implementing a role and profile provider is pretty straightforward, because they only require simple CRUD most of the time. (A single line of LINQ is enough for about half of the RoleProvider's methods.)

However, the Membership provider is a differend beast. Many of you may realize that it violates the SR (Single Responsibility) principle, because it has to do EVERYTHING related to user management. While this leaves a lot of room for customizations, it has its downsides as well. There is no information on the Internet about what their EXACT expected behaviour is, such as when should they throw exceptions or simply return null, and stuff like that.

I use this sample implementation for reference, but it also contains several contradictions.

For example, it uses its own ValidateUser method for checking for credentials in the ChangePassword method. But the ValidateUser also updates the user's LastLoginDate to the current date. So, does the framework expect that I set it in my own provider as well, or is it simply a mistake in the sample? The other is: the ChangePassword method throws an exception every time when validating the new password, but CreateUser doesn't ever throw an exception, it simply returns false. And last, but not least: it counts the invalid password attempts of the user and locks them if it passes a threshold. While this is good, but it requires manual action to unlock the users. Is it a problem if my provider automatically unlocks the user after a certain amount of time? (EDIT) I almost forgot: the CreateUser method in the sample inserts the ID from the method parameter. I actually think this is bad practice, because I use inters with auto incement as IDs, so inserting them from some method parameter is not an option. Should I just ignore the parameter, or require that its value is null and throw an exception if it isn't?

All in all, does ASP.NET have any assumptions about the behaviour of a MembershipProvider? Is there any documentation which describes when should I throw an exception or just return null?

I also tried to find a set of generic unit tests which would provide some guidance about the expected behaviour, but no luck, I found plenty of articles about "Unit testing is good", and "How to unit test a MembershipProvider", but not one where there would be any actual tests.

View 1 Replies

C# - Integrate Radio Service - Tune Station From A Predefined List?

Jun 17, 2010

Our team working on a networking project We want to integrate radio services in our networking project We want to tune a radio station from a predefined list How can we achieve this?

View 1 Replies

SQL Reporting :: How To Do Custom Authentication

Jan 20, 2011

I have done it as mentioned in the readme file in the samples folder. But after completing all the steps when I open my browser and give in the url http://<servername>:<portnumber>/Reports, it shows the following error:

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

View 4 Replies

How To Custom Reporting For End Users

Apr 8, 2010

Is there a third party tool or something similar that will allow users to create reports on their own without any programming? One code base but custom reports for each user in the system that they create.

View 7 Replies

SQL Reporting :: Rdlc And Custom Datasource?

May 18, 2010

After being thoroughly frustrated with the typed datasets using the xsd designer, i built a custom class as an alternative. When I built it, I used the ComponentModel.DataObjectMethodType and ComponentModel.DataObject so that I could access them from the wizards. In the aspx file where the rdlc resides, using the wizard, I can select an objectdatasource and set the typename and selectmethod and add the object to the file. But when I go into the reportviewer, it doesn't show up as a project datasource for me to be able to add it to the reportviewer even after rebuilding the website. A few google searches didn't help so here I am asking if anyone can point me down the correct path.

View 5 Replies

SQL Reporting :: Header And Footer In SSRS As A Custom Item?

Mar 30, 2010

I have at least 87 report in my project what i am thinking to create a custom header and footer item in the report. In Header and footer we are showing a image so if we want to change the image then we need to change the image in all my 87 reports so is there any template that we can set in my header and footer so child report inherits from them.

View 1 Replies

SQL Reporting :: Custom UI For SSRS (Mimic Report.aspx)?

Jun 21, 2010

I'm currently working on a project that will allow users to do the following:. Choose one or more reports from the report library.2. Cycle through each report, choosing the parameter values to use to run each report.3. Generate a pdf containing all of the reports in one large file.4. Download the pdf.I'm handling 1, 3, and 4 just fine but running into some problems with item 2. The multi-select parameters are giving me headaches. Basically I want a page that contains the parameter selection piece of the standard SSRS web interface but instead of "View Report" it would fire off a function I've created that saves the parameter values and then reloads the page for the next report in the list chosen by the userDoes anyone know if the Report.aspx source code is available somewhere? I'm currently using a PopupControlExtender, CheckboxList, and Textbox to try and mimic the functionality of the multi-select parameter interface that's provided by SSRS but am having trouble getting the page to postback when the user clicks outside the list
of parameter values (the default SSRS interface does this).

View 3 Replies

SQL Reporting :: Giving Custom Colors For Graph Values In SSRS2000?

Aug 26, 2010

I am stuck here with the color for the graph values i want to give custom colors for each values present in the graph, is it possible in SSRS2000.

Problem Statement : Suppose if i want to display two data fields as bar graph

Data Fields are : Vegetable Count and Fruits Count

I want Vegetable count to be in Blue Colour and I want Fruits count to be in green colour.

View 2 Replies

Custom Server Controls :: How To Use A Custom Server Control That Is Defined In Inline Code In The Same Page

Oct 22, 2010

I have to use inline code for an aspx page and I need to use a custom server control that is defined in the same aspx page but the control does not get processed as a server control. it gets returned as is as static html tag.

View 3 Replies

SQL Reporting :: How To Add Custom Text For Null Vale Of Column In SSRS 2005

Jan 28, 2010

I am new to SQL Server Reporting Services. I am generating Reports VS 2005 Business Intelligence Report Server Project.

Here I got a general QQ when I am generating report.

How can i add custom text if column value is null. I tried to add it by column Expression property.

i,e =IIF(IsNothing(Fields!DOB_YY.Value) , "Null", Fields!DOB_YY.Value)

Here I added custom text as 'NULL'. But its not doing any changes in my pages.

View 12 Replies

SQL Reporting :: Filtering On Multiple Items Is Disabling Custom Drill Through Actions?

Dec 10, 2010

I am using Excel 2007 to connect to a SQL Server 2008 Analysis Services database.

View 4 Replies

SQL Reporting :: How To View HTML Code In Rdlc

Jun 8, 2010

I am using VS2005 and have a rdlc that is ready to be render to a pdf file.

The problem now is that one of the field is in HTML code.

e.g. Instead of new line, it show "<br/>".

View 1 Replies

SQL Reporting :: Send Report To Printer From Code-behind?

Sep 26, 2010

I would like to create a print button to send a .rdlc report to the users printer. Since i'm not using report viewer to view my reports using it's controls is not an alternative.

I have a button that generates a .pdf file from the report, and now i would like to make a similar button, but to print the report.

View 1 Replies

SQL Reporting :: Populate Report Viewer By Code?

Aug 17, 2010

I have a button "Show Report" to show some data from table what I should write under this button to populate the reports ?

View 5 Replies

SQL Reporting :: C# Code Call SSRS Subreport From ReportViewer?

Nov 18, 2010

Any C# Code or any setting in Reportviewer to call SSRS Subreport from ReportViewerThe SSRS Subreport executes properly from report manager.

View 1 Replies

Custom Server Controls :: Firefox (Firefox/3.6.13 ) Not Saving Cookies For Https In Logi Report(It's A Reporting Software0?

Feb 7, 2011

I am using Logi Reports for creating reports in my application. I am passing cookies from web application to these logi reports. Cookies were workign correctly before, but after the release of this version. Cookies are not working in these logi reports.

View 1 Replies

Custom Sized Paper Code For Printer?

Apr 25, 2010

I have EPSON LQ 300 Printer which driver or software doesn't allow user defined paper size.But i need code to access printer paper size ( custom size ) in asp.net c#

View 1 Replies

Web Forms :: Looking For Custom Code To Create Webparts?

Feb 2, 2011

I have few ASPX pages and I am planning to have some webparts on these pages.

a) Looking for custom code to create ASP.NET webpart (code samples, webcasts or samples would be great)

b) Once I have webpart created, I would like to know how I can refernce them in ASPX pages.

View 1 Replies

Security :: How To Extend The RoleProvider To Have Custom Code

Feb 24, 2010

I am obviously missing something here and it is driving me batty. I am trying to implement a custom role provider so that I can add some of my own custom code to it. I have created my CustomRoleProvider class, I have inherited the RoleProvider base class and implemented its members. I have made the required changes to my web.config so that my CustomRoleProvider is used. This is all working great.

All of this is wrapped up in a wrapper class as provided by the MVC Membership Starter Kit that I am using and wish to extend.

Now I want to add my own custom functionality.

When I add a function to my CustomRoleProvider I cannot see it or access it.

How do I add functionality to my CustomRoleProvider so that I can use it?

View 1 Replies

Web Forms :: Setting Up Custom Validation With VB Code-Behind?

Mar 3, 2011

I am trying to set up my first custom validator in VS 2010 VB. I want it to use a Sub or Function that is in my code-behind. I have searched the WEB but the instructions and examples that I have found do not show me how to use code-behind.

The main problem that I am running into is that I can not find a way to connect the validator to a sub that preforms the validation check.

View 3 Replies

SQL Reporting :: Reporting Services And Reporting Manager?

Sep 27, 2010

I have question is it possible to install Report Manager (IIS Service) on different server than Reporting Services is installed? I would like have IIS service (Report Manager) on one server and Reporting Services mechanism on the second one. Do you think this solution is possible?

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved