so strange
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.
what's wrong.col1-col4 have data when I test stored procedure on SQL server.
Comments
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 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
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