Search results

Thanks for the response guys! I have considered views but this is a read only database (SQL, read only access) and I don't have access or privileges to create a view...(corporation database) I am just using a datadirect ODBC connection to the database..... I don't need to use all the...

Hello All, I am linked to a database that has some tables with fields that are in excess of 255 fields. When I look at them in Crystal, it displays all the fields. Is there a workaround that would allow me to see all the fields? I tried to play around with passthrough but didn't work. Any...

Exactly!!! Thank you very much.....I changed it and wala!!! it works....Thanks to all!!

Thank you I have removed the ( ) and I get the same thing....do I need to refresh something...folder maybe?

Hello All, I am trying to attach a excel file to email. I have the file being exported to a location then I would like for the email to attach but I keep getting runtime saying that it has been moved or deleted....and the file is there... Do I need to put a pause in or something to give time...

Hello All, I have a table that have multiple entries and I am trying to get it all on one line base off of account number. The way the table was set up (not me) repeats the data when I run a query against it. I know I possibly can run a cross tab query that might clear this up but have a...

Thanks guys, I mentioned red tape...I should have said crimson tape....this is a big company..so to get your pencil sharpened can take a week..lol In all seriousness sometime I have to weight how much time it will take to go thru that due to my deadlines....we have to submit a ticket and the...

That would be nice however, that is lock behind a red taped vault..in the fortress of IT...I don't have access to the main tables in SQL

Hello All, I have a linked table in access to a SQL db. However, I run in the field limitation of 255 and the field I need is below the 255 more. If I was able to sort the link table I could possible still get the field I need.....Crystal has this option to do this..(put the field in abcd...

Thanks, I pulled it from Amazon and tried them both Download one of the following, depending on the system architecture of your SQL client tool or application: 32-bit: https://s3.amazonaws.com/redshift-downloads/drivers/odbc/1.4.8.1000/AmazonRedshiftODBC32-1.4.8.1000.msi The name for this...

Hello Everyone, Does anyone know a way around this "Reserve Error (-7713)?" I am trying to link through Amazon Redshift ODBC driver. I am connected and have access to the data however, when I try to link to one of the tables I get this error I have tried the REGIT WorkArounds=8192 fix and...

Agreed... We are talking about old...since whenever databases..... I just work here...in work around city because...problems have been past down from generation to generation...lol I figured as much...but thought I give it a shot... Thanks again guys!

Hey Guys, Ran into a problem I have not encountered before. I am linked to a SQL db that have many tables. One in particular has 403 fields....I am limited to see and use the first 255 any way around this?? Anyway to choose the fields I want....most of those fields I do not even use... The...

Hey guys, Can you use a Hex function in a query or is there a equivalent? Thanks, cg

Ok...I will try it!! :)

Yeah...you are right.... I wish I had time to figure it out...:confused: I think I will just make a copy of the query and name it something that can be searched..... double the queries....double the fun ;) Thanks

Hey Guys, Weird question, Is there a way to search on the description of a queries? Say if I want to make some notes about the query I built because I might need to use it later....or remember how I did it... Any way? or Naa?

It was easier to just make 3 queries and join them....may not be the best way but it works...lol:banghead:

Thanks, I was looking for more in separate fields instead of concatenate... I may have to use 3 separate queries to get them on one line....I thought there may have been a better way....thanks

Hello All, I have a query which list a customer number and a POL Code. When I run the query it list some duplicates...for example Cust # | POL Number | Address --------- -------------- ------------ 12345 - ONL - 56 Chicken St 12345 - PA2 - 85...