<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl" href="RSS_xslt_style.asp" version="1.0" ?>
<rss version="2.0" xmlns:WebWizForums="https://syndication.webwiz.net/rss_namespace/">
 <channel>
  <title>Codejock Developer Community : Reports: LoadSettings Error</title>
  <link>http://forum.codejock.com/</link>
  <description><![CDATA[This is an XML content feed of; Codejock Developer Community : Suite Pro : Reports: LoadSettings Error]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Wed, 13 May 2026 17:07:37 +0000</pubDate>
  <lastBuildDate>Sun, 30 Jan 2005 13:02:19 +0000</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 12.04</generator>
  <ttl>360</ttl>
  <WebWizForums:feedURL>forum.codejock.com/RSS_post_feed.asp?TID=1664</WebWizForums:feedURL>
  <image>
   <title><![CDATA[Codejock Developer Community]]></title>
   <url>http://forum.codejock.com/forum_images/codejock-logo.gif</url>
   <link>http://forum.codejock.com/</link>
  </image>
  <item>
   <title><![CDATA[Reports: LoadSettings Error : OK. I talked my way through it...]]></title>
   <link>http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4893&amp;title=reports-loadsettings-error#4893</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://forum.codejock.com/member_profile.asp?PF=884">DDJJ</a><br /><strong>Subject:</strong> 1664<br /><strong>Posted:</strong> 30 January 2005 at 1:02pm<br /><br /><P>OK.&nbsp; I talked my way through it and figured it out.&nbsp; As noted above, I had thought that the Load/Save Settings methods removed the need to even load the columns each time the user opened a report.&nbsp; The key&nbsp;is that these methods load and save column "settings" vs. the column "definitions" (for the lack of a better word to use).&nbsp; Once I started loading the definitions again, before running the LoadSettings method, it works beautifully&nbsp;&nbsp;<IMG style="CURSOR: pointer" &#111;nclick="AddSmileyIc&#111;n'smileys/smiley17.gif'" alt=T&#111;ngue src="https://forum.codejock.com/smileys/smiley17.gif" border="0">&nbsp; with all of the appropriate "settings" in place.</P><P>Maybe I'm just slow, but I don't think the documentation was really helpful here.&nbsp; That's OK.&nbsp; I still like the tools.</P><P><IMG style="CURSOR: pointer" &#111;nclick="AddSmileyIc&#111;n'smileys/smiley31.gif'" alt=Hug src="https://forum.codejock.com/smileys/smiley31.gif" border="0"></P>]]>
   </description>
   <pubDate>Sun, 30 Jan 2005 13:02:19 +0000</pubDate>
   <guid isPermaLink="true">http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4893&amp;title=reports-loadsettings-error#4893</guid>
  </item> 
  <item>
   <title><![CDATA[Reports: LoadSettings Error : Maybe I&amp;#039;ll try to jumpstart...]]></title>
   <link>http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4892&amp;title=reports-loadsettings-error#4892</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://forum.codejock.com/member_profile.asp?PF=884">DDJJ</a><br /><strong>Subject:</strong> 1664<br /><strong>Posted:</strong> 30 January 2005 at 12:40pm<br /><br /><P>Maybe I'll try to jumpstart this again...</P><P>I think the problem might relate to what I expect the LoadSettings/SaveSettings methods do.&nbsp; I had thought that we (the developer) could create a report in code, adding columns to the report as well as determining which columns would be visible the first time the user views the report.&nbsp; Once the user has viewed the report, and added or deleted available columns from the view to meet their (the user's) needs, we could then save the user's "settings" and therefore NOT have to load the columns the next time around, just the data.&nbsp; The user's column settings (which columns are visible, how they are aligned, etc.) would thereby be maintained from one session to the next.&nbsp; The columns available to the user will always stay the same...just which ones are visible, the widths, alignment, etc., would change from session to session.</P><P>Am I thinking this through correctly?</P>]]>
   </description>
   <pubDate>Sun, 30 Jan 2005 12:40:48 +0000</pubDate>
   <guid isPermaLink="true">http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4892&amp;title=reports-loadsettings-error#4892</guid>
  </item> 
  <item>
   <title><![CDATA[Reports: LoadSettings Error : Here&amp;#039;s the code used to save/load...]]></title>
   <link>http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4732&amp;title=reports-loadsettings-error#4732</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://forum.codejock.com/member_profile.asp?PF=884">DDJJ</a><br /><strong>Subject:</strong> 1664<br /><strong>Posted:</strong> 13 January 2005 at 9:03pm<br /><br /><P>Here's the code used to save/load the report settings (note that the code verify's whether a file has already been created to save the settings for the particular report):</P><P>Private Sub SaveReportSettings(sType As String)</P><P>&nbsp;&nbsp;&nbsp; Dim FreeF As Integer, sFile As String, sLayout As String<BR>&nbsp;&nbsp;&nbsp; <BR>&nbsp;&nbsp;&nbsp; sFile = App.Path &amp; "\" &amp; sType &amp; ".000"<BR>&nbsp;&nbsp;&nbsp; FreeF = FreeFile<BR>&nbsp;&nbsp;&nbsp; If VerifyFile(sFile) Then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Kill sFile<BR>&nbsp;&nbsp;&nbsp; End If<BR>&nbsp;&nbsp;&nbsp; Open sFile For Binary As #FreeF<BR>&nbsp;&nbsp;&nbsp; Put #FreeF, , frmMain.wndReportControl.SaveSettings<BR>&nbsp;&nbsp;&nbsp; Close #FreeF</P><P>End Sub<BR>Private Function LoadReportSettings(sType As String) As Boolean<BR>&nbsp;&nbsp;&nbsp; <BR>&nbsp;&nbsp;&nbsp; Dim FreeF As Integer, sFile As String, sLayout As String</P><P>&nbsp;&nbsp;&nbsp; If VerifyFile(App.Path &amp; "\" &amp; sType &amp; ".000") Then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; On Error GoTo LoadReportSettings_Error<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sFile = App.Path &amp; "\" &amp; sType &amp; ".000"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FreeF = FreeFile<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sLayout = Space(FileLen(sFile))<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Open sFile For Binary As #FreeF<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Get #FreeF, , sLayout<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Close #FreeF<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; frmMain.wndReportControl.LoadSettings sLayout<BR>&nbsp;&nbsp;&nbsp; Else<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Exit Function<BR>&nbsp;&nbsp;&nbsp; End If<BR>&nbsp;&nbsp;&nbsp; LoadReportSettings = True<BR>&nbsp;&nbsp;&nbsp; Exit Function<BR>LoadReportSettings_Error:<BR>&nbsp;&nbsp;&nbsp; Err.Clear<BR>&nbsp;&nbsp;&nbsp; Exit Function<BR>End Function</P><P>Here's the code setting up the report:</P><P>Private Sub CreateItemReport(sFilter As String)<BR>&nbsp;&nbsp;&nbsp; <BR>&nbsp;&nbsp;&nbsp; Dim Column&nbsp; As ReportColumn<BR>&nbsp;&nbsp;&nbsp; Dim lIndex&nbsp; As Long<BR>&nbsp;&nbsp;&nbsp; <BR>&nbsp;&nbsp;&nbsp; With frmMain.wndReportControl.Columns<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set Column = .Add(lIndex, "Item ID", 4, True)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lIndex = lIndex + 1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column.Visible = False<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set Column = .Add(lIndex, "Subject", 60, True)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lIndex = lIndex + 1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set Column = .Add(lIndex, "Description", 100, True)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lIndex = lIndex + 1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column.Visible = False<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set Column = .Add(lIndex, "Type", 6, True)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lIndex = lIndex + 1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column.Visible = False<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set Column = .Add(lIndex, "Start Time", 20, True)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lIndex = lIndex + 1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column.Alignment = xtpAlignmentRight<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set Column = .Add(lIndex, "End Time", 20, True)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lIndex = lIndex + 1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column.Visible = False<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column.Alignment = xtpAlignmentRight<BR>&nbsp;&nbsp;&nbsp; End With</P><P>&nbsp;&nbsp;&nbsp; 'Add Records to the ReportControl<BR>&nbsp;&nbsp;&nbsp; ProcessItemRS sFilter, g_sItem</P><P>End Sub</P><P>Here's the code writing the data to the report:</P><P>Private Sub AddItemRecord(objItem As Object, lItemID As Long, sID As String, _<BR>&nbsp;&nbsp;&nbsp; lItemID As Long)<BR>&nbsp; <BR>&nbsp;&nbsp;&nbsp; Dim  Record&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; As ReportRecord<BR>&nbsp;&nbsp;&nbsp; Dim  Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  As ReportRecordItem<BR>&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;&nbsp;Set Record = frmMain.wndReportControl.Records.Add()<BR>&nbsp;&nbsp;&nbsp; <BR>&nbsp;&nbsp;&nbsp; With Record<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Tag = sID<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .AddItem lItemID<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .AddItem objItem.Subject<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .AddItem objItem.Description<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .AddItem objItem.Type<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .AddItem objItem.StartTime<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .AddItem objItem.EndTime<BR>&nbsp;&nbsp;&nbsp; End With<BR>&nbsp;&nbsp;&nbsp; <BR>End Sub</P><P>Hopefully, this helps.&nbsp; Let me know if you need any add'l info.</P><P>Thanks!</P>]]>
   </description>
   <pubDate>Thu, 13 Jan 2005 21:03:16 +0000</pubDate>
   <guid isPermaLink="true">http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4732&amp;title=reports-loadsettings-error#4732</guid>
  </item> 
  <item>
   <title><![CDATA[Reports: LoadSettings Error : Hi Dan - any chance you can post...]]></title>
   <link>http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4729&amp;title=reports-loadsettings-error#4729</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://forum.codejock.com/member_profile.asp?PF=280">ianp</a><br /><strong>Subject:</strong> 1664<br /><strong>Posted:</strong> 13 January 2005 at 7:11pm<br /><br /><P>Hi Dan - any chance you can post your code? </P><P>Also, I've come across this error if the number (and order of) columns added to the control, does not correspond to the column configuration in the settings string...</P>]]>
   </description>
   <pubDate>Thu, 13 Jan 2005 19:11:54 +0000</pubDate>
   <guid isPermaLink="true">http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4729&amp;title=reports-loadsettings-error#4729</guid>
  </item> 
  <item>
   <title><![CDATA[Reports: LoadSettings Error : Humm, I&amp;#039;m not sure.  Are...]]></title>
   <link>http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4728&amp;title=reports-loadsettings-error#4728</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://forum.codejock.com/member_profile.asp?PF=790">dlord</a><br /><strong>Subject:</strong> 1664<br /><strong>Posted:</strong> 13 January 2005 at 5:42pm<br /><br /><P>Humm, I'm not sure. </P><P>Are there any other signs of problems with your report performing other functions.</P><P>Is that the whole error message...?</P><P>Sorry that didn't help</P>]]>
   </description>
   <pubDate>Thu, 13 Jan 2005 17:42:59 +0000</pubDate>
   <guid isPermaLink="true">http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4728&amp;title=reports-loadsettings-error#4728</guid>
  </item> 
  <item>
   <title><![CDATA[Reports: LoadSettings Error : That&amp;#039;s pretty much the exact...]]></title>
   <link>http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4724&amp;title=reports-loadsettings-error#4724</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://forum.codejock.com/member_profile.asp?PF=884">DDJJ</a><br /><strong>Subject:</strong> 1664<br /><strong>Posted:</strong> 13 January 2005 at 11:35am<br /><br /><P>That's pretty much the exact same code I'm using, without any luck.</P><P>Is it possible that my property settings for the report control might impact this?&nbsp; For example, the various edit settings, etc.</P><P>Thanks!</P><P>Dan</P>]]>
   </description>
   <pubDate>Thu, 13 Jan 2005 11:35:52 +0000</pubDate>
   <guid isPermaLink="true">http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4724&amp;title=reports-loadsettings-error#4724</guid>
  </item> 
  <item>
   <title><![CDATA[Reports: LoadSettings Error : It works good for me. Here is...]]></title>
   <link>http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4714&amp;title=reports-loadsettings-error#4714</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://forum.codejock.com/member_profile.asp?PF=790">dlord</a><br /><strong>Subject:</strong> 1664<br /><strong>Posted:</strong> 12 January 2005 at 7:36pm<br /><br /><P>It works good for me. Here is a clip of the code for Save and Load. Enjoy - </P><P>Private Sub cmdSaveReport_Click()<BR>SaveFilename = tbSaveFilename.Text<BR>SaveFilename = Trim(SaveFilename)<BR>If Not IsNull(SaveFilename) Then<BR>SaveFilename = App.Path &amp; "\" &amp; SaveFilename </P><P>&nbsp;&nbsp;&nbsp; Dim FreeF As String<BR>&nbsp;&nbsp;&nbsp; FreeF = FreeFile<BR>&nbsp;&nbsp;&nbsp; 'Kill sFile<BR>&nbsp;&nbsp;&nbsp; Open SaveFilename For Binary As #FreeF<BR>&nbsp;&nbsp;&nbsp; Put #FreeF, , frmReport.wndReport.SaveSettings<BR>&nbsp;&nbsp;&nbsp; Close #FreeF<BR>&nbsp;&nbsp;&nbsp; <BR>End If<BR>End Sub</P><P>Private Sub File1_Click()<BR>Dim LoadFileName As String<BR>LoadFileName = App.Path &amp; "\" &amp; File1.FileName<BR>Dim sLayout As String<BR>Dim FreeF As String<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FreeF = FreeFile<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sLayout = Space(FileLen(LoadFileName))<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Open LoadFileName For Binary As #FreeF<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Get #FreeF, , sLayout<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Close #FreeF<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; On Error GoTo 0<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; frmReport.wndReport.LoadSettings sLayout<BR>End Sub</P>]]>
   </description>
   <pubDate>Wed, 12 Jan 2005 19:36:24 +0000</pubDate>
   <guid isPermaLink="true">http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4714&amp;title=reports-loadsettings-error#4714</guid>
  </item> 
  <item>
   <title><![CDATA[Reports: LoadSettings Error : I keep getting an error when I...]]></title>
   <link>http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4711&amp;title=reports-loadsettings-error#4711</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://forum.codejock.com/member_profile.asp?PF=884">DDJJ</a><br /><strong>Subject:</strong> 1664<br /><strong>Posted:</strong> 12 January 2005 at 11:19am<br /><br />I keep getting an error when I use the LoadSetting method ("method of object...failed).&nbsp; Is there any documentation out there besides what little bit is in the help file?]]>
   </description>
   <pubDate>Wed, 12 Jan 2005 11:19:29 +0000</pubDate>
   <guid isPermaLink="true">http://forum.codejock.com/forum_posts.asp?TID=1664&amp;PID=4711&amp;title=reports-loadsettings-error#4711</guid>
  </item> 
 </channel>
</rss>