I have a similar problem where our vendor's MS Excel report has text dates formatted as, for example, 7022002 and 11212004, which translate to 7/02/2002 and 11/21/2004 respectively. My client cannot sort by this date field which is causing them problems with their data analysis. I tried...
Thanks to all that replied. We (me and a co-worker) offerred 2 solutions to the client agency requesting this info:
1. Created a comma delimited text file containing all of the fields we have available, but not in the same size the client requested. The IsNull suggestion worked great on fields...
Crystal Reports XI.
I'm having problems exporting a large amount of data (i.e. many fields) from Crystal to a text file. I created a formula to assemble all of the required fields, which must be fixed length to match a mainframe system (formula is below). Each sub-formula makes the...
Hi.
I fixed the problem using a workaround solution. First, for the route number on the report I just used the RouteNumber from the table since the value returned by the query will equal the parameter value selected by the client (duh). For the "as of date", I created an expression named...
Hi.
I was wondering if anyone has come across this issue in MS Access 2000 when exporting a report to MS Word 2002 (PC is running Windows XP with Service Pack 2):
Modules: form (frmRouteByDate), query (qryRouteByDate) and report (rptRouteByDate).
I have a form that allows the client to...
Hi.
I created a Class module for processing all of the selected items found in a ListBox, which we use in a Crystal Reporting application where clients select values such as company codes for reporting purposes. You may be able to use this Class module for what you are trying to do with the...
There may be a roundabout way to “disable” the checkbox within the ListBox. When you identify which item in the ListBox needs to be disabled, set the ItemData property for that item to a specific value:
' Disable a specific ListBox item.
Dim intIdx As Integer
For intIdx = 0 To...
Sorry to have responded so late.
Another option would be to ask if the client wants to save the data in the form's QueryUnload event. Here's a rough code sample.
'*****************************************************'
'DESCRIPTION: (generated by VB)
' Before exiting, see if the client wants...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.