Search results for query: *

Hello, I'm linking a subreport to a main report, using a character field (employee number) in the main container report to link to an employee number prompt in the subreport. The problem is, for employee numbers with a leading zero, the subreport at runtime generates an empty result set. All...

Hello - I have custom groups of shortcuts I had created in Access 2003. In Access 2007, I cannot see those custom groups. What's weird is, I can see the custom groups in one database but not another. I cannot figure out why. Any ideas?

I saw a similar thread, but my code below is a bit different. Any ideas appreciated. It copies a Word doc into an Outlook email. The code below errors out at the .Active Inspector line. Further below I paste a version that DOES work; however, it comes up with the Outlook security message...

Has anyone found a way in Access 2007 or beyond to SORT by "Description" in the Navigation Pane? That ability was present in Access 2003.

Hello, I'm running Crystal reports on the web. I'm getting the infamous java.lang.NullPointerException error when running the Crystal report on the web. The Crystal report runs fine on my PC. The text of the error is as follows -- anyone have any ideas? Caused by...

Hello -- when double-clicking on a summary value to open a drill-down detail tab, the latter doesn't show a shared variable value that I'm pulling from a subreport. Do shared variables not appear in the drill-down detail tabs? Thanks!!

Hi Group -- does anyone know how to initialize the ODBC connection stored in an Access session? I have a series of pass-through queries, and I need to establish a different ODBC connection for each. Just hard-coding the ODBC Connect Str property in the query's properties doesn't work because...

Hello everyone, I have a Crystal that I want to refresh through VBA. The database connection and datasource is already saved with the Crystal. Any ideas on how to accomplish the refresh? What I'm trying to do through VBA is essentially simulating the user action of clicking the lightning bolt...

Hello, I have some VBA code that establishes an ADODB.Connection. Is there any way I can use that ADODB.Connection to log on and refresh a Crystal report? Below is my ADODB code where I establish a "Cn" variable containing the ADODB connection parameters. What I was hoping to do is use this...

Does anyone know what the website is now to search on Crystal Knowledge Base articles? The best I've found so far is the following URL, but no real success. https://www.sdn.sap.com/irj/boc/support

Hello, Has anyone successfully printed addresses on batches (500+) envelopes? Currently all that seems possible is feeding the envelopes through the manual side tray, which of course isn't amenable to large batches of envelopes. -SL

Hello, Has anyone heard of, or used, any good third-party products that "burst" reports or files to secured websites, controlled by individual user access? So far I've googled and found OPIN systems and Merkur Group. I googled on search terms like "secure document delivery," "secure document...

Hi, This code uses WebDAV to upload files automatically to SharePoint. I didn't write it, though. "Jeff Jones" did. My question is, the code below doesn't have an error-trapping routine that notifies me, at run-time, if a file didn't successfully get uploaded to SharePoint. Instead, the code...

Has anyone here had success in using the "Microsoft Query" tool to call an Oracle stored procedure? If so, any syntax tips on how to code the stored proc call in Microsoft Query would be much appreciated!

Hi Group, My problem is noted by the asterisk (*) below: (1) Insert a subreport in a group footer of the main rpt. The main report & subreport are each based on different stored procedures, but both involve the same two stored proc parameters. The subrpt also contains the same two groups as...

Hi Group, This problem has plagued me for some time: in a Crystal report, I have a "whileprintingrecords" formula that references summary information. I'd like to display groups in the report based on whether this "whileprintingrecords" formula is at least a certain value...

Greetings Group, I created a MONTHS_BETWEEN expression and am trying to incorporate this function in the "WHERE" clause of my query. Has anyone tried this? I'm experiencing an error: SQL error. Stmt #: 4353 Error Position: 0 Return: 1840 - ORA-01840: input value not long enough...

Group, My apologies ahead of time if this question is extrememly elementary ... To be sure, I did spend a considerable time searching for previous posts on this subject but couldn't seem to find an answer to the following question: What I'm trying to do is use Visual Basic simply to "Log...

Hi Group, I have a main rpt with two embedded subrpts. I'm using shared variables. There are two group fields in the main rpt. One subrpt is placed in the main rpt's first group header; the second subrpt is placed in the main rpt's second group header. I'm using shared variables in Crystal...

Hello group, In a group header of a main report, I've embedded a subreport. So, the subreport gets invoked for each group header row in the main report. When I run the main report, the subreport properly displays in my first page preview. Then, however, when I try to use the arrow icons to...