Click here to Skip to main content
15,891,777 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: onclick event giving error in asp.net 1.1,not in asp.net2.0 Pin
Christian Graus5-Jun-09 10:18
protectorChristian Graus5-Jun-09 10:18 
QuestionRadtreeview control/checkbox Pin
AndyInUK5-Jun-09 1:29
AndyInUK5-Jun-09 1:29 
Question[Message Deleted] Pin
Jain Vijay5-Jun-09 1:07
Jain Vijay5-Jun-09 1:07 
AnswerRe: How to find cursor position in HTML Editor Pin
Ashfield5-Jun-09 1:35
Ashfield5-Jun-09 1:35 
QuestionTurning off validateRequest for a user control [modified] PinPopular
c24235-Jun-09 0:37
c24235-Jun-09 0:37 
AnswerRe: Turning off validateRequest for a user control Pin
Alex Random1-Nov-10 3:55
Alex Random1-Nov-10 3:55 
GeneralRe: Turning off validateRequest for a user control Pin
c24233-Nov-10 8:23
c24233-Nov-10 8:23 
QuestionStrange Behaviour of Crystal Report Pin
Girish4815-Jun-09 0:33
Girish4815-Jun-09 0:33 
Hello,
I have created one crystal report in VS 2005. Its datasource is ref cursur returned by oracle stored procedure and it is working fine except one formula filed which i have code like following:
Here CURSPKG_JOIN is the name of oracle package and
OPEN_JOIN_CURSOR1 is the name of stored procedure.

Name of formula field is:finalres

iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.R1}='G'
or {CURSPKG_JOIN.OPEN_JOIN_CURSOR1.R2}='G'
or {CURSPKG_JOIN.OPEN_JOIN_CURSOR1.R3}='G'
or {CURSPKG_JOIN.OPEN_JOIN_CURSOR1.R4}='G'
or {CURSPKG_JOIN.OPEN_JOIN_CURSOR1.R5}='G'
or {CURSPKG_JOIN.OPEN_JOIN_CURSOR1.R6}='G',
iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='1','FIRST DIVISION BY GRACE',
iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='2','SECOND DIVISION BY GRACE',
iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='3','THIRED DIVISION BY GRACE',
iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='C','SUPPLEMENTARY',
iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='F','FAILED',
iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='P','PASSED',
iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='Z','PARTIALLY PASSED',
'xx')))))))
,
iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='1','FIRST DIVISION',
iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='2','SECOND DIVISION',
iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='3','THIRED DIVISION',
iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='C','SUPPLEMENTARY',
iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='F','FAILED',
iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='P','PASSED',
iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='Z','PARTIALLY PASSED',
'yy'))))))))

and i put this formula filed on to the report; but it is printing the required result at somewhere and somwhere no print (even, i have given the false part i.e. 'xx' and 'yy') even with the same condition. I have double checked the data in the table and just for checking; i have placed the FR column on the report, which is carrying right value though. FR column is varchar2 length 1 character.

Please guide me where i am missing....!
Thanks & Regards
Girish Sharma
QuestionTabControl - Active Tab Index Question Pin
Programm3r5-Jun-09 0:06
Programm3r5-Jun-09 0:06 
AnswerRe: TabControl - Active Tab Index Question Pin
Programm3r5-Jun-09 0:26
Programm3r5-Jun-09 0:26 
Questionrender ListBox Pin
Koss_G4-Jun-09 22:54
Koss_G4-Jun-09 22:54 
AnswerRe: render ListBox Pin
Christian Graus4-Jun-09 23:04
protectorChristian Graus4-Jun-09 23:04 
QuestionCan anyone help Pin
owolabi Victor4-Jun-09 22:22
owolabi Victor4-Jun-09 22:22 
AnswerRe: Can anyone help Pin
Christian Graus4-Jun-09 22:26
protectorChristian Graus4-Jun-09 22:26 
AnswerRe: Can anyone help Pin
Manas Bhardwaj4-Jun-09 22:30
professionalManas Bhardwaj4-Jun-09 22:30 
AnswerRe: Can anyone help Pin
Abhijit Jana4-Jun-09 23:07
professionalAbhijit Jana4-Jun-09 23:07 
AnswerRe: Can anyone help Pin
Vasudevan Deepak Kumar4-Jun-09 23:40
Vasudevan Deepak Kumar4-Jun-09 23:40 
AnswerRe: Can anyone help Pin
J4amieC5-Jun-09 0:17
J4amieC5-Jun-09 0:17 
AnswerRe: Can anyone help Pin
AndyInUK5-Jun-09 0:50
AndyInUK5-Jun-09 0:50 
QuestionImage loading problem.... Pin
rjv2dlv4-Jun-09 21:25
rjv2dlv4-Jun-09 21:25 
AnswerRe: Image loading problem.... Pin
Christian Graus4-Jun-09 21:43
protectorChristian Graus4-Jun-09 21:43 
GeneralRe: Image loading problem.... Pin
rjv2dlv4-Jun-09 21:57
rjv2dlv4-Jun-09 21:57 
GeneralRe: Image loading problem.... Pin
Christian Graus4-Jun-09 22:25
protectorChristian Graus4-Jun-09 22:25 
AnswerRe: Image loading problem.... Pin
A k ch4-Jun-09 22:18
A k ch4-Jun-09 22:18 
GeneralRe: Image loading problem.... Pin
rjv2dlv4-Jun-09 23:44
rjv2dlv4-Jun-09 23:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.