Search results for query: *

Thank you LB, Oh thank you! :D I shall try this out shortly & let you know if it succeeds (crossing fingers). Sincerely, Myla

Hello, I am using Crystal Ver 9.2.2.693 & my information that I am making reports for is a SQL Database. I created several reports that show all issues on our many routes. This report shows current year issues (i.e. damaged product, ticket not signed, etc..) and this report also shows prior...

Hello JoyCR9, Thanks to Synaspevampire's help in a post I had similar to yours with strange date ranges I was able to do this with his help and get the date ranges I needed based on strange date ranges: You can create a range parameter to select beginning and ending dates and then in the...

Crystal Verion 9.0 - SQL Server 2000 Good Morning, I am working on a report that I need to show product sold for each week (Saturday to Sunday). I am alittle confused on how to use date formula's. I am working with {tblinvoicedate.Invoice}, {totalQty.Invoice}. I have grouped the bakeries...

Good Morning, Thank you Synapsevampire, seeing what you wrote has let me see that I have been approaching my problem in a totally incorrect manner. I shall try what you have suggested and see how it works. Here is what I have thus far on my report since I did not show all the information...

Crystal Version 9.0 & SQL Server 2000 Good Afternoon, I have posted this before and did not explain this right, hopefully this time someone can help, ahhhh! I need to show QTR and YTD information on my report, based on the Parameter date that is selected. My parameter is based on the...

Good Morning, I am using Crystal Reports version 9 and SQL Server 2000 I need to get the QTD and YTD information for my report. I have set up a parameter that reads the Week Ending Date (Saturday's Date )from {tbl.manufacturedbudget.EndDate} and it is working great for retrieving the...

Good Morning, I have tried to use the parameter in the Qtr & YTD and for some reason it gives me the wrong information, so I do not understand what I am doing wrong. Also thanks for putting that site link on your post, I went there and wrote the person in Texas for on-site training as my...

Hello dgillz, I see what you are talking about. I am sorry, when I created the Week Ending formula, I used 2 formulas. One I created but did not place on the sheet: if {tblBudgetManufactured.EndDate} = {?WE Date} and {tblCompany.CompanyName} = {?Bakery} then...

Hello dgillz, No I want it the formula to show how many manufactured buns were created each quarter based on the parameter Week Ending Date (WE Date) that the user selects. Are week ending date (which is a Saturday date) is used in our Manufactured Dozens Database in our Sales System...

Good Afternoon, I am using Crystal Version 9 and SQL Server 2000 (Sales Database). I have created a Dz Mfg report and I am having a problem with the calender1stqtr (actually all quarters). The amount returned is not correct, so I am using this formula incorrectly or doing the wrong formula to...

Hello and Thanks, I tried your formula, but it keeps showing an error on THEN maybe I am supposed to type something else? It keeps highlighting Then and saying "the ) is missing. I am confused. It did this same error message when I tried different variations of using the IsNull, this is...

Good Afternoon, I am using Crystal Report 9 and MS SQL Database. I am creating an Incident report that has these fields (manual cross-tab): 2004 2003 +/- Variance +/- Percent Del Issues 55 55 Damage 78 22 56 Arrival...

Thank you pgtek, I shall read up on linking parameters. I have not done that yet,ahhhh (this is making me insane, hahaha). Thank you Synaspvampire and I shall remember in the future to post what version, etc. Have a great day and thanks for all your help. Sincerely, Myla

Crystal Reports 9, SQL Database I have to have the same information shown again because one section is for manufactured dozens of buns: WE 4/3 WE 3/27 QTD YTD REG 52,500 25,400 77,900 105,500 QTR ETC ETC Second group (or...

Thanks. When I create a sub-report, would the parameter from the 1st report affect the sub-report? Or can I create a parameter field for the sub-report as well? Sincerely, Myla

Hello, When you want to add a second group, with the same product does it always show up right underneath your first group? Example 1st Group Reg 2nd Group Reg 1st Group Qtr 2nd Group Qtr I wanted to add another group but not directly underneath the first group. I wanted it to look like...

Thank you Ibass, you have helped me immensley and your formulas worked like a charm. I was showing zero because the date field also including a time in the SQL Database, so I used your formula but changed the in {?WEDate} to = {?WEDate} and it worked! :D I also did the formula you suggested...

Crystal Reports 9 Using an SQL server type database I created two parameters for Week Ending Date and Bakery Name, which thanks to Synaspe & Ibass I was able to get it to work. Then I place the WE Date in the Page Header and created 3 formulas using {?WE Date}-7, etc to change the dates in...

I want to learn as much as I can and how to work on Crystal Formulas and SQL formulas to use in Crystal. Thank you for all your help. I really appreciate it. Have an awesome day today. Sincerely, Myla