Home > Default > Dynamically inserting data to make a report

Dynamically inserting data to make a report

October 11Hits:0
Hi all, I am facing a problem with report generation. Currently I am making reports using excel templates. I am attaching the picture of sample template here. As you can see B22 is the location of item 1 and B23 is the location for Description 1. Space for description is fixed. Now B30 is the location for item name 2 and B31 is the location for item description 2. My problem is, if description of the item 1 is very small, that already allocated space will be waste.Or if Description 1 is very large, I cannot accomodate it in the given space. So I need item name 2 to come exactly under description 1, rather than fixing the space for item name 2 and subsequent rows. In short, the allocation should be dynamic, according to the size of the descriptions. Is it possible through LABView? Any ideas?
I dont need it to be done with excel only. I need that format of my quotation should be same thats all..Is there any other ways to do this?
Thanks in advance,
example.JPG ‏175 KB


Do you need to show the measure calculated for those 18 months as a total on 1 row, or do you need to select a single month and then display on row filters 18 distinct rows?
The first is trivial as driezl has suggested.
The second will require a second calendar table.
I created this example workbook for a coworker who had a similar problem. You will have to use the disconnected table as your filter and pull your related table onto the rows.
Finally, the easiest way to deal with the sort of date arithmetic you need to do is to restructure your date table to have a series of "Sequential" fields. These fields should be the number of units of time since the beginning of your calendar.
For example, consider a calendar starting on January 1, 2010. For January - December 2010, [MonthSequential] = 1, 2, ..., 12. For January - December 2011, [MonthSequential] = 13, 14, ..., 24, and so on, incrementing by 1 for each sequential month in time.
Assuming you have this set up in your date tables (one related to your model - DimDate - and one disconnected - DisconDimDate) your measure would look like this:
18 Month Measure:=
CALCULATE( [Measure]
, FILTER( DimDate
, DimDate[MonthSequential] >= MAX( DisconDimDate[MonthSequential] )
&& DimDate[MonthSequential] <= MAX( DisconDimDate[MonthSequential] ) + 18
Please review this example along with the workbook I have linked above.

Read other 9 answers


Related Articles

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.762 s.