same table
2 Topics
Add column or replace value?
Hello, I'm having some trouble puting a formula together to add a column that will return Sub Account 12345 for the first row in the table below. The account number for the department that needs to be replaced will always be 236. Account Sub Account Invoice Number Amount 236 00000 5555 -10 526 12345 5555 20 205 00000 5555 30Solved1.4KViews0likes4Comments
Adding a table multiple times to the same dataset
I need a way to query data from one common table multiple times, looking for different results. Yes, I could use a subreport, but for other reasons, it won't help. Here's a example of what it is I'm trying to do. Table 1: CourseRegistrations Table 2: People I have one table for course registrations where the student ID, the faculty ID and the coach ID are all stored in each record as foreign keys. All foreign keys point to the People table, as it houses all students, staff, and faculty. To pull a record for each student with the faculty member instructing the course, and the coach involved for whatever reason, I need that table included 3 times in the dataset to pull the needed data. In Crystal Reports (CR), I could include the "People" table 3 times as I would access information about students, faculty, and coaches from it. CR would rename each table instance with aliases that I could even rename, all originating from one table, People. For example: Table 1: CourseRegistrations Table 2: People_Student Table 3: People_FacultyMember Table 4: People_AthleticsCoach In CR to pull data, I'd simply join registration's foreign keys to the People aliases to pull names for the 3 types I needed for each record sent to the report. I have yet been able to find a similar function in Report Builder to accomplish the same results. Any thoughts? Thanks, KevinSolved3.9KViews0likes6Comments