RE:POST Urgent Please Help 1

[sxmnl]

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


{NUMERICLOG.TIMESTAMP} in DateTime ({@StartTime}) to
DateTime ({@EndTime})

More Info Below

{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 will provide it.This is Killing me

 

[lyanch]

You can't use shared variables as selection parameters for subreports. See thread149-487420 I just answered a similar questions.

Lisa

 

[sxmnl]

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 then delet my selection {NUMERICLOG.TIMESTAMP} I have another formula called Time in my chart for the (on change of) portion of the chart. that is time({NUMERICLOG.TIMESTAMP}) so I thought if I got the formula corect then I would insert in place of time({New Formula})

now I may be way off on this, I have only been working with crystal for 5 weeks

I see in the selection parameters you can right a formula

Any Help Is appreciated

Thanks in Advance

 

[lyanch]

Link the formulas (outputing what ever value you are currently assigning to the shared variables) to parameters in the subreport (you don't *have* to use parameters as selection criteria). Then, use the parameters in the formula where you are using the shared variables now.

Lisa

 

[sxmnl]

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

 

[lyanch]

In your subreport, create two parameter fields (they look like {?StartTime}) for your variables.

In the main report create two formulas @StartTime and @EndTime that have the output value that you were previously placing in the shared variables.

Right click on the sub report and select "change subreport links". Select the first formula, uncheck the box that says "Select data in the reportt...", in the drop down that says "Subreport parameter to use" scroll until you find the associated parameter (the scroll bars are REALLY tiny).

Do the same with the second formula.

Now use the parameter fields in the subreport in your formulas.


Lisa

 

[sxmnl]

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 the third sub ??

That is whats next

Thanks Again
Lee