Search results for query: *

I have about 5 text fields the need to be converted to a number, modified and displayed. When I try to convert, I lost 90% of the number. If the text was .677655576821 and it needs to be converted to a percent with 6 numbers after the decimal, it needs to change to this 67.765576%. Crystal...

I am trying to create a grid layout which there is conditional backround color of a field in CR 8.5. If left({procRptSummaryBySiteGradeSpan;1.vcProResult},3) = "yes" then green else if {procRptSummaryBySiteGradeSpan;1.vcProResult} = "No" then Red else What would I place in here if I want no...

I tried a cros tab, but it will not let it display correctly. Furthermore, I just found out every field in the report has to have a border around it. How do you add single spaces before the borders and flush them together. Due to the powers that be, this is supposed to look like some kind...

Connecting to SQL server: What I need is a table/box structure that is dynamic: Legend Symbol Desc Symbol Desc Symbol Desc Could be 5 or 10 fields depending on parameters. The symbol and desc will be pulled from a SQL server db. While I can get the fields there, I cannot seem...

there are only 2 fields being generated. All from the same table. I have tried a subreport and I get all the data. Problem seems to be in formatting. The borders are spaced and I cannot add the tital bar

I am generating a deatils section in CR8.5. In the page fotter, I need to place a legend there to show what the symbols and colors stand for. I cannot seem to find a funtion in CR that will allow me to create this without making a chart. Is it possible to make a grid or a table to hold this...

what is the char() reference for a tab field? What i am trying to do is create a legend table and I have no chart, just the fields. I was originally hoping just to insert both the key and the descr fields. Well, now I need to add spaces. Was contemplating just drawing a line between the two...

thanks Mike. Sorry madawc. Seems like every day i am on a different version of CR. I will specify in the future

I have several fields I am trying to format in formulas. The problem is when i convert them to text, the formatting keeps changing from what I want. Cstr(int(year(currentdate)))+ "AYP Status" How do i remove the columns and decimals within the formula? I have tried changing the global...

Not sure yet... I modified the query to fid the DB and it has been running for almost an hour. I am glad it only needs to be scheduled once a day.

no... just need one row per id no

I have several rows duplicated in my temp table that contain text and objects. As I am creating the procedure to create the table, is there any way of filtering out to insert only 1 record per ID? I have tried grouping and selecting distinct, however because of the text fields, it will not...

Thanks guys... Both a real help. I have to start finding a specialty. 3 weeks in access, 1 in sql, then back to crystal and VB then back to SQL. My mind starts to get sooo confused at times, but y'all are lifesavers.

yes, there will be several rows with the same proidno. I need some kind of way to take every row (100000) and send those to the output table. I will not have any rows with the same Proidno and role and different employees. I was hoping to do one loop through this or have it processed during...

I think I can do this with a case statement, however, I am not 100% sure of the syntax or how to do this. What I have done so far is created a temp table with all the fields I need. I have 20 user defined fields that I need to export as a single record from a 1-many relationship. I started...

I am removing the first character from the text field. when they swicthed systems, the IDs have an extra character ion the front and I need to remove it to get the query to work.

I need to convert this query from SQL Server to Access. Any help would be appreciated. Thanks in advance SELECT dbo.Project.PROIDNO, dbo.Project.PROOFFICE, dbo.Project.PRODEPT, Employee_1.EMPSNAME AS Pic, dbo.Employee.EMPSNAME AS PM, dbo.Project.PROLNAME FROM...

Somehow my Db is being a pain, I cannot seem to link my sql Server view to access. Keeps giving me an ODBC error when trying to run it. I need to rewrite this query in access. Any help is appreciated. SELECT dbo.Project.PROIDNO, dbo.Project.PROOFFICE, dbo.Project.PRODEPT...

I have a view in SQL serever 2000 that I was trying to link to access. However every time I linked it, I could not open the table. So I need to rewrite this view in access. I am not an access programmer, so my SQL seems to be off in this, even though it runs fine in SQL Server. SELECT...

I am having a brainf*&*t today. Simple string query to remove the first character off of the string. They could be various lengths so just need to cut off the leading char.