I probably don't have the security settings to see the table. Atleast thats what my coworker thinks as well. I hope that there is a way to right a formula in order to insert these employees portraits beside their name. In the book it shows the table name as portrait and the following under...
Thanks for the reply! However, it looks like I have to look further into the SQL and ODBC in order to figure this one out because it's not part of the CR 8.5 tables that I have already. The sad part is, I know nothing about SQL or ODBC. I guess the tech who set up all the other tables didn't...
Hi lbass,
It's me again and I am confused as to why one of my tables in CR 8.5 isn't listed, it's called: portrait. I found the SQL script file where it is listed as Cr_portrait along with all the other script files which are listed in CR for me to select from when I make my other reports. I...
Hi lb!
Who's da Man? Da Bass Man!!! > {lb} I finally inserted the group the way it was supposed to be then I used the that formula of yours and it was magic to me. I can't thank you enough. I think my headache is finally subsiding. Lastly, yes my main goal was to produce a report of all of...
Allow me to clarify this statement:
The badge number and badge proximity number can both be the same numbers or different numbers in one cardholder's profile but no two cardholders can have the same badge # nor have the same proximity number as another cardholder therefore each badge # and prox...
IM sorry for the confusion,I've only took a 2 day course on crystal reports 8.5 and I've had about a year of reading help files when time was available. So IM definetly a newby. IM using Crystal Reports 8.5 and the database is ODBC/SQL
Example Data and Expected ouput is the following for...
IM sure your formula would of worked have I given more of a landscape view of my tables. There are 3 tables in which I can get data from, i.e. company,cardholder,and badge. I add company name into my report from that table, I add {cardholder_lname} + "," + {cardholder_fname} from Cardholder...
I have a table called Disabled which holds two numbers: 0 and 1 0 = Active 1= Disabled
I can find all my active profiles because the rule is that every profile can only have one Active instance but have multiple Disabled instances within it. So, I have two types: one has just disabled...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.