Recent content by lthomas6

The column labels are attached to the same guidelines. I am choosing all fields and column labels and setting to same height. Is there anything else I should be doing?

Perhaps it may help if I state what the formula field contains. It is as follows: @display = whileprintingrecords; stringvar x; if len(x)>1 then left(x,len(x)-1); This is placed in the group footer. In the details, there is another formula @accum = whileprintingrecords; stringvar x := x +...

lbass- they do move to the left and right this is why I don't understand why they are not working. turbear - i tried that and it didn't help. It actually created 2 additional columns. Any other suggestions?

I have a Crystal 10 report using SQL. For the extra spacing, I did the following and it worked for all columns except for one. - all the headers and fields are the same height and are aligned at the top -used guidelines to link column headers and fields together so there is no white space...

I have a crystal 10 report which was created using an Oracle driver and uses a command object that points to an Oracle database. Now this report needs to point to a SQL database. Is there an easy way to achieve this without creating a new report?

I am trying to to see if the database expert in Crystal has a way where I can put my where conditionals in it instead of the select expert. The issue I am facing is that since I have 8 reports in the report where 5 of them are the same table but with different aliases, it is causing an...

thank you!

I had a make a change to this to have @accum = whileprintingrecords; stringvar x := x + {Entity_1.Name} & " " & "(" & {corptax1.UserFieldValue} & ");" The issue I am having is that sometimes {corptax1.UserFieldValue} can be null. In that case I want it to display nothing. In this case it is...

Ok, I understand what you mean now. I was able to achieve my goal. Thank you!

This report is different. It does not have any subreports. The approach that was used there was creating a group and that will not work in this case since we cannot have the data grouped but display in details section. Let me know if I need to provide further information on this for...

I have a crystal 10 report using sql backend which pulls the following data. This report does not have any groups and is pretty straightforward.The details secion is where all the data lies. There is one field which displays ownership info for an entity. ie: taxcode record# Entityname...

Thank you, that worked!

I have a crystal 10 report using sql backend with following setup Group header displays the following: _______________________________________________________ Matter Type: Commercial Contracts _______________________________________________________ Details section displays the...

Thank you.

I am now able to get it all to work. This error was due to a null value so I updated the @display formula to read: whileprintingrecords; stringvar x; if not isnull({Entity.Name}) then left(x,len(x)-1) else " ";