Search results for query: *

I am attempting to remove highlighted selections on a multi-selected list box when the form where the list box resides is refreshed. I am using Access 2003. The following is the coding that is being used: Me!mylistbox.Value = Null This code works fine as long the list boxes does not have the...

I am using Access 2000 and attempting to use a Pivot Table. I am able to get this to work except there are some formatting issues. Specfically, I would like to format the table as follows: - Zero "0" will appear in the cells where no values are present - Totals with commas for the...

I am using: Crystal Reports 9.0, Excel 2003 and would like to save the Crystal Reports as an Excel spreadsheet with all the format intact. However, when I export the data from CR into Excel using Export/MS Excel 97-2000 option located under 'File' option of the toolbar, an extra row is added...

I use a variable in a report. The variable is passed from a subreport to the main report. I noticed that the value for the final variable is displayed on the main report when the sub report is visible (not Suppressed). The variable becomes zero when the sub report is not visible (Suppressed)...

I am using CR version 9.0 and am attempting to transfer the data from the report into a Word Perfect Document. I would prefer to save the exported data from the Crystal Report as a dbase file which is not an option because this is the format that is accepted by the Word Perfect not *.txt file...

This is the second time to send this message. I cannot seem to locate my first attempt that I sent out yesterday. If this is not the proper forum to make this request then let me know. I am attempting to develop a Crystal Report that links to a stored procedure instead of a database table...

I am looking for information on how to use stored procedure. I have a stored procedure that retrieve the maximum date from a table. I want to print the date that is retrieved from the stored procedure which does not involve a parameter. Crystal is not letting me insert the stored procedure...

I am attempting to group a list of Matter_No based on the analyst who handled the last stage of a Matter_No. The fields in question include the following: Table 1 Matter_No Stage Start Date Attorney 123 2...

I am attempting to create a report using fields from three database tables: MM, MA, and CD tables. The MM table is joined to the MA table by a left outer join and the MA table is connected to the CD table by a left outer join. The fields that are selected on the report include: MM.Matter_ID...

My reports contains a text box with names in it. I would like the height of the text box (entire row actually) to grow or shrink horizontally as preferred to vertically which is what the Can Shrink? and the Can Grow? options in the Property table of the text box offers. thanks in advance, William