Search results for query: *

You can use the following code to get a count of the number of lines in an Access app, and you can adapt it to return other properties as well. Sub LinesInMods() Dim lines As Long Dim m As AccessObject For Each m In CodeProject.AllModules DoCmd.OpenModule m.Name With...

I have an application built using Word 2000 as a container. The application requires the use of a special template, which is installed on local client PCs. In the template there is code that runs on the Document_Open event. A document created from this template opens and runs the code...

Right. I think the confusing thing here is that I do not have any parameter fields in the report. The report is run as part of a Crystal Info batch job, which means there is no user interaction: no prompting of users for parameter values. The parameters are passed using Crystal Info. I...

I am working with Crystal Reports 6 in an environment where batch reporting is done using Crystal Info. Data is provided to the reports from SQL Server 7 stored procedures. I have a situation where a single report is run multiple times by Crystal Info, each time with different parameters. How...

I am working on a server with MSXML 2.5 (service pack 1) installed and no option to upgrade. I want to use ASP (server-side VBScript) code to pass a parameter into XSLT. I've done this before with MSXML 4.0, but cannot figure out the syntax to do the same thing with the earlier version. Any...

Woops. One amendment: my nav bar won't navigate siblings, but to the closest preceding or following <small> node. Technically, the navigation will be between cousins.

I am an XSL newbie. I have a simple XML that I want to use with XSL to create an HTML page displaying the value of a given node along with a navigation bar with forward and back buttons to browse that node's siblings. My function already knows the value of the node it wants to display, and is...

I have a cross tab with three summary field values for financials by quarter. The cross tab looks something like: Q1 Q2 Q3 Q4 Total ------------------------------------------------------- Program #1 | <Baseline> | <Projected> |...

I wasn't able to work with Hierarchical groups for a bit since I got sidetracked on other tasks. I finally got to this today, and I can use hierarchical grouping options to partially satisfy my requirement. I can show the parent record in a group header and have the related children show in...

Unfortunately, I believe the 'hierarchical grouping' feature applies to the case where the report connects directly to a database, allowing a parent-child relationship to be estalished across tables. Since I'm getting an ADO recordset from a SQL Server 2000 stored proc, I don't think I have...

I am a CR newbie. I'm trying to create a report that contains many subreports, which link to SQL Server 2000 stored procedures as a datasource. Some of these subreports contain data collected from two tables with a one-to-many relationship (a parent table and a corresponding update table)...

Thanks! I just needed the syntax -- now this should be a piece of cake.

I have an SP that produces a table that can be either one or two columns, depending on a paramter. I'd like to call it from a second SP and accept the result. I can't seem to get the syntax correct to exec the first SP and accept its return value. Since in this particular instance I know...

I am a CR newbie. I'm trying to create a report that contains many subreports, which link to SQL Server 2000 stored procedures as a datasource. Some of these subreports contain data collected from two tables with a one-to-many relationship (a parent table and a corresponding update table). I...

I need to create a function that can loop through the <area>'s in an image map and pull their titles into an array. I am loading various documents containing image maps into a frame. These documents and their maps will vary over time, and are provided to me, so I cannot edit them in any way...

I do not believe the native SQL server driver included with CR supports NTEXT. Try the ODBC driver for SQL Server. You will take a performance hit (slight), but this should solve your problem.

I am attempting to run a simple report through ASP (ActiveX report viewer & RDC) connected to a SQL Server 2000 stored procedure. The code fails on the following line: session(&quot;oRpt&quot;).ReadRecords And I receive the following error message: Server has not yet been opened. The...