There is an acct period table but it shows every accting period since we went on the system. I could use the year field to narrow it down to the correct year and it has a field for the period of 1 to 12 with the beginning and ending dates for each period.
Here is sort of how I want it to look...
Hopefully I can explain this. I want to be able to create a report that has a beginning and ending balance by vendor where it would show the beginning balance - checks + invoices = ending balance. The problem I have is that there are two date ranges: The beginning would be 10/1/06 to 10/28/06...
It is only the subreport and sometimes it's there and sometimes it's not. It's just not there. The subreport has a label and even it doesn't show, but on some printers it's there. I'm not sure if it has anything to do with fonts. I'm using times new roman.
I have a report that was created in CR 9. This report has a subreport in it. I can send this report to different printers and on some the subreport prints and on other printers it doesn't. Has anyone else had this problem? If so, how did you fix it?
I'm sorry. I'm lost. The id number will come from the requirements table. I'm not sure how to do this. There will be more than 4 cards that was just an example. Sorry if I'm fustrating you.
Lori
I need some help. I have an erp system that I want to write a report in crystal. I need to create a report for a workorder. A workorder will have main header cards that have an ID number. Behind each of the header cards could be another set of header cards with ID numbers. For example...
Well, I really hadn't thought about it always being current year so anything to make it simpler would be appreciated.
Turkbear:
I want all customers in current and only the 1 specific customer is the month of december.
Let's see if I can explain this. I have a COS report that I need to get data for the current year and the month of December. I've figured out that formula by using DateAdd to my start date parameter. But now comes the hard part. I also need it to show me info for all customers in the current...
kskid,
I created the first formula and put it in the header but the other formula kept giving me an error when I tried to create it. It told me the rest of the text was right. What am I doing wrong?
Madawc,
Ok the group summary is working but the running total is close. When I do the...
Ok guys, I need some help. I have a report that reports on our weekly incoming orders for the year. Here is my problem. Let's say that week 1 had a total of 49 order and week 2 had a total of 25 orders. For week 1 the cumulative would be 49 and week 2 cumulative would be 74 which is 49 + 25...
Does anyone know if you can have a summary total of a parameter? If so, can someone please explain to me how to do it? I have a number parameter that I enter and I need it to be totaled at the end of the report.
I want to be able to show only the last 2 years of info in my database. I know I can go into the query and tell it to show only >=2003 but I need to make it automated so that I don't have to change it every year. Does anyone of a formula that I can use that will do this?
Lori
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.