Page 1 of 1
Execute reports without databands?
Posted: Mon Jan 13, 2014 5:38 pm
by theregister
You know you usually drag and drop a data source into the report so it compiles and shows you the result of the query selected. But you can also drag and drop single columns, is there a way to make a single column compile without being inside a databand, just the column by itself?
Re: Execute reports without databands?
Posted: Tue Jan 14, 2014 7:25 am
by HighAley
Hello.
theregister wrote:You know you usually drag and drop a data source into the report so it compiles and shows you the result of the query selected. But you can also drag and drop single columns, is there a way to make a single column compile without being inside a databand, just the column by itself?
Without Data Band you will get the current value of the column only.
Could you describe your issue more detailed and we'll try to give your another way out.
Thank you.
Re: Execute reports without databands?
Posted: Tue Jan 14, 2014 4:30 pm
by theregister
Yeah that's exactly what we saw, we get the first value of that column on the table. What I'm asking is if there is a way to make dragging and dropping a column the same as if I had dragged and dropped a datasource, or at least somewhat like it, so if I dragged and dropped the CustomerID column, it would show me all the customers' IDs on the table, like if I had done this "SELECT CustomerID FROM Customers", now I realize I can very easily do this via the datasource, but I'm being asked if there is another way to make it even simpler than it is. Thanks.
Re: Execute reports without databands?
Posted: Wed Jan 15, 2014 12:15 pm
by HighAley
Hello.
I should noticed that it is a current value. It will be first before using DataBand, but if you use this value somewhere else you will not always get the first value.
Thank you.
Re: Execute reports without databands?
Posted: Thu Jan 16, 2014 12:54 am
by theregister
Yeah, we saw that, either the first or some other value, but what we want is to be able to show all the values, just by dragging and dropping that column, instead of having to add the data source first and then selecting the column, it would be very helpful if we could do this.
Re: Execute reports without databands?
Posted: Thu Jan 16, 2014 6:58 am
by Alex K.
Hello,
For show all records from datasource you need use the DataBand component.
Thank you.