# of fields allowed in a report

Home Forum General # of fields allowed in a report

This topic contains 2 replies, has 0 voices, and was last updated by  Anonymous 9 years, 1 month ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #457

    Anonymous

    Hello, about a month ago I made a report off of a form I was using , it had 227 field in it and it worked fine, I down loaded my data into Excel.

    Yesterday I tried using the report again with the data collected since I used it last.

    It did not work, after hours of tiring to get it to work I discovered that the report will only now load if there are fewer then 182 fields in it?

    Is this new count 182 something that can be trusted for future reference?

    #5190

    ijobling
    Participant

    Very hard to say. Consider first what else could have changed since the report was last allowing you to ‘export’ to then read into Excel? if you are using the ondemand version then it is Mid Jan since there was an update so could that be involved here? if not, then it could be that the size of the data you are trying to download is now too large for what your PC can cope with for some reason and you should consider looking at a different method to work with your data. For instance do you need to export ALL the data (assuming that your 182 fields refer to fields on the form collecting data) all the time? Have you looked at how in a report you can filter to show specific sub sets of the data or how you can set up multiple report fields to present the data in different ways and then instead of exporting one huge file, export out the specific information you need in more manageable quantities. And over all this if you use the connection agent module, how you can use an ‘insert’ action to write the data out directly to a database table as your users submit the data where they are more capable of working with large data sets

    #5194

    Anonymous

    Thanks for the reply, I gather from what you wrote the report has a maximum amount of data it can export, so if I have more rows I will need to eliminate some columns to stay under the maximum.

    All my data gos into SPSS,I tried using the csv from the migrate option and this worked very well, I hope I will never have to write another report again.

    At some point it seems I will need to get the connection agent as this looks like the best option for exporting data.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.