Search results for query: *

using fp2003. I have dataform.asp secured so that if clicked the user is prompted to login.asp. Once logged in, I would like to direct them to the dataform.htm form page to fill in the information. Can anyone tell me how to redirect them to the dataform.htm page after they successfully log...

Thank you both, dgillz and lbass so much. This is exactly what I needed! KayKay

I just read what I wrote and realize that it makes no sense, sorry. What I meant to ask is: If {table.purchdate} <=10 (ex.01/02/05) how do I get the due date to be 01/10/05? Thanks again

I think that this will work just fine. If I do want the next month would I need to check the purchase and do something like this? if day({table.purchdate})<=10 then dateadd("m",2,{table.purchdate}-day({table.purchdate})+10) KayKay

sql2k cr9 I need to be able to find the 10th of the month following the purchase date (supplied from table). Is there a simple formula for this? Please help KayKay

Thanks LB, I actually already had multiple page headers a through d and I added page e with your suggestions. I applied the formatting to all above page headers (above the new page e header). I have tried the suggestions and I am having a hard time setting the format size for only the new...

using cr9 sql db I am printing invoices and need to print terms and conditions on the back page of each page (using a printer with duplexing capabilities). Should I use a subreport for the Term and Conditions page or can I create another group and force it (somehow) to print every other page...

HELP! cr9 Sql Server stored procedure We have a manual cross tab report in which we have conditional formula's for each 7 columns (Sat, sun, mon,etc) We are retrieving the data from the stored proc correctly but cannot display it properly. We would like the data in the same week to appear in...

I did create a group for both month and part. I figured out how to do this now. I basicaly created the same formulas for the part# that I did for the Month footer, It is not pretty but I get the reaults that I need. Thanks for your replys. Karen

My results are displayed like: % ONTIME # ONTIME TOTAL # LATE % LATE August 2003 83.7% 4093 4889 796 16.3% PartA 13.2% ### ### ## ??.?% September 2003 77.6% 4029 5189...

I am using cr9,SqlServer I have 2 tables InvInfo Part# PartDescr OrdHistory Ord# Part# RqstDate ShipDate This is how it looks now with 1 group: % ONTIME # ONTIME TOTAL # LATE % LATE August 2003 83.7% 4093 4889 796 16.3%...

I am trying to create an exception report and have had no luck so far. I have two tables Count1 and Count2(Inventory entries counted twice for accuracy). I want to compare Count1 with Count2 and report ONLY the exceptions. The fields in each record which could have different entries include...

I currently use Crystal Info. I guess I can write a vb application to check for each new customer, I was hoping there was an &quot;easier&quot; way. Thanks

Using cr.ver 7 . Daily I print order confirmations for each customer as one report and fax them to each customer one at a time. To save money I would like to email the reports, I can email them one at a time, Is there a way to email them to their address automatically? I have included their...

I cannot open this table or run reports with this table. I get the following error message: [Pervasive][Pervasive ODBC Client Interface][PervasiveLNA][Pervasive][ODBC Engine Interface]Invalid date, time or timestamp value. (#0) I have tried to rebuild the table in Access but all i can do is...