Jump to content

Creating a Report in Filemaker


LadyofUC

This topic is 3313 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

            I’ve used Filemaker as a simple database for years, but now I want to create a simple report. My data is currently in Excel. Attached is a pdf depicting an example of what I hope to accomplish. Can anyone please tell me if Filemaker can accomplish my goals, and if so, how should I proceed?

 

Thanks so much, Anna  :logik: 

Concatenations.pdf

Link to comment
Share on other sites

Will your report always show three (or some other fixed number of) Quarter columns? Filemaker is not flexible in the horizontal direction, and if the number of Quarters you want to report can fluctuate, you should consider changing your report's format to something like:

 

Course 1:

•  Quarter A - X

•  Quarter B - Y, Z

•  Quarter C - V

Course 2:

•  Quarter A - U, W

•  Quarter B - S,

•  Quarter C - R, S

Link to comment
Share on other sites

  • Newbies

Will your report always ...

Yes. The reports will always display three Quarters. Thanks so much for your question. Do you see a way that I can accomplish my goal with Filemaker?  :yep:

Edited by Lee Smith
Please do not quote the entire post when responding
Link to comment
Share on other sites

Do you see a way that I can accomplish my goal with Filemaker?

 

Yes, but I hesitate because you describe your skill level  as 'Novice' and this is not going to be simple at all.

 

First, you will have to find the three Quarters (or rather Semesters, if I understand correctly what your data is about) of interest. This is already not simple, because these are not sequentially numbered, so you cannot just find those that are "higher than the maximum minus three" - as you could do with numerical data, if you wanted to find the last three semesters.

 

Once you have the names of the three semesters, you can use them in three calculation fields (or a single repeating calculation field with 3 repetitions)  to get the list of instructors (which your file for some reason labels as "State") that will be teaching a particular course in each of the three semesters (this is referring only to your first report). This too is far from being trivial.

 

I would urge you to consider a more traditional report along the lines I have shown in my previous post.

Link to comment
Share on other sites

This topic is 3313 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.