Hi. I am new to Crystal Reports going thru VB.Net 2005/MS-SQL. I have hit a wall in trying to build a report and could use some help.
I have to build a report that captures sales processed thru 9 sites. The sales need to be reported for each site divided by the month they were completed in.
I tried this --- ({caselog.case_district}="1") and (Month ({caselog.case_rptdate})=1) --- but when put in the report, all I got was a the word False next to the site number and then the site number repeated and a "False" appeared next to the site number, and so for each record in the table. Not good...
What I'm looking for is this.....
Unit Jan Feb Mar Apr .... YTD
1 15 24 11 17 67
2 24 11 35 5 75
3 15 19 10 21 65
4 21 31 11 12 75
...
Someone else mentioned something about "running totals", but I couldn't find that anywhere in the Formula Builder. Can somebody point me in the right direction? Any help would be greatly appreciated.... Thanks....