so strange

edited 11:50PM in FastReport .NET
I made a datasource from stored procedure, which generate a table with col1,col2,col3,col4,for a report.And put col1,col2 on report head,col3,col4 on the end.but strange,col1,col2's data show correctly,col3 and col4 show empty,however.
what's wrong.col1-col4 have data when I test stored procedure on SQL server.

Comments

  • edited 11:50PM
    Hello,

    You should put data columns in the Data band only. All other bands such as report title, report summary etc may print wrong values because the datasource is in indeterminate state here.
  • edited January 2010
    AlexTZ wrote: »
    Hello,

    You should put data columns in the Data band only. All other bands such as report title, report summary etc may print wrong values because the datasource is in indeterminate state here.
    I put col1,col2 on report title,it's work,col3,col4 on data footer(not page footer),but not.if I exchange them,col1,col2 on footer,col3,col4 on title.It's the same error:col1,col2 work,col3,col4 are also empty.so strange.
  • pinbotpinbot Texas
    edited 11:50PM

    I would test by putting all 4 columns in the databand and see if you get the same dataset as running the SP on the server. I do this sometimes.

    Also, another trick is to edit the datasource in FR and run through the wizard to make sure it picks up any changes in your SP. You can also view the data in the wizard. Make sure it's returning what you are expecting. Perhaps you made changes to the order/types of the SP output?

    I do this if I add a colum to an SP after I've created the dataset in FR. FR does not detect changes to SP unless you run through the wizard again.

    Hope that helps.

    Bryan
  • edited 11:50PM
    pinbot wrote: »
    I would test by putting all 4 columns in the databand and see if you get the same dataset as running the SP on the server. I do this sometimes.

    Also, another trick is to edit the datasource in FR and run through the wizard to make sure it picks up any changes in your SP. You can also view the data in the wizard. Make sure it's returning what you are expecting. Perhaps you made changes to the order/types of the SP output?

    I do this if I add a colum to an SP after I've created the dataset in FR. FR does not detect changes to SP unless you run through the wizard again.

    Hope that helps.

    Bryan
    It's the same error.How can I do?
  • edited 11:50PM
    Hello,

    Something is wrong with your data, or SQL text is not correct. Are you able to view the data in the "Data" window (select the datasource and press the "View Data..." button)?
  • edited 11:50PM
    AlexTZ wrote: »
    Hello,

    Something is wrong with your data, or SQL text is not correct. Are you able to view the data in the "Data" window (select the datasource and press the "View Data..." button)?

    I'v viewed that datasource.But empty with no records,even col1,col2
  • edited 11:50PM
    Could you send me a demo that demonstrates this error? tz@fast-report.com

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.