Search results for query: *

Hi there! I have a CR8 report which I need to run via the web through the Web Server. It is called via the java viewer. I also have two database users on an Oracle 8 database platform. User1 is permissioned to everything in the database. User2 is permissioned only for a few views that are...

Hello all. Does anyone know the syntax needed to pass a datetime parameter through via a URL. ie/ www.site./Reports/MyReport?DateTimeParam0='yyyy,mm,dd' Thanks, CrystalVisualBOracle

Does anyone know the format needed to pass in a DateTime parameter to a Crystal Report (8) from a jsp page. For example I want to pass in August 8, 2001. What's the format of the date supposed to be? YYYY,MM,DD? MM-DD-YYYY? Any help would be appreciated. Thanks!! CrystalVisualBOracle

Hi all. I'm trying to group by a field called description in my report but when I click to Add a Group in CR, that field doesn't appear. My report is based on a Crystal SQL Query which looks as follows: SELECT A.MC_LICENSE_ID, A.COUNT, B.HITS, B.USERS, C.M_PUBLICATION_ID...

Hello All. I have a report which queries off of two Oracle 8 tables. The tables are linked with an outer join. SELECT LICENSE_DATA.KEY, LICENSE_DATA.DESCRIPTION, USER_RIGHTS.USERID, USER_RIGHTS.STARTED, USER_RIGHTS.EXPIRED FROM LICENSE_DATA, USER_RIGHTS WHERE...

Hello all. I rarely have to use outer joins so this may be something simple I am overlooking. Below is a query with two tables. There may be records in the LICENSES that don't have corresponding records in USERS so I created an outer join to get those records. The problem is that if there...

Hello all. I'm trying to learn how to call an Oracle 8.1.7 stored procedure from Crystal Reports 8. I created the package and procedure as specified in by crystal. In testing, the package and procedure both execute correctly. Every time I try to create the report and select the procedure to...

Hello all. I am trying to use the Count(fld,condfld) function to sum up the number of records returned for each group on my report. Here's an example. SALES REPORT Joe's Sales Team Jenny Jones 10/12/2001 10 Units Sold Client A Bob Evans 10/13/2001 7 Units Sold...

Does anyone know if there is a way to count distinct records in Crystal Reports? ie/ Count the distinct number of userid's that are printed on a report? Record Sales Report By Day User 198 Sold 10 records on Jan 12 User 199 Sold 8 records on Jan 12 User 198 Sold 11 records on...

Has anyone ever used an Oracle stored procedure to create a Crystal Report? I'm trying to figure out if the parameters required for the procedure always have to be the same or if they can change each time a report is generated. For example, I have a stored procedure "Get_Users&quot...

Hello all! I have a java.sql.date object called startdate that I need to initialize and set. Initializing it is easy enough java.sql.Date startdate; But how do I set string variable (ie/ String SomeStringDate = "01/01/2001") to startdate's java.sql.Date format? Basically I...

Hello all! I have a java.sql.date object called startdate that I need to initialize and set. Initializing it is easy enough java.sql.Date startdate; But how do I set startdate to say, January 1, 2005? Does anyone have an example of this? Thanks in advance, CrystalVisualBOracle :-)

Hi there. I need help learning how to deal with string variables that may or may not be null in a JSP page.I have a program which (in simplified form) looks like this... Main.jsp (1) Goes to class where several users are selected. Each user's user info is put into tokenized format and added...

Hi there! Is there a method that will return an integer from the request object? "request.getParameter" only seems to return a string. int searchtype = (int)request.getParameter("searchtype"); Thanks in Advance, CrystalVisualBOracle :-)

Hi there! Is there a method that will return an integer from the request object? "request.getParameter" only seems to return a string. int searchtype = (int)request.getParameter("searchtype"); Thanks in Advance, CrystalVisualBOracle :-)

Hi there. I am fairly new to Java and I'm in the middle of creating my first program. I've already completed a lot of it but I'm having trouble figuring out how to design one particular peice. In my program there is a user say "Dave" and a bunch of "Groups" that Dave can...

Hi there. I in the midst of my first jsp application and I'd like a little advice on the scenario I'm facing. In my program I have a user say, "DAVE". I also have a large number of groups that "DAVE" can belong to. (The number of groups changes on daily.) I have to...

Hi there. I have a form which lists a bunch of user data. The username and userid need to appear but must not be altered by the user. All of the other data in the form is editable. All of the fields are then supposed to be sent to the next UpdateUser.jsp page. Unfortunately, the username and...

I'm trying to loop through a vector, detokenize it's results and display them in a drop down list box on my jsp page. Unfortunately, it doesn't seem to be looping correctly. My list box displays empty. Does anyone see what I'm doing wrong? I'm new to Vectors so it may be something simple...

I have a program that's currently designed as follows UserData.class - contains the following method Public Hashtable Get_Companies(){selects every company name and company id from Companies table alphabetically by company name Puts resultset into a hashtable. Then returns the hashtable.}...