Home rbuser Comments
New Blog Posts: Merging Reports - Part 1 and Part 2

rbuser

About

Username
rbuser
Joined
Visits
1
Last Active
Roles
Member

Comments

  • Using parameters on the query.
    It has nothing to do with RB in particular.
    Just create a query like:

    SELECT ...
    WHERE YourDateField BETWEEN :DateIni and :DateEnd

    Then set the proper values to the parameters
  • That's what I want to do but how do I limit the query based on the dates he
    supplies. I don't see with RB how to insert a variable. LL
  • Why don't you create a form to ask the user the dates tange he wants to use and
    then open the report?

  • My appoligies for the crosspost. someone told me I should have posted to the
    DADE group.
    Anyways, ppdaLastRecord is in the pipeline state. I thought that I had a
    problem with a column header/footer that was on the report even though t…
  • If not using DADE, how about using your queries with aliases for the field names
    (You'll have to change the queries anyway)? In that way you shouldn't have to
    change nothing on the reports.

    SELECT
    Field1 as OldField1Value
  • Hi Vinnie,
    The problem actually was NOT fixed in the version I sent you!
    That's why it's reverted back to the original code.

    RBuilder uses the component name rather than the database name
    in their dialog. That …
  • Jon,

    At one time (several months ago), you had sent me a copy of the unit with
    this issue corrected. I've noticed it is now back to the way it was and
    requires the db name to match the component name. Will this be corrected
  • I've added a warning about this on the web site.
    It is buried in the documentation but it is easily missed.
    Hopefully everything is working OK now.

    Jon

  • Vinnie,


    Renaming the DatabaseName to be the same as the component name made it
    work, thank you very much!

    J. Michael Eubanks
    Ideal Software Systems
  • How about the DataDictionary component? My guess would be that since the
    list of tables and files is based on the data dictionary, it may be related
    to the problem. Is it possible one of its properties like DatabaseName or
    Session i…
  • 1. This is apears to be random

    2. Thank you, wil look in to it.


    Yours truly,

    Paul Menheere

    "Alexander Kramnik (Digital Metaphors)" wrote
  • Paul,

    what happens when you change the color to clRed?

    regards,
    Chris Ueberall;

  • I am using windows colors ( clBlack) only

    regards,
    Paul


  • Hi Paul,

    when using system colors (e.g. 'clInactiveCaption') there could be
    differences from machine to machine, because system colors are depending on
    the user's display settings.

    regards,
    Chris Ueberall;
    <…
  • Joseph,
    Sounds like a church database to me

    Based upon my work with index cards/labels you would want
    a static detail band. How are you assigning the data to the
    band now?

    I've avoided the proble…
  • In article <3d29f802$1@dm500.>, "Alexander Kramnik \(Digital Metaphors\)"
    says...
    |Though we see great potential in the Linux theater, we must make our
    |decisions based on business realities. Therefore, we currently have no pl…
  • Hi

    I know there are other posts regarding Kylix, but most seem from some while
    ago and I'd like to understand the current thinking / plans at DM, if
    possible

    Thanks

    Clive
  • the problem couldn't be solved with any of your guidelines... instead, David
    McNeill solved it (.public.reportbuilder.subreports): I had to set the
    StopPosition property to something like PaperHeight - MarginBottom - ..
    no it works!!<…
  • Don't worry, it would appear that the problem lay in a combination of
    A) Size of the chart
    B) Size of one of t…
  • I am also trying to do something very similiar, i.e. show only the details
    for upto detail count to a certain number(N). I tried the following:
    Place a DBCalc component in the detail band and set calculations
    to count. This will numb…
  • i'm using an SQL query to grab all records I want to print data from paradox
    tables then I print. the bigger time sink seems to be in the printing and
    not so much in executing the query.. would TkbmMemTable speed up the
    printing? …
  • I tried this using an HP LaserJet 4Si, and didn't have the problem. Why
    would this happen only on certain printers?

  • I'm using Windows 2000 Professional, with RB v6.03, and an HP LaserJet 8000
    Series PCL 6 printer (mapped network printer). If you turn on "View->Debug
    Windows->Event Log" while the project is running, you can see the printer
    dr…
  • Hi Tom,


    same procedure as always?
    Why don't you guys use the announcement group for that kind of information?

    Chris Ueberall;
  • Yes, absolutely.


  • Did you set the AllowSaveToFile property of the Dessigner to true?

  • Check TppReport's PageNo and AbsolutePageNo and AbsolutePageCount properties in
    the Online help.

  • Where do I change pagenumber variable and where should I check the
    pagenumber variable?

    Thanks


  • I'm not sure but, guessing a little:
    1. The invoice should be a subreport of the customer report.
    2. Check the PrintBehavior property of the subreport. There's a pbSection type
    that seems to do what you want.

    For the second…
  • Tom,

    Is it possible to setup a pipeline that isn't tied to a data table? I'm
    getting the info I want to put in the chart from about a dozen pipelines,
    but there's not any way I know of to put all that info into one pipeline