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!

Recent content by sxmnl

  1. sxmnl

    getting data from two tables into a report

    Thanks, I have a question. This will not join the tables will it ? I really just want to preform this query once a month with out effecting the tables. If I can get the query correct then I can do the same with customers and what product they purchased. Also I'm new to the website sql can you...
  2. 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...
  3. sxmnl

    Affiliate Program Direct Link to a Product

    Hi Chris, I'm the owner of the website www.Magazine-Land.com 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...
  4. 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...
  5. 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...
  6. sxmnl

    RE:POST Urgent Please Help

    Lisa if I wasn't married and you where here. I'd give ya KISS Thanks I learned somthing I never new how to Link formulas. Know I'm 92% done with this one. Tomorrow a new fight. I think I can use this again. But before I leave. If I have Two sub-reports can I pass this from the 2nd sub too...
  7. sxmnl

    RE:POST Urgent Please Help

    Thanks again, Can you explane the part link the formulas to the subreport I tried to creat a parameter called @StartTime and one Called @EndTime and i left everything else blank. well my chart was plank also. Is that what you meant for the link? Thanks Again for helping Lee
  8. sxmnl

    RE:POST Urgent Please Help

    Lisa thanks, ya that is a fellow employee from the company I work for. He is at the office trying to help me with this problem. I'm on site doing some work for a customer. I understand your statement..about selection parameters for subreports. The idea i'm trying to do is right the formula...
  9. 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...
  10. sxmnl

    Using a SharedVar in a dateTime function

    thanks for the response. {NUMERICLOG.TIMESTAMP}=(DateTime)value so does the @StartTime and @EndTime that is what it shows. This is the Format I recieve on my SharedVar shared datetimevar End = 2/25/2003 9:35:53PM shared datetimevar Start = 2/25/2003 2:50:33PM If you need more Info. I...
  11. 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...
  12. sxmnl

    Case Statement for Crystal / Shared Variables/batch

    First off thanks for the response. I decided to break this down to individual tasks. so right know I'm trying to see if I can pass variables to a chart fist. if {?Reactor Number}=1 then {@II524}= 'Control Modules/II524_01:Linl.PV,IM02_1m_3yrs' else if {?Reactor Number}=2 then {@II524}= 'Control...
  13. 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...
  14. 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...
  15. 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...
See more

Part and Inventory Search

Back
Top