Search results for query: *

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

ok it did not work. I tried a couple of different things this code below does convert correctly. cdatetime({PDL_TASK_VIEW.FCREATIONTIME}) But when I try to use it with cdatetime{PDL_TASK_VIEW.FCREATIONTIME} >= datetime(year(currentdate),month(currentdate),day(currentdate),5,45,0) Any more...

ok here is the exact format 29-Jan-2003 04:51:05 that is the {PDL_TASK_VIEW.FCREATIONTIME}

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)...

I'm sorry you really went over my head on that, I'm new to Crystal so please be gentle. the PDL_TASK_VIEW.FCREATIONTIME is a string value. so I'm woundering if I can convert this to a datetime value then try and use my original code ?? {PDL_TASK_VIEW.FCREATIONTIME} >=...

Ok, Then how would the correct format of the code Look. Thanks in Advance