Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Lawson Crystal Reports and Prod Verses Dev
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Chris Radcliffe
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5187
People Online:
Visitors:
311
Members:
0
Total:
311
Online Now:
New Topics
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1351
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
Lawson Crystal Reports and Prod Verses Dev
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Layne
Basic Member
Posts: 24
3/20/2013 3:52 PM
In developing Crystal Reports and their associated Views, Stored Procedures, and SQL Commands, where do most of you do your work? Do you do most of it in a Lawson Development Environment and then transfer all needed SQL and RPT files to Production, or simply do your work in Production to start with? If you needed to maintain a Development Environment so your users could always have access to all of your reports, how do you keep the Production and Development Product Line Crystal Reports, Views, and Stored Procedures synced without a decent amount of manual intervention? Once a report is published to Production and changes are desired, do most of you just make those changes in Production or in Development first. Not sure if we are large by some comparisons, but we have over 200 SmartNotes and over 200 Crystal Reports and this can be a major ordeal. Our users have occasional need to test some of the reports in Development, and actual reports are sometimes needed to test changes or upgrades to LBI, as well as patches that may change the structure of the database. Just looking for ideas on how others approach this issue. Thanks in advance.
Jan
Veteran Member
Posts: 55
3/20/2013 5:47 PM
Hi Layne
I write my sql into the Crystal report and publish into Production since these reports aren't updating anything. Of course, prior to publishing into production, I test the Crystal reports by running outside of LBI and making sure they work correctly. Right now, we're not using any stored procedures but I'd suspect we'd have to do that in a test or dev environment/area first since we play by I.T. rules then. Have you guys written any stored procedures for your reports so far? I'd be curious to know what rules are set for stored procedure creation, testing, and publishing are. Is it just I.T. that creates stored procedures, or can your more technical business analysts also create them?
Georgette
Veteran Member
Posts: 52
3/20/2013 6:06 PM
I don’t have that many reports, but have a similar issue.
I have two directories set up, one for production, one for dev. I write one Crystal report in production and put it in the production directory with a prd_ prefix.
I then do a save as, rename the report with a dev_ prefix and save it in the dev directory. I go into the Crystal Database \ Set Datasource Location option to point to the correct server for development.
If it is a revised report, the republish option can be used in LBI. Otherwise, I publish the new ones to their respective dashboards. (We are in the process of upgrading, so cannot publish in the same place.)
I have not done this, but in your situation with that many reports, I would think of having two LBI dashboards separated by Tabs, one called Production, one called Development.
We don’t use stored procedures.
Good luck!
Layne
Basic Member
Posts: 24
3/20/2013 9:21 PM
@Jan. Yes, the majority of our reports use Stored Procedures and when they are not used, it usually means the Report Writer didn't have that access to the database. The things that Stored Procedures can do to the database could be devastating since they can delete, insert, update, and truncate (to mention some of the things) the data. We have some Analyst in our rather large organization that can write SQL at this level, but it would be posted by someone on our team. They could not post it themselves.
Layne
Basic Member
Posts: 24
3/20/2013 9:21 PM
@Jan. Yes, the majority of our reports use Stored Procedures and when they are not used, it usually means the Report Writer didn't have that access to the database. The things that Stored Procedures can do to the database could be devastating since they can delete, insert, update, and truncate (to mention some of the things) the data. We have some Analyst in our rather large organization that can write SQL at this level, but it would be posted by someone on our team. They could not post it themselves.
Matthew Nye
Veteran Member
Posts: 514
3/21/2013 10:11 AM
>In developing Crystal Reports and their associated Views, Stored Procedures, and SQL Commands, where do most of you do your work?
I never do development in production before running my scripts in a non-prod environment. It is a major violation of best practices to do report design work in production first. Depending on your level of permissions, you could potentially cause outages at worst and at best degrade system performance.
>Do you do most of it in a Lawson Development Environment and then transfer all needed SQL and RPT files to Production, or simply do your work in Production to start with?
Yes, this is the best way to control impact on the production environment.
> If you needed to maintain a Development Environment so your users could always have access to all of your reports, how do you keep the Production and Development Product Line Crystal Reports, Views, and Stored Procedures synced without a decent amount of manual intervention?
You may already be doing this but I would recommend trying to create a "semantic" layer for all your reports. Id imagine a lot of your report logic has just slight variations on each other, mostly around filters (WHERE clause). Create common views or stored procedures that returns the base data set for collections of reports and only customize the WHERE or Selection Expert for each report. Youll still need to run ALTER scripts for your DB objects in PROD when youve made changes in DEV.
In terms of reports synch, with LBI the only complete way to do this is to do database restore speriodically. Make a backup of the source RS database and restore it to the target RS database. then copy the directory for the source report file repository and copy it to the target.
The short answer is, if you want to truly synchronize 2 environments, theres no quick way to do it. You can also try using Solution Packs to just bring specific reports from one environment to another.
>Once a report is published to Production and changes are desired, do most of you just make those changes in Production or in Development first.
Again, always in development.
> Not sure if we are large by some comparisons, but we have over 200 SmartNotes and over 200 Crystal Reports and this can be a major ordeal. Our users have occasional need to test some of the reports in Development, and actual reports are sometimes needed to test changes or upgrades to LBI, as well as patches that may change the structure of the database. Just looking for ideas on how others approach this issue. Thanks in advance.
I would say thats a pretty hefty load, of course that all depends on user load and frequency of use as well as the size of the data sets of each report but I would think what would benefit you most would be a data warehouse, data mart or at least reporting tables. In this case you dont have to worry so much about production/development question since the data is decoupled from your operational systems. Refresh can be handled via an ETL process to load the tables and you dont have to worry about migration as much.
hth,
Matt
You are not authorized to post a reply.