Search results for query: *

Hey thanks for all your help with this question and others! It was a record selection issue...i had a <> to 0 condition that was causing the error...thanks!

Hi, I'm using CR XI with an excel database. I'm trying to create 3 outputs for one group based on three separate date ranges. The ranges are pulled from parameter fields. They are: Week (Start/End) - WTD Month (Start/End) - MTD Cumulative (Start/End) - Cum My report looks something like...

Not sure if I should start a new post or continue this one... I now need to get these values to print out in a group. I have a group of error codes, so it shoudl go something like this: Error code # a 5 b 9 c 0 d 2 I have an example report...

Thanks LB! Your code work...if it's not a bother, would you mind explaining why the negative (if its not null and not = the value then 0, else 1) check works but not the positive one (if is = to value) ??? Thanks so much! Joe

Hi, I'm using CR XI with an Excel Database. I've tried a few ways to do this, but I was given an example where this worked, so now this is what I'm trying: I need to consolidate data from 3 columns. The database must stay in Excel, so a Command Object based on Access is out of the question...

Thanks. Could I also ask what the proper syntax is??? File Name: C:\<file path>\Working Copy.xls Table Name: TestDB Here's what I've tried so far: Select * From "C:\<file path>\Working Copy.xls"."TestDB" Select * From 'C:\<file path>\Working Copy.xls'.'TestDB' Select * From 'Working...

Hi, I need to write my own SQL statement because I have 3 distinct columns with the same data elements. The only way I could find to combine them into one element on a report (to summarize) was to create a Command Object through a SQL statement...then I could Union the elements together into...

Hi, Using CR xi with an Excel 8.0 ADO Database connection. I am trying to write my first CR SQL Statement and can't figure out the proper syntax to connect to a table. Can someone please help me...i've searched everywhere :( and can't figure it out. I'm trying something like Select...

Awesome...i'll give it a try...thanks so much! joe

Hi, This is my second attempt at a post for this problem...i'm new to the forum, but i'll do my best to describe my problem. I'm using CR XI to access an Excel database. The data is arranged as follows: Transaction Date[tab]Error Type 1[tab][tab][tab]Error Type 2[tab]ET3...

One other note: I've been able to group by each column (i.e. Count of Major Error 1), but what I need is: Major Error 1 + Major Error 2 + Major Error 3

Thanks for the heads up on format, that was my first post. I'm using cr xi with an excel database. Example data: Major Error 1 Major Error 2 Major Error 3 Error text (8) Error text (2) <Empty String> <Empty String> <Empty String> <Empty...

Hi, I have a database with 3 fields that contain the same data. They record up to three errors in a transaction. These errors are of the same group(Major or Minor). They can have multiple types (majorError1...n, minorError1...n) In my report, I want to group the three columns together and...