Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: wreiche
  • Content: Threads
  • Order by date
  1. wreiche

    running total at the bottom of each page

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

    CR Report from ado.net dataset contains no data

    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"...
  3. wreiche

    Disconnecting Report Object from database

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

    sub-report parameter links do not stay set

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

    passing parameters from subreports to sql queries

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

    Date in SQL Query is always today's date

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

    Generating one bar chart per row in data table

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

    Charting the output of a formula

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

    formula problems

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

    Year to date rollup in charts and reports

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

    formulas as parameters

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

    Crystal Report XI Chart Expert Stacked Bar Chart Interface

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

    Using parameters in a command query

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

    Passing Parameters from main to sub reports

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

    how to edit suppress condition on page header

    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

Part and Inventory Search

Back
Top