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...
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...
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 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 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...
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...
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...
I've got a report that should contain two charts. The first contains the average processing time of data sets summarised by region for the previous month. The second is the average processsing time of data sets summarised by region for the year-to-date. Is there an easy way to do this in the...
I am using Crystal reports XI 11.0.0.1282.
I have data parameter which is linked to several sub reports where it is used for data selection and display.
I have also implemented a formula which displays the date in a more user friendly (and bilingual) way. I would like to make the formula...
I created a stacked bar chart and tried to modify the legend for it by using the colour highlights tab within the chart expert. When I select the tab, the report is regenerated about 4 times (the parameters form pops up and I have to click cancel 4 times). Each time I make a change in the...
I am trying to generate a report which extracts data from an Oracle database using a database command which has two parameters - the start and end times of the data to be extracted. The query works if the date/time selection criteria is removed, but returns all rows. The query also works if it...
I have a main report where I have the user enter the start and end of the time frame in the report. I am trying to pass these to a subreport. From the main report, I am using "edit / subreport links". I select the subreport and try to add the parameters to that subreport. However, when I try...
I created a crystal report from a blank report. The page headers do not print on even number pages because the page header has suppress set to "remainder(pagenumber,2) = 0". The formula is greyed out so I cannot edit it from the formula workshop. How do I modify this?
Werner
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.