Search results for query: *

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

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

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

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 am using Crystal 10 with sQL database. I have a main report with multiple subreports. 3 of the prompts needed for this report are 3 fields from 3 of the subreports. How do have the report prompt for these 3 prompts(as date). These 3 fields are currently not prompts in the main or subreports...

I have a crystal 10 report with sql backend. My main report has 8 subreports. One of the subreports(RR) has a field called requested Response. this field returns a date value. The second subreport (IR) has a field called initial response which returns a date value. What I need is the value...

I have a report which has several columns. The first column has a subreport to calculate reserve. The second column has a subreport to calculate cost. There is a third column in the report that calculates the value. So it has a formula which = reserves - costs. The issue I am seeing is that...

I have a report which has several columns. The first column has a subreport to calculate reserve. The second column has a subreport to calculate cost. There is a third column in the report that calculates the value. So it has a formula which = reserves - costs. The issue I am seeing is that...

This is a Crystal 10 Oracle report. I have a report that has 1 subreport. In the subreport there is a prompt for select userfield. When the report runs, the user is prompted for some prompts. The user will also like to be prompted by a parameter in which it will allow them to sort/group by the...

I am using SQL and Webi.I have to calculate the Month name from a number field. ie: month_date_closed = 1 in the datab ase, however I want the report to display January. the below code achieves this however the month_date_closed is a prompt in the report. How do I have the below logic altered...

I am using Crystal 10 SQL backend. I have 2 subreports in my report. first subrport has a summarized field called reserve_total Second subreport has a summarized field called cost_total I want the main report to display the subtraction of reserve_total - cost_total. how can I achieve this?

I have a Crystal 10 report connecting to a Oracle 10 db. When the selection criteria is set to below, the report pulls in the record fine: ({USERFIELD.USERFIELDPROFILE_ID} = 10059.00 and {USERFIELD.USERFIELDVALUE} = 'True') and {MEMBER.RELATIONSHIPCLASS_ID} in [1020,1030] and (day(currentdate)...

I have a Crystal 10 report which uses SQL db. The report uses OLE DB and has 4 tables and 3 subreports. I need to add a table however the table has no joins to any of the other tables. It is a systemsetting table so this should be fine. Crystal gives error of "Failed to open a rowset. Query...

I am using a Crystal 10 report pointing to a SQL db. I have a report with a paramter 1..Cancelled Equity. This is a boolean checkbox parameter that is automatically set to default to false. The selection criteria is: ({?CancelledEquity} = FALSE AND isnull{Security.CancelDate}) or...

I have a report which has a subreport. The subreport has a field called Change date. I need to pull the most latest Change date. This subreport pulls data from a single table. The main report has a parameter field called Todayprompt. The report should pull the latest changedate and this...

I am using Crystal 10, SQL backend. I have created a report with 1 subreport. The main report has a field caled Parent Matter Budget Amount . There is a field called Total Matter Cost in the subreport (it is the calculation of the subtotals in this report). I need to subtract the Total Matter...

I am trying to create a report which will do the below. Please assist. I am using Crystal 10 against an Oracle database. 1. Can we "Auto Select" dates based on the date a report is run. For example, if the report is run on any day from the first of the month through the 14th of the month...

I am running a Crystal 10 against a SQL database. Notice ID Date 10011 2009-04-03 23:20:56.187 10011 2010-05-13 13:50:31.560 10011 2010-05-14 10:05:48.693 I am trying to capture into the report 2 things: 1. the first sent notice and 2. the last sent notice. This should display in the report...