Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 309 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
[Reports] Structure from same Table?
Jens_Murer
Member Posts: 6
Hi.
It's me again.
Now that I have filled many movies, 'rooms' and prices together to shows I'd like to print a programme for my cineplex.
For this, I want to order the shows by date, giving the date once and after that all movies shown on this day, then the next date, the movies and so on.
My shows have the following attributes:
- OID (PrimaryKey, autoincrement)
- date
- time
- movieID
- movieTitle
- price_Categorie
- roomNumber
Do I have to out the dates into a seperate table to be able to put them as headlines or make them keys too, in order to get the shows get ordered by it?
- jens
It's me again.
Now that I have filled many movies, 'rooms' and prices together to shows I'd like to print a programme for my cineplex.
For this, I want to order the shows by date, giving the date once and after that all movies shown on this day, then the next date, the movies and so on.
My shows have the following attributes:
- OID (PrimaryKey, autoincrement)
- date
- time
- movieID
- movieTitle
- price_Categorie
- roomNumber
Do I have to out the dates into a seperate table to be able to put them as headlines or make them keys too, in order to get the shows get ordered by it?
- jens
0
Comments
You need a key with field 'Date' then use the report wizard and select the sort order as Date and you should be able to design the report.
Regards
Suresh.
Sound to me like you trying to build a Navision something in M$ Access...
Or do you just have your properties messed up and do you mean AutoSplitKey?
If it was hard to write, it should be hard to understand."