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 Mike Lewis 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: *

  1. Varith

    Converting MYTYPE* to MYTYPE (impossible ?)

    There is no reason why you can't just call doSomething (*a). Its valid. Of course if you control the doSomething call, you may want to change it to match up so things are less confusing.
  2. Varith

    Dynamic Parameter

    Crystal Reports 11 will do what you are looking for. If you can't upgrade to that, I think you would be stuck doing the work yourself via the ReportDocument object and your own database calls. I just got finished doing that for a web app myself -- they didn't want to switch to 11.
  3. Varith

    Why does my stored procedure need to be reset

    I haven't much tried it with XI (I'm using 10 at the moment) but I've found that when using stored procedures its better to use the Oracle drivers rather than OLE DB.
  4. Varith

    CrystalReportViewer hitting the database after every page

    Well from what I can tell it adds some parameters to track the some state information (such as web page) and then goes back to the page that has the viewer component every time it switches. So if I just set the report viewer to the datasource it loads up the whole dataset again. I'm...
  5. Varith

    CrystalReportViewer hitting the database after every page

    Thanks SV but that doesn't seem to work. It seems feeding CR datasets or just exporting the whole thing to PDF and viewing it is the best way to go in the long run
  6. Varith

    CrystalReportViewer hitting the database after every page

    I'm using CR 10 Developer version, using the .Net CrystalReportViewer object. I have a report that calls an Oracle stored procedure to obtain a fairly small (< 100 rows) dataset. In the RDC refreshing the report only calls the stored proc once. CrystalReportViewer seems to hit the stored proc...
  7. Varith

    A different grouping in the report footer.

    I have a report that shows summary data grouped by Territory/Company/Business unit. At the end of the report there is a summary table of the same data grouped by business unit only. Right now I have a subreport in the report footer. The data for both the main and subreport comes from a stored...
  8. Varith

    Getting a single value from grouped rows

    Mufasa, You are right, it works, It is just that the execution time for the query (which is a little more complicated than I showed) jumps from 3-4 seconds to 25-30 when I add in that extra select statement. Sem, Yeah, I pointed out the ordering problem also. Specifically the values 'N'...
  9. Varith

    Getting a single value from grouped rows

    I'm trying to figure out an efficient method of grabbing the first value in a column where the rows have been grouped but I do not want them grouped on that particular column. I have a table that looks like this: TRANSNUM TRANS_CODE --------------------------- 1 RN 1...
  10. Varith

    Share Your IT Horror Stories

    My favorite horror story was (almost) completely self-inflicted. I was working my first programming job as the first employee for a company that made card access systems (the type that unlock doors). One of the owners of the company had designed the hardware and firmware for the card readers and...
  11. Varith

    RAS: Using Formulas for sorting

    I'm having a problen using RAS. I need to programmatically create a formula field to be used in a sort. When I create the field using RAS and save it via the formula controller, the IsRecurring property is set to false. However this is a recurring field and the sort controller will not accept it...
  12. Varith

    Very wide reports?

    I've had a request to be able to let users select an arbitrary number of columns dynamically then have those columns show up in the DHTML viewer regardless of the report page size. That is, the user should be able to scroll way to the right and see columns that would not normally show up on the...
  13. Varith

    Pass Parameters to report issue! Help

    Are the parameters being passed in very long (> 256 chars)? There is a problem, with a patch though I forget which one, with long parameters. Actually even with that patch I kept running into problems when parameter sizes rose above 500 characters. Eventually, on Crystal's tech support...
  14. Varith

    Setting landscape in RAS

    Thanks. I'm have found something that *almost* does what I need. If I get the report from the InfoStore and go into Report.PluginInterface.ReportPrinterOptions and set .PageLayout to 4 and .LandscapeMode to true and save it back into the APS, then the DHTML viewer, at least, displays landscape...
  15. Varith

    Setting landscape in RAS

    Does anyone know how to programmatically set up a new report, created through RAS, to use landscape rather than portrait? I can go into the report designer, set the printer to &quot;No Printer&quot; and switch it from portrait to landscape but I can't seem to find a way to accomplish the same...
  16. Varith

    Getting error using TTX file

    I am writing an application that uses existing reports to create new reports (much like ePortfolio does). I have developed one report usign a TTX file and save it to the APS. When I try to use RAS to copy the table defined in the TTX file (using DatabaseController.AddTable) I get an error saying...
  17. Varith

    Using COM viewers with C++

    Has anybody called the enterprise 9 COM viewers from C++? Specifically I am trying to use CrystalReports.CrystalReportViewer's GetHtmlContent function. I pass it 2 IDispatch * (the request and response objects, passed from a web page) and a _variant_t set to VT_NULL for the session parameter...
  18. Varith

    Threading, COM and the RAS

    I have some reports that are retrieving there data from COM+ components. It works fine when no errors are encountered but if the component hits a snag and exits, the RAS reports that no rowset could be found (which is fine) but then, on the next call to that component, it will get hung up and...

Part and Inventory Search

Back
Top