How to add Dynamic Colunms in a report
-
I am new in visual studio and i want to know if it is possible to make some colunms on a report to be dynamic so as to allow a user input for a example i have created this report called: Sales Report this is how my Sales Report looks likes. SalesCountry CurrentMonthSales PriorMonthSales Australia 592.809 619.855 England 270.132 546.596 China 186.928 154.576 As seen above in this report, i want to make CurrentMonthSales,PriorMonthSales colunms dynamic so to allow user input because these fields changes dynamically according to user's criteria.A user may want to view current monthsales of December instead of November.
-
I am new in visual studio and i want to know if it is possible to make some colunms on a report to be dynamic so as to allow a user input for a example i have created this report called: Sales Report this is how my Sales Report looks likes. SalesCountry CurrentMonthSales PriorMonthSales Australia 592.809 619.855 England 270.132 546.596 China 186.928 154.576 As seen above in this report, i want to make CurrentMonthSales,PriorMonthSales colunms dynamic so to allow user input because these fields changes dynamically according to user's criteria.A user may want to view current monthsales of December instead of November.
I don't think you need dynamic columns. From your descriptions, the columns are fixed i.e. they are SalesCountry, CurrentMonthSales, and PriorMonthsSales. What you need is a dynamic report i.e. data is provided to the report depending on some input criteria. Assuming you are using SQL Server as the database, you need to create a stored procedure that takes a parameter for the current period, then it returns data to your report using those 3 columns. So, the data is dynamic but the columns are fixed. Since you don't specify what report engine or database you're using, I can't be more specific.