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...

Man... I tried that using the MID function... haha thanks K! Works great!

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?

Thanks for the insight K! Helpful as always... I removed my formula from "Select Expert Formula" and created a custom function accordingly to clean it up. As for the employee selection problem: if teamAll = true then true else employee = teamID Thanks again! Until next time... Cheers!

Sorry for the poor description.. let me try again.. I'm ultimately trying to select the records based on user inputs. I've used boolean values to control whether or not records with specific values will be included in the report. I think I've been able to complete this task except for when...

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 enlarged my test dataset which has revealed a bug in my report... =( It looks as though groups are created based on the records from my main report. The problem is that records contained in the subreport that do not fall into one of the groups created in the main report are omitted. (Main...

Great! Thanks for pointing me in the right direct LB. I was able to find a whitepaper on passing the print-time formulas to a subreport. Just out of curiousity, could I have approached this a different way? (ie. Other than passing shared variables to the main report to create the table and...

So I got my tables to work using the sample\logic you provided LB.. Many Thanks! Now, I'm trying to create a chart and depending on which summaries I choose: - I'm unable to use the summaries as values (don't show up in list) - Get the message, "A print time formula that modifies variables is...

Ok, so here's the scoop... I'm trying to summarize data from an archive DB with the current DB. There are two problems that I've noticed with my implementation thus far: 1. The shared variables don't seem to be resetting to 0 on change of GH2: Subtype Subreport Links - cardtype, subtype MAIN...

Ahhh yess... that just proves how good you are LB... worked liked a charm!! Well, at least my test data worked... lets see how the full implementation goes... =) Thanks again!

So I've made my shared variables and successfully passing data to my main report.... Now how do I tie the groups in my main report to the subreport? What I currently have is a count for all records with 2 groupings and my shared count variable doesn't reset on the change of the groups in my...

Alrighty, so I was charting the summary values rather than formulas... but now I don't have any x-axis labels... so close... :)

Ok.. so now that I have my table of value... how do i chart my x-axis values? I've selected all the summary formulas for the "Show Values" but how do I setup the "on change of..."

Thanks for the help LBass!!!! I got your solution to work!!! Created a single formula for each hour along with running totals... No grouping required! Cheers!

Great so the algorithm may work, but i'm not sure how to put it into code.. :( Here's what I have so far: @hour is - numberVar hour := ToNumber (Left (ToText ({Trans.TTIME}), 2)); I group on @hour and it only displays values for hours containing records otherwise the hour is omitted. How and...

Is there a way to code my report in such a way so that for each hour... if records for the hour = 0\null\empty... then returns a 0 to the table\chart.. Thanks