Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ja01
  • Content: Threads
  • Order by date
  1. ja01

    showing different instances of the same data horizontally

    Let's say I have a table called d_gift. The table includes the following fields: d_giftkey, d_giftdate, d_gifttype and d_giftamount. A person can make multiple gift transactions which means the data would show vertically based on the number of transactions. Is there a way syntax wise to set...
  2. ja01

    Problem combining date fields into a created field

    I have a created field in Access called Birthdate(text)which is blank. I want to pulled 3 fields, birthm(text) birthd(text) and birthyr(text) into the created field called Birthdate. The display should read MMDDYYYY (ie 09112007). In the query section in Access, must I do an update query and...
  3. ja01

    Grouping Issue

    Using Crystal9 to create a report that requires a specific grouping. I want to display some data as follows: On detail Line A dbo.Prospect_name On Detail Line B dbo.Leader_name On detail Line C dbo.Campaign_Value Here is an example: John Smith (dbo.Prospect_name) Ed Smith...
  4. ja01

    Date Issue - Wierd!!!!!

    Here is the SAS program I wrote to display a userid and the count of the userid: proc sql; create table address1 as select addruserid, count(addruserid) as addrCount from my.address where addrdate between '26-feb-2007'd and '31-mar-2007'd group by addruserid; run; Everything works okay except...
  5. ja01

    Displaying Data in Crystal

    I am using crystal 8.5 (have access to cr 9 and 10). Here is a description of a report I am trying to do: Name Name Type John Smith preferred John L Smith formal Address Address Type 1313 S Street Miami Fl Preferred 125 T Street Washington Former...
  6. ja01

    SQL Displaying of Data Horizontally

    Using MS SQL Server 2005, I want to display instances of data horizontally. For example if I choose select membid, membtype from membership where membid = '0001' I would get 0001 c2 (0001=membid, c2=membtype) 0001 c3 (0001=membid, c3=membtype) Is there a way to set up an sql statement to...
  7. ja01

    Cross Tab Question

    I have an sql table called GENERIC. It has a SORTNAME field. Here is an example of data SMITH/JOHN. It also has a NAME field. Here is an example Mr. John SMith. In my cross tab I have a formula, GENERIC+''+Name. This is the only way I know how to alphabetize the name. As we know the...
  8. ja01

    Parsing Help

    In a sas.log file I have the following: smith (data type is text or $) 2006-03-02:00:00:00 (data type is date time) my report (data type is text or $) The log file lists everything vertical or 1 line for each entry Issue#1 : I need to parse the data into sas and create a table that looks like...
  9. ja01

    Parsing sas.log data to create a sas table

    In a sas.log file I have the following: smith (data type is text or $) 2006-03-02:00:00:00 (data type is date time) my report (data type is text or $) The log file lists everything vertical or 1 line for each entry Issue#1 : I need to parse the data into sas and create a table that looks like...
  10. ja01

    Displaying multiple line data on the same line

    Is there any way to display multiple lines of data (which display vertically by default) in a horizontal or side by side way on a crystal side. I tried doing this on the front end or in the sql table that crystal pulls data into but that does not work. For example if a person has 1 degree a...
  11. ja01

    Showing multiple lines of data on same line

    Here is my situation. I have a script select schoollookup, degree, schoolname from school left outer join degrees degr where degr.table_code=degree Output: If a person has 2 degrees, the first degree will be schoollookup 1 and the second will be schoollookup2. They will display veritically...
  12. ja01

    Running a report automatically in SAS

    I have a report that creates a work table as follows proc sql; create table address as select addrdate,addruserid from d.address where addrdate >= '05-feb-2007'd order by addruserid; quit; 1. Is there a way to have SAS run this report automatically at 4:00PM each day everyday and put it in the...
  13. ja01

    Applying triggers to sinple sql queries

    I have the following update query in SQL update dbo.core set birthyr = Year(BirthD), brthmn = Month(BirthD), brthdy = Day(BirthD) Now my boss wants me to turn off triggers while this update query is excecuting then turn it back on. I have not used triggers prevously but I...
  14. ja01

    Timed Auto Development

    Here is my situation: I use an sql table called userlist. I bring the table into MS Access and create a make_table everyday and it is done manually. Does anyone know a way to automatically invoke either sql enterprise manager or ms access thorugh a macro to automatically produce a simple...
  15. ja01

    update query using Birthdays. Microsoft SQL Server 2000

    I ran a query to show an id and birthday as follows: select id,birthd,brthyr,brthmn,brthdy from dbo.core where id= '0000000' The results are id=00000000, birthd=1877-01-01, birthyr=null, brthmn=null and brthdy=null I want to take the birthd and populate it into the three null tables. Thus I...
  16. ja01

    Grouping in Crystal 10

    I have a report that must use the same group throughout the report. I am repeating the group by selecting insert section below. Each group insert includes a different set of subreports. Here is my question. Is there a way to uniquely name each group section so that I use the Keep group...
  17. ja01

    One Group Using Crystal 10 - End of Page Issue

    I am using one group due to use of several subreports. I repeat the group (we will call it coreID group) Here is a sketch: Group1a:coreid Name Group1b:coreid Address Group1c:coreid Employment In this example the employment may actually continue on the next page. Since I am using only 1...
  18. ja01

    ODBC Connection using SQL server

    I attempted to add a system DSN ODBC connection. This connection requires an SQL login and password. I successfully added ODBC connections to several other computers. For some reason, this one will not accept the ODBC. Once I get past the login and password area and click okay, I get a login...
  19. ja01

    Search Results Listing

    I used search results and typed in .mdb to locate all access files on my drive. It lists the following fields: Name and In Folder. Here is my question. Is there a way to generate a list from the search location without doing a print screen??
  20. ja01

    Date Parameter with a Crystal Report

    This is a combination crystal and SQL issue: I created a VIEW in enterprise manager to capture a payment based on date and type. Here it is SELECT giftkey, giftid, gifteffdat, giftamount, giftplgkey, gifttype, giftclass2, giftclass1, giftacctgp FROM dbo.gifts WHERE (giftclass2...

Part and Inventory Search

Back
Top