Hi, thanks for the response.
The problem with those is that they throw an error when it gets to a record that actually has a letter included. I need to restrict the where clause to only apply to records that are numeric
I have a field that I need to remove a certain range of numbers from, however, this field is VARCHAR2 and can contain letters.
My current code is as follows (in the Where clause): field.field_name not between '27000000' and '27999999'
The problem is this is also taking out records that are not...
Hi gmmastros,
My apologies, I am in fact using Oracle SQL.
Letters still need to be in some of the records of the field, so it does need to remain a text field.
I will try the convert function that you advised.
Thanks
Hello,
I have a field that I need to remove a certain range of numbers from, however, this field is VARCHAR2 and can contain letters.
My current code is as follows (in the Where clause): field.field_name not between '27000000' and '27999999'
The problem is this is also taking out records that...
Thanks for the response. I might be able to have our IT department set something up to automatically make a copy and save it on our server once a night or something like that.
I was just curious if there is any way to get around having to do this
I am trying to use an Excel table as an ODBC connection but I am having trouble adding the datasource in Crystal and I am getting an error saying "Logon Failed, Details: HY000 The Microsoft Jet database enginer cannot open the file '(unknown)'. It is already opened exclusively by another user...
I have a report where I need to include the first two records that appear in the detail section, in the group header. I know that the first record of the detail section will be shown if placed in the group header, however I am looking for an easy way to have this record and the very next one...
Lbass,
Thank you again, this worked well.
I also trying to place a pie chart on the report showing this sum we just came up with on change of Line.
The formula doesn't show up when I go to the advanced portion of the pie chart creator, is there something else I need to do to be able to graph...
Lbass,
I now need to sum up my averages for each family so I can see my totals under each line(the first group of the report).
I am again having a similar problem as I was before with the field not able to summarize but I am unsure how to apply your previous post to this.
Hello,
I am creating a report that pulls in products that are forecasted by our customers. The way my report works is the user inputs an end date, and the report goes out and pulls in all of the products that are forecasted up to that date.
On my report I display Part Number, Part...
^ In regards to my post above I meant to say I was using a "For all records" type pie chart like you recommended.
Since posting I have also created formulas to calculate the time spent on each task on a per line basis, so this way I can effectively use the sum function under the pie chart...
lbass,
I have tried doing what you stated above but when I add even just a few of my @DaysNPM and @DaysCPM formulas under a pie chart that is set "For each record", I end up just getting and blank pie chart with "0" as my value shaded all in blue.
Here are exactly how my formulas calculate as...
Currently I have it set up like this exactly:
On Change of (named @chartformula):
If {@Change Type Trim}="NPR" then "NPR" else if
{@Change Type Trim}="CPM" then "CPM" else if
{@Change Type Trim}="NPM" then "NPM" else if
{@Change Type Trim}="CPR" then "CPR"
Else "Misc"
{@Change Type...
Thank you lbass for your help on this.
I'm a bit confused from your last post. What do I need to sub in for the 'ship date', 'order date'?
I'm not sure if I am completely understanding the command that you have written.
I don't think I'm seeing how this incorporates all of my different tasks?
The constant is the Total available workdays between two user specified dates. To calculate "Misc" I do what you said above and subtract this from the sum of the other values.
My "on change of" formula is: (Ill call it "OCO" for later:
If {TASK}="A" then "A" else if
{TASK}="B" then "B" else if
{TASK}="C" then "C" else if
{TASK}="D" then "D"
Else "Misc"
My show value formula is:
If {OCO}="A" then {TASK A Formula} else if
{OCO}="B" then {TASK B Formula}else if...
I am looking to make a pie chart that shows workload percentage by task, and if all the available time is not being allocated to these 4 specific tasks, I want the remaining portion of my pie chart to display an "unused time" percentage.
I currently have my pie chart breaking down each task but...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.