.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> ASP.Net >> Post New QuestionBookmark and Share Subscribe to Forum

crystal report function

Posted By: Dom     Posted Date: January 12, 2010    Points:2   Category :ASP.Net
CREATE FUNCTION [dbo].[GLAS_AGING]
( @tnum int,
@flag VARCHAR(1))
RETURNs int as
BEGIN
declare @result int
begin
IF @flag = 'Y' AND @tnum > 999
set @result= 8

IF @tnum<=30
set @result= 0

IF @tnum <= 90
set @result=1

IF @tnum > 90 AND @tnum <= 180
set @result=2

IF @tnum > 180 AND @tnum <= 365
set @result= 3

IF @tnum > 365 AND @tnum <= 545
set @result= 4

IF @tnum > 545
set @result= 5
end
return @result

END
---------------------
this is function how to invoke this function to crystal report in asp.net.....
how to create in crystal report formula editor?

Responses
Author: Naim Khan             
Posted Date: April 21, 2010     Points: 5   

hello friend,

check this link
http://www.dotnetspider.com/resources/Category542.aspx

Regards,
Naim Khan

Naim Khan


Software Developer
khan.naim786@yahoo.com
khan.naeem1987@gmail.com


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend