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: benr
  • Order by date
  1. benr

    subreports and Oracle stored procedures

    Hi All, <br> <br> I have a report with 3 subreports. The main report and each subreports get their data from stored procedures to Oracle 8(different stored proc. for each reports). <br> <br> Each stored procedures gets parameters (dates...) and run a query against a view. Each stored procedures...
  2. benr

    How to return mutlirows recordset to Crystal Report 7

    Please disregard the last sentence (I would use Stored Procs.) in my previous message . <br> <br> Forgot to clean-up ;-). (Although I wish I could use stored proc). <br>
  3. benr

    How to return mutlirows recordset to Crystal Report 7

    Hello All,<br> <br> I am using Crystal Reports 7 to build reports for Oracle 8.<br> <br> Usually, my reports call views from Oracle. But for some reports, I need to calculate data as the data is gathered. <br> <br> So my question is the following:<br> <br> Is there a way to return multirows...
  4. benr

    Error using a view created in Oracle 8.3

    I found what the problem...<br> <br> When using subqueries, alias for tables should all be different otherwise the driver ODBC seems to misread/mix them.<br> <br> I fixed that and now it works.<br> <br> Weird... :)<br>
  5. benr

    Error using a view in report created with Crystal Report report design

    Carp,<br> <br> That's what I believed but not so.<br> <br> I found what the problem was though...<br> <br> When using subqueries, alias for tables should all be different otherwise the driver ODBC seems to misread/mix them.<br> <br> I fixed that and now it works.<br> <br> Weird... :)<br> <br>...
  6. benr

    Error using a view created in Oracle 8.3

    Hi All,<br> <br> I'm building reports that gets its data from Oracle 8.3 through Intersolv ODBC driver. <br> <br> I've created a view (fairly complex one) where subqueries and union are involved. When i run the view in Oracle ( select * from view) all is OK. The data appears.<br> <br> My problem...
  7. benr

    Error using a view in report created with Crystal Report report design

    Hi All,<br> <br> I'm building reports using Crystal Reports that gets its data from Oracle 8.3 through Intersolv ODBC driver. <br> <br> I've created a view (fairly complex one) where subqueries and union are involved. When i run the view in Oracle ( select * from view) all is OK. The data...
  8. benr

    Assistance with Learning VFP

    Hi Spook001,<br> <br> If you are looking for help and advice on VFP, you should visit Universal Thread web site. It is THE web site on VFP<br> (http://www.universalthread.com/).<br> <br> As a member (free of charge) you can ask questions to the VFP community (the top guys in VFP are...
  9. benr

    Any Chicago Progress coders out there?

    There is a bunch of us, here in Montreal (Canada).<br> <br> We thought that PROGRESS was big in the US, according to the peg (peg.com) site.<br> <br> Anyways, there is some work around here in PROGRESS but the community ( developpers and companies requiring PROGRESS) is small.<br> <br> If you...
  10. benr

    Crystal Report and ORACLE

    We are thinking of using the Notes client.<br>
  11. benr

    Crystal Report and ORACLE

    databarn,<br> <br> Thanks for the reply.<br> <br> I know I can do this if i was launching report from VB or VFP (or any other language). But can I do this within Crystal Report?
  12. benr

    Unnecessary space in a report 'between' sections

    I do not know if that will apply...<br> <br> I did some work with PROGRESS 4GL and we had the same kind of problem, except it was with the report writer included with PROGRESS.<br> <br> Anyway, we found out that we had to be real careful with the font that we were using, especially if it was...
  13. benr

    Crystal Report and ORACLE

    Hi, <br> <br> I am using CR7 with ORACLE 8. <br> <br> I&lt;m designing reports that will be launched through Lotus Notes. I will produce a exe file for each report. Some of the reports have parameters, some other dont. <br> <br> My problem is that every time i launch a report, the report needs...

Part and Inventory Search

Back
Top