Search results for query: *

Hi all, I'm not sure if it's possible but I'd like to combine the follow two queries into one: select substr(reserved, 11, 10) as employees, tdate from jobs union all select employee, tdate from items select compname, storeid, address, city, state, country, pcode, telnum, faxnum from store...

Hi all, I'm using CR 11 and trying to accomplish the following: 1. Get the distinct employee names from 2 different DB's for groupings. - Jobs holds the employee name in characters 11-20 in the "reserved" field. - Items holds the employee name in the "employee" field. 2. If the...

Hey all, Using CR XI and I'm trying to select the substring of a field. I've tried using MID(field, start, end) but it doesn't seem to be working. Am I using the proper function name? Anyone know where I can find a listing of CR SQL functions?

Hi all, Using CR XI and trying to select records based on values in an array. I'm getting the following error message "An array's dimension must be an integer between 1 and 1000 when I execute the following formula: numberVar array itemtypes; numberVar counter; if {?VAULT_DEPOSITS} = true...

Hi All, CRXI Just wondering if it's possible to setup finite groups which would display the group names regardless of whether the database contained records for that group.

Hi all, Using CR XI and wondering if it's possible to customize the design of the parameter dialog box that users use for inputting. Is it possible to change the dialog box title and add instructional text?

I need my table and chart to display a zero value for hours that don't have any records. I've tried 2 methods of grouping my data using IF-Then-Else and Case controls. ------ select {@hour} \\where time is stored as HH:MM:SS case 00 : "12 AM - 1 AM" case 01 : "1 AM - 2 AM"... ------ if...

Hi All, I'm creating a report in CR XI that displays customer activity by the hour. My current report groups by MID(string) of a time field. The problem that I have is that hours are only displayed when there is activity for a particular hour, but, what I want is to list all hours and then...

Hi all, I'm using CR XI and creating a report that pulls data from 2 databases; current and archive transactions. Both DBs have the same structure and the only difference is that they're located in different folders. The report that I've made so far is able to pull data from only 1 DB with...

Where do I find the runtime package needed to distribute my reports without installing CR XI onto other machines? As well, are there any distribution limitations on this? If this sort of thing doesn't exist, how do I distribute my reports to non-CR clients? Thanks.

Hi all, Is there a way to manually force the x-axis labels to display at a 45 degree angle? Thanks in advance!

Is there any way I can save a CR11 template as a previous version of CR say version 6.5? Thanks again!

Hi All, Just wondering if there's a way to distribute report templates for users to run on their machines that do not have CR installed. Thanks!

Hi all, I've created a report using CR XI and would like to distribute the report to users who may not have CR installed. Is there some way I can package the report so that users without CR installed can run the report? Thanks!

I've place the fields in the details section but since the tables are joined, field data from Table1 displays data from Table2 regardless... and vice versa. What I want to happen is to list all records in Table1 and Table2 that meet my parameter values. What's happening now is that records...

I have two tables that I'd like to pull all data from which meet my parameter field criteria. So far I've tried linking the tables via the "account" field but no data is listed in the details section. My parameters are starting date, ending date, and account number. I'd like to list records...

Hi All, Is it possible to set a condition for displaying items on a chart? (ie. omitting zero sum items from the x-axis) If so, how? Thanks in advance!

Hi all, I'm trying to add the sums of groups based on certain group criteria. Ie. Groups are 1, 2, 3, 4, 5. I want to add the sum of groups 1 & 3 & 5. Any help is much appreciated. Let me know if I've described the problem clearly enough. Thanks! John