Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-19-2017, 11:01 AM   #1
sxschech
Newly Registered User
 
Join Date: Mar 2010
Posts: 404
Thanks: 10
Thanked 77 Times in 68 Posts
sxschech is on a distinguished road
Compare design of two reports

Ran a report that contains a subreport. Was proofreading the output and noticed that the subreport was truncating. I looked at a report that was saved last month in PDF and it did not have truncation, so I imported the subreport from a backup of last month's file and all was well again. The concern I have is I don't recall if there were any design changes to the report between last month and this month, or what other issue would have caused the truncation effect, (was it corruption without error message or crash)? I tried to visually compare the two reports and they appear the same, it is not a code issue as there is no vba behind the report. The sql statement is identical and the Sorting and Grouping look identical as well as the number of text boxes. I found a program on the web that can locate differences and it found some, but because the differences were not vba, I couldn't decipher what/where the differences are because they were in hex or some other numeric notation. (sample attached). For now I'll go with the older version of the subreport, just wanted to put this out there in case anyone has another thought on comparing or what may have happened to cause truncation between last month and this month.
Attached Images
File Type: png CompareTwoReports.PNG (55.0 KB, 21 views)

sxschech is offline   Reply With Quote
The Following User Says Thank You to sxschech For This Useful Post:
Uncle Gizmo (06-19-2017)
Old 06-19-2017, 02:09 PM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 9,435
Thanks: 36
Thanked 3,048 Times in 2,963 Posts
CJ_London is a jewel in the rough CJ_London is a jewel in the rough CJ_London is a jewel in the rough
Re: Compare design of two reports

Quote:
The concern I have is I don't recall if there were any design changes to the report between last month and this month
learn a well known and effective developer methodology - take backups before any changes, document your code where changes are made and keep a detailed log of changes - who, when, why, what, where

You can use the access database documenter to run a report on each report - generally easier to compare side by side
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 06-19-2017, 03:36 PM   #3
sxschech
Newly Registered User
 
Join Date: Mar 2010
Posts: 404
Thanks: 10
Thanked 77 Times in 68 Posts
sxschech is on a distinguished road
Re: Compare design of two reports

Quote:
learn a well known and effective developer methodology - take backups before any changes, document your code where changes are made and keep a detailed log of changes - who, when, why, what, where
To clarify:
I back up each file that I use at least once a day (before I open the file) regardless of whether I make changes, just in case something happens - that is how I found the earlier report.

I document changes in vba, just haven't figured out the best way for me to document non vba changes such as moving or adding a textbox to a report and determining how often/significant a change should qualify for such documentation since some changes such as moving a text box over a quarter inch or changing point size from 9 to 8. Otherwise end up spending too much time on putting together a list of too many changes. Then also the issue of documenting inside the file as a table or outside in a text or excel file.

Thanks:
for mentioning the database documenter. I'll take a look and see if that sheds any light. I think the report in question is ok from standpoint of not being changed as it is a fairly simple report having only two text boxes.

sxschech is offline   Reply With Quote
Old 06-19-2017, 04:09 PM   #4
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 30,282
Thanks: 8
Thanked 3,547 Times in 3,491 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Compare design of two reports

I use a version table for front end updating, and one field is for the changes made to that version. That said, for the things you describe I'd just say "tweak such-and-such report", not detail each little change. I would know that I made changes to it though, so if something went horribly wrong I could pull a copy of the form/report from a backup.

__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Tags
compare design , subreport , truncation

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Design with forms and reports hardhitter06 Theory and practice of database design 1 01-17-2007 07:18 AM
[SOLVED] How to Design Reports using forms Namrud Reports 1 04-03-2006 04:45 PM
[SOLVED] Unable to design forms & reports semutmerah Forms 2 08-14-2005 09:50 PM
Can't Design or Run Reports shaggy Reports 2 05-04-2005 02:02 PM
[SOLVED] Allowing users to design their own reports in an MDE SteveP Reports 1 07-03-2001 11:31 AM




All times are GMT -8. The time now is 10:51 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World