General information
Category:
Reports & Report designer
Hi Steve,
Thanks for the response. Guess I should be a little less concise. What I have is a situation where I have to allow the user to pick any number of items from a list box which contains friendly names for actual table field names and non table entries which are calculations involving various table fields (percentages,efficiencies,actions/time,etc...) all of various data types as well as the columns for the report. The only way I have been able to get this onto paper is to SELECT everthing from the SQL Server using CAST and CONVERT functions and forcing everthing in the returned dataset into character, then concatenating the selected fields together and copying this conglomeration into another cursor that is used as the data source for the report. The report form has a single variable for the column string in the header and a single variable for the row string in the detail section. My problem is, is there a standard way to tell the code when to use the Portrait report form or Landscape report form other than on the length of the column/row strings? I use a grid on a form to display it without any problems. Hope this makes sense. If you have a better (or different) suggestion on how to approch this, I'm all virtual ears.
Thanks,
Keith
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only