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 Rhinorhino 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: sxmnl
  • Content: Threads
  • Order by date
  1. sxmnl

    getting data from two tables into a report

    Hi, I'm sure this is easy for someone.. I'm trying to create a report for a affiliate from my web site. He would like a monthly report to show what products he sold from his site. I have two tables that this data resides on. 1) tblorderdetails 2) tblorders in the tblorders there is a field...
  2. sxmnl

    Affiliate Program Question (Links & Cookies )

    Hi, I'm the owner of a website Magazine-Land that has a built in affiliate program, this just brings them to the site and creates a cookie to remember who they are while they are there to give the affiliate credit for any purchases. I have a customer that would like his link to go directly to a...
  3. sxmnl

    Affiliate Program Direct Link to a Product

    The affiliate program just brings them to the site and creates a cookie to remember who they are while they are there to give the affiliate credit for any purchases. They would need to follow the normal affiliate link to the site, then paste the direct link into the URL location to go directly...
  4. sxmnl

    RE:POST Urgent Please Help

    Hi, I have a main report that has a StartTime and EndTime I have shared these variables to my subReport. To use as a start time and end time in my line chart. Both {@StartTime} and @EndTime are a datetime variable. This is my code below. I keep getting a error that it need a date...
  5. sxmnl

    Using a SharedVar in a dateTime function

    Hi, I have a main report that has a StartTime and EndTime I have shared these variables to my subReport. To use as a start time and end time in my line chart. Both {@StartTime} and @EndTime are a datetime variable. This is my code below. I keep getting a error that it need a date Help Please...
  6. sxmnl

    Case Statement for Crystal / Shared Variables/batch

    This is a tough one for me being I've only worked with crystal for 5 weeks. I have 18 reactor's and I'm trying to show a profile of each reactor with a line chart that would consist of 4 tags. I have the chart working with four tags. Example I want to share Tag1, Tag2, Tag3 & tag4 each tag let...
  7. sxmnl

    Help with Charts/plotting raw values

    I'm new to Crystal so be gentle. I'm trying to plot 4 variables on one chart, these variables come from the same table over a period of time . I pull the data in fine. But when I chart it. It only showes one continues line for all four variables. I would like it to show four seperate lines and...
  8. sxmnl

    Charting - Main report/subreports

    I am attempting to use a main report with 3 subreports. Each subreport contains rows of data in the form of time,datavalue. In the main report I'd like to plot each of the data sets as a separate data series (in other words 3 traces where each trace represents a data series from one of the...
  9. sxmnl

    Converting string to dateTime

    Thanks In Advance I have a program that runs some math at 05:55:am every day. But I want to grab the new values for that day only, and add to a report for that day. My code looks like this {PDL_TASK_VIEW.FCREATIONTIME} >= datetime(year(currentdate),month(currentdate),day(currentdate),5,45,0)...
  10. sxmnl

    ? what ERROR Means

    Ok I'm getting a error !A date-time is required here and I'm not sure why ? any clues my code looks like this {PDL_TASK_VIEW.FCREATIONTIME} >= datetime(year(currentdate),month(currentdate),day(currentdate),5,45,0) I have a program that runs some math at 05:55:am every day. But I want to grab...
  11. sxmnl

    String coversion to Numeric then Back to sSring

    I'm New to crystal, I'm so close now, I need just a little more help. my table looks like this Variable Name Value ------------- ----- Catalyst 1 Amt 1 Antifoulant Charged 0 Antifoulant Start Time 12/31/1979 Batch Cycle Elapsed...
  12. sxmnl

    String conversion to NumericText {batch}

    I need some help. I'm new to Cystal. I have a table called {PDL_VARIABLE_VIEW.VARIABLENAME} this table has 100 names in it. I have another table called {PDL_VARIABLE_VIEW.VARIABLEVALUE}this is a string table. inside the {PDL_VARIABLE_VIEW.VARIABLEVALUE}I have dates & Numbers In the same table...
  13. sxmnl

    selecting only certian variables under one table with multiable names

    I'm new to crystal so be gentle. I have a table called VARIABLE_NAME, and another called Variable_Value. This is a batch process report. all the variables reside under the VARIABLE_NAME table. I have certian Variable_Value's then come threw in a msec time. I need to convert them to hour's IE...
  14. sxmnl

    Multiple time functions on the same day ???

    My report runs every day @ 7:am. I need to go back in time -24 hrs and just grab the times 7:am, 13:00, 1900: 01:00 and the data associated with those times ????? I have tried the help but thats why I'm here. Any help would be great. Thanks

Part and Inventory Search

Back
Top