Search results for query: *

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 " ";

I have 2 subreports for this report. Each pulling the same data but for different types of role_cd's. I have 1 subreport call srPrimaryLegal where I have created the 3 formulas below: @reset: whileprintingrecords; stringvar x:=""; @display: whileprintingrecords; stringvar x...

Sorry about that. There are no formulas. In the subreport, it is one field placed in the details section.

I have a crystal 10 report, sql backend using 2 database views. The main report usese only 1 db view. The issue lies in the 2 subreports which use a separate db view. For the field matterplayer in the subreport, it can return more than one matterplayer. If so, it needs to be separated by a...

I figured it out. instead of going to prompts, I pulled directly from the source using the below and it works fine now. If {V_CUSTOM_RECTYPES_FILTERED.RECORDTYPE} = 'NYSE Cases' or {V_CUSTOM_RECTYPES_FILTERED.RECORDTYPE} ='Expedited Cases' then "Statistical Overview of "...

In my case not sure if {?Disciplinary} = True and{?Disciplinary} will have same logical result since each of the parameters is set to a boolean. ie. the prompt {?Disciplinary} is type of boolean where the values are either True (if checked) or False (if not checked). I tried the explicit parans...