Search results for query: *

Thanks for the help lbass. I have two problems with the running total lines. The header line includes the total for the first line on the page, which it should not. Also, the footer line does not appear on each page, only at the end of the sub-report. I tried using beforereading instead of...

I have a subreport which generates an invoice which usually runs for several pages, one item per line. I have been asked to add a line at the top and bottom of each report page which contains the running total carried forward from the previous page (top) and the running total at the end of the...

Found my problem. The second argument to OleAdapter.Fill must be specified. OleAdapter.Fill(AirspaceDataSet, "bill_airspace");

Not sure what you meant by "comment out the selection". I set sqlcmd to blanks, and SetDataSource returns Command text was not set for the command object. Neither of the columns in the table contain nulls.

I have a working CR report which uses an oracle database for a data source. I am modifying it to use an ado.net (visual studio 2005/C#) dataset as a data source. I am following the procedure described in Business Objects "Crystal Reports for Visual Studio .net Reporting Off ADO.Net DataSets"...

I have developed a web application which uses a crystal report document to connect to the database, generate the report and export it to pdf. The application is written in .Net as a web application using c#. The report has several sub-reports (6). This all works well. However, the report...

Ooops. I forgot the hyphen in the sub-report parameter name (i.e. pm?InvoiceNumber instead of pm-?InvoiceNumber). THanks for the help.

I'm not sure I understand "have you linked to something?". I've linked a parameter in the main report (InvoiceNumber) to a parameter in the sub-report (Pm-?InvoiceNumber). For now, I've included this as a display field in the sub-report. Werner

I have a main report which contains one sub-report. I am trying to pass parameters from the main report to the sub-report by setting up sub-report links. Some of the parameters work (always the same three). With the other parameters, I define the sub-report links, but when I exit from and...

I have it working now. I started a new report from scratch and everything works as it should. Passing parameters in crystal seems to have a lot of glitches it it.

I have a report which does several queries based on a single date parameter supplied by the user. I would like to be able to have the user enter the date in the main report and then have the date passed to the sub reports (via edit / sub report links) This part works okay. I would also like...

I've identified the problem but haven't got a solution. I've used the same parameter name in the main report, the sub report and in the query within the subreport. CR is smart enough to determine that the parameter should only need to be entered once, but within the query it does not use that...

I am using Oracle 9.2. The problem is not with the oracle query but with what crystal does with the parameter. I tried the change you suggested (removing the trailing ") DUTY_DAYS_AIRCRAFT" from my original query and get no rows returned (because the "where mdr.rlvnt_dt =...

I am using crystal reports 11. I am using the database expert to create a virtual table using an SQL command. I am trying to pass a date as a parameter to the command, but it is always evaluated as today's date. If I print the parameter in the report header, it is correct, but if I select it...

Got it now. Thanks.

The formula doesn't appear in the data tab. The formula is: WhilePrintingRecords Global AccCnt as Number Global AccTm as number Global LastId as string if {Sheet2_Print_Area.Region} <> LastId then AccCnt = 0 AccTm = 0 LastId = {Sheet2_Print_Area.Region} end if AccCnt = AccCnt +...

I have a data set consisting of N rows of M values. I would like to create a report consisting of one bar chart for each row where the value of each column is represented as a bar in the chart. The logical thing to do would be to place the chart in the details section of a report, but crystal...

SV, That's what I was trying to do. Thanks. The two CR books I am using for reference do not provide a lot of information on formulas.

I have a data set which has summarised events on a monthly basis: Region Month Nbr_Evnts Evnt_Time I would like to generate a chart of this data summarised year to date. I cannot use a simple average on evnt_time because the average time must be scaled proportionately to the number of...

I'm using crystal reports XI and am trying to implement a function. Is there an if/endif construct so that I can include more than one statement following my if statement? In the example below, I have to repeat the if statement twice, once for each statement I would like executed...