Recent content by MRWARNER

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!

I have been searching for a solution and have found lots of answers but not the one I needed. I am posting this because I think it resolves my issue but I'm not sure if I will have repercussions from this method. Please respond. In CR9 Crosstabs I am trying to create a % field based on the...

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...

Using SQL 2000 Stored Procedures I needed to pass an ALL parameter back to CR9. I couldnt find any information on this for SQL. I borrowed and altered an idea from a friend and it seems to work just great. Can anyone think of any reason why this might not work? I created a temp table and put...

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...