Solved

Can I have multiple Report Comments special fields and if so, how do i access them from vb?

Posted on 2008-10-27
4
342 Views
Last Modified: 2013-11-07
Summary:
I have a listbox that i can do multiselects from.  I also have a Crystal Report, I'm using the special field 'Report Comments(type string)' since it can hold a string of length 511 as opposed to a textfields which can only hold a string of 255.  

The Problem:
If a user picks too many selections, then i get the error: 'Buffer to small to hold string or missing null byte'.  So what I want to do is:  have multiple Report Comments on the field so  that when one is filled at 511, the overflow goes into the next ReportComments.  I will do this with a for loop...I will change string to array string, then I will % by 511...otherwise add to next empty ReportComments field.  I noticed that the Report Comments fields do have names such as Comments1, Comments2, Comments3, etc...however, when I try to access them from rpt.SummaryInfo.ReportComments, i am not allowed to grab the fields by their name and only the first Report Comments is filled.  

The Question:
Is there a way to have multiple report comments where they are accessible by either index or name with VB or C#?  Thank in advance for your help...
0
Comment
Question by:silemone
  • 2
  • 2
4 Comments
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 500 total points
ID: 22858268
To the best of my knowledge, no.  Special comments are populated in the Document Properties (File|Summary Info in the standalone version of Crystal Reports) and there's only one comments section per report.The Document Properties aren't only used in Crystal Reports, but by your OS, too.  For example, if you mouse over a report in your Windows Explorer or examine it's properties, you'll see what was entered in the report (just like you'd see in properties for a Word document).
0
 
LVL 21

Author Comment

by:silemone
ID: 22870619
good rhinok...thanks for answering...so if this is the case,  in your opinion, or factual if you can find fact, why are you allowed to add more than one Reports Comments fields and why is one given objectName:  ReportComments1 and ReportComments2...Since you were the only person to answer, I'm giving you the points anyway, but any thoughts on this last question?
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 22870664
Unfortunately, I don't know the answer to that question, since I have little experience with the .net/vb versions of Crystal Reports.  I'd hold off giving points and see if we can get some of the developer-centric experts like Ido or emoreau to reply.
0
 
LVL 21

Author Closing Comment

by:silemone
ID: 31510452
Thanks for your assistance...
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question