# Anyone on here know Crystal Reports? **URL:** \ **Category:** Shift518 Off Topic\ **Created:** [June 9, 2008, 11:50am UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245 "2008-06-09T11:50:16Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![SlackJ94](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/slackj94/32/6325_2.png) [@SlackJ94](https://forums.speedlife.net/u/SlackJ94)\ **Post date:** [June 9, 2008, 11:50am UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/1 "2008-06-09T11:50:16Z")
I know a few of you are in the computing/software field like I am. Do any of you have experience with Crystal Reports? The specific problem is that I need to get a week of dates (Sun-Sat) from one date (that can be any day of the week). Any help is appreciated, thanks. ---
**Author:** ![Wayne64SS](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/wayne64ss/32/6365_2.png) [@Wayne64SS](https://forums.speedlife.net/u/Wayne64SS)\ **Post date:** [June 9, 2008, 12:16pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/2 "2008-06-09T12:16:22Z")
Granmassax is the elite crystal reports whoooooooooooooooore ;D ---
**Author:** ![GranMassaX](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/granmassax/32/6299_2.png) [@GranMassaX](https://forums.speedlife.net/u/GranMassaX)\ **Post date:** [June 9, 2008, 12:17pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/3 "2008-06-09T12:17:54Z")
I’m a crystal/sql programmer… ;D I have a DATE table that gives me all that good stuff so I don’t have to calculate it. There is probably an easier way to do it, but this does work. forumla “week start”: if (DayOfWeek ({?DATE})) = 1 then {?DATE} - 0 else if (DayOfWeek ({?DATE})) = 2 then {?DATE} - 1 else if (DayOfWeek ({?DATE})) = 3 then {?DATE} - 2 else if (DayOfWeek ({?DATE})) = 4 then {?DATE} - 3 else if (DayOfWeek ({?DATE})) = 5 then {?DATE} - 4 else if (DayOfWeek ({?DATE})) = 6 then {?DATE} - 5 else if (DayOfWeek ({?DATE})) = 7 then {?DATE} - 6 formula “week end”: if (DayOfWeek ({?DATE})) = 1 then {?DATE} + 6 else if (DayOfWeek ({?DATE})) = 2 then {?DATE} + 5 else if (DayOfWeek ({?DATE})) = 3 then {?DATE} + 4 else if (DayOfWeek ({?DATE})) = 4 then {?DATE} + 3 else if (DayOfWeek ({?DATE})) = 5 then {?DATE} + 2 else if (DayOfWeek ({?DATE})) = 6 then {?DATE} + 1 else if (DayOfWeek ({?DATE})) = 7 then {?DATE} + 0 things may get messed up depending on how your dates are formatted, but give it a try. ---
**Author:** ![Shawn96VR-4](https://avatars.discourse-cdn.com/v4/letter/s/eada6e/32.png) [@Shawn96VR-4](https://forums.speedlife.net/u/Shawn96VR-4)\ **Post date:** [June 9, 2008, 12:25pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/4 "2008-06-09T12:25:54Z")
I’d kill myself if I did Crystal all day. ---
**Author:** ![GranMassaX](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/granmassax/32/6299_2.png) [@GranMassaX](https://forums.speedlife.net/u/GranMassaX)\ **Post date:** [June 9, 2008, 12:28pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/5 "2008-06-09T12:28:11Z")
I’d kill myself if I did any one thing all day ---
**Author:** ![Shawn96VR-4](https://avatars.discourse-cdn.com/v4/letter/s/eada6e/32.png) [@Shawn96VR-4](https://forums.speedlife.net/u/Shawn96VR-4)\ **Post date:** [June 9, 2008, 12:28pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/6 "2008-06-09T12:28:45Z")
> [@GranMassaX](#): > > I’d kill myself if I did any one thing all day Some h0t slut? You are ze ghey. ---
**Author:** ![GranMassaX](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/granmassax/32/6299_2.png) [@GranMassaX](https://forums.speedlife.net/u/GranMassaX)\ **Post date:** [June 9, 2008, 12:29pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/7 "2008-06-09T12:29:38Z")
> [@Shawn96VR-4](#): > > Some h0t slut? You are ze ghey. too much of a good thing can be bad… i think… or so they say…f u! ---
**Author:** ![SlackJ94](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/slackj94/32/6325_2.png) [@SlackJ94](https://forums.speedlife.net/u/SlackJ94)\ **Post date:** [June 9, 2008, 12:33pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/8 "2008-06-09T12:33:12Z")
> [@GranMassaX](#): > > I’m a crystal/sql programmer… ;D > > I have a DATE table that gives me all that good stuff so I don’t have to calculate it. > > There is probably an easier way to do it, but this does work. > > forumla “week start”: > if (DayOfWeek ({?DATE})) = 1 then {?DATE} - 0 > else if (DayOfWeek ({?DATE})) = 2 then {?DATE} - 1 > else if (DayOfWeek ({?DATE})) = 3 then {?DATE} - 2 > else if (DayOfWeek ({?DATE})) = 4 then {?DATE} - 3 > else if (DayOfWeek ({?DATE})) = 5 then {?DATE} - 4 > else if (DayOfWeek ({?DATE})) = 6 then {?DATE} - 5 > else if (DayOfWeek ({?DATE})) = 7 then {?DATE} - 6 > > formula “week end”: > if (DayOfWeek ({?DATE})) = 1 then {?DATE} + 6 > else if (DayOfWeek ({?DATE})) = 2 then {?DATE} + 5 > else if (DayOfWeek ({?DATE})) = 3 then {?DATE} + 4 > else if (DayOfWeek ({?DATE})) = 4 then {?DATE} + 3 > else if (DayOfWeek ({?DATE})) = 5 then {?DATE} + 2 > else if (DayOfWeek ({?DATE})) = 6 then {?DATE} + 1 > else if (DayOfWeek ({?DATE})) = 7 then {?DATE} + 0 > > things may get messed up depending on how your dates are formatted, but give it a try. You are my hero. My boss loves you too. I’m ussually doing web/app programming but we’re in a time crunk so web is put on the back burner over Crystal…and I hate it. Don’t go too far, I’m bound to have another question. I jumped into crystal only 2 days ago. ---
**Author:** ![Shawn96VR-4](https://avatars.discourse-cdn.com/v4/letter/s/eada6e/32.png) [@Shawn96VR-4](https://forums.speedlife.net/u/Shawn96VR-4)\ **Post date:** [June 9, 2008, 12:34pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/9 "2008-06-09T12:34:13Z")
> [@SlackJ94](#): > > You are my hero. My boss loves you too. > > I’m ussually doing web/app programming but we’re in a time crunk so web is put on the back burner over Crystal…and I hate it. > > Don’t go too far, I’m bound to have another question. I jumped into crystal only 2 days ago. Hope ya enjoy the Crystal licensing. ---
**Author:** ![GranMassaX](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/granmassax/32/6299_2.png) [@GranMassaX](https://forums.speedlife.net/u/GranMassaX)\ **Post date:** [June 9, 2008, 12:35pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/10 "2008-06-09T12:35:37Z")
dont hate on crystal. It’s a hell of a tool for pulling data/reports together. Pair it together with some nice stored procedures and its extremely efficient. ---
**Author:** ![Shawn96VR-4](https://avatars.discourse-cdn.com/v4/letter/s/eada6e/32.png) [@Shawn96VR-4](https://forums.speedlife.net/u/Shawn96VR-4)\ **Post date:** [June 9, 2008, 12:36pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/11 "2008-06-09T12:36:39Z")
> [@GranMassaX](#): > > dont hate on crystal. It’s a hell of a tool for pulling data/reports together. Pair it together with some nice stored procedures and its extremely efficient. It’s fantastic. The licensing is not. A lot of my clients are pushing towards MS Reporting. ---
**Author:** ![GranMassaX](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/granmassax/32/6299_2.png) [@GranMassaX](https://forums.speedlife.net/u/GranMassaX)\ **Post date:** [June 9, 2008, 12:37pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/12 "2008-06-09T12:37:02Z")
> [@SlackJ94](#): > > Don’t go too far, I’m bound to have another question. I jumped into crystal only 2 days ago. I leave work in half an hour ;D ---
**Author:** ![SlackJ94](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/slackj94/32/6325_2.png) [@SlackJ94](https://forums.speedlife.net/u/SlackJ94)\ **Post date:** [June 9, 2008, 12:39pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/13 "2008-06-09T12:39:21Z")
> [@Shawn96VR-4](#): > > Hope ya enjoy the Crystal licensing. I don’t deal with that, managment does. > [@GranMassaX](#): > > I leave work in half an hour ;D Damn, oh well, I’ll leave questions for tomorrow then. :lol I hate crystal so far for one reason. I can’t just write SQL and plug it in. I wouldn’t mind if I had to make sure column names etc matched up perfectly and what not. I know exactly how to do all the reports I need to do in SQL…but can’t do diddly in Crystal. Its so idiot proof that its expert proof. ---
**Author:** ![GranMassaX](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/granmassax/32/6299_2.png) [@GranMassaX](https://forums.speedlife.net/u/GranMassaX)\ **Post date:** [June 9, 2008, 12:41pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/14 "2008-06-09T12:41:57Z")
> [@SlackJ94](#): > > I hate crystal so far for one reason. I can’t just write SQL and plug it in. I wouldn’t mind if I had to make sure column names etc matched up perfectly and what not. I know exactly how to do all the reports I need to do in SQL…but can’t do diddly in Crystal. Its so idiot proof that its expert proof. can’t you write a stored procedure then point the crystal report to that instead of a table(s)? ---
**Author:** ![Shawn96VR-4](https://avatars.discourse-cdn.com/v4/letter/s/eada6e/32.png) [@Shawn96VR-4](https://forums.speedlife.net/u/Shawn96VR-4)\ **Post date:** [June 9, 2008, 12:42pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/15 "2008-06-09T12:42:42Z")
> [@SlackJ94](#): > > I don’t deal with that, managment does. Correct. > [@SlackJ94](#): > > I hate crystal so far for one reason. I can’t just write SQL and plug it in. I wouldn’t mind if I had to make sure column names etc matched up perfectly and what not. I know exactly how to do all the reports I need to do in SQL…but can’t do diddly in Crystal. Its so idiot proof that its expert proof. You are a web programmer. Use SQL and get your own datasets and interface with Crystal. I wrote a report / query interface that did just that. Created dynamic queries via the user creating what fields / search criteria, got the data set, and sent it over to my Crystal Report for display. ---
**Author:** ![SlackJ94](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/slackj94/32/6325_2.png) [@SlackJ94](https://forums.speedlife.net/u/SlackJ94)\ **Post date:** [June 9, 2008, 12:45pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/16 "2008-06-09T12:45:03Z")
K…got a question that I kno there has to be an obvious answer for. Using forumla fields in a formula…I need to select records in that date range. EDIT2: Nvm, figured it out. {@weekStart} Knew it was obvious. > [@GranMassaX](#): > > can’t you write a stored procedure then point the crystal report to that instead of a table(s)? I have no idea. I didn’t do any of the database setup. I came onto the project a year and a half into it. Was originally brought in to just do web shit (they didnt want to pay to train someone). > [@Shawn96VR-4](#): > > Correct. > > You are a web programmer. Use SQL and get your own datasets and interface with Crystal. > > I wrote a report / query interface that did just that. Created dynamic queries via the user creating what fields / search criteria, got the data set, and sent it over to my Crystal Report for display. Not sure what you mean here. The reports I’m doing are not going on the web, they are part of an application, and are deff a last minute addition. EDIT: Nvm, I think I get what you are saying. Write a window/page to do all the work for me. Sadly we go live in 7 (well, almost 6 now) days and do not have the time to get that finished. ---
**Author:** ![Shawn96VR-4](https://avatars.discourse-cdn.com/v4/letter/s/eada6e/32.png) [@Shawn96VR-4](https://forums.speedlife.net/u/Shawn96VR-4)\ **Post date:** [June 9, 2008, 12:49pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/17 "2008-06-09T12:49:33Z")
> [@SlackJ94](#): > > K…got a question that I kno there has to be an obvious answer for. Using forumla fields in a formula…I need to select records in that date range. > > I have no idea. I didn’t do any of the database setup. I came onto the project a year and a half into it. Was originally brought in to just do web shit (they didnt want to pay to train someone). > > Not sure what you mean here. The reports I’m doing are not going on the web, they are part of an application, and are deff a last minute addition. > > EDIT: Nvm, I think I get what you are saying. Write a window/page to do all the work for me. Sadly we go live in 7 (well, almost 6 now) days and do not have the time to get that finished. I meant the application, I shouldn’t have said web. The data has to come from somewhere. I don’t have Crystal installed on this machine to check. I BELIEVE you have the ability to interface with a DB to get table data or run a Stored Procedure. For more flexibility, I created XML and used that to create my Crystal Report. In my application, I basically got my data from a SQL Connection or Oracle Connection (Doesn’t matter) and then just serialized to that XML and then opened the Crystal Report with that XML as source and it renders accordingly. Many many ways you can handlel it. But live in 6 days ain’t happening. Man, you should have had code freeze awhile back ☹ Where you work man? ---
**Author:** ![SlackJ94](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/slackj94/32/6325_2.png) [@SlackJ94](https://forums.speedlife.net/u/SlackJ94)\ **Post date:** [June 9, 2008, 12:52pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/18 "2008-06-09T12:52:44Z")
Center of Transporation Excelence in Buffalo. Dead end job for me, but damn great pay and experience for still being in school. I’m gonna start looking for a new job this fall. And I kno. Friday was the code ‘freeze.’ 3 guys are fixing bugs, 1 is setting up the servers, and I’m doing reports because someone forgot about them. It’s gonna be a super long week. ---
**Author:** ![GranMassaX](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/granmassax/32/6299_2.png) [@GranMassaX](https://forums.speedlife.net/u/GranMassaX)\ **Post date:** [June 9, 2008, 12:54pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/19 "2008-06-09T12:54:30Z")
if you only have a few reports that need to get done and your data tables aren’t HUGE then just using crystal will be fine. Stored procedures will benefit you greatly when you are dealing with a bunch of different tables and hundreds of thousands of records. Crystal will generate the SQL if you ever wanted to check it in the backend. Click on the “Database” option on the top and then click “show SQL query” ---
**Author:** ![SlackJ94](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/slackj94/32/6325_2.png) [@SlackJ94](https://forums.speedlife.net/u/SlackJ94)\ **Post date:** [June 9, 2008, 12:56pm UTC](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245/20 "2008-06-09T12:56:41Z")
I know about checking the SQL, been doing that. I hate the garbage it spits out most of the time tho. And right now we aren’t talking large numbers. In 6 months, it will be huge. I will look into using sprocs to do this once I have the time. Any books/classes you recommend for learning this stuff? I’d like to actually know it so I can throw it on my resume. [Next page](https://forums.speedlife.net/t/anyone-on-here-know-crystal-reports/237245.md?page=2)