Search results for query: *

Hi LB I did have to put the grouping back in, I lost my order when I reopened the report. Didnt realize I could have just sorted. Thanks - Again! [thumbsup2] PS: I have taken 3 different Crystal classes over the past years and they all touched on variables but never went into in depth...

If that is not the coolest thing I have seen I dont know what is. lbass You have helped me more more than once and I am in debted to you. I dont understand the coding with variables, I dont know if I ever will, but this was beautiful. Thank you, Thank you! [bigcheeks] Michele PS:I removed...

Help please, Using Cr9/SQL DB, Crosstabs: I want to add a column to the left of my row header(name)displaying a numerical sequence (1,2,3,4,5 etc....) I guess it would be like numbering the row header but I want to keep the row header (name) as the alpha sort. We will be adding new names each...

Once again, Your Brilliant! Thank you it's perfect and it sorts in the right order too. I voted for you, again. Michele [2thumbsup]

I need help with this too. I have CR9 I have multiple years to report on and when I use Month as the column header (in crosstabs)and Year as a row header the results display months for each year, so I have 2 or 3 sets of months as headers. I only want the month to display once on top like this...

To line up labels and fields you will want to click on both then right click and choose ALIGN or SIZE. Play around with this awhile and you will have everything lined up and even in no time.

Hmmmm, The way your mind works is amazing. I'll give that a try. Thanks

Thanks, this was a great tip. Do you know how we could do this with the summarized fields and the totals? Thanks again!

...duplicated the syntax in Saved for the %Saved field then added the division (({table.total_charges}-{table.REPRICED_AMOUNT})/{table.total_charges})*100 When I added this field in the Summarized area in Crosstab Expert I changed from default SUM to Weighted Avg with table.total_charges. So...

Was your report recently updated from CR8 or CR8.5 to CR9? Does it have Sub-reports, if so how many?

No recent changes and hundreds of other reports work perfectly fine. Thanks for help. Michele

I am not a developer, I cannot alter the VB application. This code is the suggested fix by (BO) Crystal Reports Knowledge base. I am now guessing it is VB code and not something I can fix within CR9. I have reset the datasource in CR9 on one of the reports and that didnt work. Can you let me...

...IS NOT NULL AND PROV_CRED_PEND.Date_unpend IS NULL AND GETDATE() between Vendor.EFF_DATE and Vendor.EXP_DATE IF @STAT NOT LIKE 'ALL' DELETE FROM #CS WHERE CREDSTAT NOT LIKE @STAT IF @PROD NOT LIKE 'ALL' DELETE FROM #CS WHERE PRODUCT NOT LIKE @PROD SELECT * FROM #CS

Have some reports (CR 9.0) that I open in a vb6 application, the db is SQL 2000 – I am connecting with ODBC If I run the report in crystal I have no problem, when I try to open it in Application I get this message : Logon failed. Details:2800:[Microsoft][ODBC SQL Server Driver][SQL Server]Login...

Have some reports (CR 9.0) that I open in a vb6 application, the db is SQL 2000 – I am connecting with ODBC If I run the report in crystal I have no problem, when I try to open it in Application I get this message : Logon failed. Details:2800:[Microsoft][ODBC SQL Server Driver][SQL Server]Login...

Have some reports (CR 9.0) that I open in a vb6 application, the db is SQL 2000 – I am connecting with ODBC If I run the report in crystal I have no problem, when I try to open it in Application I get this message : Logon failed. Details:2800:[Microsoft][ODBC SQL Server Driver][SQL Server]Login...

Using CR9 - I am getting the same error and have found this same code in the Crystal Knowledge Base. Unfortunately I dont get it. Where am I suppose to write this code? I understand I am getting this error due to writing this report in 8 and then updating to 9. I have many other reports I...

I didnt know that - OOh thank you so much. This may resolve some other issues I was having. Very Good!

Perfect - This works great, and yes these are single values Thanks a bunch I am curious though, why would it behave differently when all that was done was to flip flop field name and parameter?

Here is my code for Parameters that will allow a one or all type search with the (one) being a wildcard search. ('*'+{?Name}+'*' LIKE {@Name} OR {?Name} = "ALL") AND ('*'+{?Insureds}+'*' LIKE {@ssn} OR {?Insureds} = "ALL") I am using Crystal Reports 9 - When I use this with the WildCard "*"...