Microsoft Office Forums Unable To Get Proper Merged Results

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 04-12-2016, 02:06 PM
macropod's Avatar
macropod macropod is offline Unable To Get Proper Merged Results Windows 7 64bit Unable To Get Proper Merged Results Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,533
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default


Quote:
Originally Posted by JennEx View Post
Where did you put the new version (data file or report file) ...?
I simply replaced the attachment in post #12.
Quote:
Originally Posted by JennEx View Post
And so we're on the same page, (I'm guessing you have reason behind your approach), but I don't seem to be having issues with the time fields. It's the others line: r#_relchg, r#_crew, r#_division, r#_base and r#_pitch that are being represented improperly in the report.
Yes, but you're also getting time outputs in cells that don't have them:
Quote:
Originally Posted by JennEx View Post
For example, the boxes under "CHANGE" shouldn't have any time values in them which a couple do (They are supposed be be simply "r#_division r#_base/r#_pitch ... Bantam 82'/55', not )
.
Quote:
Originally Posted by JennEx View Post
I wonder ... the text values in the data for r#_base and r#_pitch include an apostrophe. (82', 55'). Might this be causing issues?
Possibly, in which case we might need to insert a dummy data row at the top of the worksheet, which we can then use a SKIPIF field to exclude from any outputs.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #17  
Old 04-12-2016, 04:15 PM
JennEx JennEx is offline Unable To Get Proper Merged Results Windows XP Unable To Get Proper Merged Results Office 2013
Competent Performer
Unable To Get Proper Merged Results
 
Join Date: May 2010
Posts: 158
JennEx is on a distinguished road
Default

Hi Paul, happy to see you back.

So, with your data (the corrected version) and most recent report (from post 2), no changes on my part, this is the result ...



Not much improvement. In fact, the time ranges in section 1 and 2 that used to be ok are off now. LOL I've updated the fields that are displaying incorrect data by highlighting them in red.

I looked at my datasource, in particular the fields seemingly giving me the problems. I discovered that the colummns r#_base and r#_pitching weren't text. Testing the apostrophe possibility, upon removing it in that cell, the resulting value was a time formatted value. I entered "75" and it showed as 0:00.

I changed all the r#_base and r#_pitching columns to text and reran the merge document. Still crazy merged fields for those fields I changed to text. Closed the report, went back to the data and removed all the apostrophes. Reran the merge with the same results.

Quote:
Yes, but you're also getting time outputs in cells that don't have them
Among other oddities.

I also reduced the report to just 4 sections in the table instead of 8 just on a whim and experienced the same bad data for those 4.
Reply With Quote
  #18  
Old 04-15-2016, 08:34 AM
JennEx JennEx is offline Unable To Get Proper Merged Results Windows XP Unable To Get Proper Merged Results Office 2013
Competent Performer
Unable To Get Proper Merged Results
 
Join Date: May 2010
Posts: 158
JennEx is on a distinguished road
Default

So, it appears as though I may have things resolved. I won't say I'm overly confident, it seems too good to be true. It has been one of the most challenging, inconsistent and unpredictable challenges I've ever faced in the Microsoft Office World.

No sense in rehashing all the odd problems encountered. I am in know way a pro, so I can only suspect all problems encountered with this report (and perhaps in other problems with other reports), had something to do with the tables that formed the structure of my report.

Applying all my merge fields, rules and formula to a basic document (no tables etc), all fields populated with the data as expected. There was nothing erroneous with the data, the mergefields, rules or formulas.

After rebuilding my report with the tables, and copying and pasting the merge components from the basic document to their respective places in the table, everything seems to be populating as expected.

What confused me, and still confuses me to an extend (I'm just happy it works but it makes me fear that the success may be short lived) is that during all my testing up to today, I was getting different results between my school and home computers. WIth this latest development, my time formatting is being accepted in it's basic, unprocessed form, something that earlier, required complex formula to ensure proper presentation. These appear to no longer be issues.

I may be back!

PS ... Paul, thank you for your message! I was unable to reply back.
Reply With Quote
  #19  
Old 04-17-2016, 04:37 PM
macropod's Avatar
macropod macropod is offline Unable To Get Proper Merged Results Windows 7 64bit Unable To Get Proper Merged Results Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,533
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi Jenn,

I'm glad you've got it sorted.

As for being unable to PM me, that's sadly because I had to turn off the 'reply' functionality due to the frequency with which some new members, in particular, think they can just PM me for answers to their questions instead of using the public forum.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
proper snoforlife Excel Programming 0 01-26-2016 02:16 PM
Unable To Get Proper Merged Results Hyperlinks Not Linking to Proper Sections of Doc MoiraB Word 2 08-26-2015 07:13 PM
Unable To Get Proper Merged Results Table will not allow sorting because "cells are merged". I can't find the merged cells. wendyloooo Word Tables 1 05-26-2015 01:19 PM
Proper Text Format sufian,naeem Excel 1 05-05-2014 05:59 AM
2013 search results take a long time - they fill in as results in reverse date order themookman Outlook 0 10-11-2013 12:01 PM


All times are GMT -7. The time now is 04:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft