Search results for query: *

Hello experts, I need to know how to exclude weekends in days from this case statement..... I need it to work with the case statement as I don;t want to adjust my whole code. For example ie. if Date 1 = May 2, 2008 and date 2 = May 5, 2008 Looking at this example the day difference = 3 days...

Hello once again experts, I am in desparate need of a solution. I am using Oracle 9.2 and have created a package/stored procedure that I tap into crystal Report XI. This procedure accepts 2 parameters: StartDate and EndDate. Here is my very simple code: CREATE OR REPLACE PACKAGE BODY...

Thanks Lbass, My apologies as you were correct on the what I should see if I entered the parameter directly on the report. I do see what you said but because I have been playing around with different variations on my own I gave you incorrect informationJ Anyways, I do see as below...

You may have missed the answers in the original message, but I understand as it is a long thread:) In my original Question I said "So if I place this parameter right now I get 1 value which in this case is number 1." So if I enter 1,2,4 I get 1 returned on the report. It cuts off 2,4...

LBass, I will first tell you what happened when I put your formula’s in my report and then I will explain more of what I want to clear up any confusion. So if I add a formula and call it @test and add this as you asked stringvar array status := split({?STATUSSELECT},","); numbervar...

LBass, Thanks for the help. Sorry I may have miscommunicated. My parameter is not an Integer but a VARCHAR(2). The reason is because I have a function in the database that allows the user to enter multiple values separated by a comma. So for this situation I would enter 1,2,4. This list...

Lauriesamh, Thanks for the response. I don’t think your code will help me but I appreciate the effort. Just looking at the code, it looks like it will only display the values that I enter in the parameter and not the actual description. We have to remember that my parameters are bare and...

Using crystal reports XI with oracle 9.2 stored procedure. I have one parameter in the stored procedure called status, that is an IN parameter. Now when I run a crystal report with that stored procedure I get prompted for that parameter. In my stored procedure I also have function that will...

THANKS SHECO FOR HELPING ME OUT. ON THE VIRTUAL DIRECTORY OF THE WEB SERVER, UNDER PROPERTIES-AUTHENTICATION METHODS, THE ONLY THING THAT IS CHECKED IS INTEGRATED WINDOWS AUTHENTICATION. Anonymous access HAS NO CHECK MARK IN THE BOX. THANKS

Hello professionals, I am in need of assistance with Active Directory and ASP and IIS. I have the following piece of code: UserName= instr(Session("User"),"\") userSession = Mid(Session("User"), UserName+ 1, len(Session("User"))- UserName) Set objConnection =...